The short answer

To reconcile a bank account, take the month's bank statement and match every deposit and withdrawal on it to the transactions in your books, add anything the bank recorded that your books are missing, and investigate anything in your books that isn't on the statement. The account is reconciled when your cleared balance equals the statement's ending balance, with any remaining items explained by timing, such as a check that hasn't cleared yet.

To reconcile a bank account, match every transaction on the month's bank statement to your books, record what's missing, investigate what doesn't belong, and confirm that your cleared balance equals the statement's ending balance. Done every month, each reconciliation stays small, and it's the step that makes every report built on your books trustworthy.

This guide covers the general method, which works in any bookkeeping software or a spreadsheet, then the QuickBooks Online steps, the differences you'll usually find, and a worked example with made-up numbers.

What does a bank reconciliation prove?

A bank reconciliation proves that the cash balance in your books agrees with the bank's records for the same date, and that every difference between them has a known reason. The bank's statement is an independent record of what actually went in and out of the account, so matching your books to it catches errors that are invisible from inside the books.

It catches problems like:

  • a sale or expense that was never recorded;
  • the same transaction recorded twice, often once by hand and once from a bank feed;
  • an amount typed wrong ($1,280 entered as $1,820);
  • a transaction recorded in the wrong account or the wrong month;
  • bank fees, interest and automatic payments nobody entered;
  • charges you don't recognize, which may need a call to the bank.

What it doesn't prove: that each transaction is in the right category. A reconciled account can still have a software subscription booked as office supplies. Category review is a separate step, covered in our small business bookkeeping guide.

What do you need before you start?

You need the bank statement for the month, your books entered through the statement's ending date, and last month's reconciled ending balance.

  1. The statement. Download the PDF statement, not just the transaction list. Its beginning balance, ending balance and ending date are what you reconcile to. Our guide to what records a small business should keep covers saving statements each month.
  2. Your books, up to date. Record or review every transaction through the statement's ending date first, including anything imported from a bank feed that's waiting to be categorized.
  3. Last month's ending balance. This month's reconciliation starts where last month's ended. If last month was never reconciled, start with the earliest unreconciled month and work forward.

How do you reconcile a bank account, step by step?

Work through these steps in order, one account and one month at a time.

  1. Check the beginning balance. The statement's beginning balance should equal the ending balance of your last reconciliation. If it doesn't, something in a reconciled period was changed or deleted. Find that first, because every later month will be off by the same amount.
  2. Enter the statement's ending balance and ending date. These are the targets.
  3. Match deposits. Tick off each deposit on the statement against a deposit in your books. Watch for deposits the bank shows as one amount that you recorded as several payments, or the reverse.
  4. Match withdrawals. Do the same for checks, card purchases, transfers, loan payments and automatic debits.
  5. Record what's missing from your books. Bank fees, interest earned, automatic payments and forgotten card charges are the usual items. Enter each one with its proper category and date.
  6. Investigate what's in your books but not on the statement. Each item is either a timing difference (a check you wrote that hasn't cleared, a deposit made on the last day of the month) or an error (a duplicate, a wrong date, a transaction in the wrong account). Leave timing differences uncleared; fix errors.
  7. Confirm the difference is zero. Your cleared balance should now equal the statement's ending balance exactly. Not "close": exactly.
  8. Save the reconciliation report. Keep it with the statement. It lists what cleared and what was still outstanding, which is where you'll start next month.
  9. Follow up on old outstanding items. A check that's still uncleared after a couple of months may have been lost, never cashed or recorded wrong. Contact the payee or correct the entry rather than carrying it forever.

What causes differences between the bank and your books?

Most differences fall into a handful of types, and each has a standard fix.

Common reconciliation differences and what to do
DifferenceWhy it happensWhat to do
Outstanding check or paymentYou recorded it; it hasn't cleared the bank yetLeave it uncleared; it should clear next month
Deposit in transitDeposited at month-end; the bank posted it after the statement dateLeave it uncleared; confirm it appears next month
Bank fee or interestThe bank recorded it; nobody entered itAdd it to your books
Duplicate entryEntered by hand and imported from the bank feed, or imported twiceDelete or exclude the extra copy, once you're sure it's a duplicate
Amount entered wrongTyping error or transposed digitsCorrect the amount to match the source document
Combined depositSeveral customer payments deposited together appear as one bank depositGroup the payments into one deposit in your books
Wrong account or monthRecorded against another account, or dated outside the periodMove or redate the entry

A useful clue: if the difference divides evenly by 9, look for two transposed digits. $1,820 entered instead of $1,280 is off by $540, which is 9 × 60.

What does a reconciliation look like with real numbers?

Here's a simple example. The business and every figure below are made up for illustration.

A design studio's March statement shows an ending balance of $8,420.00. Its books show $9,000.00 for the same account. Working through the steps, the bookkeeper finds four items:

  • a $1,250.00 customer payment deposited on March 31 that the bank posted on April 1 (deposit in transit);
  • a $600.00 check to a contractor, written March 29, not yet cashed (outstanding check);
  • a $15.00 monthly bank fee on the statement that was never entered in the books;
  • an $85.00 software charge recorded twice: once by hand, once from the bank feed.
Illustrative March reconciliation (made-up figures)
Bank sideAmountBook sideAmount
Statement ending balance$8,420.00Balance in the books$9,000.00
Add: deposit in transit$1,250.00Less: bank fee not recorded-$15.00
Less: outstanding check-$600.00Add back: duplicate software charge$85.00
Adjusted bank balance$9,070.00Adjusted book balance$9,070.00

The two adjusted balances agree, so the account is reconciled. The bank fee and the duplicate are fixed in the books now. The deposit and the check are timing differences: they stay uncleared and should appear on April's statement.

In software like QuickBooks Online you don't build this table yourself. You tick the items that appear on the statement and the program compares the cleared total to the statement's ending balance. The logic is the same.

How do you reconcile in QuickBooks Online?

QuickBooks Online has a built-in Reconcile tool. Intuit's help article "Reconcile an account in QuickBooks Online" describes these steps (menu names can differ slightly between versions of the interface):

  1. Go to All apps, then Accounting, then Reconcile. The first time, select Get started.
  2. Choose the account from the Account dropdown.
  3. Check the Last statement ending date. The statement you're reconciling should start the day after it.
  4. Enter the Ending balance and Ending date from the statement, then select Start reconciling.
  5. Compare the list with the statement and tick each transaction that appears on it. The Cleared balance updates as you go.
  6. When the Difference reaches $0.00, select Finish now, then Done. If it doesn't, select Edit info to check the ending balance and date you entered.

Saved reconciliations appear under History by account on the Reconcile page. In the account register, reconciled transactions show an R, cleared ones a C, and uncleared ones a blank.

If the difference won't reach zero, Intuit's guide to fixing reconciliation issues suggests checking, in order: the beginning balance, the ending balance and date you entered, combined deposits, transactions missing from QuickBooks, transactions that aren't on the statement, and amounts that are slightly off. It warns to delete a transaction only when you're certain it's a duplicate or an error.

QuickBooks lets you finish with a difference, in which case it records an adjusting entry for the amount. Intuit's own guidance is that it's usually best to resolve differences instead and to talk to your accountant first. An unexplained adjustment hides the error rather than fixing it, and a small difference can be two larger errors that partly cancel out.

Be careful with reconciled transactions. Editing, deleting or unreconciling a transaction from a finished month changes the beginning balance of the next reconciliation. Intuit also notes that undoing an entire reconciliation is permanent and deletes the saved report, so download it first and ask your accountant if you're unsure.

How often should you reconcile, and which accounts?

Reconcile every account once a month, soon after its statement is available. That includes checking and savings accounts, business credit cards, lines of credit and loans, and payment processors that hold your money before paying it out, such as Stripe, Square or PayPal. Each has a statement and each can drift.

Monthly keeps each reconciliation small. A month with a few dozen transactions is quick to check; a year's worth found at tax time is a project. It also means problems surface while they can still be fixed: a duplicate vendor charge you can dispute, or a customer payment that never arrived.

If your accounts haven't been reconciled for months, start with the earliest unreconciled month and go forward in order, one month at a time. Our guide to getting your books ready for tax season covers the rest of the year-end cleanup.

When should you get help?

Get help when the backlog is long, when the beginning balance doesn't match and you can't find why, or when the same differences keep coming back. Those usually point to a setup problem, such as a bank feed connected twice or transfers recorded as income, which is faster to fix once than to work around every month.

Sumify reconciles your bank and credit card accounts each month as part of monthly bookkeeping in QuickBooks Online, and brings behind accounts up to date with catch-up bookkeeping.

Frequently asked questions

How often should I reconcile my bank account?

Once a month, as soon as the statement is available. Monthly is often enough to catch errors, missing transactions and duplicates while you still remember them, and it means each reconciliation covers only a few weeks of activity.

Do I still need to reconcile if my bank feed is connected to my software?

Yes. A bank feed imports transactions, but it can bring in duplicates, miss items, or be matched to the wrong entry. Reconciling against the statement is what proves the account balance in your books is right.

What if I can't find the difference?

Check the beginning balance, the ending balance and date you entered, then look for missing, duplicated and slightly-off transactions. Avoid forcing the account to balance with an adjustment; if you still can't find it, ask your bookkeeper or accountant before finishing.

Should I reconcile credit cards and loans too?

Yes. Reconcile every account that has a statement: checking, savings, credit cards, lines of credit, loans and payment processors. The steps are the same; only the statement changes.

Sources

  1. Intuit QuickBooks Help: Reconcile an account in QuickBooks Online
  2. Intuit QuickBooks Help: Fix issues at the end of a reconciliation in QuickBooks Online
  3. Intuit QuickBooks Help: Undo or remove transactions from reconciliations in QuickBooks Online

This article is general information for U.S. small businesses. It isn't tax, legal, or accounting advice for your situation. Sumify provides bookkeeping and is not a CPA firm; for tax questions, talk with a CPA or enrolled agent.