Create Account Group Hierarchies

Account groups organize your Sage Intacct accounts into the categories your reports use, such as the structure of your organization or financial categories. The GL Report Setup data model handles this setup. Create a report code, assign an account group code to each of its lines, then set the report code global variables so each report uses its code.

Create a report code

Creating a report code adds 100 blank lines to it, which you fill in the next section. A report code that already exists returns an error. You create it by running the GL Report Setup info page.

1. In SEI, select Data Models and Views from the navigation panel.
2. Expand Sage Intacct, General Ledger, and Configuration.
3. Right-click GL Report Setup and click Execute Info Pages.
4. Under Create/Update Account Groups Hierarchy, click Update.
5. Under Manage Reports, enter a report code and click Create.

Assign account group codes

1. Expand GL Report Setup and open the Report Setup worksheet.
2. In the Code column, enter a code for each account group.
3. Click Save Changes in the toolbar on the right.

Set the report code global variables

Complete this part after you create the report codes. Each global variable stores the report code of one financial report:

Report code global variables

• @@IS_REPCODE for the income statement report
• @@CF_REPCODE for the cashflow report
• @@PL_REPCODE for the profit/loss report
• @@BS_REPCODE for the balance sheet report

1. In the navigation panel, click the gear icon, then click Global Variables in the sidebar.
2. In the search bar, enter REPCODE.
3. Click the pen icon of a variable in the table.
4. In Script, enter the report code you created for that report, such as IS.
5. Click Update, then repeat for each variable.