The Only Freelancer Tax Spreadsheet You Actually Need

Bookkeeping software is too much for most solo freelancers. QuickBooks asks questions you do not know how to answer. Wave and FreshBooks feel like flying a plane when you need a bicycle.

Here is the bicycle.

The Five Columns

Open a spreadsheet. Google Sheets or Excel. Name it "2026 Taxes." Create these columns.

Date	Description	Amount	Category	Receipt

That is it. Five columns.

Date. When you paid or were paid. Format it YYYY-MM-DD so sorting actually works.

Description. What was it. Be specific enough that your tax preparer can understand it six months from now. "Office Depot. Printer paper and toner." Not "Supplies."

Amount. Positive for income. Negative for expenses. Or use separate columns for income and expenses if that is clearer to you.

Category. Pick from a short list. Home office. Software. Meals. Travel. Equipment. Marketing. Professional services. You do not need 47 categories. You need 7 to 10.

Receipt. A link to the photo or file. Or just "yes" if you have it saved. Your tax preparer only needs to know the receipt exists. They will ask for it if the IRS asks them.

The Weekly Routine

Every Sunday. Open the spreadsheet. Open your business bank account. Enter every transaction from the past week. Five minutes if you had a slow week. Ten minutes if you had a busy one.

Do not skip weeks. A skipped week becomes a skipped month. A skipped month becomes a January panic where you spend two full days reconstructing twelve months of transactions.

The Template

Here is a copy-paste template. Adjust the categories to fit your work.

Date	Description	Amount	Category	Receipt
2026-01-05	Client LLC. Q1 retainer	3,500	Income
2026-01-06	Adobe CC annual	(599.88)	Software	yes
2026-01-08	WeWork day pass	(29.00)	Office	yes
2026-01-12	Client LLC. Additional scope	1,200	Income
2026-01-15	Q4 estimated tax payment	(4,200)	Tax	yes

Why This Works

Your tax preparer can use this directly. Give them the spreadsheet and your receipts folder. They will import it, categorize it properly against IRS schedules, and file a clean return. No forensic accounting. No hourly billing to sort your transactions.

If the IRS asks questions, you have a timestamped log of every business transaction with receipt references.

When to Upgrade

When you hire an employee. When you have inventory. When you have more than 50 transactions a month. At that point, QuickBooks or a dedicated bookkeeper is worth the money.

Until then, the spreadsheet is enough. I have been using this exact system for three years. Five columns. Five minutes. Sunday morning. My preparer has never asked me to clarify a transaction.