How to Reconcile a Bank Account in QuickBooks After Importing a Statement
After you import a statement into QuickBooks, reconcile by setting the beginning balance, entering the statement ending balance and date, then checking off each imported transaction until the difference is zero. The most common error is double counting (the same transaction entered twice from a bank feed and an import), so clear that before you reconcile.
Importing is not reconciling
Two separate steps get confused all the time. Importing puts transactions into QuickBooks. Reconciling proves that what is in QuickBooks matches what the bank actually processed. You can import a perfect file and still have a register that does not agree with the statement, usually because of timing, duplicates, or a wrong beginning balance.
If you convert your bank's CSV or Excel export into a QBO file with QBO Maker and import it through File > Utilities > Import > Web Connect Files (QuickBooks Desktop) or the Upload from file option under Bank transactions (QuickBooks Online), the transactions land in the bank feed or register. Reconciliation is the next, separate task, and it is what catches mistakes.
Step 1: Review and post the imported transactions first
Do not reconcile straight from a pile of unreviewed transactions. In QuickBooks Online, open Bank transactions (formerly Banking) and work the For Review tab. Accept matches QuickBooks suggests, categorize the rest, and add them to the register. In QuickBooks Desktop with Web Connect, accept or match items in the Bank Feeds center.
Only transactions that have been added to the register can be reconciled. Anything still sitting in For Review will not appear in the reconcile window, which is a frequent reason the difference will not hit zero.
Step 2: Open Reconcile and confirm the beginning balance
In QuickBooks Online go to Settings (gear) > Reconcile. In QuickBooks Desktop go to Banking > Reconcile. Pick the correct account.
QuickBooks fills in the Beginning balance automatically using the ending balance from your last reconciliation. Compare it to the beginning balance printed on the statement you are working from. If they match, continue. If they do not match, stop. A wrong beginning balance means a prior period was changed, deleted, or never reconciled, and no amount of checking boxes in the current period will fix that. Resolve the prior period first.
Step 3: Enter the statement ending balance and date
Type the Ending balance exactly as it appears on the bank statement, and enter the Statement ending date. These come from the bank, not from QuickBooks. Reconciliation works by comparing the bank's stated ending balance to the sum of everything you check off, so an incorrect ending balance guarantees the difference will never reach zero.
Enter any bank service charges or interest earned in the fields provided (QuickBooks Desktop) or as separate transactions before reconciling (QuickBooks Online), so they are accounted for.
Step 4: Match the register to the statement, line by line
Now check off each transaction in QuickBooks that also appears on the statement. Work down the statement and find the matching line in the reconcile window. Watch the Difference figure in the corner; the goal is 0.00.
- On the statement but not in QuickBooks: the import missed it. Add it, then check it off.
- In QuickBooks but not on the statement: usually a deposit in transit or an uncleared check (timing). Leave it unchecked. It will clear next period.
- Amounts off by a few cents: often a rounding or sign issue in the original file. Fix the transaction.
When the difference is 0.00, select Finish now. If it will not zero out, the cause is almost always a duplicate, a missed transaction, or a wrong beginning or ending balance, in that order of likelihood.
Avoiding double counting (the number one cause of a failed reconcile)
Double counting happens when the same real-world transaction lands in QuickBooks twice. The usual sources:
- Bank feed plus manual import. If a bank feed is connected and you also import a CSV/QBO covering the same dates, every overlapping transaction appears twice.
- Re-importing the same file. Uploading the same statement export a second time re-adds everything.
- Manual entry plus import. Someone keys a check that the import also brings in.
How to prevent and fix it:
- Pick one source per account. Either rely on the bank feed or import files, not both, for the same date range.
- Mind the date overlap. When you convert a statement, trim or pick a date range that starts the day after your last import ends. QBO Maker shows the transactions before you download, so you can confirm the range.
- Find duplicates before reconciling. Sort the register or the For Review list by date and amount; identical pairs stand out. In QuickBooks Online, use Exclude for items still in For Review, or delete the duplicate from the register if it was already added.
- Never delete a transaction that is already reconciled just to remove a duplicate without checking the balance. Deleting a cleared item throws off the beginning balance of the next period. Identify the correct one to keep first.
A clean import is the easiest way to avoid all of this. Because QBO Maker runs in your browser and lets you preview the rows before download, you can confirm dates and amounts and rule out overlap before anything touches QuickBooks.
If a reconciliation went wrong
If you finished a reconcile that included duplicates or a bad balance, you can undo it. In QuickBooks Desktop, go to Banking > Reconcile > Undo Last Reconciliation. In QuickBooks Online, an accountant user can undo a reconciliation from the reconciliation history, or you can manually clear the affected transactions. After undoing, clean up the duplicates, confirm the beginning balance, and reconcile again from a known-good starting point.
Frequently asked questions
Do I have to reconcile after every import?
Reconciling after each statement is the safe habit. It is the only step that proves the imported data actually matches the bank, and reconciling regularly (monthly, or even weekly for busy accounts) catches duplicates and missing transactions while they are still easy to fix.
My beginning balance does not match the statement. What now?
That means an earlier period was edited, deleted, or never reconciled. Do not adjust the current period to compensate. Find and fix the prior change first (QuickBooks has a beginning-balance discrepancy report to help), then reconcile the current statement.
How do I tell a duplicate from a real second transaction?
Compare date, amount, and payee. Two charges to the same vendor on the same day for the same amount can be legitimate, so check the bank statement: if the statement shows the transaction once but QuickBooks shows it twice, one is a duplicate. Keep the one tied to a match or a posted entry and remove the other.
Will importing a file again create duplicates?
Yes. Importing the same statement export a second time re-adds every transaction in it. Import each date range once, and when you convert a new statement, start the range the day after your previous import ended.
Can QBO Maker reconcile for me?
No. QBO Maker converts your bank's CSV or Excel export into a QBO, QFX, or OFX file that QuickBooks can import. Reconciliation happens inside QuickBooks. A clean, correctly dated import file makes reconciliation faster because there is less to fix.