Bank Reconciliation: The Complete Guide

Bank reconciliation is the routine of comparing the cash transactions in your own records against the transactions on your bank statement, then explaining every difference between the two ending balances. When both sides are accounted for and agree, the account is reconciled. This guide walks through what reconciliation is, why it matters, the items that cause the two sides to differ, the step-by-step process, how often to do it, and the errors to watch for.

What bank reconciliation is

You keep a record of cash — in a spreadsheet, a ledger, or accounting software. The bank keeps its own record of the same account. The two should describe identical money, but at any given moment they rarely show the same number, because transactions reach each set of records at different times. Reconciliation is the act of matching the two records line by line and adjusting for the timing and recording differences until they tie out. For a plain-English introduction with a worked example, see what is a bank reconciliation.

Why it matters

A reconciled cash balance is a trustworthy one. The process surfaces problems early:

• Unrecorded items — bank fees, interest, or automatic charges you have not entered yet.
• Errors — a transposed digit, a duplicated entry, or a payment posted to the wrong account.
• Missing transactions — a deposit or check that never made it into your books.
• Unauthorized activity — charges you do not recognize, caught while the bank's dispute window is still open.

Reconciliation also supports your recordkeeping obligations. The IRS expects businesses to keep records that back up the income and deductions reported on a return — see the official guidance on recordkeeping.

The reconciling items

Differences between your books and the statement fall into a handful of categories. The key is knowing which side each item adjusts, and in which direction.

Items that adjust the bank side

These are transactions already in your books that the bank has not finished processing.

• Outstanding checks — checks you have written and deducted in your books, but which have not yet cleared the bank. The statement balance is temporarily too high, so outstanding checks are subtracted from the bank side.
• Deposits in transit — deposits you have recorded but which the bank has not yet posted. The statement balance is temporarily too low, so deposits in transit are added to the bank side.

Items that adjust the book side

These are transactions the bank has processed that you have not yet recorded.

• Bank fees and service charges — money the bank has already taken. Subtract these from the book side.
• Interest earned — money the bank has already added. Add this to the book side.
• Other bank-initiated entries — automatic payments, returned-check charges, or direct debits you learn about from the statement. Record each on the book side in the appropriate direction.

When every item is placed on the correct side, the adjusted bank balance and the adjusted book balance should be equal. That common figure is the reconciled balance.

The step-by-step process

1. Gather your two records. Pull the bank statement for the period and open your own cash records covering the same dates.
2. Match the cleared transactions. Tick off each transaction that appears in both records with the same date and amount. Matched items need no adjustment.
3. List the bank-side items. Note any deposits in transit and outstanding checks — entries in your books not yet on the statement.
4. List the book-side items. Note any fees, interest, and other bank entries on the statement that are not yet in your books.
5. Adjust each side. Add deposits in transit to and subtract outstanding checks from the bank balance. Adjust the book balance for fees, interest, and other entries.
6. Compare the adjusted balances. If they agree, record the book-side adjustments as actual entries in your records and the reconciliation is complete.
7. Investigate any remaining gap. If the two sides still differ, the difference points to an error — a missed transaction, a wrong amount, or a duplicate — that you track down before closing the period.

How often to reconcile

Reconcile each account every time you receive a statement, which for most accounts is monthly. Higher-volume accounts benefit from a more frequent rhythm — weekly, or even at each statement cycle the bank makes available. Reconciling on a regular schedule keeps the number of items small and makes any discrepancy easier to trace while it is still recent.

Common errors

• Transposed digits — writing $4,800 as $4,080. These produce a difference divisible by 9, a useful clue when hunting a gap.
• Duplicated entries — recording the same transaction twice in your books.
• Wrong-sign entries — entering a deposit as a withdrawal or the reverse.
• Forgetting bank-initiated items — overlooking fees or interest that only appear on the statement.
• Date-range mismatch — comparing a statement period against the wrong span of your records, so genuinely matching items look unmatched.
• Stopping at "close enough" — leaving a small unexplained difference rather than resolving it. An unresolved gap, however small, means something is still wrong.

Tools and spreadsheets

Reconciliation can be done on paper, but most of the work is lining up transactions, and that is far easier once the statement is in a spreadsheet you can sort, filter, and tick off. Accounting software automates the matching for accounts it connects to; a spreadsheet gives you full control when you would rather work the rows yourself.

Either way, the data has to be structured first. If your bank only gives you a PDF, see how to convert a bank statement to Excel, or turn the statement into clean rows with the bank statement converter and reconcile from there.

Next steps

Once you understand the items and the logic, the routine itself is mechanical. For a walkthrough of the procedure end to end, see how to do a bank reconciliation.