DEV Community

Thesius Code
Thesius Code

Posted on • Originally published at datanest-stores.pages.dev

Freelance Financial Dashboard

#freelancing #career #productivity #business

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

  1. Extract the ZIP archive
  2. Open dashboard-setup-guide.md — follow the Google Sheets setup
  3. Copy the template to your Google Drive
  4. Configure your tax rate, expense categories, and income sources in the Settings tab
  5. Log your first month of income and expenses
  6. 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)
Enter fullscreen mode Exit fullscreen mode

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        │
└─────────────────────┴────────────────────────────────────┴───────────┘
Enter fullscreen mode Exit fullscreen mode

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)
Enter fullscreen mode Exit fullscreen mode

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%)
Enter fullscreen mode Exit fullscreen mode

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

  1. Separate business and personal accounts. Makes tracking dramatically easier
  2. Photograph receipts immediately. Attach to the expense row as a note
  3. Review profit margins by client. Some clients cost more than they're worth
  4. Update tax estimates quarterly. Adjust based on actual income, not projections
  5. Back up monthly. Download a copy of the spreadsheet at month-end
  6. 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.

Get the Full Kit →

Or grab the entire Freelancer Toolkit Pro bundle (11 products) for $149 — save 30%.

Get the Complete Bundle →

Related Articles

Top comments (0)