This article explains how to add, move, format, and delete rows in a ScaleXP report, and how to edit columns for time periods, budgets, and variances.
How to add or change a row
To change, edit, or add to row content in a report, go to Reports > Edit > Edit rows.
To add a new row with data in it, click in the box at the bottom of the screen and select the data and/or formula you wish to add.
By selecting Formula, you can create your own combination of accounts, ScaleXP metrics, CRM data, and/or manual calculations. See How to create or edit a formula in a report for help on creating formulas.
To add a divider row (either blank or with text in it), click + Add divider (bottom right).
How to move a row
To move a row, click on the six dots at the far left of the row.
To change financial categories, groups, or subgroups (reorder, rename, and/or change included accounts), use the Configure base Profit & Loss or Configure base Balance Sheet button (top middle).
How to format a row
Click on a row to edit it. The row turns blue and reveals the editing icons, as shown below.
-
To rename the row, click the first icon (T shape), type the new name into the pop-up box, and save it.
-
To delete the row, click the second (trash bin) icon.
-
To style the row, click the third (paintbrush) icon to reveal formatting options such as bold/unbold, borders, color, and number formatting.
- Decimals: How to format the numbers in a report to show different decimal places or number type
- Color: How to add color to a report
- Borders: How to add a border to a report
- Click Bold to bold/unbold the text.
-
To choose the level of expansion detail for the row (so detail shows by default without expanding in reports, and shows when used in presentations), use the expansion dropdown menu. See How to expand/hide rows in a report.
Tip: To hide (or show) rows with nil values on all reports, go to Settings > Organization settings > Organization values and change the toggle under Hide accounts with 0 values.
How to edit columns (time periods, budgets, variances, and more)
You can edit columns from the main reports page or from within the report editor.
Choose from pre-selected columns or create your own combination. These can cover:
- time periods like month, quarter, year, year to date, etc.
- tracking codes, classes, or accounting entities — either individually or in combination
- budgets of your choice
- variances between columns
Read more in How to create and edit report columns.
Other helpful hints
Go to Configure base Profit & Loss or Configure base Balance Sheet to change the way accounts are categorized and create new groups. See How to configure your P&L and balance sheet in ScaleXP (consolidated company) or How to configure your P&L and balance sheet in ScaleXP (single company).
To change the definition of a metric for use across reports, KPIs, charts, graphs, and presentations, go to Settings > Metric library and find the definition you wish to change. See What is the ScaleXP metric library?
Related articles
- Getting started with reports: How to create and edit a report
- How to create or edit a formula in a report
- How to create a new report from a template
- How to format a report
- How to create and edit report columns
- How to report on specific entities and eliminations in a consolidated company
- FX rates: What foreign exchange rate is being used?
- How to report on Xero tracking codes or QuickBooks classes in ScaleXP
- How to configure your P&L and balance sheet in ScaleXP (consolidated company)
- How to configure your P&L and balance sheet in ScaleXP (single company)