Getting started with reports: How to create and edit a report

Find, pin, format, edit, and create reports in ScaleXP, and set report dates and columns.

This article will set you up to create reports within ScaleXP. It's really important that you have configured your P&L and balance sheet within the Load Data tab before creating your first reports.

This is detailed in these articles:

You can watch the video below, or follow the steps to configure your first reports in ScaleXP.


Find the reports section

Find reports by clicking on Reports in the top menu bar.

Reports in the top menu bar

You can see the list of reports on the left sidebar. Some basic financial reports are pre-populated for you as a starting point; these are fully customizable.

Select the report to view using the menu on the left sidebar; it will be highlighted in blue and the title will appear at the top left of the page.

All reports are downloadable and instantly available for use in presentations. At the top of the page you will see the report name on the left. This title can be edited either here or in the sidebar view.


Pin reports (optional)

To the left of the title is a star. Use this to pin key reports for easy reference. Pinned reports appear at the top of the list, in the STARRED section.


Select dates and column configuration

Next to the title is the report date. This reflects the month deemed to be "current" for report date ranges. You will also see a list of column options, including various date ranges and views against budget. Where relevant, you can also add views by entity, department, and more.

Read more about column options, as well as fixed versus variable date ranges, in How to create and edit report columns.


Format an existing report

Use the Format button (top right) to format the whole report at once. Options include adding a % of revenue column, showing general ledger account numbers, showing values in thousands, setting decimal places, showing negatives in brackets, and changing the currency.

See How to format a report for detail on all of these options, and How to add a % revenue column for the new % of revenue toggle.


Edit an existing report

Any report can be edited in terms of content and default time period. These options are found in the Edit menu (top right button).

Read more in How to edit a report and create your own custom rows and columns.


Create a new report

To add a new report, click the + New button, then select New report.. Read more about new report options in How to create a new report from a template.


Organise your reports: Create folders

To add a new folder, click the + New button, then New folder.   Then move any unstarred report into the folder.

Read more in How to create folders for Reports


Organise your reports: Reorder reports and folders

Reorder your reports by clicking on a report name and dragging it to a new position.within the list on the sidebar.

Move within the starred section, within a folder, or within the list below the folders.

Similarly, reorder folders by clicking on a folder name and dragging it to a new position within the folders list.

 

Should you want further clarification or help getting your reports set up, don't hesitate to contact support@scalexp.com.