Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Bank Reconciliation Issue.

Posted on by

Hi Friends, D365 F&O in use from the last one year. But Bank reconciliation was not being used. Reconciliation was being done using excel outside the system. But now we want to start reconciliation from this month onwards. But when we try to start the reconciliation for this month, all the previous entries of one year appear for the Cleared checkbox. So do we have to reconcile from the beginning for the whole year? Can't we start from this month and previous transactions won't appear in the list?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Bank Reconciliation Issue.

    Hello Rupesh,

    Many thanks for the clarification.

    If you just started with the reconciliation then I would expect that everything that has been recorded in the past shows up as unreconciled.

    Do you have the developers around who could help you probably with reconciling the old transactions.

    If you have then they can probably help you here with a script/job.

    In case you don't have somebody around who could help you then I would consider whether setting up a new bank account would help.

    Probably something like "BankNew" and then to start from today onwards with the reconciliation of the newly setup bank account.

    That's of course not perfect and you would have to transfer the balance to this new account.

    Probably discuss internally if this would be an alternative workaround for you.

    The advantage would be that reconciling the old transactions is not needed as it has been done outside of D365FO.

    Best regards,

    Ludwig

  • RE: Bank Reconciliation Issue.

    Hi Ludwig,

    By all the previous entries I meant, all the transactions happened using Bank Subledger account, since the beginning of operations last year appear in the reconciliations transaction form to mark "cleared" against the bank statement entries.

    But it seems all previous entries will come as unreconciled in this month's reconciliation report. Thanks Anyways.

  • Ramit Paul Profile Picture
    Ramit Paul 22,300 Most Valuable Professional on at
    RE: Bank Reconciliation Issue.

    Hi, you can start from anytime, however the previous transactions will still be in un-reconciled in the banks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Bank Reconciliation Issue.

    Hello Rupesh,

    Can you explain in more detail what you mean when you say that all the previous entries ... appear for the cleared checkbox?

    Could you share a screenprint?

    Best regards,

    Ludwig

  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,161 on at
    RE: Bank Reconciliation Issue.

    Since its one year best option to  try complete past 12 months , bank reconciliation is always forward ,following by month or whatever the period breakdown. so if you do it in middle other months remain as unreconciled and may show incorrect balances  .i dont think its a good thing to do.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans