GL Account Balance Synchronization

For DataSync to be able to read GL account balances directly from Sage Intacct, users must create Reporting Periods for each year that will be reported on in SEI.

To setup in Sage Intacct:

1. In Sage Intacct, navigate to General Ledger > Setup > Reporting Periods.

   

2. Click Add to create a Reporting Period.

   

3. Enter reporting period information according to the screenshot below.

   

   Note  

   We strongly recommend using the standardized reporting period name “SEI Opening <YEAR>”.

   

To modify the filter in DataSync:

1. Locate your tracking-enabled synchronization/consolidation extraction(s) and click on the number under Tables.

   

2. Search for balance using the text box and hover over the Filter field for the Glaccountbalance table. Click on the icon to edit the filter.

   

3. Within the brackets following Period IN…, enter your Reporting Period names in a comma-separated list. All items in the list must be wrapped in single quotes. View examples and screenshot below for reference.

   Example list:

   ‘SEI Opening 2020’,

   ‘SEI Opening 2021’,

   ‘SEI Opening 2022’,

   ‘SEI Opening 2023’,

   ‘SEI Opening 2024’