Bank Statement to Google Sheets for Work Expense Reports
Pull work purchases from your bank statement PDF into Google Sheets for an expense report. Converted in your browser, never uploaded.
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).
- Choose the file in the converter near the top. It's opened on your device only.
- Delete personal purchases with × so only work items remain.
- Set Export layout to Standard columns (free, like the QuickBooks, Xero and YNAB layouts), choose Download CSV, then keep only the rows you're claiming.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-05-12 | Airport taxi | -48.60 | |
| 2026-05-14 | Conference registration | -295.00 | |
| 2026-05-15 | Train ticket | -74.50 |
Sample rows, Standard columns setting.
Google Sheets notes
- Uploading the file to Google Sheets is your own step. RowSmith doesn't connect to your Google account or send anything there. RowSmith is not affiliated with Google.
Why it fits expense reports
Plenty of teams take expense reports as a shared sheet. Convert the statement, delete the personal rows and import the rest straight into the report template your manager sent.
If your company's template lives in Google Sheets, keep a personal import tab inside it. Each claim period, import the new rows there, copy the work items into the report section and leave the import tab hidden before you share the report.
Tip: Import into a new sheet in the same spreadsheet as your report template, then copy only the rows you're claiming across.
Questions
Will my personal transactions end up in the report?
Only if you leave them in. Delete them in the preview before downloading, or after importing, before you share.
Can I add the project code?
Yes. Add a column in Sheets after importing, or edit the description in the preview before you download.
Is it safe to put bank data in a work spreadsheet?
Only the rows you keep go into the sheet. Remove personal transactions and anything like balances before you share it with your company.
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.