Performance and Report Formats, explained.
Performance is where you read the numbers: the history month by month, and the month against the plan. It is also where you shape how every statement is laid out, and that layout follows you into forecasts and documents.
Financial History on the P&L. The mouse is over Online sales, so its format strip is showing. The rest of the year and the Year to Date column sit to the right of this excerpt. Home & Garden Retail Co is an example company, figures in £k.
1. Financial History and Performance vs Plan
Two ways to read the same lines.
Financial History lays the months side by side. Performance vs Plan takes one month and sets it against the budget and last year.
Performance opens on two tabs. Financial History shows your actuals for every reporting line, one column per period. Switch the period toggle between Annual, Monthly and, where the statement supports it, TTM for trailing twelve months. Annual has one column per year. On Monthly and TTM, pick the period from the Year end dropdown. Monthly ends with a Full Year column, or Year to Date while the year is still running.
Performance vs Plan is the month in context. Choose the Month, and in Compare to pick the adopted Budget or the adopted Revised Forecast. If neither is adopted there is no Compare to dropdown, and the plan columns show the rolling 12 month forecast, headed Forecast. The table has three groups of columns: the month, year to date and trailing twelve months. Each group shows the actual, the plan and the prior year, then a Variance pair: against the plan and against the prior year. The variance columns carry a small bar, blue to the right when the figure is up, red to the left when it is down. A company with twelve months of history or fewer gets a shorter table: the month and year to date only, each with the actual, the plan and one variance. The tab only appears once there is something to compare against.
Beneath both tabs sit the statements: P&L, Balance Sheet, Cash Flow, Key Metrics, plus Indicators for hand-entered figures. Sales & Margin appears when the company has Units. Dimensions, for breaking the P&L down by department, region or any other dimension, appears in Financial History once one dimension is enabled, and in Performance vs Plan once two are.
Indicators holds non-financial indicators such as headcount, transactions or enquiries: numbers that matter but are not in the accounts, typed in month by month. The tab appears when your workspace has indicators switched on, and the Non-Financial Indicators guide covers setting them up and reading them.
Drilling in. Click any line's name, or the small chart icon that appears at its left, and the line opens in the line window: the headline figure, how it moved against last month and last year, its trend chart with a TTM or Monthly toggle, and supporting charts for growth and percentage of sales. A Start Date dropdown in the header moves the chart back in time.
Performance vs Plan for June against the budget. The Year to Date and TTM groups, laid out the same way, sit to the right of this excerpt.
Click a line's name to open the line window.
2. Building Report Formats
The layout is a Report Format. Edit it right on the page.
A Report Format is a saved layout for one statement: which lines show, in what order, and how they look. It holds no figures. There is no edit mode to switch on: point at a line and the tools appear.
Every company starts with a Default format for each statement, copied from Actuly's starting layout. The Report Format dropdown in the controls bar lists your company's formats together with Actuly's own, which carry "(Actuly)" after their name and are read-only. Picking one changes what you are looking at. Clicking the blue star next to it does something more: it makes that format the company's active one, which every other screen, and every document block left on its default, opens on.
Point at any line and a small strip of icons appears just after its name:
- Drag to reorder moves the line among its neighbours. Dragging a Unit reorders the Units under that one line only.
- Line styling opens the styling window, covered in section 3.
- Reset unit order appears once a line's Units have been reordered, and puts them back in the order set on the Reporting Dimensions page.
- Move to section moves a line you added, or a calculation, into another section.
- Delete line removes a line you added, as long as nothing sits beneath it. Everything else can be hidden but not removed.
Add Line, in the Report Options menu under Editing, creates a line of your own with no figures, such as a heading or a label. It opens the styling window titled New Line with the name box ready, drops the new line at the top of the report, and you drag or move it into place.
The moment the layout differs from what is saved, a pill appears at the bottom of the screen reading Unsaved format changes, with Save, Save as new format and Discard. Each styling, add, move or delete is sent to the server and the table redraws from the result, so what you see before saving is exactly what you will get. Try to leave with unsaved edits and Actuly asks whether to save first.
Making your own format. Open the one closest to what you want, change it, and choose Save as new format. It saves what is on screen, edits included, under the name you give it. Then star it if it should be the company's active layout. Delete removes a format you made. Reset applies only to the Default and puts it back to Actuly's starting layout.
Top: Premises is being dragged below Staff Costs, and a line the user added shows the move and delete icons. Below: the save bar that appears at the bottom of the screen.
3. Line formatting and hiding
Every line can be renamed, styled, collapsed or hidden.
The styling window has two tabs. Appearance is how a line looks. Visibility is whether, and how, it shows at all. Both have a live preview.
Above both tabs sits Rename. Tick it, type a new name, and the line is called that everywhere, including its total row. The original name stays shown beneath so you never lose track of what it was.
Appearance. The preview at the top is drawn with exactly the styles the report uses, so it is a faithful miniature. Beneath it, four groups: Title style gives the row a background (Main title in pale blue, Second title, Subtitle in pale orange, or none). Text offers Bold, Italic, Uppercase and Indent. Rules draws a thin or thick line Above and Below. Spacing adds a gap above or below.
Visibility. The preview here shows structure rather than looks: where the line and its sub-items will land. Show this line as is one choice of four: a heading with its sub-items beneath, a single line showing its total, just its sub-items with no heading, or hidden. Two extra options: skip a lone sub-item and show what is beneath it directly, and keep the line even in months with no figures. Don't show totals drops the Total row under a group. And Hide from Financials reports or Hide from Forecast reports hides the line on one side only, which the two pills under the preview confirm.
Hide Cash or Tangible Assets on the balance sheet and a red warning reminds you that those lines are forecast as a category, so hiding them means a manual forecast instead.
Appearance restyles Staff Costs as a renamed, bold, uppercase subtitle. Visibility hides Overheads from forecasts only.
Seeing what is hidden
Hidden lines are gone from the page, which is the point, but you need a way back to them. Four controls in the Report Options menu handle it, and they do four different things.
Show hidden lines draws every line the format hides at half strength, figures and all, so you can restyle it, move it or unhide it. It reveals only what the format hid. It does not open groups collapsed to a single total line, and it does not bring back lines with no figures.
Choose report lines, on the P&L, Balance Sheet and Indicators tabs, is for rows with no figures yet, such as a new product, region or cost. A Unit with no figures, or an indicator with nothing entered, is not drawn. Open the dialog, tick a blank line or Unit, and Confirm: the page refreshes and the row is kept in the report with no data. Greyed ticks are lines with data, which always stay, and ticking a Unit ticks its line too. A kept row shows in Financial History, Performance vs Plan and documents however empty it is, and the forecast treats it as an ordinary row that you can give a method or type figures into. Untick a row you added to drop it again. On the Balance Sheet only lines can be kept, not Units. On the Dimensions tab it works with Break down by, but it is not offered once Columns turns the Units into columns, and kept rows do not show in those column layouts.
Show Blank Lines appears only on the Dimensions tab, when Columns turns the Units into columns or builds the All Dimensions matrix. Those layouts leave out rows that are zero throughout, and this brings them back. The ordinary P&L and Balance Sheet do not need it: they always show their lines, at zero when empty, and hide only Units with no figures.
Hide Sub items collapses every group to its total row for a quick summary view. It changes nothing in the format and flips back with Show Sub items.
Display Preferences, at the top of the same menu, is the other thing people reach for. It controls how numbers are written: millions, thousands or units; brackets or a minus sign; currency symbol; and decimals. These are stored per company and are separate from the Report Format. A format decides which lines exist and how they look; Display Preferences decides how the figures read.
With Show hidden lines on, the hidden Directors' remuneration line shows at half strength.
Ticked lines show in this report. Greyed ticks have data and always stay. Tick a blank line or unit to keep it in the report with no data, so documents and forecasts can use it, or untick one you added to hide it again.
Choose report lines. Retail and Online sales have data, so their ticks are greyed. Garden centre cafe has none yet and is ticked to keep it.
These preferences are stored per company
The options at a glance
| Where | Option | What it does |
|---|---|---|
| Name | Rename | Changes the line's name everywhere, including its total row. The original is shown beneath. |
| Appearance | Title style | Main title (pale blue background), Second title, Subtitle (pale orange), or none. |
| Appearance | Text | Bold, Italic, Uppercase, Indent. |
| Appearance | Rules | A thin or thick line Above and Below the row. |
| Appearance | Spacing | Space Above, Space Below. |
| Visibility | Show this line as | Heading with sub-items, a single total line, sub-items only with no heading, or Hidden. |
| Visibility | Also | Skip a lone sub-item and show what is beneath it directly. Show the line even when it has no figures. |
| Visibility | Totals | Don't show totals removes the Total row under a group. |
| Visibility | Reports | Hide from Financials reports, Hide from Forecast reports. |
| Hover strip | Drag to reorder | Reorder lines, or units under one line. Reset unit order undoes the latter. |
| Menu | Show hidden lines | Draws format-hidden lines at half strength so you can get them back. |
| Menu | Choose report lines | Keeps a blank line or Unit in the report with no data; feeds documents and the forecast. P&L, Balance Sheet and Indicators, not the Dimensions column layouts. |
| Menu | Show Blank Lines | Dimensions tab, when Columns is set; shows all-zero rows. |
| Menu | Hide Sub items | Collapses every group to its total. A view, not a format change. |
| Menu | Display Preferences | Units, minus style, currency symbol, decimals. Stored per company, not in the format. |
4. Formats in forecasts
Chosen in the forecast. Built in Performance.
The forecast pages use the same Report Format dropdown, so a budget reads like the P&L the board is used to. But a format can only be changed here.
Open any forecast and the Report Format dropdown is in its controls bar, listing the same formats. Pick one and the forecast redraws in that layout straight away, hidden lines and all. Lines marked Hide from Forecast reports stay out, and lines marked Hide from Financials reports come back, which is how one format serves both sides.
What you will not find on a forecast page is any way to edit the format. We treat the actuals as the source of truth, and many companies forecast at a different level. So create your formats in Performance and watch them flow into Forecasts.
The forecast page has a star of its own, but it is orange and belongs to the Forecast Version dropdown, where it adopts a budget. The blue star on Report Format and the orange star on Forecast Version do different jobs: one picks the company's layout, the other picks the company's plan.
The budget in the Board P&L format. Payroll and the hidden Overheads heading came from section 3. No star on Report Format here, and no strip on hover.
5. Formats in documents
The same layout, on the page.
Document tables can be built by format, so the board pack shows exactly the P&L the board sees on screen.
In the document builder, a P&L or Cash Flow block has a Type dropdown. Choose Profit and Loss (by format) or Cash Flow (by format) and a Report Format dropdown appears listing your Report Formats, Actuly's included. Balance Sheet and Key Metrics blocks are always by format, so the dropdown is simply there. A Custom Table has a By format mode too. And the Full Report block, which puts a whole statement on the page, monthly, annual or TTM, from your actuals or from a forecast, has a Report Format dropdown that defaults to the company's active one. It is wide, so the editor suggests a landscape section for it.
Everything in the format carries through: renamed lines, bold and indents, rules and spacing, collapsed groups, hidden lines. The table in the document, the preview in the editor and the PDF are all drawn from the same merged layout.
The one thing to watch. A document block remembers which format it uses. Delete that format in Performance and the block keeps showing its last figures behind an amber warning, with a Reset and refresh button that falls back to the active Report Format. Rename a format freely; delete one only when nothing points at it.
A P&L block by Report Format, and the warning a block shows when its format has been deleted.
One format, three places
Performance
Where formats are made. Point at a line, style it, hide it, reorder it, save. Star the one the company should open on.
Forecasts
Choose any format from the dropdown. The budget reads in the board's layout. Nothing can be edited here.
Documents
Tables and Full Reports by format. The PDF matches the screen, line for line.
In short
Shape the statement once. Read it everywhere.
- Financial History is the months side by side. Performance vs Plan is one month against the budget and last year.
- Point at any line to drag, style, move or delete it. The save bar appears when something changed.
- Appearance is how a line looks. Visibility is whether it shows. Show hidden lines gets them back.
- Forecasts use the formats but cannot edit them. Build in Performance, choose in the forecast.
- Document tables and Full Reports by format put the same layout on the page and in the PDF.
More guides
Keep going
Dimensions
Where dimensions come from, Standard and Split, the Dimensions view, forecasting by dimension.
Forecasting
Versions, the three ways a line gets its numbers, special lines, and why everything balances.
Documents
Getting the data right, blocks, your own calculations, AI text and the AI Assistant, saving, locking and exporting.
Workflows
Schedules, jobs and tasks, assignments and notifications, and where to see everything.
Non-Financial Indicators
Setting them up, entering them each month, reading, forecasting and reporting them.
Dashboards and the Scorecard
The Overview, the Companies list, the Scorecard's colours, and keeping them fresh.
All help guides
Every guide, grouped by what you are doing.
Still stuck? Contact support and we will get back to you.