cancel
Showing results for 
Search instead for 
Did you mean: 
lo5335
Level 2

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 Comments 4
Nicole_N
QuickBooks Team

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

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!

lo5335
Level 2

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

Thank you! I will try these.

0786015788
Level 1

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

For the case of Multiple currency, my ledger balance has a correct balance in shillings but the equivalent in US$ (THE home currency) is way above the ledger balance. Why is so and how do i fix it.

Candice C
QuickBooks Team

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

Good morning, @0786015788

 

Congrats on making your first post here in the Community! I appreciate you chiming in on this thread about ledger balances. 

 

To clarify, have you tried the steps from above that my colleague provided? 

 

If not, I recommend performing these steps to get a better understanding of why this may be happening in your account. If you have tried these instructions, I suggest consulting with your accountant about this situation. They'll be able to assist with every details and give you best solution for your business. 

 

Keep us updated on if these steps work, or how the conversation goes with your accountant. I'll be waiting for your response! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us