How to reconcile in QuickBooks Online

What reconciling in QuickBooks means

Reconciling in QuickBooks means proving that the balance QuickBooks shows for an account matches the balance on the statement from the bank, card issuer or lender, transaction by transaction, as of the statement date. When the Difference on the reconcile screen reads 0.00, every transaction in the period is accounted for, and the report is saved as proof.

Why it is worth doing every month:

• It finds what never reached QuickBooks: bank fees, interest, a deposit made from a phone.
• It finds duplicates, which usually arrive after a bank feed reconnection or an import that overlapped the feed.
• It catches charges nobody in the business made, while there is still time to dispute them.
• It makes the Profit and Loss and balance sheet true before a lender or the CPA relies on them.
• It fixes a starting point: each reconciliation ends on the balance the next one begins with.

Reconcile every account that gets a statement: checking and savings, every credit card, lines of credit and loans, and clearing accounts for PayPal, Stripe or Square where the provider issues one. Cards and loans have a few differences, covered below.

Before you start: a reconciliation checklist

1. The statement for the period, as a document (PDF or paper), not a balance read off the banking app.
2. Every transaction for the period entered and categorized, including anything still in the bank feed’s For review tab.
3. The Last statement ending date from the Reconcile screen, so you know which statement comes next.
4. The ending balance of the last reconciliation, to compare with the new statement’s beginning balance.

Intuit lists the second item as a prerequisite rather than a suggestion. Reconciling is a check against an independent record (see our foundational guide to bank reconciliation explained for the underlying formula). It is not a place to enter transactions you have not entered yet.

If the account is connected to a bank feed, work through the downloaded transactions first. The feed is how transactions get into the file; the reconciliation is the later test of whether what got in matches what the bank says happened. Doing them in the other order means discovering the feed created duplicates at the point where they are hardest to unwind.

How to reconcile a bank account in QuickBooks Online

In five steps:

1. Open All apps, then Accounting, then Reconcile.
2. Choose the account and check the Last statement ending date.
3. Enter the Ending balance and Ending date from the statement.
4. Tick each transaction that appears on the statement until the Difference reads 0.00.
5. Select Finish now and keep the report.

Each step, in more detail. Go to All apps, then Accounting, then Reconcile. If it is the first reconciliation in the file, there is a Get started button before anything else appears.

Choose the account from the dropdown. Check the Last statement ending date shown above the entry fields: the statement you are about to reconcile should begin the day after it. If it does not, you either have the wrong statement or a gap in the history, and both are worth resolving before going further.

Enter the Ending balance and Ending date, copied from the statement rather than from the QuickBooks register. This is not a formality. Typing the register balance into the field that is supposed to hold the independent figure turns the entire exercise into a test of whether QuickBooks agrees with itself, which it always will.

Select Start reconciling. QuickBooks shows the account’s transactions next to what you are matching against. Tick each one that appears on the statement. As you go, the Cleared balance moves and the Difference shrinks. When the Difference reads $0.00, select Finish now, then Done.

The reconciliation report is saved automatically. It is retrievable afterwards from the Reconcile page under History by account, which is also where an undo lives if one is ever needed.

How to re-reconcile a month that was already reconciled

QuickBooks Online does not reopen a completed reconciliation for editing. Before reconciling a month again, check whether it needs it, because the two fixes are sized very differently.

If a few transactions in the month were wrong, the month usually does not need redoing. Unreconcile just those in the register (the steps are further down this page), correct them, and tick them again in the next reconciliation. The month’s report stays in the history. If the month itself was wrong, because it was finished against the wrong statement balance or forced to zero with an adjustment, undo it from History by account and reconcile it again from the statement. That undo also removes every reconciliation completed after it, so count how many later months it takes with it before you start.

What the beginning balance is telling you

The beginning balance is the most useful number on the screen and the one people skip past.

For an account that has been reconciled before, QuickBooks expects it to equal the ending balance of the last completed reconciliation. When it does not, something that was part of a closed period has been edited, deleted, voided, or unreconciled since. Intuit’s own troubleshooting names those as the causes, along with an incorrect opening balance on the account itself.

A wrong beginning balance is not fixable inside the current reconciliation. Clicking more transactions will not resolve it, and forcing the current month to zero on top of it buries the original break one period deeper. Stop and work backwards instead: a bank balance that won’t reconcile covers finding the period the break actually happened in.

Matching is a judgment, not a checkbox

For each transaction on the statement, find the transaction in QuickBooks that represents the same real-world event, and confirm the date, the amount, the payee, and the account before ticking it.

The distinction that matters: the goal is to tick everything that appears on this statement, not everything that looks familiar. Two $250 payments to the same vendor in the same week are not interchangeable, and clearing the wrong one leaves a correct transaction sitting unreconciled where it will confuse next month.

On an account connected to a bank feed, some transactions can arrive already ticked, and Intuit notes the account may show as balanced before you have done anything. Treat those ticks as suggestions. Scan the ticked list for anything that is not on this statement, such as a payment dated in the next period, before selecting Finish now.

AI-powered reconciliation: what the statement upload does

QuickBooks Online Plus, Advanced and Intuit Enterprise Suite can read the statement for you. On the Reconcile screen, select Upload (or use Statement Auto Import) and choose the statement file. QuickBooks reads the ending balance and ending date and fills them in; Intuit says verifying the file can take up to an hour. Then select Start reconciling and open the Insights tab, which sorts the period into three lists:

List on the Insights tab	What it means	What to do
Paired transactions	In QuickBooks and matched to a line on the statement	Confirm, as you would a manual tick
Transactions in bank feed needs review	On the statement, still in For review, so not in the books	Categorize or match them in Bank transactions, then come back
Extra transactions in QuickBooks	In the books, not on the statement	An outstanding check or deposit in transit stays uncleared; a duplicate gets removed (check its reconciled status first); a wrong date gets fixed

Intuit lists the usual reasons for an extra transaction as timing differences, duplicate entries, manual entries, and transfers or deposits that have not cleared. Telling those apart is the part the upload does not do. An extra $250 payment might be a check the vendor has not cashed, which should be left alone, or the second copy of one that cleared, which should be deleted. Only someone who knows the business can say which.

What the upload does well is the comparison, which is the slow part, and it removes the most common error on the screen: a mistyped ending balance. Because that balance comes from the statement itself, the check stays independent, which matching the bank feed alone never is. It does not repair a beginning balance broken by an edit to an earlier month, and it is optional: typing the figures in is still the standard method on every plan.

Why won’t my QuickBooks reconciliation balance?

A difference is a diagnostic, not an obstacle. If it is $250, there is a reason it is $250, and posting an adjustment to make the screen say zero destroys the information without fixing anything. Work through the causes in this order, because it runs cheapest first.

Check the statement date and ending balance you entered. This is the most common error and takes ten seconds to rule out: select Edit info at the top of the reconcile screen to see both and correct them. A wrong ending date makes a perfectly correct set of transactions look wrong.

Look for a missing transaction. If something on the statement is not in QuickBooks, decide whether it was never entered or is still sitting in the bank feed. For a connected account, go to All apps, then Accounting, then Bank transactions, and check the review queue, the excluded list, and anything categorized to an account you did not expect.

Look for a duplicate. Duplicates distort the register without always producing an obvious symptom, and they cluster after a bank reconnection, a manual import that overlapped the feed, or a downloaded transaction that was added instead of matched. Duplicate transactions from a bank feed covers removing them safely, which matters because some of them will already be reconciled.

Check transaction dates. A payment that cleared the bank on September 30 and was entered in QuickBooks as October 1 lands in the wrong statement period. The transaction is what is wrong, not the reconciliation.

Check the beginning balance again. If the current reconciliation opens on a different figure than the last one closed on, the problem is historical and the current month cannot resolve it. QuickBooks Online produces a Reconcile Discrepancy report for exactly this, listing what changed and when.

Look for a reconciliation that was forced. If a prior period was closed with an unexplained adjustment, the current period inherits it. Trace back to the earliest month where the balances stop agreeing rather than treating this month as an isolated event.

Forced months are easy to find. When a reconciliation is finished with a difference and Add adjusting entry is selected, QuickBooks records an expense transaction (or an income transaction, if the difference was positive) with Reconcile Adjustment in the memo. Open Search, then Advanced Search, choose All Transactions, and search for a memo that contains “Reconcile”. Each result is a month somebody forced, and its amount sits in the Profit and Loss as if it were a real expense or real income.

Check, in this order	What it rules out	Where to look
Statement date and ending balance	A typo in what you entered	Edit info on the reconcile screen
Missing transaction	Something on the statement that is not in QuickBooks	Review queue, excluded list, unexpected accounts
Duplicate	The same transaction recorded twice	The register, after a reconnection or an overlapping import
Transaction dates	An entry in the wrong statement period	The date entered against the date it cleared
Beginning balance	A change to a period already reconciled	The Reconcile Discrepancy report
A forced reconciliation	An adjustment inherited from an earlier period	Advanced Search, memo contains “Reconcile”

Reconciling a credit card, loan or line of credit

The steps on the Reconcile screen are the same. Three things are different.

The balance is a debt. Enter the statement’s new balance, the amount owed on the closing date, as the ending balance. Not the minimum payment, and not the available credit.

A payment to the card is a transfer, not an expense. It is one transaction that lowers the checking balance and the card balance together. Recorded as an expense, it counts the month’s spending twice: once when each charge was categorized and again when the bill was paid. When the card and the checking account both have bank feeds, the payment downloads into both. Record it as a transfer in one feed and match it in the other, rather than adding it twice.

Loans rarely have a feed. Reconcile a loan or line of credit against the lender’s statement whenever one arrives, and at least at year end before the CPA asks. Each payment splits between principal, which lowers the loan balance, and interest, which is an expense; the lender’s statement or amortization schedule gives the split. A loan balance that never moves usually means every payment was posted to interest or to an expense account.

How to reconcile a vendor statement in QuickBooks Online

A vendor statement is not reconciled on the Reconcile screen. That screen proves a bank or card balance; a vendor statement is checked against what QuickBooks says you owe that vendor, using reports.

Run Vendor Balance Detail (or A/P Aging Detail) for the vendor, dated the statement date, and put it next to the statement. Every open invoice on the statement should appear as an open bill, and the two totals should agree. When they do not, the gap is almost always one of four things:

What you see	Usual cause	Fix
A bill open in QuickBooks the vendor shows paid	The payment was recorded as an expense or check instead of through Pay bills	Link the payment to the bill, and remove the duplicate expense
An invoice on the statement with no bill	The bill was never entered	Enter it with the vendor’s invoice date and number
A credit on the statement not in QuickBooks	A return or credit memo was never recorded	Enter a vendor credit and apply it to the bill it relates to
Totals differ by a payment in transit	The vendor had not received or posted the payment by the statement date	No entry; confirm it appears on the next statement

The first row matters most. A payment recorded as an expense counts the cost twice on the Profit and Loss and leaves the bill open forever. The accounts payable journal entry guide covers how bills and bill payments are meant to post.

Unreconciling one transaction, without unwinding the month

If a single transaction was cleared by mistake, there is no need to undo the whole reconciliation. Go to All apps, then Accounting, then Chart of accounts, find the account, and select View register. Locate the transaction, select it to expand it, then select the box in the checkmark column repeatedly: the status cycles from R for reconciled, to C for cleared, to blank.

Intuit describes this as removing a transaction from a reconciliation, which is precisely what it is. It changes that transaction’s status and nothing else, and it will change the beginning balance of the next reconciliation, so it is not free. Undoing an entire reconciliation is a much larger operation with consequences worth understanding first: how to undo a reconciliation in QuickBooks Online.

This is Online, not Desktop

The accounting is identical and the software is not. QuickBooks Desktop has its own reconcile window, its own discrepancy report, and its own way of handling a prior-period change. Following a Desktop walkthrough inside QuickBooks Online because the vocabulary matches is a reliable way to spend an hour looking for a menu that does not exist. If the file is being migrated from Desktop to Online, the reconciliation history is one of the things worth verifying after the conversion rather than assuming it carried across intact.

Common QuickBooks reconciliation mistakes

Posting an adjustment to reach zero hides the cause and moves it into next month’s beginning balance. Deleting a legitimate outstanding payment removes a real transaction to solve a timing difference. Adding a bank feed transaction that already exists in the register creates a duplicate. Changing a date without evidence relocates the problem instead of fixing it. Undoing several reconciliations at once expands a small repair into a large one.

A reconciliation is a control. It works when it is used to find out what happened, and it stops working the moment it is used to make a screen agree.

Common questions about QuickBooks reconciliation

Do I need to reconcile in QuickBooks every month?

Yes, once a month, as soon as each statement arrives. QuickBooks does not force it, but every month skipped makes the next one harder: an error found in a month reconciled last week takes minutes to trace, and the same error found a year later can take a cleanup. Every account with a statement gets reconciled, not just checking.

Does QuickBooks reconcile automatically?

No, though it can look that way. On a connected account, transactions matched from the bank feed can arrive already ticked, and the screen may read 0.00 before anyone has looked. The feed is the bank’s data copied into QuickBooks, so it cannot prove itself. A reconciliation needs the ending balance from the statement and a decision about each tick. The AI statement upload on Plus and Advanced reads that balance from the statement for you, but a person still decides what each unmatched item is.

Can I reconcile manually in QuickBooks Online?

Yes. Manual is the standard method and works on every plan: type the ending balance and ending date from the statement, then tick each transaction. The AI-powered statement upload is optional, available only on Plus, Advanced and Intuit Enterprise Suite, and it ends on the same screen with the same ticks to confirm.

Why won’t QuickBooks let me reconcile?

Usually one of three things. The ending balance or ending date is missing or wrong, which Edit info fixes. The transactions on the statement are still in the bank feed’s For review tab, so they are not in the register yet and cannot be ticked. Or the beginning balance no longer matches the statement because something in an earlier reconciled month was changed. That last one cannot be fixed on this screen: see a bank balance that won’t reconcile.

How long does a reconciliation take?

A few minutes per account when the books are current and the bank feed is reviewed every week: enter the balance, check the ticks, finish. It takes longer when the feed has piled up or months are behind, because each month has to be reconciled in order, from its statement, before the next can start. Several months that will not tie is a cleanup, not a long reconciliation.

How do I reconcile for the first time in QuickBooks Online?

On an account’s first reconciliation, the beginning balance is the opening balance the account was given when it was added to QuickBooks. Pick the statement whose beginning balance equals that figure, usually the first statement after the account’s start date, and reconcile forward one statement at a time from there. If the opening balance was never entered or is wrong, the first reconciliation will be off before you tick anything; fix it first, which opening balance equity covers.

When the file will not reconcile at all

Some files cannot be reconciled forward because the history underneath them was never right: months forced to zero, an opening balance nobody verified, or a stretch where nothing was reconciled at all. Those get fixed by walking back to the last period that genuinely tied and rebuilding from there, which is cleanup work scoped by how far back the break sits:

$99per month of backlog20% off 6+ months

If you cannot find the last period that genuinely tied, send the file for a free review before forcing anything.

If the accounts are accurate and simply behind, that is catch-up rather than cleanup. Both are the same rate, and both are on the pricing page.