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?
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
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.
Hi, you can start from anytime, however the previous transactions will still be in un-reconciled in the banks.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156