Bank Reconciliation Issue.

(0) Share

Report

Posted on by Rupesh Jadhawar

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?

All responses (5)

Answers (1)

Sort by

Suggested answer

A.Prasanna 8,227 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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