Skip to main content

Financial Module

The Sage Intacct General Ledger (GL) module in SEI provides two data models: GL Summary for account-level, summarized financial views, and GL Transactions for detailed, line-level transactions. Both data models use the same report codes for consistency in reporting. To ensure accurate balances and correct roll-up of accounts, you need to generate opening balances and configure report codes before using the cubes.

ModuleDescription
GL SummaryProvides a summarized, account-level view of financials. Useful for high-level reports. Opening and ending balances have their own fields.
GL TransactionsIncludes transaction details. Each account's opening balance appears as a record in fiscal period 1.

Benefits of the financial module​

  • Ensuring accurate opening balances: Maintain correct roll-forward and period-to-period balances for all key accounts.
  • Standardizing reports: Use consistent report codes so financial, operational, and ad-hoc reports always show matching numbers.

Mandatory configuration​

Calculate the opening balance​

  1. Log in to SEI.
  2. In the navigation panel, select Data Models and Views.
  3. Expand Sage Intacct, then General Ledger and Configuration.
  4. Right-click Calculate Opening Balance and select Execute Info Pages from the context menu.
  5. In the fields labeled From and To, enter the beginning and ending fiscal years for which you want to calculate the opening balance.
  6. Select GL Reports and/or GL Transactions as needed.
  7. Click Run.

Configure the report codes​

Report codes control hierarchical grouping and account rollup for all financial reports. The SEI template uses internal Sage Intacct account groups, but all reports (except Trial Balance) require you to define report codes manually.

  1. Expand Sage Intacct, then General Ledger and Configuration.
  2. Right-click GL Report Setup and select Execute Info Pages from the context menu.
  3. Under Manage Reports, enter the new report code and click Create.
  4. Under Create/Update Account Groups Hierarchy, click Update.
  5. Close the dialog once complete.
  6. From the Configuration folder, expand GL Report Setup and open the Report Setup worksheet.
  7. Expand your report code, then use the prompt in the Code column to fill in account groups.
    The order in which groups are entered determines how the final reports are sorted.

Edit the global variable​

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click Global Variables.
  3. Use the search box and enter REPCODE to quickly find the relevant global variables. There are separate variables for each report code:
    • Income Statement (IS): @@REPCODE_IS
    • Balance Sheet (BS): @@REPCODE_BS
    • Profit/Loss (PL): @@REPCODE_PL
    • Cashflow (CF): @@REPCODE_CF
  4. Click the pen icon next to each variable. In the Scripts field, enter the value that matches the report code you created, such as IS for the income statement.
  5. Click Update to save the value.
tip

Verify that the report codes were configured correctly by opening the Reports or Report Details worksheets in the GL Summary or GL Transactions data model.

Optional configuration​

Map UDD fields​

The financial module of the Sage Intacct template provides 20 user-defined dimension (UDD) fields that you can map as needed. These fields can be swapped and remapped at any time without having to reload all data into SQL, giving you flexibility to adapt to changing reporting requirements.

  1. Expand Sage Intacct, then General Ledger and Configuration.
  2. Expand the UDD Mapping for Live Template data model and open the UDD Mapping worksheet.
  3. In the Code column, use the prompt icon in each cell to map your UDD codes to the desired ID.
  4. In the Toolbar panel, select Save or Save As to save your changes.
  5. In the navigation panel, right-click the UDD Mapping for Live Template data model and select Execute Info Pages from the context menu.
  6. Under Map UDDs to View, click Execute Mapping.

Generate book exchange rates​

If Sage Intacct has the Consolidation Books module enabled, you can configure book exchange rates in SEI to view line-level details for consolidated books. Out of the box, the template supports up to two consolidated books; additional books can be added as needed.

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click Global Variables.
  3. Use the search box to find variables starting with BOOK.
  4. Click the pen icon next to @@GLOBALCONSOBOOK1 (or other book variables as needed).
  5. In the Scripts field, enter the book ID for your consolidation book exactly as it is defined in Sage Intacct.
  6. Click Update to save.
  7. In the navigation panel, select Data Models and Views.
  8. Expand Sage Intacct, then General Ledger and Configuration.
  9. Right-click the Book Exchange Rates data model and select Execute Info Pages from the context menu.
  10. In the fields labeled From and To, enter the period range for which you want to generate exchange rates.
  11. Leave Generate Lines for Manual Entry unchecked to automatically calculate exchange rates for every account-month combination based on Sage Intacct data.
    If you check this box, all rates are set to 1 and you must enter rates manually later.
  12. Click Generate.
    Generated exchange rates appear in the Book Exchange Rates worksheet. Adjust rates as needed.
note

Consolidated currency amounts do not appear in worksheets by default. You can find them under the Consolidated Currency Amounts folder in Dimensions and Measures on the Toolbar of the GL Transactions data model.