Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 3, 2023
Question

Balance sheet cash amount does not equal the general ledger balance QB Online

Hi-

My Balance sheet amount for cash matches register and bank rec, but the amount on the General Ledger for cash is different. Why?

I also have a hard time with the balance sheet report because it should be as of a day, but it gives options like for the whole year.

This is happening in Quickbooks Online.

Thank you.

4 replies

Nicole_N
QuickBooks Team
March 8, 2023

Hi there, @lo5335.

 

I can give you some tips on how to check for the difference and help you fix it. Please take note that this can affect your books. That said, seeking an accountant is recommended before proceeding.

 

You'll want to review the previous reconciliation report to check if there were transactions that were not supposed to be reconciled. I'll show you how:

 

  1. Go to Accounting, then select the Reconcile tab. 
  2. Click the History by account link.
  3. Choose the Account and Report period.
  4. Open the year with the statement ending date.
  5. Click View report. 

 

This report will show all the reconciled transactions. You'll want to review the list and check what is causing the difference.

 

You can correct the unreconciled period by undoing the process. Check out this article that details that process: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Also, you have to check your uncleard and cleared transactions and see if they're causing the difference. I'll guide you on how:

 

  1. Open a Balance Sheet report.
  2. Select your bank account by double-clicking on the amount.
  3. In the Transaction Report overview, click the Customize button.
  4. Expand the Filter view.
  5. Check the Cleared box.
  6. Select Cleared or Uncleared in the drop-down menu. 
  7. Click Run report.

 

After finding what's causing the difference, you'll want to double check your General Ledger report and compare it with your register balance. 

 

You can also visit this link to learn more about managing transactions in QBO: Categorize and match online bank transactions.

 

Let me know in the comment below if you have additional questions. I'd be glad to answer them for you. Have a great day!

lo5335Author
March 8, 2023

Thank you! I will try these.