Freelance Financial Dashboard
Google Sheets financial tracker with income, expenses, tax estimates, profit margins, and monthly/yearly comparison charts.
📄 Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample📁 File Structure 22 files
📖 Documentation Preview README excerpt
Freelance Financial Dashboard
By Freelancer Toolkit Pro | $39
A complete Google Sheets financial tracking system for freelancers. Track every dollar in, every dollar out, estimate your taxes, measure profit margins by service and client, and compare year-over-year growth — all from a single spreadsheet.
Disclaimer: This product is for informational and organizational purposes only. It is not tax or financial advice. Consult a licensed accountant for your jurisdiction.
What's Inside
Spreadsheets (CSV → Google Sheets / Excel Import)
| File | Purpose | Sample Data |
|---|---|---|
sheets/income-log.csv | Every invoice: client, amount, category, payment status, days to pay | 30 realistic invoices ($1,200 - $7,500) |
sheets/expense-log.csv | All business expenses with categories, deductibility flags, and receipts | 40 expenses across 11 categories |
sheets/monthly-summary.csv | Month-by-month P&L: revenue, expenses, profit, tax set-aside, take-home | 8 months of worked data |
sheets/tax-estimate.csv | Quarterly estimated tax calculations: federal, SE tax, state | 4 quarters with rate breakdowns |
sheets/profit-margin.csv | Margin analysis by service category + client profitability rankings | 4 categories, 7 clients |
sheets/yearly-comparison.csv | Year-over-year metrics: revenue, profit, client count, avg invoice, DSO | 3 years of comparison data |
Formulas Reference
| File | Purpose |
|---|---|
formulas/FORMULAS.md | 23 Google Sheets formulas with cell references, worked numeric examples, and decision frameworks |
Pages (Guides)
| File | Purpose |
|---|---|
pages/dashboard-setup.md | Complete layout guide: KPI placement, chart data tables, color coding |
pages/how-to-read-your-numbers.md | The 5 numbers that matter most, monthly review checklist, red flags |
Documentation
| File | Purpose |
|---|---|
docs/SETUP-GOOGLE-SHEETS.md | Step-by-step CSV import, column formatting, formula setup |
docs/CUSTOMIZATION.md | How to adapt categories, tax rates, payment methods for your business |
docs/chart-setup-guide.md | 6 chart types with exact setup instructions and data source formulas |
Features
- Income Tracking — Log every invoice with client, category, amount, payment status, and days to payment
- Expense Management — 11 expense categories with tax-deductible flags and receipt tracking
- Monthly P&L — Automatic profit/loss calculation with profit margins and take-home pay
- Quarterly Tax Estimates — Federal, self-employment, and state tax calculations with safe harbor rates
- Client Profitability — Effective hourly rate by client reveals which relationships are really profitable
- Service Category Analysis — Gross and net margins by service type for strategic pricing decisions
- Year-over-Year Comparison — 12 metrics tracked across years with growth percentages and projections
- Visual Dashboard — 6 chart types (bar, pie, donut, line, horizontal bar, grouped column) with setup guides
- 23 Working Formulas — SUMIFS, SUMPRODUCT, ARRAYFORMULA, COUNTIFS, and more with worked examples
... continues with setup instructions, usage examples, and more.
📄 Content Sample docs/chart-setup-guide.md
Chart Setup Guide — Freelance Financial Dashboard
Step-by-step instructions for creating the visual charts that bring your data to life.
Chart 1: Monthly Revenue Bar Chart
Purpose: See revenue trends at a glance. Instantly spot your best and worst months.
Setup in Google Sheets
1. Go to your Dashboard sheet
2. Select the monthly data table (Month | Revenue | Expenses columns, rows for Jan through Dec)
3. Click Insert → Chart
4. In the Chart Editor:
- Chart type: Column chart (or "Bar chart" for horizontal)
- Stacking: None
- Data range: Your monthly table
- Series: Revenue (blue), Expenses (red)
5. Click Customize tab:
- Chart title: "Monthly Revenue vs Expenses"
- Legend position: Bottom
- Gridlines: Horizontal only
- Colors: Revenue =
#2196F3(blue), Expenses =#f44336(red)
Data Source Formulas
Build this helper table on your Dashboard sheet:
| Row | A (Month) | B (Revenue) | C (Expenses) |
|---|---|---|---|
| 1 | Jan | =SUMPRODUCT((MONTH('Income Log'!A:A)=1)(YEAR('Income Log'!A:A)=2025)('Income Log'!H:H="Paid")*'Income Log'!F:F) | =SUMPRODUCT((MONTH('Expense Log'!A:A)=1)(YEAR('Expense Log'!A:A)=2025)'Expense Log'!E:E) |
| 2 | Feb | (same formula, change month to 2) | (same formula, change month to 2) |
| ... | ... | ... | ... |
| 12 | Dec | (same formula, change month to 12) | (same formula, change month to 12) |
What the sample data shows:
- January: $11,600 revenue / $1,035 expenses
- March peak: $15,600 revenue (large Silverstone Corp project)
- Clear pattern: revenue varies, expenses stay relatively stable
Chart 2: Revenue by Service Category (Pie Chart)
Purpose: Understand your revenue mix. Which services drive your business?
... and much more in the full download.