Preparing bank statements for tax season: a checklist

To prepare bank statements for tax season: collect every statement for every account for the full tax year, confirm there are no gaps, convert them into a spreadsheet, categorize every transaction, separate out transfers and personal items, and total by category, keeping the original statements as records. The checklist below walks through each step.

This is a practical data checklist, not tax advice. What’s deductible and how items are treated depends on where you are and your situation, so confirm with a qualified tax professional.

1. List every account

Before gathering anything, write down every account the business (or person) used during the tax year:

Business checking / current accounts
Savings accounts
Credit cards, including cards used only occasionally
Payment platforms that hold balances
Accounts opened or closed during the year
Personal accounts used for business spending, if any

Missing accounts are the most common source of missing expenses.

2. Collect the statements

Every monthly statement for the tax year, for each account
The statement that covers the start of the year and the one that covers the end, even if they span into other years
PDFs from online banking where possible, since they’re better than scans
Scans or clear photos of any paper-only statements

If your tax year doesn’t match statement periods, you’ll need the statements that straddle each end.

3. Check for gaps

For each account, line the statements up in order and check:

Each statement’s opening balance equals the previous statement’s closing balance
Statement periods join up with no missing dates
The first statement covers the first day of the tax year, and the last covers the final day

A balance that doesn’t carry over means a missing statement.

4. Convert to a spreadsheet

Working from PDFs means reading every line. Convert instead:

Convert each statement into rows with date, description, amount and balance
Stack all statements for an account in date order
Add an account column if combining accounts
Check each converted statement: opening + money in − money out = closing

statement.work converts PDFs, scans and photos from any bank into the same columns, so a year of statements across accounts becomes one sheet. See why convert statements.

5. Trim to the tax year

Remove transactions dated before the first day or after the last day of the tax year
Keep the removed rows somewhere. You’ll need them next year

6. Categorize everything

Use a fixed category list (see our sample list)
Map categories to what your return, or your preparer, needs
Clear the “uncategorized” bucket completely

7. Separate what isn’t income or expense

These distort totals if left in:

Transfers between your own accounts, including credit card payments
Owner draws and contributions
Loan principal received or repaid (interest is separate)
Refunds, netted against the original expense
Personal spending on business accounts, or business spending on personal accounts

8. Look for problems

Duplicate charges, which may be refundable and shouldn’t be claimed twice
Bank fees and interest, often missed but real costs
Unusual or unrecognized transactions
Batched deposits, matched to the sales they represent

Our guide to duplicate charges and hidden fees explains the quick checks.

9. Total and summarize

Pivot table: category × total for the year
Optional: category × month, to spot anything odd
Note large or unusual items with a short explanation
Reconcile totals to any bookkeeping software figures

10. Gather the supporting evidence

Bank statements show money moving; they don’t always show what it was for.

Receipts and invoices for significant expenses
Notes on mixed-use items (vehicles, phone, home office)
Payout reports from payment processors
Loan statements showing interest vs principal

11. Package it for your preparer

The original statements (PDFs)
The categorized spreadsheet
The category totals summary
A list of open questions

Ask your preparer which format they want. Many prefer Excel for review and CSV for import. Clean, categorized data usually means less of their time spent on data entry.

12. Keep records

Store original statements and the spreadsheet together, by tax year
Keep them for as long as the rules where you are require

Summary

Every account, every statement, no gaps; convert, check, categorize; remove transfers and personal items; total; attach evidence. Doing it monthly instead of once a year makes tax season a summary rather than a project. If you prepare returns for clients, see statement.work for tax preparation.