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

Reconciling bank account with different bank account balance on statement vs on the bank account

(5) ShareShare
ReportReport
Posted on by 458
I have a question regarding how to get the bank balance and GL balance on my bank account to match the bank account balance on the bank account reconciliation. Currently I have the bank statement lines all matched against corresponding transactions in the bank account ledger entries. There are four not matched transactions on the bank account ledger entries. Two of them cancel each other out, and the remaining two are outstanding checks. The GL account balance and bank account balance at 03/31/25 match at -16.48, but on the bank statement, it shows 124.38. So, it is out by 140.86 on the GL account and bank account balance. I tried to increase the bank balance by entering a journal entry for 140.86 debiting the bank account and debiting the bank GL 10200. But this did not work as the test report for the bank account reconciliation increased the bank and GL to 124.38, and the bank account balance on the statement showed 265.24, so still out by 140.86. What is the entry or reversal I need to do to ensure that the GL account and bank balance shows 124.38 on 03/31/25, to match the 124.38 on the bank account balance on the statement balance side?
bank balance out ...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    20,275 Super User 2025 Season 2 on at
    Unable to see attachment. i think its under scan process.
    If your bank ledger is accurate but GL is off, post a GL-only journal to adjust the balance. If a transaction is missing from the bank ledger, enter it as a bank transaction instead.
    Please check part 2 and part 3:
  • Suggested answer
    Ramesh Kumar Profile Picture
    7,527 Super User 2025 Season 2 on at

    GL account and Bank Account in BC show -16.48 as of 03/31/25. Bank statement shows a balance of 124.38. Difference: 124.38 - (-16.48) = 140.86 You tried a general journal entry (debit bank account + debit GL 10200) which resulted in doubling the balance (i.e., wrong accounting).

    To correct this and get GL and Bank Ledger to match the bank statement balance of 124.38, you need to:  Make a journal entry that debits the bank GL and credits an appropriate offset account (NOT the bank account card directly). In Business Central, the Bank Account and GL Account for cash/bank are not automatically the same—so you shouldn't be debiting both the bank account card and the bank GL in the same entry.

    Use General Journal (or Cash Receipt Journal)

    Account Type

    Account No.

    Description

    Debit

    Credit

    G/L Account

    10200

    Bank GL Account

    140.86

     

    G/L Account

    [Offset]

    Adjustment Account

     

    140.86

     
    Replace [Offset] with an appropriate GL account (e.g., suspense, prior period adjustment, or whatever is valid for your organization). Do NOT use the "Bank Account" as the Account Type. Just adjust the GL directly if this is purely a GL discrepancy.
     
    Post the Entry Once this is posted, your GL Account (10200) should show a balance of 124.38, which matches your Bank Statement.
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at
    Generally, if you post to Bank Account, it will automatically be posted to GL, which is linked through the following settings.
    Unless you post directly to GL Account, it will not affect Bank Account.
     
    Hope this can give you some tips.
    Thanks.
    ZHU
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,631 Super User 2025 Season 2 on at
    Hello,
     
    To reconcile your bank account in Business Central, ensure all transactions on the bank statement are matched with the bank account ledger entries. Reverse any incorrect journal entries and manually match any remaining transactions. Use the Bank Account Reconciliation page to verify the statement date and balance, and post the reconciliation once the difference is zero. This should align the GL account and bank account balances with the bank statement balance of 124.38 as of 31/03/25.

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