Help Center

Overview: Improve reporting and analytics

Your reports use your P&L and balance sheet groupings, so you set up the groupings once and then create or edit reports on the Reports tab.


What this guide covers

  • Grouping your accounts the way you report, by upload or by hand.
  • Finding, creating and editing reports.
  • Formatting a report, if you need to.

Set up in three steps

  1. Set up your P&L groupings under Load Data > Configure P&L, BS. Upload them with How to import your P&L groupings from an existing report or another system, or create them by hand with How to configure your P&L and balance sheet in ScaleXP (single company).
  2. Open Reports: Getting started with reports: How to create and edit a report.
  3. Create or edit a report: How to create a new report from a template and How to edit a report and create your own custom rows and columns.

Optional: format the whole report or single rows. See How to format a report.


What you get

  • Your reports on the Reports tab, which you can star, sort into folders and download to Excel or CSV. See How to download a report to Excel.
  • Formula rows that combine accounting data with CRM data, Google Sheets or Microsoft Excel data and ScaleXP metrics. See How to create or edit a formula in a report.
  • The transactions behind any account row, so you can check a figure without leaving the report. See How to see transaction detail behind account balances.
  • Groupings that apply everywhere: renaming, moving or regrouping accounts changes every report for that company, and moving accounts changes chart figures too. Existing chart series keep their own names, which you change in Configure Chart.

Where to go next