General Ledger sync
Nonprofit organizations have unique needs for recording transactions. The General Ledger account and journal entry sync takes information from different sources in Intacct and syncs this information from Intacct to Salesforce as managed lists.
Enable General Ledger sync
The General Ledger is the central ledger for your Intacct company, where you create and maintain accounts and journals.
To enable General Ledger synch:
- Log in to Intacct as an administrator.
-
Go to Company > Admin > Subscriptions > Advanced CRM Integration and select Configure.
- On the Settings tab, in the General Ledger Integration section, select the Enable General Ledger synchronization checkbox.
When checked, selected General Ledger accounts and journal entries are synced to Salesforce. - Select General Ledger Accounts, Journals, and Journal Entries to sync and Save your changes.
- Sync General Ledger Accounts
- Sync General Ledger Statistical Accounts
- Sync General Ledger Journals
- Sync General Ledger Statistical Journals
Sync General Ledger Accounts
It's not necessary to sync all General Ledger accounts to Salesforce. Intacct recommends syncing only those accounts that are intended for use on journal entry lines in Salesforce. General Ledger Accounts are a managed list that's only synced from Intacct to Salesforce.
To choose accounts to sync:
- Select the Select accounts to sync with Salesforce link.
The Select accounts to sync dialogue opens. - Add accounts by selecting them individually, or adding a range of accounts, or both.
How to add individual accounts or a range of accounts Add accounts individually Add a range of accounts - To add accounts individually, tap Select.
A list of available accounts is displayed. - Use the right arrow to move selected accounts from the Available items list to the Selected items list.
- Use Done when you finish selecting accounts.
A list of your selected accounts is displayed.
Use Add or edit to change the selected Accounts as needed.
- To add a range of accounts, use the From account dropdown menu to select a starting account.
- Select an ending account from the To account dropdown menu and select Add.
A list of the selected accounts is displayed. - Adjust the list as necessary.
- Use the X to remove individual accounts.
- Use Add or edit to add and remove accounts.
- Use Remove all accounts if you want to start over.
- Use Done when you finish selecting accounts.
A list of your selected accounts is displayed.
- To add accounts individually, tap Select.
- Select Synchronize to sync the General Ledger Accounts to Salesforce and select Close.
After configuration, any changes made to the selected Accounts in Intacct are synchronized with Salesforce. Accounts are stored on the Intacct Account object in Salesforce, which is a managed list.
The Intacct Account object in Salesforce contains this information.
| Salesforce field label | Data synced |
|---|---|
| Intacct Account name | Account title |
| Intacct ID | Account number |
| Normal Balance | Debit or Credit |
| Account Type |
Balance Sheet Account Income Statement Account |
| Active |
Checkbox An inactive account can be one that has been deleted in Intacct.
|
| Intacct Entity | Intacct Entity |
| Required Dimensions |
Checkbox Indicates which dimensions are required for General Ledger postings using this account.
|
Sync General Ledger Statistical accounts
It's not necessary to sync all General Ledger statistical accounts to Salesforce. Intacct recommends syncing only those accounts that are intended for use on journal entry lines in Salesforce. General Ledger statistical accounts are a managed list that's only synced from Intacct to Salesforce.
To select statistical accounts to sync:
- Use the Select statistical accounts to sync with Salesforce link.
The Select Accounts to Sync dialogue opens. - To add statistical journals, use Select.
A list of available statistical journals is displayed. - Use the right arrow to move selected statistical journals from the Available items list to the Selected items list.
- Use Done when you finish selecting statistical journals.
A list of your selected statistical journals is displayed. - Use Synchronize to sync the General Ledger statistical accounts to Salesforce and select Close.
After configuration, any changes made to the selected Accounts in Intacct are synchronized with Salesforce. Accounts are stored on the Intacct Account object in Salesforce, which is a managed list.
Sync General Ledger Journals
Journals are containers where Journal Entries are posted. Journals are managed lists that are only synced from Intacct to Salesforce.
It's not necessary to sync all journals to Salesforce. Intacct recommends you sync only journals that will are to post Journal Entries to Salesforce. Limiting the journals you sync can also help to protect against posting to unintended journals.
To select journals to sync:
- Use the Select journals to sync with Salesforce link.
The Select Journals to Sync dialogue opens. - Use Select to add journals.
A list of available journals is listed. - Use the right arrow to move selected journals from the Available items list to the Selected items list.
- Select Done when you finish selecting journals.
A list of your selected journals is displayed. - Use Synchronize to sync the General Ledger Journals to Salesforce and select Close.
After configuration, any changes made to the selected journals in Intacct are synchronized with Salesforce. Journals are stored on the Intacct Journal object in Salesforce, which is a managed list.
The Intacct Journal object stores the following information.
| Salesforce field label | Data synced |
|---|---|
| Intacct Journal name | Journal record title |
| Symbol | Journal symbol |
| Active |
Checkbox An inactive journal can be one that has been deleted from Intacct.
|
Sync General Ledger Statistical Journals
Statistical Journals are containers where Statistical Journal Entries are posted. Statistical Journals are managed lists that are only synced from Intacct to Salesforce.
It's not necessary to sync all statistical journals to Salesforce. Intacct recommends you sync only statistical journals that are used to post Statistical Journal Entries to Salesforce. Limiting the journals you sync can also help to protect against posting to unintended journals.
To select statistical journals to sync:
- Use the Select statistical journals to sync with Salesforce link.
The Select Journals to Sync dialogue opens. - Use Select to add journals.
A list of available statistical journals is listed. - Use the right arrow to move selected statistical journals from the Available items list to the Selected items list.
- Select Done when you finish selecting statistical journals.
A list of your selected statistical journals is displayed. - Use Synchronize to sync the General Ledger statistical journals to Salesforce and select Close.
After configuration, any changes made to the selected statistical journals in Intacct are synchronized with Salesforce. Journals are stored on the Intacct Statistical Journal object in Salesforce, which is a managed list.
Journal Entry Lines field mapping
See Journal Entry Standard Field Mapping for more information.
In this topic
