Skip to main content
C
Chris97277
April 2, 2024
Question

Bank Balance does not match QB Balance

  • April 2, 2024
  • 2 replies
  • 0 views

Our QB online account got imported into QB back in 2022. The people before me never correctly categorized or expensed the banking transactions so now our QB balance and our actual bank balance does not even match at all. Is there any way I can go about fixing this without screwing up our 2022 financials? I do not want our Balance Sheet to be misstated with an incorrect bank balance.

2 replies

AlverMarkT
AlverMarkT
April 2, 2024

Hi, Chris. It's great having you in the Community.

 

Before everything else, please know that while the bank balance represents the current bank balance amount, the QBO balance represents the amount for all the recorded transactions under the bank account. I can help fix the transactions that were incorrectly categorized in 2022 and reconcile the account to ensure having an accurate financial records. 

 

First, I'd recommend having your bank statements in 2022 ready and checking the account's balance for the same day as the opening balance in QuickBooks. You can refer to this article to review the opening balance: Fix issues the first time you reconcile an account in QuickBooks Online. 

 

Next, since the transactions have been incorrectly categorized, you can consider to Batch Undo them to place them back under For review. I've attached a screenshot for reference. 

 

  

Once done, categorize and match the 2022 transactions. 

 

You can then reconcile the bank account following these steps: 

 

  1. Go the Gear icon, then Reconciliation.
  2. Select the Account.
  3. Enter the Ending balance.
  4. Click on Start reconciling.
  5. Compare the two transactions. If they match, put a checkmark next to the amount in QuickBooks. This marks it as reconciled. 
  6. If a transaction doesn't appear on your statement but you see it in QuickBooks, don't put a checkmark.
  7. Compare each transaction on your statement with what's in QuickBooks.
  8. When you reach the end, the difference between your statement and QuickBooks should be $0.00. If it is, select Finish now.

 

While following these guidelines in fixing this, I'd still encourage consulting an accountant to ensure that the 2022 financials is accurate: Transfer funds between accounts.

 

In case you need to record movement of funds from one account to another, let me add this article as a guide:  

 

We'll be here in the Community if you need further assistance addressing differences between the bank and QBO balance. We'll do our best to assist. Take care.

E
Elmer031067
February 19, 2025
 

Hi, the balance sheet bank balance is incorrect vs the bank ledger. why this happening? i can't refresh also the balance sheet

 

 

 

A
AntoniettaE
February 19, 2025

There are instances where your bank balance and QuickBooks balance do not match, Elmer. Let me share some information on how these two works for your bank account in QuickBooks Online (QBO).

 

The balance in QuickBooks is impacted by all transactions that are entered, including those that have been added manually or matched within the system. While the bank balance represents the actual balance in your bank account.

 

Here are possible reasons why these balances don’t match. These are due to the following:

 

  • Outstanding transactions.
  • Edited or deleted transactions.
  • Duplicate transactions.
  • New transactions for a connected account.

 

To ensure your financial records are accurate, you need to perform a reconciliation. This means carefully checking your accounts in QBO to make sure every transaction matches your bank statement.

 

First, gather your latest bank statement and log into your QBO account. Then, compare each transaction in QBO with the ones listed on your bank statement. Look for discrepancies, such as missing transactions or mismatched amounts. After identifying any differences, update your records as needed.

 

For further details, feel free to check out this material: Reconcile an account in QuickBooks Online.

 

Moreover, I'd like to provide you with an article that could be useful in reviewing your reconciliation: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Additionally, you can take advantage of our QuickBooks Live Expert Assisted services anytime if you require further assistance organizing your entries for an accurate record of your transactions.

 

We're dedicated to keeping your experience safe and secure while you reconcile! If you have any questions or need a helping hand, feel free to reach out below.

Terms & ConditionsAccessibility statement