Reports are built on your P&L and balance sheet groupings, so check each item below before you create or edit a report.
Connections
- Your accounting system is connected and the first import has run. See Getting started with Xero or Getting started with QuickBooks.
- Optional: a CRM (HubSpot, Salesforce or Pipedrive) connected, if you want CRM data in report rows. See Subscription management and renewal tracking: Getting started with CRM integration.
- Optional: a Google Sheet or a Microsoft Excel spreadsheet, if you want to report on data from outside your accounting system. See How to add live metrics through Google Sheets or How to add live metrics through Microsoft Excel.
Access you need
- To connect Xero, a Xero login with Standard or Adviser permission. See What level of Xero access do I need to import data?
- To connect QuickBooks Online, Admin access in QuickBooks Online. See What level of QuickBooks do I need to import data?
- To change groupings or reports, the Admin role in ScaleXP. View only users see every report but can't change anything. See How to add team members and change permission levels.
Set up in ScaleXP first
- Your P&L and balance sheet are configured under Load Data > Configure P&L, BS, with every account in the right category. Changes there, such as renaming a group, apply to your reports straight away. Existing chart series keep their own names, which you change in Configure Chart. See How to configure your P&L and balance sheet in ScaleXP (single company) or How to configure your P&L and balance sheet in ScaleXP (consolidated company).
- Optional: a budget loaded, if you want to compare actuals against it. See How to add a budget or forecast.
Decide before you start
- Whether to upload your P&L groupings or create them by hand. Uploading takes an Excel .xlsx file, such as a list of accounts under each group or a board pack, and works for the Profit & Loss statement and the balance sheet, uploaded one at a time. See How to import your P&L groupings from an existing report or another system.
- Whether you want subgroups in your reports, or groups only.
- Which template to start a new report from: P&L, Balance Sheet or Cashflow, or Create my own report. See How to create a new report from a template.
- Which time periods to show, and whether to compare to a budget or report by tracking code or class. See How to create and edit report columns.
Next step
- When these are in place, go to Overview: Improve reporting and analytics.