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...
Suggested answer

Bank Account Reconciliation Outstanding Bank Transactions

(0) ShareShare
ReportReport
Posted on by 39

Hello!

When running our first bank reconciliation, the statement Total Balance field and ledger Balance To Reconcile fields match. However, when we post this reconciliation and move to the second reconciliation, our "Balance To Reconcile field is not equal to our Total Balance field, despite everything else being correct. 

We reversed the first reconciliation and ran the Test Report (Actions -> Posting -> Test Report...)

On this report there is a field on the right called "Outstanding Bank Transactions", and in our case there is $45 in this field. We have no idea where this $45 is coming from and believe this $45 is skewing the second bank reconciliation. 

Can anyone help explain how Business Central calculates this "Outstanding Bank Transactions" field?

Screen-Shot-2021_2D00_06_2D00_30-at-11.51.14-AM.png

Screen-Shot-2021_2D00_06_2D00_30-at-11.51.36-AM.png

I have the same question (0)
  • JAngle Profile Picture
    121 on at
    RE: Bank Account Reconciliation Outstanding Bank Transactions

    The mentioned value is calculated on the report layout so would need to open that to verify exactly. The bank account ledger entries (right hand side) in your image has a “Posting Date” filter. Is the $45 not an unapplied line sat outside of the filter?

  • corwiley Profile Picture
    39 on at
    RE: Bank Account Reconciliation Outstanding Bank Transactions

    The Statement Date field controls which ledger entries are shown on the right hand side and I have it filtered to all entries 2/2/20 and before. There are many ledger entries that are unapplied after the 2/2/20 Statement Date however, 45 is not one of them. Please see the screen shot. I filtered the bank ledger entries to 45 and there is not a 45 transaction in this bank account.

     Screen-Shot-2021_2D00_06_2D00_30-at-4.25.01-PM.png

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Bank Account Reconciliation Outstanding Bank Transactions

    Hello,

    I see you imported your Bank Statement to create the Lines, yes? If no and you ran suggest based on the Statement Date, do you have any transaction in the Bank (Bank Ledger or Check Ledger) that is 45.00? At first I would think its an outstanding Bank Ledger transaction from a prior period. Please open the Bank Ledger and filter on an Amount for 45.00|-45.00.

    Thanks,

    Steve

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 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans