Skip to content
Tutorials Center
My learning

Topics

Lesson 21 of 36 ยท Banking and Reconciliation

Reconciling a Bank Account

Reconcile a bank or credit card account in QuickBooks: enter the statement balance, tick off cleared items, fix a difference, and see the math with a runnable reconciliation stand-in.

A reconciliation proves that your QuickBooks account agrees with the bank's statement. Accepting bank-feed transactions is not enough: the feed can miss items, duplicate them, or show different dates. Reconciling is the control that catches those problems, and it is the single most valuable monthly habit in bookkeeping.

QuickBooks cannot run on this site. The steps below are for QuickBooks Online (the Desktop edition is very similar). The TryIts are JavaScript stand-ins for the arithmetic; they do not read a real statement.

The idea

The bank statement lists what the bank had processed by the statement date. Your books may contain items the bank has not processed yet (a check you wrote that has not been cashed, a deposit made on the last day). These are outstanding items. Reconciling means:

Beginning balance + cleared deposits - cleared payments = Statement ending balance

When that holds, the difference is 0.00 and the account is reconciled.

flowchart LR
    A["Beginning balance<br/>(last reconciliation)"] --> B["+ Cleared deposits"]
    B --> C["- Cleared payments"]
    C --> D{"Equals statement<br/>ending balance?"}
    D -- Yes --> E["Difference 0.00: Finish"]
    D -- No --> F["Find the error"]

The reconciliation equation.

Step by step

  1. Open Accounting > Reconcile (or Gear icon > Reconcile). Choose the account.
  2. Enter the Statement ending date and Ending balance exactly as printed. For a credit card, enter the balance owed. Check that the Beginning balance shown equals the previous statement's ending balance. If it does not, an earlier reconciled item was changed.
  3. Click Start reconciling. QuickBooks lists payments (checks and expenses) and deposits up to the statement date.
  4. Tick every item that appears on the statement with the same amount. The Difference at the top updates as you tick.
  5. When Difference is 0.00, click Finish now. Save or print the reconciliation report.

Items you leave unticked are the outstanding items. They appear on the next month's reconciliation.

If you use bank feeds, tick the items in the order of the statement, not the order in QuickBooks. Compare the count and total of ticked deposits and ticked payments against the statement summary, which usually prints both.

When the difference is not zero

Work through these causes in order, which finds most problems quickly:

  • Typo in the ending balance or in a transaction amount.
  • A transposed number: an error divisible by 9 (such as 45.00 instead of 54.00, a difference of 9.00) often means two digits were swapped.
  • A missing transaction: a bank fee, interest or an automatic payment never entered. Add it from the reconcile window (the Add option is under the transaction list) or from the bank feed.
  • A duplicate: the same transaction recorded twice, once manually and once from the feed.
  • A transaction in the wrong direction: a deposit entered as a payment doubles the error (the difference is twice the amount).
  • A changed or deleted reconciled item since last time. The Reconciliation discrepancy report (Reports) lists changes made to reconciled transactions.
JS Reconcile a month

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The outstanding items (DEP-33 and CHK-503) are exactly why your register balance at month end differs from the bank's balance: the register includes them, the statement does not.

JS Clues from the size of the difference

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Never force it

QuickBooks lets you click Finish now with a difference by creating an adjustment entry in Reconciliation Discrepancies. Do this only as a last resort for small amounts, and note why. A plug hides a real mistake and will confuse your accountant. If a difference is large, Undo the reconciliation (Reconcile page, History by account, Undo) and fix the cause.

Reconcile every bank, credit card and loan account each month, even quiet ones. Once reconciled, treat past transactions as locked: changing a cleared item breaks next month's starting balance. Your accountant can also set a closing date (see Month-End Close Checklist).

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. A check you wrote has not yet been cashed on the statement date. What is it called?

    Outstanding items are in your books but not yet processed by the bank; you leave them unticked until they clear.
  2. 2. Your difference is exactly 18.00. What is a likely cause?

    Differences divisible by 9 often come from swapped digits. 18.00 is divisible by 9, which makes a transposition worth checking.
  3. 3. Which equation must hold when you finish a reconciliation?

    The cleared items, not the whole register, must reproduce the statement ending balance. Outstanding items may remain.
  4. 4. Why is changing an already-reconciled transaction a problem?

    The beginning balance must equal the last statement's ending balance, and an edit to a cleared item shifts it.

Summary

  • Reconcile each account monthly against the statement.
  • Tick cleared items until the difference is 0.00; outstanding items carry forward.
  • Find causes in order: typos, transpositions, missing or duplicate items, wrong direction.
  • Do not plug differences, and do not edit reconciled transactions.

Next: Credit Cards, Transfers and Deposits