As a freelancer, I spent years checking my bank balance with that pit-of-stomach feeling. "Did I make enough this week? Are my expenses running wild? Can I afford that software subscription?"
The problem wasn't my income — it was the lack of real-time visibility. I needed to see, at a glance, exactly where I stood each week without spending hours in Excel.
Enter the 4-column weekly tracker.
The Setup
I built a Google Sheets template with four core columns:
- Week Starting (date)
- Income Total (auto-summed from a log)
- Expense Total (auto-summed from a log)
- Surplus/Deficit (income minus expense, color-coded)
Underneath, two simple log sheets: one for income (date, client, amount, status) and one for expenses (date, description, category, amount).
Why It Works
- No formulas to write — SUMIF does the heavy lifting
- Weekly view matches how contractors get paid (typically per project, not monthly salary)
- Tax-ready — every expense is categorized and flagged as deductible
- 12-week rolling window keeps you focused, not overwhelmed
The Result
After three years of use, I pay less in late fees, negotiate better rates (because I know my cost base), and sleep better.
If you want the exact template I use, I put it up on Gumroad for a few bucks: Freelance Weekly Budget Tracker — Google Sheets. It's pre-filled with all the formulas, dropdowns, and conditional formatting — just copy and start typing.
No macros, no ads, no data collection. Just a spreadsheet that works.
Top comments (0)