Templates
Each workbook has live formulas, a sample sheet showing how it fills in, and a page explaining every number. Free, no sign-up.
A 13-week cash flow forecasts receipts and disbursements week by week, by the direct method, to find the lowest cash week while there is still time to act. This page builds one on a worked example and gives a free Excel template that places each open invoice in the week the customer is likely to pay.
What a board report should include and in what order, a one-page financial summary worked for a quarter, how to write the commentary, and a free Excel workbook with the summary, KPIs, cash and covenant headroom, a risk register and a sources sheet.
How a budget vs actual report works: variance as actual minus budget, the sign rule for revenue and cost lines, and a flexed budget that stops lower volume passing for a saving. Includes a free Excel template by line and cost center, with year to date, commentary and checks.
A free Excel budget template for companies: build next year's operating budget from units, prices, headcount and cost-center lines, phase it by month with a seasonal row, and compare it with actuals. It is a business budget, not a household one.
A complete statement of cash flows by the indirect method, laid out as a US 10-K shows it, with every line traced to the balance sheet or the income statement. The free Excel template builds the statement from two balance sheets and a P&L and checks that ending cash ties to the balance sheet.
What a monthly financial dashboard should show, the ten figures on a CFO dashboard with the formula for each, a worked month against budget and prior year, and a free Excel template that builds every figure from a trial balance and a budget, with checks that it ties.
A free Excel KPI dashboard template with a finished sample: eight KPIs, each with actual, target, prior month, variance and an On track, Watch or Off track status set by a written rule. Pick the month in one cell and every row updates.
A free monthly management accounts template in Excel for UK companies: paste the trial balance and get the summary, the P&L against budget and last year, the balance sheet, a cash-flow bridge, aged debtors and creditors, commentary and a checks page.
A free Excel P&L template for companies: paste a trial balance, map each account once, and get a monthly profit and loss statement with margins, a budget, a variance sheet and a check that it ties to the ledger.
A free monthly sales forecast template for Excel, by region or product. It forecasts the existing business from last year's same months times the recent growth rate, adds new-business pipeline weighted by your own stage win rates, and back-tests the method on the last completed quarter.
Enter revenue and costs to calculate gross, operating and net profit margin, plus markup, or find the selling price that hits a target margin. The formulas and a worked example are below the calculator.