cancel
Showing results for 
Search instead for 
Did you mean: 
valentin-whiteir
Level 1

Why isn't my transaction report reflecting my correct bank balance?

does a balance sheet reflect bank account total?
2 Comments 2
FishingForAnswers
Level 9

Why isn't my transaction report reflecting my correct bank balance?

@valentin-whiteir  A balance sheet total reflects all events in QuickBooks associated with the balance sheet account in question as of the selected date

 

A bank account balance reflects all events associated with the bank account that have cleared the bank.

 

These two things are not necessarily the same thing.

MariaSoledadG
QuickBooks Team

Why isn't my transaction report reflecting my correct bank balance?

Let me explain why the transaction report doesn't match your bank balance. I'm here to guide you on what you are supposed to do,  Valentin. 

 

The QuickBooks balance better known as transaction report is the sum of all bank transactions that you've added or matched. This is affected by all your transactions in the register and the ones you haven't reviewed yet. On the other hand, your bank balance is a real-time balance and the actual bank balance of your account. This is solely determined based on the transactions on the register. 

 

There are several factors why these balances don't match. These are due to the following:

 

  • Outstanding transactions.
  • Card (liability) account.
  • Edited or deleted transactions.
  • Duplicate transactions.
  • New transactions for a connected account.

 

You'll have to make sure to categorize and match your downloaded transactions based on your bank statement to check what causes the difference.

 

 

A balance sheet is a financial statement that contains details of a company's assets or liabilities at a specific point in time. An individual bank account in QuickBooks will most likely show the same bank account total on the balance sheet report depending on the factors that I just elaborated above. Please see the screenshot below for your visual guide:

 

What you see on the Balance Sheet:

 

 

What you see on the Chart of accounts:

 

 

You'll want to export both your balance sheet and register to Excel, to come up with an organized report so you can compare the two or even consolidate them if it's necessary. To export a report, follow the steps provided below:

 

  1. Go to Reports.
  2. Search for and select the report you want to export.
  3. Select the Export/Print▼ dropdown, then select Export to Excel.
  4. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

 

To export from your register, click the View register hyperlink so it shows the transactions. Then click the export icon. 

export.png

Furthermore, you can learn on what are the available reports that you can use so it shows the correct account information you need. I've added this article for more details: Reports Included in Your QuickBooks Online Subscription.

 

As always, I'm still all ears in case you have any other questions about bank and QuickBooks balances. Have a great one!

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

Need to get in touch?

Contact us