Help Center

How to create a new report from a template

Create a new report from your P&L, balance sheet or cash flow template, then set its time periods and save it.


1. Start a new report

  1. Go to Reports and click + New at the top of the sidebar, then New report.
Reports sidebar with the New menu open, showing New report and New folder

2. Choose a template

  1. Under Starting with a template, choose P&L, Balance Sheet or Cashflow. To build a report from a blank page instead, choose Create my own report.
Create New Report panel with Create my own report and the P&L, Balance Sheet and Cashflow templates

3. Set the time periods

  1. On the Time tab, set how many Months, Quarters and Years to display.
  2. If you want a budget comparison, pick a budget under Compare to. The preview on the right updates as you go.
New P&L report on the Time tab with Months, Quarters, Years and Compare to, next to a preview of the report
  1. To report from a fixed start date, such as the start of your financial year, use the Fixed Period tab. To report by tracking code or class, use the Classes, Locations tab.
New P&L report settings on the Classes, Locations tab with Value Basis, Class, Location and Time to display

4. Name and save the report

  1. Type a name for the report in the title box at the top of the preview.
  2. Click Save, or click Additional config options to save the report and open the report editor for further settings.

The report is fully customizable afterward: change time periods and budgets from the Columns dropdown, or click Edit to change rows and columns. In a consolidated company you can also report by entity - see How to report on specific entities in a consolidated company.


See the transactions behind a figure

Once your new report is ready, select any account row to see the transactions behind the balance. See How to see transaction detail behind account balances. For a full listing of every transaction across all P&L accounts for a month, quarter, year to date, or full year, choose Download Transaction Detail from the report’s Download menu (see How to download a report to Excel).


How it works

The report uses the most recently edited version of your P&L, balance sheet or cash flow configuration, so it reflects your current categories and groupings.