Pull Work Expenses from a Bank Statement PDF into Excel
Build an expense report from your bank statement PDF. Convert to Excel in your browser, filter to the work purchases and copy them over.
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 expense reports
- Download the statement covering your trip or claim period 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.
- Delete personal purchases with × so only work items remain.
- Set Export layout to Standard columns (QuickBooks, Xero and YNAB layouts are free as well), choose Download Excel, then keep only the rows you're claiming.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-05-14 | Conference registration | -295.00 | |
| 2026-05-14 | Parking garage | -32.00 | |
| 2026-05-15 | Train ticket | -74.50 |
Sample rows, Standard columns setting.
Excel notes
- Each file you drop adds its rows to the same table, so several statements download as one sheet. Add a column afterwards if you need to tell the accounts apart.
Why it fits expense reports
When work purchases went on your own card or account, the statement is the quickest record of what you spent. Convert it to Excel, delete the personal rows and you have the start of your expense report.
After filtering to work purchases, add columns your finance team asks for, such as purpose, client or cost center. Sort by date and the list usually lines up with the report form. Keep the receipts in the same order to make attaching them quicker.
Tip: Delete personal rows in the preview with the × button before you download, so the Excel file only holds the items you're claiming.
Questions
Is the statement enough as a receipt?
That depends on your employer's policy. Many still want itemized receipts. Use the spreadsheet to list the items and attach whatever your policy requires.
Can I change a description before downloading?
Yes. Click any cell in the preview to edit it, for example to add the client or project name.
Can I convert a corporate card statement?
If it's a text-based PDF with a date, description and amount table, it may convert. Check whether charges show as positive or negative before you total them.
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.