Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI 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.
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:
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:
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here