cancel
Showing results for 
Search instead for 
Did you mean: 
Murphy Empire
Level 1

Can anyone help? I have been using QB for over a year and my QB balance has never matched my bank account balance. I am not sure how to fix it at this point.

I have 2 biz accounts and 1 biz credit card in QB.... none of them match.
1 Comment 1
BettyJaneB
QuickBooks Team

Can anyone help? I have been using QB for over a year and my QB balance has never matched my bank account balance. I am not sure how to fix it at this point.

Help has arrived, @Murphy Empire.

 

It's my priority to ensure that you'll be able to match your balance between QuickBooks and your bank.

 

QuickBooks balance is based on the transactions that you entered on the system. That said, any entries made in QBO will change its balance. On the other hand, the bank balance is based on the amount that was cleared out from your financial institution.

 

Moreover, having both balances not to match can be caused by outstanding checks, duplicate transactions, transactions that may have been modified or deleted. 

 

To isolate the issue, I would recommend checking out the transactions added in QuickBooks and compare them to your bank statement. You may pull up the Transaction Detail by Account report to view the entries for the said account.

 

Here's how: 

  1. Go to the Reports menu from the left menu.
  2. Use the Find report by name search bar to search for Transaction Detail by Account.
  3. Select the report to open it.
  4. Click Customize.
  5. Go to the Filter section and mark Account.
    transactiondetailbyaccount.PNG
  6. Choose the accounts you want to open.
  7. Click Run report.

You can also view the entries from the Chart of Accounts. To do this, you'll need to hit View Register of the bank account that you're working with.

 

 

To give you more details about what are the best things to do if you encounter issues while reconciling your accounts, please see this reference: Learn how to review your beginning balance and look for issues for accounts you haven't reconciled b...

 

Know that you can always get back to me here in the Community if you have any other questions. I'll be around to lend a helping hand. Keep safe!

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

Need to get in touch?

Contact us