How to Reconcile Bank Statements (Step by Step)
Reconciliation is how you know your books are right. Here's exactly how to do it, even if you've never done it before.
What is reconciliation?
Reconciliation means comparing your bookkeeping records against your bank statement to make sure they match. Every transaction in your bank should be in your books, and vice versa.
When they don't match, something is wrong: a transaction was missed, entered twice, categorized incorrectly, or the amount is off. Reconciliation catches these errors before they become tax problems.
Think of it like balancing a checkbook, except instead of just checking your balance, you're confirming that every individual transaction in your records matches what the bank shows. The goal is simple: at the end of reconciliation, your bookkeeping ending balance matches your bank statement ending balance to the penny.
Why reconciliation matters
Reconciliation is the quality control step of bookkeeping. Without it, your financial data is an educated guess. With it, you can trust your numbers.
It catches errors you'd otherwise miss:
- A $500 client payment that never got recorded
- A subscription you canceled that's still charging your card
- A transaction that was accidentally duplicated during import
- A bank fee you didn't know about
It protects you at tax time: When you hand your CPA a P&L report, they're trusting that the data is accurate. If your books don't match your bank statements, your tax return is built on bad data. Reconciled books = accurate tax return = no surprises from the IRS.
It catches fraud: If someone has unauthorized access to your business account, reconciliation is often how you find out. Unfamiliar transactions that don't match any expense you authorized stand out during reconciliation.
Before you start
Gather these before you begin reconciling:
- Bank statement for the period (download from your bank's website or use the monthly statement PDF)
- Your bookkeeping records for the same period
- The previous period's ending balance (this becomes your starting balance)
- A list of outstanding items from the last reconciliation (transactions that hadn't cleared yet)
If you're reconciling for the first time, your starting balance should match the bank statement's opening balance. If those don't match, go back further until you find a point where they do.
Step-by-step process
Step 1: Get your bank statement.
Download or access your statement for the period you're reconciling (usually monthly). Note three numbers: opening balance, closing balance, and the number of transactions.
Step 2: Compare the opening balance.
Your bookkeeping tool's opening balance for this period should match the bank statement's opening balance. If it doesn't, your previous reconciliation may have an issue, or there were adjustments between periods.
Step 3: Match deposits (income).
Go through each deposit on your bank statement and find the matching entry in your books. Confirm the date, amount, and source match. Check off each one as you verify it.
Step 4: Match withdrawals (expenses).
Do the same for every withdrawal, payment, and fee on the bank statement. Match each one to a transaction in your books. This includes automatic payments, checks, debit card charges, wire transfers, and bank fees.
Step 5: Identify discrepancies.
After matching everything you can, look at what's left:
- Transactions in the bank but NOT in your books = missed entries (add them)
- Transactions in your books but NOT in the bank = entered early, pending, or incorrect (investigate)
- Amount mismatches = typos or partial payments (correct them)
- Duplicate entries = double imports or double entry (delete the extra)
Step 6: Adjust and confirm.
Add missing transactions, delete duplicates, correct amounts. Calculate your adjusted book balance. It should now match the bank statement's ending balance exactly.
Step 7: Mark as reconciled.
Lock the period in your bookkeeping tool so reconciled transactions don't get accidentally edited. Start fresh next month.
Bank statement ending balance: $12,450.00
Your books ending balance: $12,525.00
Difference: $75.00 (your books are higher)
Investigation:
- Found a $50 bank maintenance fee not recorded in books → Add it (books decrease by $50)
- Found a $25 wire transfer fee not recorded → Add it (books decrease by $25)
Adjusted book balance: $12,525 - $50 - $25 = $12,450.00 ✅
This took 3 minutes. Most reconciliation "mysteries" are just bank fees you forgot to record.
Common discrepancies and fixes
- Pending transactions: A charge shows in your books but hasn't cleared the bank yet. This is normal for recent transactions. Note it as "outstanding" and it'll clear in the next period. Common with checks and some debit card holds.
- Bank fees: Monthly maintenance fees, NSF fees, wire transfer charges, or overdraft fees that you forgot to record. Banks don't always make these obvious. Check the statement carefully for small charges.
- Interest earned: Small amounts of interest credited by the bank that weren't entered in your books. Even if it's $0.12, it counts. Record it as income.
- Duplicate imports: If you import CSV files AND have bank sync connected, you might get duplicate transactions. This is the most common reason books show a higher balance than the bank. Always use one import method, not both.
- Transfers between accounts: Transfers sometimes show as an expense in one account and income in another. They should be recorded as transfers (not income/expense) so they don't inflate your P&L.
- Rounding differences: Rare, but currency conversions or split payments can create penny differences. If you're off by less than $1 after matching everything else, create a small adjustment entry.
- Returned items: A check that bounced or a refunded charge. The original transaction is in your books but the reversal might be missing.
Reconciling multiple accounts
If you have a checking account AND a credit card (and you should), reconcile them separately. Each account gets its own reconciliation against its own statement.
Order matters:
- Reconcile checking account first (this is your primary cash account)
- Reconcile credit card(s) next
- Reconcile any savings or money market accounts last
If you transfer money between accounts, make sure the transfer shows up in both reconciliations. A transfer out of checking should have a corresponding transfer into savings.
For most small businesses, you'll reconcile 2-3 accounts monthly: one checking, one credit card, maybe a savings account. The whole process takes 20-30 minutes once you're used to it.
How often to reconcile
Monthly is the standard and what most CPAs recommend. Do it when your bank statement closes, usually within the first week of the following month. Takes 10-20 minutes if you've been categorizing transactions weekly.
Quarterly at minimum. If monthly feels like too much, at least reconcile every quarter. Going longer than that makes errors exponentially harder to find. Trying to reconcile 6 months of transactions at once is a recipe for frustration.
Always reconcile before tax time. Your year-end numbers need to be accurate through December 31 before giving anything to your CPA. Don't hand over un-reconciled data.
Reconcile immediately if something looks wrong. If your balance seems off, a transaction looks unfamiliar, or a client claims they paid but you don't see it, don't wait for month-end. Check it now.
Reconciling credit cards
Credit card reconciliation follows the same process as bank reconciliation, but there are a few nuances:
Pending charges: Credit cards often show pending authorizations that haven't posted yet. Only reconcile against posted transactions on the statement, not pending ones.
Statement date vs. transaction date: A purchase on January 30 might not appear on your January statement if the statement closes on January 28. It'll show on February's statement. Don't count it twice.
Returns and credits: Refunds might take a billing cycle or two to appear. Note the expected credit and match it when it shows up.
Annual fees and interest: If you carry a balance (try not to), interest charges appear on the statement. Record these as business expenses ("Bank fees and interest") if the card is exclusively for business use. Annual fees are similarly deductible as a business expense.
Credit card payments: When you pay your credit card from your checking account, record it as a transfer, not an expense. The individual charges on the credit card are the expenses. The payment itself is just money moving between accounts.
If you use bank sync, reconciliation is mostly about confirming what's already there. Your tool has already pulled in the transactions; you're just verifying the totals match. It takes 5 minutes instead of 20. Bank sync doesn't eliminate the need for reconciliation, but it turns it from a chore into a quick sanity check.
Reconciliation built in
Hivebooks has a built-in reconciliation workflow. Mark transactions as reconciled, track your balance against your bank statement, and know your books are accurate. Combined with bank sync, most of the matching is done before you even start.
Try Hivebooks Free →