How I Track Freelance Income Without Accounting Software

QuickBooks Self-Employed costs $15/month. FreshBooks starts at $17/month. Xero? $13/month. For a freelancer with five clients and straightforward income, that's $150-$200 a year spent on... tracking money. I refused. Here's the Google Sheets system I built instead — it took 30 minutes to set up, 10 minutes a month to maintain, and has handled two tax seasons without a single error.

Why I Ditched Accounting Apps

The problem with most accounting software isn't the price — it's the complexity. I don't need double-entry bookkeeping, bank reconciliation, or automated expense categorization. I need to answer four questions: How much did I earn this month? Who hasn't paid yet? How much do I owe in taxes? Can I afford that new monitor? A spreadsheet answers all four.

The Google Sheets Template (Free)

I use a single spreadsheet with three sheets: Income, Expenses, and Tax Summary.

Sheet 1: Income

Columns: Date | Client | Project | Invoice # | Amount | Status (Invoiced/Paid/Overdue) | Payment Method | Notes

I use conditional formatting: "Overdue" turns red automatically if the invoice date is older than 30 days and status isn't "Paid." At the bottom, a =SUMIF(Status,"Paid",Amount) formula shows my actual received income, not just invoiced amounts.

=SUMIF(E2:E100,"Paid",D2:D100)   // Total paid income
=SUMIF(E2:E100,"Overdue",D2:D100) // Total overdue — chase these clients

Sheet 2: Expenses

Columns: Date | Category (Software, Hardware, Internet, Office, Travel) | Description | Amount | Receipt Link

I snap a photo of every receipt with my phone, upload to a Google Drive folder, and paste the share link. No paper, no scanner.

Sheet 3: Tax Summary

Queries Income and Expenses sheets to calculate:

Gross Income = SUM(Income!D2:D100)  // All invoiced
Taxable Income = Gross Income - SUM(Expenses!D2:D100)
Estimated Tax (25%) = Taxable Income * 0.25   // I set aside 25% for quarterly taxes

Every month, I transfer 25% of net income to a separate savings account. When quarterly estimated taxes are due (US: April 15, June 15, September 15, January 15), the money is already there. This alone saved me from a $3,200 surprise tax bill that hit me in my first freelance year.

Monthly Review Routine (10 Minutes)

On the 1st of every month, I do three things:

1. Reconcile payments: Check bank account, mark invoices as "Paid," update the sheet.
2. Log expenses: Scan receipts from the past month, enter into Expenses sheet.
3. Check Tax Summary: Transfer 25% of net income to tax savings account if I haven't already.

That's it. Ten minutes, one coffee, done. No reconciling bank feeds, no categorizing transactions with AI, no monthly subscription.

Have a freelance finance system that works better? I'd love to hear it. Reach us at contact@viperstream.cloud.