How to reconcile in QuickBooks Online

Before you open the screen

Two things need to be true before reconciling is worth starting. The statement for the period has to be in front of you, as a document, not as a balance somebody read out. And the transactions for the period have to be entered and categorized already, which Intuit lists as a prerequisite rather than a suggestion. Reconciling is a check against an independent record. 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.

The steps

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.

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.

Reading a difference that won’t clear

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. 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.

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.

Things that make a reconciliation worse

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.

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:

$99 per month of backlog

If the accounts are accurate and simply behind, that is catch-up rather than cleanup, and it is priced differently. Both are on the pricing page.