Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Bank Rec Module

Posted on by 15

We just switch from using Cash mgr to Bank rec. We closed our period to begin Dec but need to bank rec Nov but the program will only allow us to bank rec for Dec. We need to be able to go back one period to bank rec the previous month on some of our account while also being able to bank rec some accounts in the current month.

Spoke with a SL advisor we use and they didn't think you could do past and current months in the bank rec module--Why not?

I seems to me to that most companies can not finish the bank rec' for the previous period before the first of the current month.

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Bank Rec Module

    Hello RdCorbin,

    I talked with a Bank rec specialist, here is his explanation:

    When they setup bank reconciliation, they should have set it up in the period they want to ‘start using’ bank reconciliation.  They cannot add bank reconciliations for prior periods.  Example:  If you want to create period 10-2019 as your first bank reconciliation, then you would need to setup bank reconciliation in period 10-2019.  You cannot setup bank reconciliation in period 11-2019 and then enter a bank reconciliation for period 10-2019.

    If they are just starting bank reconciliation, they can delete data from the BR tables, including BRSetup, and then just start over.  Go into BR Setup, and enter the period number that they want to use for their first bank reconciliation.

    The customer wrote “It seems to me that most companies cannot finish the bank rec for the previous period before the first of the current month”.

    For that reason, they can close GL ahead of the BR module.  If GL is in period 11-2019 as an example, BR can still be in period 09-2019 or 06-2019.  BR is the only module that is not required to be closed prior to GL being closed.  But you still cannot enter a bank reconciliation for a prior period.  If GL is in period 11-2019, there is no problem with BR being in period 10-2019 or period 09-2019, but if it is already in period 11-2019, then you can’t go back and add a period 10-2019 bank reconciliation.

    Best Regards,

    Jana MacDonald

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Bank Rec Module

    Hello RdCorbin,

    I'm assuming that this is by design, however I will put your question to a financial team member to get confirmation or workaround

    Best Regards,

    Jana MacDonald

    MSFT Dynamics support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans