Freelance Agency Finance System — Invoice, Tax, Pipeline & Dashboard Tracker for Solo Agency Owners

Description
Stop guessing your numbers. The Freelance Agency Finance System is a 15-sheet Excel workbook that tracks invoices, pipeline, quarterly taxes, and cash flow — all in one file.

What this actually does
Most finance templates track one thing. This one tracks the full cycle — from the moment a prospect enters your pipeline through invoicing, payment, tax estimation, and profitability analysis. You enter data once. Everything else updates automatically.

15 integrated sheets:
▸ Dashboard — Revenue, expenses, net profit, utilization rate, DSO, health score, and pipeline coverage. Monthly table with 12-month rolling averages and variance tracking. Seven automated alerts tell you when something needs attention.
▸ Goals — Annual targets for revenue, profit, utilization, client acquisition, DSO, and pipeline. Auto-calculates YTD progress with ✓ / ⚠ / ✖ status indicators.
▸ Pipeline — Track deals through Lead, Qualified, Proposal, Negotiation, Closed Won/Lost. Probability-weighted forecast calculates automatically based on stage. Days since last contact flags stale deals.
▸ Clients — Full client directory. Auto-calculates total projects, hours logged, revenue billed, amount paid, and outstanding balance per client.
▸ Projects — Budget vs. actual tracking per project. Variance in dollars and percentage. Effective rate calculation. Over-budget flag feeds the Dashboard alert system.
▸ Time Log — Log hours by client and project. Rate auto-populates from the client directory. Billable vs. non-billable toggle feeds utilization calculations on the Dashboard.
▸ Invoices — Full register with issue date, due date, status, paid date, tax/VAT column, and aging. Invoice number auto-generates. Overdue invoices feed the Dashboard AR aging summary.
▸ Expenses — 8 agency-specific categories. Deductible/non-deductible toggle. Feeds the Tax Engine and Dashboard expense tracking directly.
▸ Client LTV — Lifetime value, months active, projected LTV, churn risk tier, and LTV x Margin per client. Uses actual invoice history — not estimates.
▸ Break-Even — Enter your monthly fixed costs and rate. See exactly how many hours you need to bill to break even. What-if column shows the impact of a rate increase. Dynamic commentary updates automatically.
▸ Tax Engine — Quarterly estimated tax calculator. Covers Income Tax + Self-Employment Tax (Social Security 12.4% + Medicare 2.9%, applied to 92.35% of net earnings per IRS rules). SS wage base set to $176,100. Standard deduction set to $15,000. All rates are editable. US-focused; non-US buyers can adjust rates in Global Settings.
▸ AI Prompts — 39 ready-to-use prompts for monthly summaries, variance explanations, tax planning, client proposals, discovery calls, pricing analysis, and year-end reviews. Seven dynamic fill cells auto-populate from your live data — copy and paste directly into Claude or ChatGPT.
▸ Owner's Draw — Track personal withdrawals against net profit. Draw ratio indicator. Reserve progress warning if you are drawing down before your emergency reserve is funded.
▸ Upgrade Guide — Product ladder and feature comparison.
▸ Start Here — One-page setup. Enter your country, fiscal year, target rate, and utilization. Everything else connects automatically. Setup progress meter tracks your five required steps.

What makes this different
Every formula is wrapped in error handling — the file opens clean on an empty dataset. No #REF! errors, no broken lookups while your data is still sparse.
The Tax Engine applies the 0.9235 SE multiplier correctly. Most templates either skip self-employment tax entirely or apply it to 100% of net income, which overstates the liability. This one does the math the way the IRS does.
The Health Score is a composite 100-point score across seven criteria: utilization, margin, pipeline coverage, DSO, churn rate, draw ratio, and emergency reserve. One number tells you whether your agency is in good shape or needs attention.
No macros. No VBA. No Google Sheets. Pure Excel formulas — no security warnings, no "enable editing" prompts, no cloud dependency.

Who this is for
Solo freelancers and independent agency owners who manage their own finances. If you are billing clients, tracking your own pipeline, estimating quarterly taxes, and trying to figure out whether you are actually profitable — this is built for you.

Who this is not for
Multi-user accounting, payroll for employees, or industry-specific invoicing (construction, legal, medical). This is a solo operator tool.

Requirements
Microsoft Excel 2019 or later — PC or Mac. Not compatible with Google Sheets. No VBA, no macros, no add-ins.
Instant download
You receive one .xlsx file immediately after purchase. No subscription. No expiry.

Refund policy
Digital download — all sales are final. If something is not working as described, message me and I will fix it.