Freelancer Income & Expense Tracker (Google Sheets)
Bookkeeping that does itself. Log income and expenses, and this sheet auto-categorizes every expense and tells you exactly how much to set aside for taxes - so you're never caught short.
WHAT'S INSIDE
- Auto-categorizing expense log: type "taxi" or "Instagram ads" and it files the category for you (Google Sheets).
- Income log with optional withholding and net-received.
- A Summary tab: total income, deductible expenses, net profit, and your recommended tax set-aside.
- Expense breakdown by category and an estimated-tax reminder tab with a live countdown.
- A worked example so you can see it in action.
WHO IT'S FOR
Freelancers, solopreneurs, and side-hustlers in any country who want clean books without accounting software.
HOW TO USE
Upload to Google Drive, open with Google Sheets, make a copy. Set your tax set-aside % once, then log as you go.
FORMAT
Instant-download Excel (.xlsx), built for Google Sheets. No signup, lifetime access.
Note: This tool does not calculate your actual tax (rules differ by country). The set-aside is a savings estimate - confirm with your tax authority or accountant.