cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
accounts599
Level 1

If we did not use online banking for the past 3 years and now link the bank the bank balance in Quickbooks is much higher than the bank balance itself how can I fix it ?

We only start using the link bank from March this year

1 Comment 1
Jayson_E
QuickBooks Team

If we did not use online banking for the past 3 years and now link the bank the bank balance in Quickbooks is much higher than the bank balance itself how can I fix it ?

I'll guide you on how to resolve the discrepancies between your QuickBooks Online (QBO) balance and your actual bank balance, accounts599. Let me explain the details below.

 

First, please note your bank balance reflects the real-time status of your account as reported by your financial institution. On the other hand, QuickBooks balance is based on the transactions you've recorded or imported into QBO.

 

Since no bank account was linked to your QBO account for the past three years, your QBO balance is higher than your actual bank balance. This happens because transactions before linking in March were not recorded in the software.

 

Other common reasons for balance differences:

 

  • Outstanding/pending transactions
  • New transactions for a connected bank account
  • Duplicate transactions
  • Edited/Deleted transactions
  • Credit card (liability) account

 

To resolve this, you need to manually upload the transactions from before you linked your bank account in March. Here’s how:

 

  1. Go to the Transactions menu, then select Bank transactions.
    image (14).png
  2. In the Link account drop-down, click Upload from file.
  3. Follow the on-screen instructions to upload your bank’s transaction file (.CSV format).

 

Lastly, I'll share these resources to help you categorize your transactions accurately and reconcile your accounts to ensure your QuickBooks balance matches your bank:

 

 

If you have any other questions or need further help with managing bank transactions in QuickBooks Online, please don’t hesitate to reply below. We're here to support you every step of the way.