Updated
26 min read

Imagine reaching the end of the month and finding that your bank statement balance doesn’t match the one in QuickBooks Online. A payment may be missing, a deposit could be duplicated, or a previously reconciled transaction may have been changed. These discrepancies can affect your beginning and ending balances, making it harder to complete your reconciliation accurately.
QuickBooks Online reconciliation helps you compare your accounting records with your bank or credit card statement, identify differences, and correct errors. If you use an eligible QuickBooks Online plan, AI-powered reconciliation can simplify the process by matching transactions and highlighting items that need your attention.
In this blog, we’ll walk you through the reconciliation workflow, explore AI-powered reconciliation, and explain how to identify and fix beginning and ending balance issues in QuickBooks Online.
Reconciling an account in QuickBooks Online means comparing the transactions and balance recorded in QB with your actual bank or credit card statement. The purpose is simple: make sure your books reflect what actually happened in your financial account.
Note: For this reason, it is generally recommended to reconcile accounts regularly using the corresponding bank or credit card statements.
QuickBooks Online also provides an AI-powered reconciliation process for eligible plans. Below are the steps to make the best use of AI-powered reconciliation in QuickBooks Online.
The AI-powered reconciliation feature is currently available with QuickBooks Online Plus, QuickBooks Online Advanced, and Intuit Enterprise Suite. To start a reconciliation:
So, these are the steps that can help you reconcile an account in QuickBooks Online with the help of AI. Once the AI-powered reconciliation process is complete, QuickBooks Online provides insights that help you understand how your statement data compares with the transactions recorded in QuickBooks.
The Insights tab helps you understand how the transactions in QuickBooks compare with those on your bank statement. It can highlight several types of differences that may need your attention.
QuickBooks may also identify potential explanations for extra transactions, such as timing differences, duplicate entries, manually recorded transactions, or unclear transfers and deposits.
Note: An unmatched transaction is not automatically an error.
Once you have your monthly bank statements, you can start comparing the transactions recorded in QuickBooks with those listed on your account statement. Before you begin, check that the opening or beginning balance matches the balance shown on your statement for that date.
Once you finish reconciling an account, the ending balance in QuickBooks should match the balance on your account statement. If the two amounts don’t agree, the account still needs to be reviewed.
Note: If you need to correct a reconciliation or start the process over, it’s best to contact your accountant. They can help make the necessary changes without creating new discrepancies in your accounts.
Now that you know how AI-powered reconciliation works in QuickBooks Online, it’s time to look at the common errors and their solutions. But before you start a reconciliation, it’s important to understand two balances you’ll come across in QuickBooks Online: the opening balance and the beginning balance. Although they sound similar, they serve different purposes in the reconciliation process.
In simple terms, the opening balance starts the account, while the beginning balance starts each new reconciliation.
If you’re reconciling an account for the first time in QuickBooks Online and the balance doesn’t match, an incorrect opening balance is often the reason. Your opening balance serves as the starting point for tracking the account in QuickBooks.
Before you begin, keep a copy of the relevant bank or credit card statement handy and make sure you have access to the Chart of Accounts.
The opening balance is recorded as a journal entry in the account register. Here’s how to find it:
Note: If you recently added older transactions dated before the opening balance, reconcile those transactions first before continuing.
Once you’ve located the opening balance, compare it with the actual balance for the same date on your bank or credit card statement.
During the first reconciliation, the opening balance should be the only reconciled entry. Other transactions should not have an R status. To verify this:
Once the opening balance and register are corrected, the beginning balance on your reconciliation screen should match your bank statement. You can then proceed with the reconciliation.
Next step: If QuickBooks still shows an incorrect beginning balance after you’ve completed these checks, you’ll need to review the issues that can affect accounts that have already been reconciled.
Now that you know how to fix issues when reconciling an account for the first time in QuickBooks Online, it’s time to look at what you can do when the numbers don’t match at the end of a reconciliation. Let’s walk through the checks you can make to find and resolve the difference.
Struggling to Reconcile Your QuickBooks Online Account?
Having trouble reconciling your account, fixing a beginning balance, or resolving reconciliation discrepancies in QuickBooks Online? Contact us today for expert QuickBooks support and get your accounts reconciled accurately and with confidence.
When you reconcile an account in QuickBooks Online, the ending balance should match the balance on your bank statement, leaving a difference of zero. If the numbers don’t match, work through the following checks before finishing the reconciliation.
Start by confirming that your reconciliation began with the correct numbers.
Next, check whether the ending balance and date entered in QuickBooks match your bank statement.

If the difference remains, move on to the next step.
Your bank may sometimes combine several payments into a single transaction. If QuickBooks has recorded those payments separately, the balances may not line up.
If the difference is still there, continue to Step 4.
Once you’ve confirmed the opening, beginning, and ending balances, narrow down the remaining transactions that could be causing the difference.
If the balances still don’t match after these checks, continue investigating the remaining transactions in the reconciliation.
If transactions appear on your bank statement but aren’t recorded in QuickBooks, they can prevent your reconciliation from balancing. First, make sure all downloaded transactions have been reviewed and categorized. Follow the steps given below:


Note: If needed, select the appropriate account and save the change.
Once you’ve reviewed your records carefully, compare them with your bank statement and look for transactions that haven’t been recorded in QuickBooks.
Once you’ve compared the transactions in the Reconciliation window with your bank statement, you may find entries in QuickBooks that don’t appear on the statement. Before removing or changing anything, verify whether the transaction belongs to an earlier statement period.
If the transaction wasn’t part of a previous reconciliation, review its status in the account register and mark it as reconciled if appropriate.

In case you find the transaction on a previous reconciliation report, check whether it was entered more than once before making any changes.
If the QuickBooks balance still doesn’t match your bank statement, continue to the next troubleshooting step.
Sometimes, a transaction in QuickBooks may look like the one on your bank statement but have a slightly different amount. Before changing anything, review the transaction carefully and consult your accountant if you’re unsure about the correct adjustment. Avoid editing transactions, such as invoices, that have already been paid by customers.
A common reason for a small difference is a bank or processing fee that was added after the original transaction was recorded in QuickBooks. If your bank statement includes such a fee, you can record it separately.
If you’ve reviewed your QuickBooks records and still can’t find the source of the difference, the issue may be with your bank or credit card statement. Review the statement carefully and contact your financial institution if you find a discrepancy.
Ending balance issues are only one part of the reconciliation process. Next, let’s look at what can cause the beginning balance to change after a previous reconciliation.
If the beginning balance doesn’t match when you start a new reconciliation in QuickBooks Online, something may have changed in the account since your last reconciliation. The beginning balance should match the previous reconciliation’s ending balance. If it doesn’t, you’ll need to identify and resolve the difference before continuing.
Before troubleshooting, understand the common causes that trigger this issue.
A beginning balance can change when something is altered in your account after a previous reconciliation. Here are some common reasons:
Now that you understand the causes, let’s take a quick look at the troubleshooting steps to get rid of beginning balance issues after a previous reconciliation in QuickBooks Online.
Tip: Note the exact amount of the beginning balance difference before you begin. The changes you identify should add up to this amount.
Go through the report one transaction at a time to identify what changed and determine the right correction.
Before making any corrections:
If the report doesn’t show anything but your beginning balance is still off, check for changes that may not appear in the report.
Open Settings and select Audit log. Filter the results by the account and the period since your last completed reconciliation. Look for any transactions that were deleted or voided during this time.
Once you’ve addressed the discrepancies, the Total discrepancy difference should show $0.00. The changes you identified should also equal the difference you recorded in Step 1. At this point, your beginning balance should match the bank statement, and you can continue with the reconciliation.
If you still run into problems, review fix issues the first time you reconcile an account in QuickBooks Online. If the balance remains incorrect after completing these checks, consider working with Bookkeeper to resolve the difference.
In case you want to change the beginning balance in QuickBooks Online, go through the next section.
If your beginning balance doesn’t match, you’ll need to identify the underlying discrepancy and correct the transactions causing the difference before continuing. Here are the steps:
Before jumping into the reconciliation process, first verify the account’s opening balance. Quickly check the dates and amounts. This gives you a reliable starting point for fixing the beginning balance in QuickBooks Online.
Check the beginning balance in QuickBooks Online with your bank records to identify any differences.
After recording the opening balance in QuickBooks, compare it with the actual balance in your bank records.
When reconciling an account for the first time, check the register to make sure no other transactions have been incorrectly reconciled.
Following these steps can help you identify the cause of a beginning balance issue after a previous reconciliation and correct the balance in QuickBooks Online without affecting the rest of your reconciliation history.
If you find transactions dated before the opening balance, you may need to reconcile those older transactions separately. This helps bring the account records in QuickBooks Online in line with your actual bank or credit card statement.
If you recently added transactions dated before the opening balance, you may need to review and adjust it before reconciling the account. The opening balance represents when QuickBooks starts tracking the account and summarizes transactions recorded before that date. When older transactions are added later, the original opening balance may no longer reflect the account history accurately.
This can happen when QuickBooks has limited historical transactions available after you first connect an online bank account. The good news is that there are two ways to handle this and we’ll now show you how to get this done.
You don’t necessarily need to enter every older transaction when setting up an account in QuickBooks. The opening balance already represents the account’s balance before you began tracking transactions in QuickBooks, so you can leave it unchanged and focus on recording transactions from your chosen starting date onward.
When creating an account, choose the date from which you want QuickBooks to begin tracking activity and enter the corresponding balance from your actual bank account for that date. Setting the opening balance at the start of a bank statement can also make your first reconciliation easier and more straightforward.
When you need to include transactions from before your current opening balance, you’ll first need to update the opening balance date and amount. This gives QuickBooks the correct starting point and helps prevent older transactions from being counted twice.
Note: Adding older transactions is usually easier before you complete your first reconciliation. You can still add them after several reconciliations, but you may need assistance from your accountant to avoid affecting previously reconciled records.
This updates the account’s opening balance to match your bank records, giving QuickBooks the correct starting point and keeping the account properly balanced. Now all you need to do is reconcile the account.
Once the opening balance reflects the correct date and amount, you can move on to reconciling the account. If you encounter issues during your first reconciliation, review the troubleshooting steps for a first-time reconciliation. For accounts you’ve reconciled before, use the relevant steps for resolving reconciliation issues.
Once the older transactions are added and the opening balance is updated, the account should be ready for reconciliation. Matching the opening balance with your bank records helps QuickBooks start from the correct point and makes it easier to keep future reconciliations accurate.
Reconciling your QuickBooks Online account doesn’t have to feel like a monthly hunt for a missing dollar. Once you know where to look, most reconciliation issues can be traced back to a few common causes, such as incorrect opening or beginning balances, missing transactions, duplicates, timing differences, or changes made after a previous reconciliation.
The key is to work through each difference carefully rather than making quick adjustments just to reach a zero balance. QuickBooks Online’s AI-powered reconciliation can also help by highlighting transactions and differences that need your attention.
With your balances checked, transactions reviewed, and discrepancies resolved, you can finish each reconciliation with greater confidence. And when an issue affects a previously reconciled period, don’t hesitate to involve your accountant before making changes.
Think of reconciliation as a financial cross-check between your accounting records and your actual bank or credit card activity. Even when transactions are imported automatically, differences can still occur because of timing, duplicate entries, manually entered transactions, or transactions that have not yet cleared the account.
To reconcile for the first time in QuickBooks Online, open All apps > Accounting > Reconcile and select the bank or credit card account. Enter the statement ending date and ending balance, then review the transactions and select the ones that appear on your bank statement. Check the Difference and resolve any missing, duplicate, or incorrect transactions. When the difference reaches $0, complete the reconciliation.
Yes. QuickBooks Online lets you undo a reconciliation either all at once or manually, transaction by transaction. The full undo option is available to primary admins, in-house accountants, and users of QuickBooks Online Accountant. Follow these steps:
1. Go to All apps > Accounting > Reconcile.
2. Select History by account.
3. Choose the account and date range.
4. Find the reconciliation you want to undo.
5. Select Undo from the Action column.
6. Check the box acknowledging the consequences.
7. Select Undo reconciliation.
No. QuickBooks does not fully automate bank reconciliation from start to finish, although it can automate several steps involved in the reconciliation process.
If your opening balance is incorrect or missing, you can correct it with a journal entry. First, check whether an Opening Balance Equity entry already exists.
A. Check for an Existing Opening Balance
1. Open All apps, select Accounting, then Chart of accounts.
2. Find the bank or credit card account and select View register.
3. Look for an entry with Opening Balance Equity as the payee. If you find one, edit it instead of creating a new journal entry.
B. Create the Journal Entry
1. Select + Create or +New, then choose Journal entry.
2. Set the date before the account’s oldest transaction.
3. On Line 1, select the bank or credit card account and enter the difference as a Debit or Credit, as appropriate. Add a note such as “Opening Balance.”
4. On Line 2, select Opening Balance Equity. QuickBooks will automatically balance the entry.
5. Select Save and close.
C. Reconcile the Journal Entry
Return to the account register, find the journal entry, and mark it R if needed for the initial setup. Otherwise, continue with your regular reconciliation.
QuickBooks may show a reconciliation difference even when your current transactions appear correct because something changed in previously reconciled data. Common causes include:
1. Edited or Deleted Transactions: When we change, void, or delete a reconciled transaction.
2. Incorrect Balance: When the beginning or ending balance is incorrect.
3. Duplicate or Missing Transactions: When transactions are duplicate or missing during bank feed imports.
4. Date Differences: Transaction dates don’t match the dates on your bank statement.
5. Future-Dated Transactions: Cleared transactions fall after the statement closing date.
6. Unlinked Journal Entries: When payments or deposits are linked to the wrong journal entry.
On this page
Have a QuickBooks® question? Our ProAdvisors can help. QAsolved is not affiliated with Intuit.