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)

Sort by

Suggested answer

Zain Mehmood 4,189 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,189 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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