What the template includes
- Operating activities: receipts from customers; payments to suppliers, for salaries, taxes and other.
- Investing activities: purchase and sale of fixed assets.
- Financing activities: loans, capital contributions, dividends.
- Monthly net cash flow and balance, annual totals.
Profit vs cash flow
The profit and loss statement records a sale when goods are shipped; cash flow records it when payment arrives. Buying a fixed asset appears in cash flow as one large outflow, but in profit as depreciation over several years. Taking a loan does not change profit, but it increases cash. That is why you need to keep both statements side by side: P&L template.
How to use it
- Enter the cash balance at the start of the year (all accounts and the cash desk).
- Each month, copy receipts and payments from bank statements as positive numbers.
- Reconcile the month-end balance with the bank statement: if there is a difference, a transaction is missing.
For a weekly forecast: 13-week cash flow forecast.