Every spring, freelancers and sole proprietors face the same problem: twelve months of business spending on a credit card, locked inside twelve PDF statements, that all need to land in a spreadsheet, categorised by expense type, before any of it can go on Schedule C.
The naive approach — retyping each transaction into Excel by hand — is a guaranteed weekend lost. The good approach is roughly an evening of work. The difference is mostly in the first 30 minutes.
What you're trying to produce
For Schedule C (the U.S. tax form for self-employment income), you need a categorised list of business expenses. The standard categories include:
- Advertising
- Car and truck expenses
- Contract labour
- Depreciation
- Insurance (other than health)
- Office expense
- Rent or lease (other business property; vehicles, machinery, equipment)
- Supplies
- Taxes and licences
- Travel
- Meals (subject to limits)
- Utilities
- Other expenses (with detail)
What you ultimately want is a spreadsheet where each transaction has a date, amount, description, and one of these categories. The IRS only sees the totals, but the totals have to be defensible — if you're audited, you need to point at the line-items.
Step 1: Gather the statements (30 minutes)
Sign in to online banking for each business credit card and download every monthly statement from the tax year as a PDF. Save them into a single folder, named consistently like 2025-01-amex.pdf through 2025-12-amex.pdf. The naming sounds fussy but helps a lot when you're juggling multiple cards.
Most banks keep at least a few years of statements available, so you can do this for prior years if you're catching up. Don't try to download a single “year-to-date” PDF — they often include only summaries, not transaction-level detail.
Step 2: Convert all the PDFs (15 minutes)
Drop each statement into a PDF-to-Excel converter. Using ours: PDF in, click Excel on the results, file downloads. Repeat twelve times. There's no batch upload — yet — but each statement takes about 60 seconds.
At this point you have twelve Excel files (one per statement) sitting in your folder. Open them all, copy the rows into a single master sheet, and you've got a full year of card activity in one place. Total time so far: about an hour.
Tip: keep a column for the source filename in your master sheet, so if a transaction looks weird later you can trace it back to the original statement.
Step 3: Categorise (the slow part — 1–3 hours)
Now the actual brain work. Add a “Category” column to your master sheet, then go row by row, deciding what each transaction is.
How to make this faster:
- Sort by merchant. All your Amazon transactions land together; all your gas stations land together. You can tag a whole block of identical-merchant rows in one go.
- Don't over-think categories.Schedule C's categories are deliberately broad. A laptop is “Office expense.” A flight is “Travel.” A coffee with a client is “Meals” (and remember the 50% limit). Don't spend twenty minutes deciding between Office and Supplies — pick one and move on.
- Mark non-business transactions.If you use your business card for personal stuff (don't), flag those rows and exclude them from totals.
- Keep a “Notes” column.If you remember what a vague charge was for (“client lunch with Sarah”), jot it down. Future-you, possibly being audited, will thank you.
Step 4: Total by category (5 minutes)
With your master sheet categorised, do a quick pivot table or SUMIF by category. Those totals are what go on the Schedule C expense lines.
Cross-check: your sum of all expense totals should be close to your total card spend for the year. If it's wildly off, you've either left transactions uncategorised or marked too many things as personal.
Step 5: Keep the records
Save the master sheet, the per-statement Excel files, and the original PDFs for at least three years (the IRS's standard audit lookback; longer if you're cautious or have something unusual on your return). PDFs are the canonical source — if you ever have to defend a deduction, the PDF is what backs it up.
Doing this every month instead of once a year
The best version of this workflow is one statement at a time, the week after each month ends. PDF in, Excel out, categorise the rows on the train home. Twenty minutes a month replaces an entire weekend at tax time. The amount of categorisation you can do on a fresh memory of what each charge was for, vs. trying to remember a flight from ten months ago, is dramatic.
If a monthly habit is a bridge too far, quarterly is the next-best option. Anything is better than discovering at tax time that you have a year of PDFs and no system.
What about accounting software?
For freelancers with low transaction counts and a single business card, the spreadsheet workflow above is honestly fine. You don't need QuickBooks or Xero unless you have invoicing to track, payroll, multiple accounts to reconcile, or a CPA who insists.
If you do want to use accounting software, the workflow upgrades: PDF in, .qbo or Xero CSV out, import into QuickBooks/Xero, categorise there (with the software's autocompletion helping). The QuickBooks and Xero guides cover those flows.
One last thing: receipts
For meals, travel, and any expense over $75, the IRS technically wants receipts in addition to the credit-card record. The card statement proves that you spent money; the receipt proves what on. For most spending the statement is enough, but flag the ones that aren't in your master sheet, dig out the receipts (most are in your email), and stash them in a tax folder.
Total time to do a full year of credit-card prep this way: 3–5 hours, most of it categorisation. Compared to the weekend of typing that people who don't use a converter spend, that's a genuinely good trade.