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

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

 
5 Comments
Highlighted
Level 2

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

Hi bushy402,

I'm here to share some pointers on how you can resolve the difference on these balances.

The QuickBooks balance is the total balance of all bank transactions that you’ve added or matched to QuickBooks. While the bank balance is your bank's actual balance from the last bank feed update. If the Bank balance is greater than your QuickBooks balance, there might be bank transactions that are causing the difference. Here’s a list of possible reasons why these balances don’t match:

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

Depending on the factor that’s mentioned above, there are different steps to fix your issue. Here’s an article on the steps to fix or adjust these factors: How to Fix Differences Between QuickBooks Balance and Bank Balance.

If you have other questions, feel free to leave a comment below.

Highlighted
Level 1

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

there is  often a time lag between the REPORTED bank balance shown in Quick books, and the transactions required to be matched in Quick books being fed through.

 

The banking screen showing all done  with a green tick is misleading.

 

that simply means that the bank transaction feeds have all been posted........... the ones lagging and as yet unseen require posting in due course to bring Quick books ban and real bank into alignment.

 

In reality if there is a constant flow of transactions  you are most unlikely to see the two accounts match !  in that case it is not an error,  just a timing issue.

 

if you go online and look at your bank account, through your EYES, not quick books EYES you will soon see the point.

 

 

 

Highlighted
Level 1

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

Some days I miss my spreadsheet. I need QB for the reporting etc though. I just had the same issue. I went and undid all my transactions as I was worried I might have allocated some wrong. And now it's worse! 

Highlighted
QuickBooks Team

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

Hello there, Treescape.

 

Let me help you identify where the issue is coming from so you'll be able to get your account reconciled.

 

You can review the list of transactions in the Reconciliation window to check any transactions in your bank statement that's not recorded in QuickBooks. Physically mark them and enter those that aren't on the list. Here's how:

  1. Go to the Sales or Expenses menu.
  2. Search for transactions you see on your bank statement but not in QuickBooks.
  3. If you find any, select and open it.
  4. Check the Deposit to or Payment account. 
  5. Make sure it's in the correct account. 
  6. Click Save.

On the other hand, you can also match your downloaded transactions with the ones you already entered to avoid duplicates. Here's how:

  1. Go to the Banking menu.
  2. Select the blue tile for the account you want to review.
  3. In the For Review tab, select the transaction.
  4. Review the transactions already in QuickBooks in the Records found section.
  5. Click the link next to each record to view its details.
  6. Verify the Deposit to field.
  7. Select Match once done.

If you're seeing more than one potential match, just pick the right one. Once done, review the transactions in the Reviewed tab.  Check out the article's Step 3: Review transactions after you’ve matched or added them for the steps: Match and categorize bank transactions in QuickBooks Online.

 

I'd suggest you do your monthly reconciliations to easily catch errors and keep track of your business' income. To reconcile, kindly refer to this article for the detailed steps: Reconcile an account in QuickBooks Online.

 

Please let me know if you have other concerns. I'm just around to help.

Highlighted
Level 1

My bank balance is much higher than quickbooks balance. Why is that and how can I fix it?

Thank you. I'll give it a try!