Freelance Financial Dashboard
A pre-built Google Sheets financial tracking system with income logging, expense categorization, tax estimate calculations, profit margin analysis, and monthly/yearly comparison charts. Know your numbers without hiring a bookkeeper.
What's Included
| File | Description |
|---|---|
dashboard-setup-guide.md | Step-by-step Google Sheets setup instructions |
income-tracker-template.md | Revenue logging sheet with formulas |
expense-categories.md | Pre-configured expense taxonomy |
tax-estimator.md | Quarterly tax estimate calculator |
profit-analysis.md | Margin analysis and breakeven formulas |
dashboards/main.json | Chart configuration for visual dashboard |
alerts/rules.yml | Threshold alerts for spending and income targets |
config.example.yaml | Customization settings (tax rates, categories) |
Quick Start
Extract the ZIP archive
Opendashboard-setup-guide.md— follow the Google Sheets setup
Copy the template to your Google Drive
Configure your tax rate, expense categories, and income sources in the Settings tab
Log your first month of income and expenses
Review the auto-generated dashboard charts
Template Examples
Income Tracker Sheet
┌──────────┬────────────┬───────────┬──────────┬──────────┬──────────┐
│ Date │ Client │ Invoice # │ Amount │ Category │ Status │
├──────────┼────────────┼───────────┼──────────┼──────────┼──────────┤
│ 01/15 │ Acme Corp │ INV-001 │ $3,500 │ Web Dev │ Paid │
│ 01/22 │ DataCo │ INV-002 │ $1,200 │ Consult │ Paid │
│ 02/01 │ Example Co │ INV-003 │ $5,000 │ Design │ Pending │
├──────────┼────────────┼───────────┼──────────┼──────────┼──────────┤
│ │ │ TOTAL │ $9,700 │ │ │
└──────────┴────────────┴───────────┴──────────┴──────────┴──────────┘
Key Formulas:
- Monthly total: =SUMIFS(Amount, Date, ">="&MONTH_START, Date, "<="&MONTH_END)
- Paid total: =SUMIFS(Amount, Status, "Paid")
- Outstanding: =SUMIFS(Amount, Status, "Pending")
- Average invoice: =AVERAGE(Amount)
Expense Categories
┌─────────────────────┬────────────────────────────────────┬───────────┐
│ Category │ Examples │ Deductible│
├─────────────────────┼────────────────────────────────────┼───────────┤
│ Software & Tools │ Hosting, domains, SaaS, licenses │ Yes │
│ Office & Workspace │ Coworking, home office, furniture │ Yes │
│ Marketing │ Ads, SEO tools, business cards │ Yes │
│ Professional Dev │ Courses, books, conferences │ Yes │
│ Insurance │ Liability, health, equipment │ Yes │
│ Travel │ Client meetings, conferences │ Yes │
│ Meals & Entertainment│ Client meals (50% deductible) │ Partial │
│ Equipment │ Computer, monitor, peripherals │ Yes │
│ Subcontractors │ Outsourced work, VA │ Yes │
│ Bank & Payment Fees │ Stripe fees, wire transfer fees │ Yes │
│ Personal/Non-Deduct │ Personal purchases │ No │
└─────────────────────┴────────────────────────────────────┴───────────┘
Quarterly Tax Estimator
Quarterly Tax Estimate — Q[X] [YEAR]
Gross Income (quarter): $________
Less: Deductible Expenses: $________
Net Self-Employment Income: $________
Self-Employment Tax (15.3%): $________
→ Social Security (12.4%): $________
→ Medicare (2.9%): $________
Estimated Income Tax:
→ Federal (effective rate ____%): $________
→ State (rate ____%): $________
TOTAL ESTIMATED TAX DUE: $________
Set aside per month: $________
Formula: =NET_INCOME * (SE_TAX_RATE + FED_RATE + STATE_RATE)
Monthly Dashboard Metrics
═══════════════ JANUARY [YEAR] ═══════════════
Revenue: $8,500 ▓▓▓▓▓▓▓▓░░ 85% of target
Expenses: $2,100 ▓▓▓▓░░░░░░ 42% of budget
Net Profit: $6,400 Margin: 75.3%
Tax Set-Aside: $2,048 (32% effective rate)
Take-Home: $4,352
YTD Revenue: $8,500 vs $7,200 last year (+18%)
YTD Expenses: $2,100 vs $2,400 last year (-12%)
Usage Tips
Log expenses weekly. Don't let receipts pile up — Friday afternoon works well
Reconcile monthly. Compare your sheet totals against bank statements
Set income targets. Use the target column to track progress against monthly goals
Tag everything. Consistent categorization makes tax time painless
Use the 30% rule. Set aside 30% of every payment for taxes until you know your actual rate
Best Practices
Separate business and personal accounts. Makes tracking dramatically easier
Photograph receipts immediately. Attach to the expense row as a note
Review profit margins by client. Some clients cost more than they're worth
Update tax estimates quarterly. Adjust based on actual income, not projections
Back up monthly. Download a copy of the spreadsheet at month-end
Share with your accountant. Give view-only access for seamless tax prep
This is 1 of 11 resources in the Freelancer Toolkit Pro toolkit. Get the complete [Freelance Financial Dashboard] with all files, templates, and documentation for $39.
Or grab the entire Freelancer Toolkit Pro bundle (11 products) for $149 — save 30%.