Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
Kimberly74
Level 3

QBO balance not matching

I have a client that uses QBO but has never reconciled their linked bank accounts or linked credit card accounts since they started using QBO.  Without having to go back to 2017 and reconcile from the beginning, what is the best way to get them caught up and accurate moving forward?  The QBO balance on the transaction page is not accurate.  It appears to have payments from years back that have posted recently again.  I don't know what the client touched, but I want to make this as easy as possible so I don't have to spend hours getting it resolved.  Any suggestions would be greatly appreciated.  I'm a new user to QBO and am still learning too.

1 Comment 1
jenop2
QuickBooks Team

QBO balance not matching

A warm welcome to you and your client to the QuickBooks family, Kimberly74! We're thrilled to have you on board. Starting with QuickBooks Online can indeed present a learning curve.

 

Let me walk you through some key steps to rectify the balance discrepancies and ensure your client's financial records are accurate from this point forward.

 

An incorrect bank balance in QBO can occur due to the following scenarios:

 

  • An incorrect opening balance was entered when the account was created in QuickBooks.
  • Transactions older than the opening balance were added without updating the original opening balance entry.
  • Deleted or missing transactions in QBO.

 

Although it's technically possible to modify the balance through an adjusting entry, we typically consider this a last resort. Even when dealing with small balance issues, we strongly suggest exhausting all other options before resorting to this method.

 

Given that your client hasn't previously reconciled their account, it's best to begin the reconciliation process from the earliest available period. The Reconcile feature in QuickBooks Online (QBO) uses an automated system that builds upon previously completed reconciliations.

 

Aside from that, QBO will automatically set the beginning balance from the ending balance of your most recent reconciliation. This feature is designed to maintain continuity in your financial records.

 

To make sure everything is correct, double-check the opening balance for the account you're reconciling. There are times when the opening balance doesn't include transactions that were still pending when you created the account. The opening balance is the balance of your bank account on the day you choose to start tracking transactions.

 

Next, review the bank register if there are transactions that are listed in the actual bank statement, but aren't included in QBO. Then, follow these steps on how to manually add them in the register:

 

  1. Open your bank register in the chart of accounts.
  2. At the very top of the list, click the drop-down list beside Add check.
  3. Select the type of transaction that you want.
  4. Enter all required details and click Save.

 

add transaction register.png

 

Check out this article to read more details about this process: Manually add transactions to account registers in QuickBooks Online.

 

You may also need to delete entries in case there are duplicate transactions. You can refer to this article for a step-by-step guide: Void or delete transactions in QuickBooks Online.

 

Additional options to make sure the balance is correct are provided in this article: Fix issues the first time you reconcile an account in QuickBooks Online.

 

If the balance is still off after following these steps, you can find additional troubleshooting guidance in these articles:

 

 

Once you know your opening balance is correct, you can start the reconciliation process by following these steps:

 

  1. Click the Reconcile button in the upper-right-hand corner of the page.
  2. Choose the bank account in the drop-down list for Account.
  3. Enter all required information, then click Start reconciling.

 

start reconcile 1.png

 

1.png

Here's a comprehensive guide about the reconciliation process for additional guidance: Learn the reconcile workflow in QuickBooks.

 

Finally, I'd like to share these articles for additional guidance when reconciling accounts in QBO:

 

 

Always remember that we're here and eager to assist you. Whether it's about reconciliations or learning how to use QuickBooks Online, we're just a post away and ready to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us