top of page

Why is your QuickBooks Online balance different from your actual Bank balance?

Updated: Apr 5

If your QuickBooks Online register balance and your actual Bank balance don't match in QuickBooks Online, don't worry! There are several reasons that the balance in QuickBooks Online could vary from the bank balance.

1. Outstanding checks

The relationship between QuickBooks Online and your bank is a real-time picture. What this means is that your bank balance and the balance in QuickBooks Online will only match if you don't have any outstanding checks.

irvine bookkeeping

Think of the QuickBooks Online balance as the balance that would be in your checkbook register. When you write a check from your checkbook, you deduct it from your registered balance even though it hasn't actually cleared the bank yet. This process causes your registered balance to be different from your actual bank balance.

For example, suppose your bank balance is $1000 but you have an outstanding check for $100. In that case, QuickBooks Online will enter the check in the register causing it to look as though it has already cleared the bank and will reduce your balance by $100, which means the balance in the register of QuickBooks Online will be $900. The bank balance, however, will continue to read $1000 until the outstanding check/cheque has cleared.

2. New transactions for a connected account

Suppose QuickBooks Online is connected to your bank to download transactions. In that case, any transactions that are in the New Transactions tab and have not been added are not included in the balance on the register in QuickBooks Online but are reflected in the actual bank balance. As long as they remain in the New Transactions tab they will not affect your QuickBooks Online balance.

Adding them to the register will update the balance in QuickBooks Online, but this does not apply to transactions that have been entered on the register and need to be matched.

irvine bookkeeping

3. Duplicate transactions

Transactions may have been incorrectly added to the register instead of being matched to a current transaction already entered.

An easy way to check for duplicates is to customize your register and sort it by amount instead of date. This will place transactions of the same amount next to each other and make finding any possible duplicates much easier.

If you added a transaction but should have matched, you can undo the acceptance and then match the transaction instead. See Assigning, categorizing, editing, and adding your downloaded banking transactions.

4. Editing or deleting transactions

Editing or deleting transactions already in your register can cause discrepancies between the bank balance and the balance in QuickBooks Online.

5. Credit card and liability accounts

These types of accounts have the opposite accounting effect on your books than bank (or asset) accounts do. Because of this, the Bank Balance column for these accounts will normally be negative. What you want to look at is the Balance column and make sure that is correct (positive).

If the Balance column is negative, you need to recheck your record transactions and reconciliation to troubleshoot a credit card balance. If using downloaded transactions, have you added the payment from the bank account and then matched it from the credit card side (or vice versa), or did you use Transfer? If not, you may have added it from both the bank and the credit card or liability account, causing duplicate transactions. To fix it, undo one of the added transactions and then match it.

QuickBooks Online with Irvine Bookkeeping

At Irvine Bookkeeping, we excel in resolving such intricacies with our specialized QuickBooks services. Whether it's catch-up bookkeeping, a deep dive into QuickBooks diagnostics, consistent monthly bookkeeping, managing AR/AP, or navigating tax services, we tailor our expertise to address and rectify these discrepancies, ensuring your financial records are accurate and up-to-date.

If you need advice or services on any aspect of bookkeeping, accounting, and tax, our specialists are ready to help. Get in touch with us for a free quote.

irvine bookkeeping

10,949 views0 comments


bottom of page