Bank Statement PDF to Excel for Freelancer Tax Prep
Self-employed? Convert bank statement PDFs to Excel and organize the year's business income and costs. Runs in your browser. Not tax advice.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for freelancer and Schedule C records
- Download each monthly statement for the tax year as a PDF (scanned PDFs aren't supported).
- Add the file to the converter at the top of this page. Several PDFs can go in together.
- Look out for client payments split across lines and transfers between your own accounts.
- Set Export layout to Standard columns (QuickBooks, Xero and YNAB layouts are free as well), choose Download Excel, then add your own Category column.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-03-15 | Invoice 118 paid | 900.00 | |
| 2026-03-19 | Stock photo credits | -39.00 | |
| 2026-03-24 | Laptop stand | -46.20 |
Sample rows, Standard columns setting.
Excel notes
- The first Excel download on a visit loads a spreadsheet library from the same site. Your statement data still stays on your device.
Why it fits freelancer and Schedule C records
At tax time a freelancer has to pull a year of business activity out of statements. In Excel you can tag each row, then use a pivot table to total each tag.
A workbook with one tab per month plus a summary tab works well. Each monthly tab holds the converted rows with your own category labels, and the summary uses SUMIFS to add up each label for the year. Your preparer can then see both the totals and the rows behind them.
Tip: Insert a pivot table with your Category column as rows and Amount as values. Keep a tab for items you're unsure about to ask your tax professional.
Questions
Can RowSmith fill in Schedule C categories?
Not today. Add your own Category column after downloading.
Is a converted spreadsheet a substitute for my statements?
No. Keep your original statements. The spreadsheet is a working copy to help you organize them.
How do I handle a refund from a supplier?
It shows as a positive amount on the statement. Keep it in the same category as the original purchase so the year's total for that category is net of the refund.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.