web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    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
    29,837 Super User 2025 Season 2 on at
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    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
    Unknown Outstanding Transactions/Checks amount on Bank Account Statement
    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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,808

#2
Sumit Singh Profile Picture

Sumit Singh 2,554

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,140

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans