web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Unknown Outstanding Transactions/Checks amount on Bank Account Statement

(1) ShareShare
ReportReport
Posted on by 21
We have several tenants that having the bank account statement does not calculate the outstanding transactions/checks amount correctly. 
Below is one of the bank accounts having the issue. The outstanding bank transactions amount and outstanding checks amount should be the amount calculated on the bottom of the report. When I compared with the bank ledger entries, these transactions shown on the detail as outstanding were ones with Open status. There was no issue on last month closing but started to have these issues on multiple tenants recently. 
I'm not sure which table data I can look to get these outstanding bank balances. Does anyone have the same issue? All tenants are on current version 24.4.22295.22393.
Below is another bank account that there weren't any outstanding bank transactions as of 8/31/24. There was no issue to run the bank reconciliation as of 7/31/24. At the end of July, this bank account didn't have any outstanding transactions either. However, in August report, unknown outstanding amounts stated to show on the report. 
I have the same question (0)
  • RB-14061225-0 Profile Picture
    8 on at
    We had this issue in June this year, and then an update was put through to fix it, and it was ok for the past few months but it seems like it is back again.
  • Verified answer
    Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    The previous issue a few months ago with the bank reconciliation report was that the older method of reconciling bank statements without auto match would not populate the 'Closed at Date' field in the bank ledger entries for reconciled entries.
     
    As a result, when printing a bank reconciliation report, it filters based on this field, but since the field was empty for old reconciled entries, the report displayed them incorrectly as outstanding, which it shouldn't have. You can check in the bank ledger entries if the entries that are incorrectly being displayed as outstanding have the 'Closed at Date' field empty. If that's the case, you can modify the report to ignore this filter, or wait for Microsoft to fix it again.
     
     
     
     
  • Verified answer
    CM-13062325-0 Profile Picture
    21 on at
    Thank you for your responses. 
     
    We investigated further and also concluded that the issue was caused by closed bank ledger entries with no closed at date. We waited for MS hotfix last time, so we'll reach out and see if they are going to publish the hotfix soon. Otherwise, we probably need to modify the report on our end. 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans