Business financial templates with visible calculations

Download original Excel workbooks for profit, cash, financial position and a connected service-business forecast. Inspect the worked example and assumptions before replacing the inputs.

Four real XLSX downloads with formulas. No signup or bank account connection. Examples use invented USD amounts; the files do not certify accounting or tax compliance.

Monthly reporting

Profit and Loss Template

A monthly P&L with separate revenue, direct costs, operating costs, depreciation, interest and entered tax. Annual margins are calculated from annual totals.

XLSX with editable inputs and formulas

View example and download

Cash planning

Cash Flow Forecast Template

A direct cash-flow forecast: enter cash when it is expected to arrive or leave, then inspect opening cash, monthly changes and closing balances.

XLSX with editable inputs and formulas

View example and download

Financial position

Balance Sheet Template

Two dated snapshots with current assets, fixed assets, liabilities, equity and an independent reconciliation. An unexplained difference stays visible.

XLSX with editable inputs and formulas

View example and download

Linked forecast

Financial Projections Template for a Service Business

A single service-business model connects monthly operating drivers to profit, cash and financial position. The workbook has Summary, Forecast and Inputs sheets.

XLSX with editable inputs and formulas

View example and download

Choose the record that answers your question

Question	Start here	Period treatment
How much profit did we earn?	Profit and loss	Revenue and expense over a period
When might cash run short?	Cash flow forecast	Receipts, payments and rolling balances
What do we own and owe?	Balance sheet	Snapshot on a stated date
How do future drivers affect all three?	Financial projections	Linked monthly forecast

Keep the accounting relationships intact

A customer invoice may create revenue before cash arrives. A loan adds cash and debt without creating revenue. Capex uses cash while its depreciation can affect later profit. These templates keep those differences explicit within their stated scope.

Need to prepare a customer document? Use the invoice and receipt tools. For household planning, return to the main financial-template library.