Report FAQs
Creating and managing reports
- Rename a reportDiscover expert tips and guidelines for effectively naming or renaming your reports to improve organization and clarity in your work.
- Pin a reportLearn how to prioritize important reports by pinning them to the top of your list for easy access and organization.
- Copy a reportHow to copy or duplicate a report on the Reports tab, including copying a report across entities in a consolidated company.
- Delete a reportLearn step-by-step instructions on deleting a report and streamlining your data management process efficiently.
- Download to ExcelDownload a report to Excel or CSV, choose how much detail to include, and export every transaction behind a P&L report.
Formatting and layout
- Reorder accountsChange the order of accounts, groups and subgroups within any P&L or balance sheet category, such as revenue or operating expenses.
- Second subgroup levelHow to set up and report on a second level of subgroup (subgroup level 2) in your P&L and balance sheet reporting.
- Variance colorsVariance analysis controls for showing positive and negative results
- Rename a column layoutChange the name of a saved column layout (column configuration, column preset) in the columns dropdown so every report shows the new name
- Delete a column layoutRemove or rename a saved column layout (column configuration, column preset) from the columns dropdown, and clear the "used on the following reports" warning
Dates, currency and balances
- Fixed time periodHow to set fixed start and end dates on report columns to build financial year, fiscal year, or other fixed period reports.
- Locked rowsWhich report rows have their own time period, why rows listed under another row are locked, and how to make one editable.
- Report currencyLearn how to easily change the currency for your report and customize it to fit your specific needs.
- Other currenciesLearn how to manage invoices and bills issued in different currencies through the system efficiently and accurately.
- Credit card balancesLearn how to troubleshoot and fix inaccurate credit card balance reporting issues in ScaleXP.
- YTD earnings differenceWhy year-to-date profit on a consolidated P&L differs from current year earnings on the balance sheet when subsidiaries report in other currencies, and how to align them.
Budgets and forecasts
- View budgetsLearn how to access and view uploaded budgets with ease and efficiency.
- Multiple budgetsAdd multiple budgets to your reports within ScaleXP
- Default budgetChoose which budget or forecast is the default for each reporting entity.
- Rename budgetsLearn how to easily modify the name of your budget in a few simple steps to keep your financial organization in check.
- Costs vs budgetLearn how to effectively track and report department or project costs compared to budget for better financial management and decision-making.
Departments and metrics
- Tracking codes and classesReport by Xero tracking code or QuickBooks class: one column per code, column or row settings, or charts on a dashboard.
- Zoho reporting tagsImport up to two categories of Zoho reporting tags, then use them as columns or rows in reports and charts.
- Track employeesLearn how to easily track the number of employees and efficiently organize them by department in ScaleXP
- Set up CACHow to set up customer acquisition cost (CAC) in ScaleXP by mapping sales and marketing costs, and why CAC may show as blank.
- Customers page reportsHow to create a new report on the customers page and use customer page reports in dashboards, reports, and presentations.