Small and medium business | Business Central, N...

Bank A/C Reconciliation - Outstanding Checks Showing zeros

(5) Share

Report

Posted on by CU02031112-0

The outstanding Checks amount is 0.00 and the Outstanding Bank Transactions shows -17,805,221.10. I have exported the Table 271 for all Bank Account Ledger Entries. Which columns do i use to identify the un-reconciled entries, outstanding checks ? What does the outstanding checks amount 0.00 mean in this ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Below is the standard procedure; hopefully, it will give you some hints.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 496 on at

Like (0)

Report
Copy link

Link copied!

I think the outstanding checks relates to any physical paper checks you have issued. If you don't do that you won't have any.

The "Open" field denotes which transactions still need to be reconciled.

Remember with bank reconiliation you are reconciling bank ledger entries, if the sum of those doesn't equal the G/L entries, then you have direct postings to the G/L and this won't match. I would always disable direct posting to control accounts.

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,965 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

To identify unreconciled bank entries in Table 271 (Bank Account Ledger Entry), mainly use Open, Remaining Amount, and Posting Date. Entries with Open = TRUE and Remaining Amount <> 0 (usually filtered up to the statement date) represent transactions that are still outstanding and explain the Outstanding Bank Transactions (-17,805,221.10). Outstanding Checks = 0.00 simply means Business Central did not detect any unreconciled check entries (from the check ledger); therefore, all open items are treated as general bank transactions instead of checks. If checks were used, they would appear separately in the Outstanding Checks total.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No