Free Bank Statement Reconciliation Template (Excel)

A ready-to-use spreadsheet for tracking transactions off a bank or card statement by hand — free, no email required, no catch.

Download the template (.xlsx) →

What's inside

• Transactions tab — Date / Description / Category / Amount / Running Balance, with the running balance computed automatically by formula.
• Category Summary tab — totals by category, computed with SUMIF, updates as you add rows.
• Instructions tab — how to use it, plain language.

When this is enough on its own

If you're reconciling a handful of transactions from one statement, typing them into this template by hand is fine — that's exactly what it's for.

When it isn't

Retyping numbers out of an actual PDF bank statement — especially a long one, or several months at once — is tedious and error-prone by hand. That's the exact job Engineer Tsai Studio's PDF tables → Excel service does: send the PDF, get back a clean Excel file with every row and column accounted for and anything ambiguous clearly flagged, in 24 hours. Starter tier is $7 for up to 5 pages.

Read the full guide on converting PDF tables to Excel →

Other Engineer Tsai Studio services: product image background removal, Chart of Accounts starter pack. Questions: hello@tsaielectro.com.