Skip to main content

Reporting Codes

This feature allows accounts to be mapped to standardized reporting groups within Nectari, which are then used to automatically calculate financial KPIs and populate dashboards. By abstracting differences in companies and chart of accounts structures, reporting groups ensure consistent, accurate metrics across all reports while enabling high-level financial analysis without manual adjustments or custom reporting.

Benefits of using reports with account groups​

  • Consistent KPIs across dashboards: Ensures all financial metrics are calculated using a single, standardized mapping logic.
  • Flexible to different accounting structures: Adapts easily to variations in charts of accounts without changing dashboards or formulas.
  • Reduced manual effort: Eliminates the need for repeated account selections or custom report maintenance.
  • Improved accuracy and trust: Centralized mappings reduce the risk of inconsistencies and reconciliation issues.
  • Scalable and reusable: Once defined, reporting groups are automatically applied across all current and future financial analyses.

Configure account groups​

Map accounts to reporting codes​

  1. In the navigation panel, select Data Models and Views.
  2. Expand Sage Intacct, then Common Data and Reporting Codes.
  3. Right-click the Reporting Codes Setup data model and select Execute Info Pages.
  4. Under Account Mapping, use the prompt the select a company, then click Generate.
    This generates all the default reporting codes used for financial KPIs.
  5. Under Manage Reports, choose a report code and click Create.
  6. Expand Reporting Codes Setup
  7. Open the Reporting Codes Setup worksheet, expand the Generated group and fill in the Accounts columns with corresponding account numbers:
    • Use commas and colons to separate Accounts and Intervals respectively (ex: 12100,12250:12300,12305).
    • Use asterisks to replace multiple characters (ex: 456* means all accounts beginning with 456).
    • Use question marks to replace only one character (ex: 456? means the 4-digit accounts beginning with 456).

Optional: Import account groupings from Sage Intacct​

  1. In the navigation panel, select Data Models and Views.
  2. Expand Sage Intacct, then Common Data and Reporting Codes.
  3. Right-click the Reporting Codes Setup data model and select Execute Info Pages.
  4. Under Refresh Reporting Codes from Sage Intacct, click Import.
    This imports all the account groupings used in Sage Intacct which can then be used in custom reports.