What is a two-column bank reconciliation and how is it prepared?

What are the two columns?

One column starts from what the bank says you have; the other starts from what your own books say you have. In one teaching format, for example, the left side is labeled Balance per BANK and the right side Balance per BOOKS. AccountingCoach's and AccountingTools' explanations of the bank reconciliation do not use the name "two-column".

Each column then carries its own adjustments:

• The bank column holds items that are already in your general ledger Cash account but are not yet in the bank's records. The usual examples are deposits you recorded that the bank has not processed and checks you wrote that the bank has not yet paid.
• The book column holds items the bank has already recorded that are not yet in your general ledger Cash account. The usual examples are bank service fees, penalties, customer checks returned unpaid (NSF checks) and interest earned.

At the bottom of each column is an adjusted balance. The whole point of the format is that those two bottom lines should be the same number.

Is this something new, or what you already produce?

For most readers, what the name plainly describes is the reconciliation they already do. If you reconcile a checking account each month by starting from the statement balance, allowing for checks that have not cleared and deposits that have not arrived, and comparing the result with your books, you are doing the work the name describes. The only difference is whether the result is written out as two side-by-side columns.

Accounting software generally shows the same reconciliation in a different shape. In a typical software reconciliation module, a listing of uncleared checks and uncleared deposits appears, you check off the ones the bank statement shows as cleared, you enter as expenses the bank charges on the statement that you have not already recorded, and you enter the statement's ending balance. Here is how that screen maps to the two columns. This mapping follows a generic reconciliation module, not any one product's screens; compare it against your own tool's reconciliation report, which may lay the same figures out differently.

The main point where they differ: software usually has you post the book-side items as you go, so by the time you finish, your ledger already includes them. You do not see a separate book column with its own adjustments; you see a ledger balance that already reflects them. A written two-column statement shows those items openly, before or alongside the entries that record them. If a course or textbook shows you a two-column statement and your software shows you a tick list that compares the book balance with the statement balance, you are looking at the same reconciliation from two directions.

Do you need to prepare one or only read one?

If someone else prepared the statement, or a course presented it, you mostly need to read it. Check that each adjustment sits in the column whose record is missing it, and that the two bottom lines are identical. If you must prepare one from your own records, follow the order below.

Where do the figures come from, and in what order is it built?

Pick the period end first, usually the statement date. A common routine is to reconcile shortly after the end of each month, when the bank sends you a bank statement. Every figure you use should be as of that same date.

Build it in this order:

1. Bank column opening figure. Enter the unadjusted balance from the bank statement (or online banking information) at the period end.
2. Book column opening figure. Enter the unadjusted balance in your general ledger Cash account for that bank account at the same date.
3. Compare the detail. Match each deposit and each check or payment in your ledger against the statement. Anything that appears in one record but not the other is a reconciling item.
4. Bank column adjustments. Starting from the bank's ending cash balance, add any deposits in transit, subtract any checks that have not yet cleared the bank, and add or subtract any amount the bank recorded incorrectly.
5. Book column adjustments. Starting from your ending cash balance, deduct any bank service fees, NSF checks and penalties, add any interest earned, and add or subtract any amount your own books recorded incorrectly.
6. Total both columns and compare the two adjusted balances.
7. Record the book-column items. For the adjusted balance to appear in your general ledger Cash account and on your balance sheet, the items listed under the book column must be recorded in your general ledger.

Which column does each reconciling item go in?

Ask one question for each item: whose record is missing it, or has it at the wrong amount? It goes in that record's column.

• An amount the bank recorded wrongly is corrected in the bank column; an amount you recorded wrongly is corrected in the book column.

The common mistake is to enter an item in the column where you happened to notice it. You notice a service fee on the bank statement, so it feels like a bank item, but the bank has already recorded it. Your books are the record that lacks it, so it belongs in the book column. If an item lands on the wrong side, the two columns can still be forced to agree while each one is adjusted for the wrong things, and the totals will not show you the error.

What does a completed one look like?

Here is an invented example for a business checking account for the month ended June 30, 2026.

What the records show:

• Bank statement balance at June 30: 18,420.00
• General ledger Cash balance at June 30: 17,433.00
• Deposit recorded June 30, not on the statement: 2,300.00
• Check 1041 recorded, not yet cleared: 1,150.00
• Check 1043 recorded, not yet cleared: 2,640.00
• Monthly service fee on the statement, not in the books: 35.00
• Customer check returned unpaid (NSF) on the statement, not in the books: 480.00
• Interest credited on the statement, not in the books: 12.00

The completed statement:

Checking the arithmetic: 18,420.00 + 2,300.00 − 1,150.00 − 2,640.00 = 16,930.00, and 17,433.00 − 35.00 − 480.00 + 12.00 = 16,930.00. The columns agree, so the account is reconciled at June 30.

Recording the three book-column items brings the Cash account to 16,930.00; the three bank-column items need no entry, because your books already contain them.

When is it finished?

The statement is finished when the two adjusted balances are identical. Close is not finished: a difference of any size means an item is missing, on the wrong side, or entered at the wrong amount. Diagnosing a reconciliation that will not agree is a separate question.

It only does its job once the book-column items are recorded, so the ledger Cash balance equals the adjusted balance.

What does it prove, and what does it not?

What it proves: at one date, the difference between the bank's balance and your book balance is fully explained by the listed items, and your adjusted book balance is the cash you actually have once timing items clear. A bank reconciliation will also catch some types of fraud, after the fact.

What it does not prove:

• It says nothing about the period's activity. A standard bank reconciliation compares the book and bank cash balances at a specific point in time. It does not show that the month's total receipts and total payments agree between the bank and your books. A receipt overstated in one place and a payment overstated by the same amount elsewhere can leave the ending balance right.
• It does not prove the detail is right. Agreement means the two cash balances match after the listed items. It does not tell you that each payment was coded to the right expense, that each deposit was credited to the right customer, or that every transaction was authorized. Treating agreement as proof that the books are right in detail is the second common mistake, and it stops people investigating at exactly the wrong point.
• It covers only the ending position. Items that arose and cleared within the month never appear on it.

If your purpose is to show that cash in and cash out for the period are complete and correct, you need a fuller format. A proof of cash adds separate columns for cash receipts and cash disbursements, and it reconciles both the beginning and ending balances while explaining all receipts and disbursements over the period. The four-column reconciliation is covered as its own question.

If what you need is an ending cash figure whose difference from the bank is fully explained, this format demonstrates it. If you need to show that the period's receipts and payments are complete, it does not, and you need the fuller format.