Agency Finance Tracker Notion Template

Description

AGENCY FINANCE TRACKER — run every number in your agency from one connected Notion workspace. Log invoices and expenses as they happen and your profit, margins and outstanding AR track themselves; add retainers and your MRR & ARR calculate automatically; record a monthly cashflow snapshot and net cash + runway compute on their own. Revenue per client, per-project profitability, budget-vs-actual, spend by category, contractor payroll and who owes you what all roll up onto one command-centre dashboard. Built for creative, marketing, dev and consulting agencies (solo studio to 30-person shop) who want ONE source of financial truth instead of scattered spreadsheets.
WHAT YOU GET (7 linked databases + dashboard):• Clients — Total Billed / Paid / Costs rollups, Client Profit, Margin %, lifetime Value Tier• Projects — Project Profit (Billed − Costs), Margin %, Budget Used %, effective rate & budget flags• Invoices — Balance Due, Days Overdue, AR aging buckets (Current → 90+) & collection flags• Expenses — tied to project/client, billable amounts, monthly-equivalent for recurring spend• Retainers / Recurring — auto MRR/ARR engine (any cycle normalised to monthly), renewal flags• Team / Contractors — payouts rollup → Owed This Month, Est. Monthly Cost & payout flags• Cashflow (Monthly) — Total In/Out, Net Cashflow, Runway (months) & cash-health flag• Command-Centre Dashboard — MRR, net cashflow, outstanding AR, runway, overdue invoices, most-profitable projects, to