Finance | Project Operations, Human Resources, ...

Bank Account reconciliation not performed for the previous months in D365 F&O

(1) Share

Report

Posted on by Durga Rao P

103

Hello Everyone,

My client wants to perform Bank reconciliation for the previous months i.e, from Jan 2023 onwards, till today it has not been reconciled in D365 as it was reconciliated in outside of the system through excel, since the customer payments/receivables wasn’t entered into D365 which could match the ending balance.

For the last few months, user login to D365 > chosen bank account > Account reconciliation > Click New to choose Bank statement, Date & Ending balance > later did No reconciliation > Every time they have repeated this process & ended up with number of months bank statement details created at every month and balances transferred to the next month with no reconciliation steps due to lack of knowledge.

So, now they have decided to perform reconciliation in the system for those previous months and decided to continue in D365.

Please advise me on this to move further.

Thanks & regards,

Durgarao.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If auto reconciliation is going to be used, maybe try to upload a dummy statement to import and reconcile the past transactions.

Was this reply helpful? Yes No
Ramit Paul 22,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Durgarao,

Have couple of questions.

1. You said, they matched manually and left without completing the bank reconciliation, if this is case, why dont you make reconciled and post?

2. Do you really wan to continue with the manual approach or you want to move to format based like Mt940/BA12/ISO etc. which is shared by bank and D365 will read and can auto match?

If you want to move to format based like Mt940/BA12/ISO etc. which is shared by bank, then you can think the suggesion what Billur suggested or you cna take advantage of the new feature by which you can upload statement by excel.

Was this reply helpful? Yes No
Durga Rao P 103 on at

Like (0)

Report
Copy link

Link copied!

Hi Ramit Paul ,

Thanks for your valuable reply.

1. As a part of reconciliation, they have just created lines on every month and DID NOT MATCHED manually as they are just kept it open & those balances were transferred to next month beginning, repeated this process for few months since the customer payments/receivables wasn’t entered into D365 which could match the ending balance. .

2. As confirmed by User - First, they want to reconcile the previous months which were not reconciled, once everything seems fine next they will proceed to start manual reconciliation on for 1-2 months for their understanding later User agreed to use Advanced bank reconciliation feature using MT940 format.

Please advice me on this.

Regards,

Durgarao.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Bank Account reconciliation not performed for the previous months in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Bank Account reconciliation not performed for the previous months in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates