How to Reconcile a Checking Account: Register Worksheet

Quick Answer: To reconcile a checking account, compare your check register (or budget app) with the bank statement line by line, tick everything that appears in both, then adjust each side. Add deposits the bank hasn't credited yet and subtract checks nobody has cashed to the statement balance; add interest and subtract fees you never wrote down to your register. When the two adjusted numbers match, the account is reconciled.

Reconciling a checking account means proving that the balance you think you have is the balance you actually have. You take the bank's statement, take your own running record, and account for every difference between them. For a personal account with a few dozen transactions, it takes fifteen to thirty minutes a month with a pencil or a simple spreadsheet.

What does it mean to reconcile a checking account?

Your bank keeps one list of what went in and out of your account. You keep another, whether that is a paper checkbook register, a spreadsheet, or a budgeting app. The two lists should describe the same money, but they never line up perfectly on any given day, for two kinds of reasons.

The first is timing. You wrote check #1043 to your kid's piano teacher on the 26th and subtracted it right away; she hasn't deposited it, so the bank doesn't know about it yet. The second is information only the bank has. It charged a monthly maintenance fee and paid you a few cents of interest, and nobody sent you a receipt for either.

Reconciling sorts every difference into one of those two buckets. Anything that doesn't fit either bucket is a mistake, yours or the bank's, and finding those is the point of the exercise.

Is reconciling a checking account really necessary anymore?

A common view is that reconciling is not really necessary now that you can check your balance on your phone at any moment. The app shows the bank's number, and the bank's arithmetic is rarely wrong. So why bother?

Because the app answers a different question. It tells you what the bank has processed. It does not tell you about the $240 check you mailed for rent that hasn't been cashed, or the automatic payment scheduled for Friday. People who spend down to the app balance are the ones who get surprised by an overdraft when an old check finally clears.

Reconciling also catches things the bank won't flag for you:

• A subscription you cancelled that is still charging you.
• A debit card charge you don't recognize, which could be fraud.
• A merchant who charged you twice, or charged $84.70 for a $48.70 purchase.
• A deposit credited for less than you deposited.

And the deadline to dispute errors is real. For personal accounts, the federal rule on electronic transfers gives you 60 days from the date the bank sends the statement to notify the bank. The OCC's consumer site HelpWithMyBank.gov advises putting that notice in writing and keeping a copy. If you only look at your statements once a quarter, you can miss that window.

If your account has only a handful of electronic transactions and you never write checks, a lighter version is fine: skim the statement each month, confirm every line is yours, and note the ending balance. The full reconciliation below is worth doing whenever you write paper checks, keep a cushion that is thin, or share the account with someone else.

The worksheet, step by step

Many paper statements used to include a reconciliation form on the back. If yours doesn't, this is the same worksheet in a form you can copy onto paper or into a spreadsheet. The example uses one month of a personal account.

Part 1: Start from the bank's number

Part 2: Start from your register

Lines D and H agree, so the account is reconciled. Enter the interest, the fee and the parking charge in your register now, so next month starts clean.

Here is how to fill it in:

1. Get the statement. Download it from online banking or use the paper copy. Note the closing date; your register should be compared through that date.
2. Tick the matches. Go down the statement. For every deposit, check, debit purchase and transfer, find the same item in your register and put a check mark next to it in both places.
3. List what's unticked in your register. These are items the bank hasn't processed yet. Deposits go on line B, checks and payments on line C.
4. List what's unticked on the statement. These are items you never recorded. Interest and refunds go on line F; fees, forgotten debit charges and automatic payments go on line G.
5. Do the arithmetic and compare D with H. If they match, you're done. If not, see the next section.
6. Update your register with everything from lines F and G, and draw a line under the last reconciled entry so next month you know where to start.

What if the numbers don't match?

Start with the difference between D and H and look for a transaction of that exact amount on either list. If none exists, check whether the difference divides evenly by 9; that usually means two digits got swapped when you wrote something down. Then re-add your register: a running balance in a checkbook is only as good as every subtraction since the last time it was right.

Also look at last month. If your register's starting point this month was never reconciled, today's difference may be months old. Our page on what a bank reconciliation that won't balance usually means has a longer list of causes and tests.

Don't simply change your register to match the bank's number. You'd lose the chance to catch the double charge or the fee you could have asked the bank to waive.

How a checkbook register and the bank reconciliation fit together

The register is your side of the story, kept as things happen. Its value comes from writing each transaction down the moment you make it, including the checks you mail and the debit card taps that seem too small to matter. A register that is missing the small stuff produces a long line G every month.

You don't need a paper checkbook register to do this. Any running list works:

• A spreadsheet with date, description, amount and running balance columns. If you already track spending in one, our guide to building a budget spreadsheet from bank statements shows a layout that doubles as a register.
• A budgeting app that lets you enter transactions before they clear and mark them cleared later.
• Your bank's own CSV download. Many banks let you export recent activity as a spreadsheet file, which saves typing the statement side.

If your bank only gives you the statement as a PDF, a converter can turn it into rows you can sort next to your register. With QuickBankConvert you can preview a statement on screen without an account (one statement every 24 hours, up to 10 pages), and a free account adds CSV and Excel downloads; the free bank statement converter guide explains what each option gives you. For a personal account, sorting both lists by amount in a spreadsheet makes the ticking step much faster than flipping between a PDF and a notebook.

How often should you reconcile?

Monthly, within a week or so of the statement closing date, is the usual rhythm. It keeps the list short, and it keeps you well inside the 60-day window for disputing electronic errors on a personal account. If you're tight on cash or you share the account, a quick weekly check of the app against your register on top of the monthly reconciliation is a reasonable habit.

When you finish, keep the statement and your worksheet together. A month that ends with both columns agreeing is what people mean by a reconciled bank statement, and the reconciled figure becomes next month's starting point.

Related guides

• Bank statement reconciliation guide, for business books and accounting software.
• What you need to reconcile a bank statement
• Convert a statement PDF for Google Sheets