Bank Account reconciliation - outstanding transactions that don't exist

(1) Share

Report

Posted on by tb513

We have a bank reconciliation that shows it is balanced, and the total on outstanding checks shows $36,047.54 when looking on the main bank rec page. However, when we try to post it, it is not balanced and is showing an outstanding check total of 1,246,045.55. No where in the system is anything close to that number and we don't see any keying errors. We can't figure out where that number is coming from.

Categories:

Other

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 69,162 Super User 2024 Season 2 on at

Like (1)

Report

Bank Account reconciliation - outstanding transactions that don't exist

It looks like the Check Ledger Entries and Bank Account Ledger Entries are unbalanced. I suggest you check these details separately.

Hope this helps.

Thanks.

ZHU
Suggested answer

Valentin Castravet 22,030 Super User 2024 Season 2 on at

Like (1)

Report

Bank Account reconciliation - outstanding transactions that don't exist

Is it the report thats wrong? Or the page in Business Central? If its the report, there is a bug in the bank rec report since the last update. Sounds like your issue is related to that. You can either fix the report yourself or wait until Microsoft will. Here's a similar thread - Bank Reconciliation - Outstanding Bank Transactions amount problem (dynamics.com)

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/