Bank statements to Excel for tax preparation
To prepare taxes from bank statements, convert each monthly PDF to Excel or CSV, combine the months into one sheet, then add a category column and total it with a pivot table. BankConv converts up to 10 statements per batch, so a full year takes two uploads, and the first 5 pages are free to check.
What you can do with it
A full tax year in one sheet
Convert all 12 monthly statements (two batches of up to 10) and paste them into one Excel sheet, sorted by date.
Categorize deductible expenses
Add a Category column and tag rows such as software, travel, fuel and office supplies. A pivot table then totals each category.
Find every income deposit
Filter to money in to list client payments, platform payouts and transfers, so you can match them against 1099s or invoices.
Separate personal from business
Many sole proprietors use one account for both. A spreadsheet lets you mark each row personal or business before totals go on a return.
Older years and amended returns
Bank downloads usually cover recent months only. PDF statements go back further, so prior years can be rebuilt from statements.
How to prepare taxes from bank statements
Convert, combine, categorize, total. The spreadsheet does the adding up; you decide what each row is.
- Download the statements. Get each month’s PDF from online banking. For the tax year, you need January through December, plus December of the prior year if a payment straddles the year end.
- Convert them. Upload up to 10 PDFs at a time and export to Excel.
- Combine the months. Paste each month under the last in one sheet. Check that no statement period is missing.
- Categorize. Add a Category column. Sort by description so the same payee sits together, then tag in blocks.
- Total. Insert a pivot table with Category as rows and Amount as values.
A categorizing checklist
Most of the work is deciding what each row is. These are the rows tax preparers most often need to find:
| Look for | Why it matters |
|---|---|
| Deposits from clients and payment platforms | Gross income to match against 1099s and invoices |
| Transfers between your own accounts | Not income; exclude them from totals |
| Estimated tax payments to the IRS or state | Already paid; goes on the return |
| Recurring software, phone and internet | Often partly business use |
| Charitable donations | May be deductible if you itemize |
| Refunds and reversals | Net them against the original expense |
Tip: tag transfers first. They are the most common reason income totals look too high.
Check the conversion before you rely on it
Before any number goes on a return, confirm the sheet matches the statements. Compare the row count with each PDF. Check that the last running balance equals the statement’s closing balance. Total money in and money out for the month and compare with the summary box.
When the client sends scans
BankConv reads scanned PDFs with OCR. Clear, straight scans work best. Check amounts on scanned pages closely, and ask for the downloaded PDF when you can.
New to the terms? The glossary explains running balance, statement period and more. Prices start at $2.99 per document; see pricing.
Questions people ask
Can I convert a whole year of bank statements at once?
A batch takes up to 10 PDFs, so a 12-month year takes two uploads. Each statement gives its own file; paste them into one sheet and sort by date.
Which format is best for tax preparation?
Excel for categorizing and pivot tables, CSV for importing into accounting or tax software. Both have date, description, amount and, where printed, balance columns.
Do I still need the original PDF statements?
Yes. Keep the PDFs as your record. The spreadsheet is a working copy for sorting and totaling.
Is it safe to upload client statements?
Files travel over HTTPS and are deleted automatically after 24 hours. BankConv never connects to a bank account or asks for banking passwords.