Small Business KPI Dashboard

Every number that matters in your business, on one screen, updated the moment you type.

The Small Business KPI Dashboard is a 7-tab financial command deck with 90 live formulas — P&L, cash flow, inventory, and a pricing calculator that tells you what to charge.

WHAT'S INSIDE

• Dashboard — revenue YTD, net income, net margin, cash on hand, runway in months, SKUs below reorder, stock value

• P&L — monthly revenue, COGS, expenses, and net with automatic margin math

• Cash Flow — cash in, cash out, running balance so you never get surprised

• Inventory — 14-SKU tracker with stock value and automatic reorder flags

• Pricing Calculator — cost-plus and margin-based pricing: enter cost, get your price at any margin

• Start Here — 3-step setup guide

• Lists — hidden control tab

PROOF IT WORKS

Built on real example data: $45,600 revenue YTD, $22,270 net (48.8% margin), $30,210 cash on hand, 11.7 months of runway, 5 SKUs flagged below reorder, $5,054.75 in stock value — every number computed live by the sheet's own formulas, verified cell by cell.

WHAT YOU GET

• The .xlsx file (works in Excel AND imports into Google Sheets in one click)

• Example data pre-loaded so you see exactly how it works — then overwrite with yours

• Yellow = you type here. Everything else calculates itself.

Run your business on numbers, not gut feelings.