Freelance Income Tracker Spreadsheet — Excel + Tax Planner
About the Template
Stop guessing where your freelance money goes. This Excel tracker provides 9 professional sheets to log every payment, track unpaid invoices, estimate your tax, monitor expenses, and hit your income goals — all in one file. Works in both Excel and Google Sheets with an instant download.
Sheets Included
-
Dashboard
Your complete financial overview at a glance. Six auto-calculated KPI cards show this month's income, YTD total, unpaid invoices, average project value, top client percentage, and tax reserve. A monthly income table displays income, expenses, profit, margin, and progress vs. goal for every month of the year.
-
Charts (4 Live Visual Analytics)
Four automatically updating charts:
- Monthly Income vs. Expenses — bar chart for all 12 months
- Income Trend vs. Monthly Goal — line chart with goal reference
- Income by Category — pie chart showing your most profitable services
- Top Clients by Revenue — horizontal bar showing your best clients
-
Income Log (500 rows)
Log every payment as it arrives. Enter the date, client, project description, category, and amount — the tracker automatically calculates your tax amount and net income. Includes 11 category dropdowns (Design, Development, Writing, Consulting, Photography, Video, Marketing, and more). The invoice number column links to your Invoice Tracker.
-
Invoice Tracker (100 rows)
Track every invoice you send with six status options: Paid, Unpaid, Overdue, Partially Paid, Cancelled, and Draft — all color-coded automatically. Days overdue calculates itself from today's date. Includes an outstanding total, reminder tracking, and a payment method dropdown (Bank Transfer, PayPal, Stripe, Wise, Cash).
-
Expense Tracker (200 rows)
Log all business expenses with 12 categories. Features a "Tax Deductible" flag to mark expenses as deductible and reduce your taxable income automatically. Includes receipt tracking, a budget vs. actual comparison, and automatic feeding into your Tax Planner.
-
Client Database
Store all client details in one place: name, contact person, email, communication channel, status, hourly rate, total earned, and project count. Five status options: Active, Occasional, Inactive, Prospect, Lost. Eight clients pre-loaded as examples.
-
Tax Planner
Set your income tax rate and social security rate once — the planner handles the rest. Calculates gross income, total deductible expenses, taxable income, estimated tax liability, and your exact monthly reserve amount. Includes a quarterly reserve tracker.
-
Goals Tracker
Set your annual income target, monthly goal, and hourly rate target. Progress percentage is calculated automatically. Includes a rate growth tracker to show your year-by-year rate history for planning increases.
-
Instructions
A six-section setup guide covering: Getting Started, Income Log Tips, Invoice Management, Expense Tracking, Tax Planner Setup, and a Color Coding guide.
Key Features
- 1,213 formulas — 0 errors
- All sheets fully linked — change one number and everything updates
- Color-coded status badges throughout
- Dropdown menus for categories, currencies, status, and payment methods
- Sample data pre-loaded so you can see it working immediately
- Supports any currency (EUR, USD, GBP, CHF, CAD, AUD, and more)
- Works in Microsoft Excel 2016+ and Google Sheets
- Instant download — no subscription or account needed
Perfect For
- Freelance designers, illustrators, and photographers
- Web developers and software engineers
- Copywriters, translators, and content creators
- Consultants and business coaches
- Virtual assistants and online business managers
- New freelancers who want to start organized from day one
- Side-hustle earners managing tax on extra income
- Anyone self-employed who wants to understand their real numbers
How It Works
- Open the Tax Planner and set your income tax and social security rates
- Add your clients to the Client Database
- Log past income in the Income Log
- Track all business expenses in the Expense Tracker