How to clear multiple transactions in bank reconciliations and how to take out a consolidated report with all bank balances

(0) Share

Report

Posted on by camdam

Two questions:

Is it possible to clear more than one transaction at the time. We do not use check numbers and tried to use the "mark check interval" functionality by setting interval to 0 to 999999 but without luck.

Any other ideas?

Any way to take out a report with all ending balances (entered from bank statements)? My idea was that there could be a report showing all ending balances entered via bank reconciliations. We have ,many accounts so looking one by one makes no sense.

Or any ideas to enter and get a report with these ending balances from another functionality than the bank reconciliation functionality?

Thank you!

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi Camdam,

Have you seen the advanced bank reconciliation feature of D365. It lets you import electronic bank statements and automatically reconcile them with bank transactions in Microsoft Dynamics 365 for Finance and Operations.

There's a constraint, that the file should be in the particular format required.

Please see this link for more detail: https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/cash-bank-management/set-up-advanced-bank-reconciliation-import-process

Please click yes against the answer if the issue is resolved.

Regards,

Zain

Was this reply helpful? Yes No
camdam 5 on at

Like (0)

Report

Thank you Zain. Yes I have seen it but as we have many accounts with many different file formats it is not easily set up so simple bank reconciliation is more appropriate for us at this point.

Was this reply helpful? Yes No
Verified answer

Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi Camdam,

I reckon that is the only way to reconcile transactions with Bank in standard functionality. The other manual workaround is that you export the data in excel, can reconcile through different formulas.

You will be filtering out only those transactions which are left. Update them in the system and post them by each bank account.

Otherwise you have to customize this.

Please mark yes, if the answer is helpful.

Warm Regards,

Zain

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello camdam,

To me this sounds as you would be better off with a special / 3rd party banking solution.

I would recommend that you have a look at MS appsource and possibly test the different solutions that are offered there. For the test phase this should be for free ;-)

Best regards,

Ludwig

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to clear multiple transactions in bank reconciliations and how to take out a consolidated report with all bank balances

Helpful resources

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

How to clear multiple transactions in bank reconciliations and how to take out a consolidated report with all bank balances

Helpful resources

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