Ledgerline_CFO_Workbook.xlsx

DashboardB6
Formula
='Profit & Loss'!$O$15

Automatic

CFO Dashboard

Juniper & Oak Studio ยท Jan 2026 to Dec 2026

Report dateDec 31, 2026

Revenue vs expenses by month

Every bar is a live SUMIFS over your Income and Expenses logs.

  • Revenue
  • Expenses

Where your income comes from

Share of the year by income category.

Income$314k
  • Client Projects44%
  • Monthly Retainers21%
  • Shop: Physical Products15%
  • Digital Downloads5%
  • Workshops & Courses8%
  • Consulting Calls5%
  • Licensing & Royalties1%
  • Affiliate & Other1%

Net profit by month

Green months made money. Red months spent more than they earned.

Where your money goes

Your seven biggest cost categories, plus everything else.

Spent$213k
  • Payroll & Wages54%
  • Rent & Utilities11%
  • Contractors & Freelancers10%
  • Cost of Goods6%
  • Marketing & Advertising5%
  • Payment Processing Fees3%
  • Equipment & Hardware2%
  • Other9%

Bank balance

Closing balance at the end of each month.

Top 5 clients

Revenue this financial year.

  • Online Shop$45,540
  • Brightline Dental$44,500
  • Kestrel Analytics$32,600
  • Marlow & Finch Law$25,500
  • Tidewater Realty$23,400

Annual revenue goal

$314,008 of $330,000

$15,992 to go

Unpaid invoices by age

Older debts are harder to collect, so they turn darker.

Budget vs actual by category

Grey is the year budget, colour is what you actually spent.

  • Payroll & Wages98% of budget$114,300
  • Contractors & Freelancers89% of budget$20,605
  • Rent & Utilities100% of budget$24,419
  • Software & Subscriptions105% of budget$3,774
  • Marketing & Advertising119% of budget$10,749
  • Cost of Goods92% of budget$12,450
  • Equipment & Hardware132% of budget$5,137
  • Travel & Meals114% of budget$4,769
  • Professional Services86% of budget$3,350
  • Insurance99% of budget$1,776
  • Payment Processing Fees96% of budget$6,919
  • Education & Training76% of budget$1,133
  • Office Supplies89% of budget$1,597
  • Phone & Internet107% of budget$1,608
  • Bank Charges & Other73% of budget$218
Made with Modulify