Track Freelance Income and Costs in Google Sheets from Your Statements
Freelancers: convert bank statement PDFs to CSV and import into Google Sheets to organize your year. 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).
- Choose the file in the converter near the top. It's opened on your device only.
- Look out for client payments split across lines and transfers between your own accounts.
- Set Export layout to Standard columns (free, like the QuickBooks, Xero and YNAB layouts), choose Download CSV, then add your own Category column.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-03-01 | Client transfer March retainer | 2400.00 | |
| 2026-03-15 | Invoice 118 paid | 900.00 | |
| 2026-03-24 | Laptop stand | -46.20 |
Sample rows, Standard columns setting.
Google Sheets notes
- Leave the separator on detect automatically, and keep Convert text to numbers, dates, and formulas switched on so amounts become numbers you can total.
Why it fits freelancer and Schedule C records
A Google Sheet you can open anywhere is handy if you freelance from different places. Import each converted statement and keep a running tab of business income and costs all year instead of in April.
Set up the sheet once in January with Date, Description, Amount, Category and Notes columns, then append each month's converted rows. By the time tax season comes, the year is already sorted and you only need to review the categories you weren't sure about.
Tip: Add a data-validation dropdown for your Category column so every row uses the same few labels, then total them with a pivot table.
Questions
Can I share the sheet with my tax preparer?
You can share a Google Sheet with anyone you choose using Google's sharing settings. Decide what to share, as the rows contain your transaction details.
What if a client paid me through a payment app?
Payouts from a payment app usually show on the statement as one deposit. Add a note with the client names, since the statement won't list them.
Can I keep last year's sheet separate?
Yes. Make a copy of the spreadsheet each January, clear the rows and keep the structure. Each year then stays in its own file.
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.