Bank Reconciliation: A Practical Guide to Matching Transactions

Bank reconciliation is the process of making sure the transactions in your books match what the bank says happened. It's not exciting, but skipping it is how you end up with books that are off by $200 and no idea where the money went.

Why Bother?

Three reasons:

1. Catch errors. Typos happen. A transaction entered as $150 instead of $1,500 will show up during reconciliation.
2. Spot unauthorized charges. If someone skimmed your card or a vendor double-charged you, the reconciliation catches it.
3. Keep your books audit-ready. Reconciled books are trustworthy books. Your accountant will thank you.

The Basic Process

1. Get your bank statement. Download the PDF from your bank. Note the ending balance and date range.
2. Open your accounting software. Pull up the same account for the same period.
3. Compare ending balances. If they match, you're probably in good shape. If not, dig in.
4. Match transactions. Go through each transaction on the statement and find the corresponding entry in your books. Check off each match.
5. Investigate mismatches. Anything on the statement but not in your books? That's a missing entry. Anything in your books but not on the statement? Could be a timing issue (check hasn't cleared) or an error.
6. Adjust and document. Add missing transactions, fix errors, and note any outstanding items.

Common Mismatches

Outstanding checks

You wrote a check last month but it hasn't been cashed yet. It's in your books but not on the statement. This is normal. Note it and move on.

Bank fees

Monthly maintenance fees, overdraft charges, wire transfer fees. Banks add these without telling you. You'll see them on the statement but not in your books. Add them.

Interest earned

Small amounts that you probably didn't record. Add them.

Deposits in transit

You made a deposit right before the statement period ended and it shows in your books but not on the statement. Normal timing difference.

Data entry errors

Transposed digits ($1,350 entered as $1,530), decimal errors ($150 vs $15.00), or completely missing entries.

Doing It Faster

Manual reconciliation (comparing PDF to screen) is slow. A few things speed it up:

• Convert your statement to CSV first. Having the data in a spreadsheet lets you sort, filter, and search instead of scanning a PDF line by line. Statement Pro converts bank statement PDFs to CSV in seconds.
• Use your accounting software's reconciliation tool. QuickBooks, Xero, and FreshBooks all have built-in reconciliation that speeds up the matching process.
• Reconcile monthly. Doing it once a year means 12 months of transactions to untangle. Monthly takes 15 minutes. Annual takes all day.
• Use the free reconciliation checker tool to quickly compare two sets of transactions and find discrepancies.

Reconciliation in QuickBooks Online

1. Go to Accounting > Reconcile
2. Select the account
3. Enter the statement ending date and balance
4. Check off transactions that match the statement
5. The difference should reach $0.00

Reconciliation in Xero

1. Go to Accounting > Bank Accounts
2. Click Reconcile on the account
3. Xero shows bank transactions next to suggested matches from your books
4. Confirm matches or create new entries for unmatched transactions

FAQ

How often should I reconcile?

Monthly, ideally within a week of getting your statement. Quarterly at a minimum. The longer you wait, the harder it gets.

What if I can't find a matching transaction?

If it's on the bank statement but not in your books, add it. If it's in your books but not on the statement, check the next month's statement (it might just be a timing issue). If it never shows up, investigate and correct.

Do I need to reconcile every account?

Every bank account and credit card, yes. Cash accounts, petty cash, and non-bank accounts are up to you, but bank accounts are non-negotiable.