Start a report from a template
On Custom reports, New custom report opens a page of starting points: the 3 standard statements, 9 templates for the profit and loss, balance sheet and cash flow, a blank report, or a copy of one of your reports. Customise on a standard statement starts the same way. Nothing is saved until you save the report.
The starting points
Choose New custom report on Custom reports. The New report page offers:
- Standard statements. The profit and loss, balance sheet and cash flow as they are, to add rows, calculations and sections to.
- Templates. Nine ready-made reports for the profit and loss, the balance sheet and the cash flow, listed below.
- Blank report. An empty section. Choose Profit and loss or Balance sheet, then add rows. To start a cash flow, use one of the cash flow templates.
- Copy one of your reports. Choose a report and Copy. If a report cannot be copied here, the page says why, and Duplicate on the Custom reports list copies it instead.
The 3 standard statements
| Standard statement | What it is for |
|---|---|
| Profit and loss | The Profit and Loss screen's own format, to rename, regroup and extend. |
| Balance sheet | The Balance Sheet screen's own format, to rename, regroup and extend. |
| Cash flow | The Cash Flow screen's own format, to rename and regroup inside each section. |
The 9 templates
| Template | What it is for |
|---|---|
| Management P&L with EBITDA | For the monthly management meeting, with EBITDA before depreciation, amortisation, interest and tax. |
| P&L with key figures | The profit and loss with a statistic you choose, and revenue and staff cost per unit of it. |
| P&L by company | Each company's profit and loss side by side, with the group's adjustments and the total. |
| Budget vs actual | Actual against the budget, with the variance. |
| 12-month trend | The profit and loss month by month for the last 12 months, with a total. |
| Net assets (management) | Non-current assets, working capital and net debt, down to net assets and equity. |
| Balance sheet with ratios | The standard balance sheet with the current ratio, the equity ratio and debtor days. |
| Simplified cash flow | Operating, investing and financing in one line each, and the net change in cash. |
| Free cash flow | Operating cash less investing, which is the cash the business made before financing. |
Some templates ask questions when you open them, such as which statistic to use. A row whose question is not answered waits, and the report cannot be published until it is answered.
Customise a standard statement
On the Profit and loss, Balance sheet, Cash flow and Budget vs actuals screens, Customise makes an editable copy with the same period and companies. The standard statement stays as it is. The copy is made when you save it.
Who can build reports
Administrators build and change reports, on a screen at least 768 pixels wide. Other users read the published reports, on any screen. A group can keep up to 30 reports.