How to organize a year of bank statements for taxes

At tax time, a year of bank and card statements is the record of what came in and what went out. Your tax preparer, or your tax software, wants totals: income, expenses by type, and payments you made. Getting from twelve PDFs to those totals by hand is slow, and it is easy to miss a month or count a payment twice. Here is a way that checks itself as it goes.

This is a bookkeeping method, not tax advice. What you can deduct, and which records you must keep, are questions for your tax preparer or the IRS's own guidance.

Step 1: collect the statements

  1. Download every statement for the tax year as a PDF, for each bank and card account the income or expenses went through. Card statements count: many purchases are only on the card.
  2. Include the statement that starts before January 1 and the one that ends after December 31, so the year has no gap at either end.
  3. Name the files by account and month, for example checking-01.pdf to checking-12.pdf, so they sort in order.

Step 2: convert and check each month

  1. Open the StatementLocal converter and drop the PDFs on the page. Each statement is read inside your browser and checked on its own against its printed opening and closing balances.
  2. Get every statement to Reconciled. A statement that says Off by highlights the rows to check; here is what to do.
  3. Download each statement as Excel (.xlsx).

Step 3: join the months and check the joins

  1. Copy every month's rows, without the header row, into one sheet per account, oldest first. Add a column for the account name if you will combine accounts later.
  2. Check each join: the closing balance of one statement must equal the opening balance of the next. A difference means a missing statement or a missing row.
  3. Only then cut the rows dated outside the tax year from the first and last statements.

Step 4: categorize and total

  1. Add a Category column and fill it from a keyword table, as in categorizing bank transactions in Excel. Use the category names your preparer or your tax form uses.
  2. Mark payments between your own accounts, such as a card payment from checking, as Transfer. They are neither income nor expenses, and counting them would count the card's purchases twice.
  3. Total each category with SUMIF, and give your preparer the totals together with the full sheets.

A worked example

A freelancer has one checking account and one credit card, so twelve checking statements and twelve card statements make 24 files. Every statement converts to Reconciled, and every join checks: for example, the March checking statement closes at $6,412.08 and the April statement opens at $6,412.08. The checking sheet holds 12 card payments totaling $9,880.00, marked Transfer. The purchases those payments covered are on the card sheet, so each purchase is counted once, on the card, in its category:

CategoryAccountTotal for the year
Client incomechecking48200.00
Software and subscriptionscard-1236.00
Office suppliescard-412.57
Transfer (card payments)checking-9880.00, left out of the totals

The preparer gets the category totals, the two joined sheets and the 24 original PDFs. Rows near January 1 and December 31 get a second look, because their dates decide which tax year they belong to.

Limits of this method

Try it on one of your statements

Open the StatementLocal converter and drop one statement PDF on the page. Converting and previewing are always free, and you can download 3 statements a day free, as CSV, Excel or QuickBooks CSV. The file is read inside your browser and is never uploaded.

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on every bank's real statements, and we quote no accuracy figure for them.

Related guides

StatementLocal is not affiliated with any bank, card issuer or software company named on this page. Names are used only to say what the steps are for.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.