How to reconcile in QuickBooks Online: open Reconcile under Accounting, pick the account, enter the statement’s ending balance and ending date, check off every transaction that appears on the statement, and finish when the Difference reads $0.00. Reconciled means the books and the bank agree for that period. It does not mean every transaction sits in the right account, only that nothing is missing or doubled.
This guide is for owners who keep their own books and have either never reconciled or have a beginning balance that refuses to match. You will get the exact steps, what a finished reconciliation proves and what it does not, the three failures that cause almost every stuck reconciliation, and the Xero version. This is the check we run on every account, every month, for every client at Books LA.
What reconciled really proves
A reconciliation compares two lists: the transactions in QuickBooks and the transactions on the bank statement. When the ending balances agree and every line has a match, three things are true. Nothing on the statement is missing from the books. Nothing in the books is missing from the statement. And no transaction appears twice. That is the whole claim, and it is a strong one. Most bookkeeping errors show up as one of those three.
What it does not prove is that each transaction sits in the right account. A $1,200 charge coded to Office Supplies instead of Equipment reconciles perfectly. So a reconciled account is the floor, not the ceiling. The coding review in the monthly bookkeeping close is the next layer, and the free DIY monthly close checklist puts both on one page.
How to reconcile in QuickBooks Online, step by step
These steps follow Intuit’s own reconciliation article, checked in October 2026. Menu names move, so if a path does not match your screen, search “Reconcile” inside QuickBooks.
- 1. Prepare. Have the statement open. Make sure every transaction for the period is categorized or matched in the bank feed. Anything still “For review” will not appear in the reconciliation, which is the most common reason the numbers do not tie.
- 2. Open the tool. Go to All apps, then Accounting, then Reconcile. First time on an account, select Get started.
- 3. Choose the account from the dropdown.
- 4. Check the last statement ending date. Your current statement should begin the day after it. If there is a gap, reconcile the missing period first.
- 5. Enter the ending balance and ending date exactly as printed on the statement. Then select Start reconciling.
- 6. Confirm the beginning balance matches the statement’s opening balance. If it does not, stop here and read the next section. Matching transactions on top of a wrong beginning balance wastes the hour.
- 7. Match transactions. Work down the statement and check the box for each matching line in QuickBooks. The Cleared balance moves as you go.
- 8. Finish at $0.00. When the Difference shows $0.00, select Finish now, then Done. If it does not, do not force it. Find the difference first.
- 9. Keep the report. QuickBooks saves a reconciliation report under History by account on the Reconcile page. Lenders, investors, and CPAs ask for these reports.
The adjusting entry trap
One warning. If you cannot find the difference, QuickBooks offers to finish anyway and create an adjusting entry. Intuit’s own advice is to talk to your accountant before doing that. We would put it more plainly: never accept the adjustment. It hides the error instead of fixing it, and it comes back at year-end with interest.
Failure one: the beginning balance is wrong
The beginning balance should equal the ending balance of the last reconciliation. When it does not, QuickBooks shows an alert with a link, “We can help you fix it,” which opens the Reconcile Discrepancy Report. Per Intuit’s fix-it article, that report lists every change to a previously reconciled transaction and how it moved the balance.
If the account has never been reconciled, the cause is usually the opening balance entered when the account was created. Compare that entry to the bank statement from the day before you started tracking the account in QuickBooks. Correcting it often means a journal entry dated before the oldest transaction. This is a fair place to ask your accountant to look before you post it.
Failure two: a reconciled transaction was edited or deleted
Someone changed an amount, moved a transaction to another account, voided it, or deleted it after the month closed. The beginning balance shifts by exactly that amount. The Discrepancy Report shows what changed and offers to fix each item; Intuit’s caution is to only fix a change that was made in error. Deleted and voided transactions also appear in the audit log under Settings.
The prevention is a closing date. After each reconciliation, set the closing date in Account and settings so that changes to a closed period require a password. Reopened months are how a clean file turns into a catch-up project.
Failure three: timing differences
A check written on the 29th that clears on the 3rd. A deposit made on the 31st that posts on the 1st. These are not errors. They are transactions in the books that have not reached the statement yet, and they should stay unchecked this month and get checked next month. The trap is “fixing” them: changing the date to make the month tie, or deleting and re-entering. Both create the failure above. Leave the transaction alone and reconcile it when it clears.
If a transaction stays outstanding for more than two or three months, it is a real question. A check that never cleared, a deposit that never arrived, or a duplicate entry. That is the moment to look, not to adjust.
The Xero version
Xero works the other way around. Statement lines come in through the bank feed, and you match each one to a transaction in Xero or create one. The account is reconciled when the statement balance in Xero equals the balance on the bank’s statement and no lines are left unreconciled. The same three failures apply, with one extra: a feed that stopped and was reconnected leaves a gap of missing statement lines that has to be imported before the balances can agree. Our post on fixing a broken bank feed covers that gap for both products.
After the reconciliation
Once every account ties, read the reports. The balance sheet should show the reconciled cash balance, and the profit and loss should finally be worth reading. Our guide to monthly financial reports lists the lines to check. If reconciling one month turned up six months of problems, that is a catch-up project, and the catch-up bookkeeping cost guide explains what it involves.
How Books LA handles this
We reconcile every bank, card, loan, and processor account to its statement each month, to a near zero variance, and we lock the period afterward. When a beginning balance moves, we find the change in the Discrepancy Report and the audit log before anything else happens in the file. If you have an account that has never reconciled, a $495 bookkeeping review will show what it will take. Our Los Angeles bookkeeping services guide explains what the monthly service includes.
Frequently asked questions
How often should I reconcile in QuickBooks Online?
Monthly, as soon as each statement arrives, for every bank, credit card, loan, and payment processor account. Reconciling quarterly works but makes each difference three times harder to find. Weekly is overkill for most small businesses unless cash is tight.
Why does my beginning balance not match in QuickBooks?
Because a transaction that was reconciled in an earlier month was later edited, deleted, voided, or moved, or because the account’s opening balance was entered wrong. The Reconcile Discrepancy Report, reached from the alert on the Reconcile page, lists the changes and their effect on the balance.
What do I do if the difference is not zero?
Do not finish. Check for transactions still in the bank feed’s For review tab, duplicates, items posted to the wrong account, and amount or date typos. Compare the Cleared balance to the statement. Accepting QuickBooks’s adjusting entry hides the problem rather than solving it.
Can I undo a reconciliation in QuickBooks Online?
You can unreconcile individual transactions from the register, and an accountant user can undo an entire reconciliation. Undo only when the reconciliation itself was wrong, then redo it from the statement. Undoing to make a current month tie usually creates the next discrepancy.
Does reconciled mean my books are correct?
It means nothing is missing or doubled against the bank. It does not check whether each transaction is in the right account or whether a deposit was counted as income twice. Those are separate checks in the monthly close that come after the reconciliation.
Should I reconcile credit cards and loans too?
Yes. Every account with a statement gets reconciled: credit cards, lines of credit, term loans, and payment processors such as Stripe or Square. Loan balances on the balance sheet should match the lender’s statement each month, including the split between principal and interest.
How is reconciling different in Xero?
Xero matches imported statement lines to transactions, rather than checking boxes against a statement total. The account is reconciled when the statement balance in Xero agrees with the bank and no lines are unreconciled. Import any gap from a broken feed first.
If an account has never tied and you want a second set of eyes, book a short call and we will look at the beginning balance with you.
This post is general information, checked against Intuit’s help articles in October 2026. Screens and menu names change. Books LA provides bookkeeping services and does not advise on income tax.
