Here's how to build them.
The Four Freelance Google Sheets You Actually Need
Most freelancers start with a single tab and watch it turn into a disaster by month three. The fix isn't more rows — it's the right separation of concerns. Each sheet below has one job.
| Sheet | Purpose | Key output |
|---|---|---|
| Invoice Tracker | Log every invoice sent, paid, overdue | Outstanding AR, days-to-payment |
| Income & Expense Log | Record all income and deductible expenses | Net profit, tax estimate |
| Client Pipeline | Track leads, projects, rates | Revenue forecast, utilization |
| Mileage & Receipts | Document deductible business travel | IRS-ready mileage total |
Invoice Tracker
Columns that matter: Invoice #, Client, Date Sent, Amount, Due Date, Date Paid, Status, Days to Payment.
The Status column uses a formula, not manual typing:
=IF(E2="", IF(TODAY()>F2, "Overdue", "Pending"), "Paid")
Where E2 is Date Paid and F2 is Due Date. This updates automatically. A conditional formatting rule — red for "Overdue," green for "Paid" — makes the unpaid invoices jump out instantly.
Days to Payment is worth tracking. According to a 2024 AND CO survey, 71% of freelancers report having trouble getting paid on time. Fewer than 30% actually track how long clients take to pay. Once you have 6 months of data in this column, you'll know which clients to chase early and which ones routinely pay in 7 days flat.
Income & Expense Log
This one feeds your tax estimate, so structure matters. Columns: Date, Description, Category, Amount, Type (Income/Expense), Deductible (Y/N).
For a running tax reserve, add a summary cell:
=SUMIF(E:E,"Income",D:D) - SUMIF(E:E,"Expense",D:D)
That's net profit. Multiply by 0.153 to estimate self-employment tax, then add your marginal income tax rate on top. For most freelancers in the US, total tax on net self-employment income lands between 25% and 40% depending on filing status and total earnings.
Client Pipeline
Track every active and potential client: Client Name, Status (Lead/Active/Paused/Churned), Hourly Rate, Monthly Hours, Monthly Revenue, Started, Last Invoice.
Monthly Revenue as a formula:
=IF(B2="Active", C2*D2, 0)
A =SUMIF(B:B,"Active",E:E) at the top gives you current monthly run rate. Run that against your expense log and you've got a real-time view of whether you're profitable.
This is also where you catch utilization problems. If you're billing 22 hours a week against a 40-hour capacity, you're at 55% utilization — and the remaining 45% is either business development, admin, or dead time. Knowing the number lets you decide which.
Mileage & Receipts
The IRS standard mileage rate for 2025 is $0.70 per mile (up from $0.67 in 2024, per IRS Rev. Proc. 2024-25). Every client meeting, co-working trip, or post office run counts if it's business-related.
Columns: Date, Purpose, Origin, Destination, Miles, Amount.
=E2*0.70
That's the deduction per row. =SUM(F:F) at the bottom is your total annual mileage deduction. On a $10,000 gross year with 1,000 miles driven for business, you just reduced taxable income by $700.
Freelance Google Sheets Formulas That Actually Matter
Most formulas you'll find in tutorials are toy examples. Here are the ones that earn their place in a real freelance setup.
Effective hourly rate — not your invoice rate, but what you actually earned per hour worked including unpaid time:
=SUMIF(Invoice!C:C,"Paid",Invoice!D:D) / TotalHoursWorked
Where TotalHoursWorked is a manually tracked cell. A freelancer billing $150/hr but spending 40% of their time on admin and unpaid revision rounds might have an effective rate closer to $90/hr. The math is worth knowing.
Days sales outstanding (DSO) — average time to payment:
=AVERAGEIF(Invoice!H:H,"<>",Invoice!H:H)
H column is Days to Payment. If this climbs past 30, your cash flow is being strangled by slow payers.
Client revenue concentration:
=SUMIF(Pipeline!A:A,"Client Name",Pipeline!E:E) / SUMIF(Pipeline!B:B,"Active",Pipeline!E:E)
If any single client represents more than 50% of your active revenue, that's concentration risk worth knowing about. Losing a $5,000/month client hurts differently than losing a $2,000/month one when you only have $4,000/month total.
Linking the Four Sheets Together
The real value comes from cross-sheet references. Your dashboard tab (add a fifth sheet titled "Summary") pulls from all four:
='Invoice Tracker'!B1 ← Outstanding AR
='Income & Expense Log'!B1 ← Net profit YTD
='Client Pipeline'!B1 ← Monthly run rate
='Mileage & Receipts'!B1 ← Mileage deduction YTD
Where B1 in each sheet is a summary cell. This dashboard is what you check every Monday morning instead of opening four tabs separately.
For clients with multiple projects, SUMIF handles the aggregation — same client name appears in multiple invoice rows, and =SUMIF(B:B,"Client X",D:D) totals their revenue across all invoices.
When AI Takes Over the Formula Work
The structure above is straightforward to maintain, but the initial setup — wiring cross-sheet references, debugging formula errors across four tabs, setting up the conditional formatting — takes a few hours the first time. If your data is messy or inherited from a previous system, more.
ModelMonkey handles this kind of formula work directly inside Google Sheets. You describe what you want ("flag invoices overdue by more than 14 days in red" or "calculate effective rate from the income log") and it writes and applies the formulas without you touching the formula bar. For freelancers who want the system without spending a Sunday afternoon building it, that gap is worth closing.
As of April 2026, it connects to existing sheets rather than requiring you to start fresh — useful when you already have 6 months of invoice data in a tab somewhere.