Financial Health KPI Tracker

Reasoning

The vital signs on one page — margins, current ratio, days-to-get-paid, the cash conversion cycle, runway — tracked month over month with the formulas already in.

Enter your figures for each month — KPIs compute automatically. Add months as you close them.

Figure
Revenue
Cost of goods sold
Net income
Current assets
Current liabilities
Accounts receivable
Inventory
Accounts payable
Cash on hand
Monthly burn (fixed costs)

KPIs · latest month — click one to chart its trend

Cash conversion cycle · trend

Want this on your real numbers? Wauvel builds it straight from your QuickBooks.

Get my free report →

More free tools

ForecastingExcel · .xlsx

Annual Operating Plan (AOP) Builder

The plan you set the year by: revenue built up stream by stream, cost of sales, and operating expenses by category — twelve months across, with gross profit and operating income falling out for you.

Open the tool →

ForecastingExcel · .xlsx

Recurring Revenue Model (SaaS / Subscriptions)

Build a subscription revenue forecast the way investors read it: new customers, ARPA, churn, and expansion drive a monthly MRR/ARR build, with the new → expansion → churn bridge tying out automatically. Industry presets for SaaS, memberships, subscription boxes, and retainers.

Open the tool →

ForecastingExcel · .xlsx

Capacity & Utilization Revenue Model

Forecast revenue for a capacity business: units × sellable slots × utilization × price, plus ancillary revenue. Industry presets for salons, restaurants, hotels, clinics, trucking/fleet, and professional services — tune capacity, occupancy, and rate and watch revenue (and RevPAR-style yield) build month by month.

Open the tool →

ForecastingExcel · .xlsx

Funnel / Transaction Revenue Model

Forecast a paid-acquisition business: spend → sessions → orders → revenue, with returns, repeat purchases, CAC, and contribution. Industry presets for ecommerce/DTC, marketplaces (take rate), and lead generation — see how spend and conversion translate into revenue month by month.

Open the tool →

ForecastingExcel · .xlsx

3-Statement Financial Model

Set a handful of assumptions — growth, margins, working-capital days, capex, financing — and project a fully linked income statement, balance sheet, and cash flow three years out, monthly. The balance sheet balances and cash ties, automatically.

Open the tool →

ForecastingExcel · .xlsx

13-Week Cash Flow Forecast

The rolling weekly forecast every CFO keeps: beginning balance, money in, money out, and the projected low point that tells you exactly when cash gets tight.

Open the tool →

ReportingExcel · .xlsx

Budget vs. Actual (Monthly P&L)

A month's P&L with plan set beside reality and the variance computed for you — so every number turns into feedback instead of weather.

Open the tool →

ReasoningExcel · .xlsx

Break-Even & Contribution Margin Calculator

The number every owner should know: how much you have to sell to cover your costs. Set price, variable cost, and your fixed costs, and it solves break-even in units and revenue — then shows your margin of safety, the volume to hit a profit target, and how break-even moves when you change price.

Open the tool →