Skip to main content

Reports with Account Groups

Using account groups in Sage Intacct enables flexible reporting and custom grouping of accounts for financial analysis. By configuring account groups, you can align reports with your organization’s structure, summarize by financial categories, and quickly generate reports similar to standard Sage Intacct outputs.

Benefits of using reports with account groups​

  • Customizing report structures: Adapt and manage how account balances are grouped and reported, making reports more meaningful for your business.
  • Running efficient financial analysis: Produce summaries, roll-ups, and detailed analysis that reflect your own chart of account groupings.

Configure account groups​

Update account group hierarchy​

  1. In the navigation panel, select Data Models and Views.
  2. Expand Sage Intacct, then General Ledger and Configuration.
  3. Right-click the GL Report Setup data model and select Execute Info Pages.
  4. Under Create/Update Account Groups Hierarchy, click Update.
  5. Under Manage Reports, choose a report code and click Create.
    It creates 100 blank lines for this report code. If you select a report code already used, the system displays an error message.

Assign account group codes​

  1. In the navigation panel, expand GL Report Setup.
  2. Open the Report Setup worksheet.
  3. In the Code column, enter a code value for each account group.
  4. In the Toolbar panel, select Save or Save As to save your changes.

Configure reports​

Calculate balances for reports​

  1. In the navigation panel, under the General Ledger folder, right-click the GL Reports data model.
  2. Select Execute Info Pages from the context menu.
  3. Under Calculate Balance, enter the period using YYYYMM format.
  4. Check or uncheck Use existing precalculated balance if exists. If this is checked, you may need to re-run the Info Page after adding older-dated documents, such as a late invoice, so that balances include these transactions.
  5. Click Run.
important

The Calculate Balance feature uses the fiscal year and period you specify. For example, if your fiscal year begins in May, May 2021 appears as 202101 or as 202201, depending on your global variable configuration.

Generate group-based financial reports​

  1. Under GL Reports, open the Reports worksheet.
  2. Enter values for report code, fiscal year, and fiscal period.
    It generates generates a report that matches Sage Intacct standard outputs.
  3. In the Toolbar panel, select Save or Save As to save your changes.

Schedule daily refresh for GL balances​

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click OLAP Manager. This opens the OLAP Manager in a new window.
  3. Select Cube for refreshing the GL balances daily from the list. The Cube Details dialog opens on the right.
  4. In the Options panel, select the Navigation icon and click Scheduler.
  5. In the Options panel, click Add Job.
  6. Enter all required fields to set up your job.
  7. Click Save to schedule the refresh.