Path: Settings > Accounts > Cross References

Cross reference mapping can be defined when there is a need to translate one GL account number from an outside system to a different GL number in SGA. Cross reference accounts are used when importing files from systems like payroll, membership or the like. 

Format: A unique name to identify a set of cross reference numbers. Multiple formats can be created as needed. The account mapping can be defined differently within each set.

Reference: The item from the outside source that gets assigned to a particular chart of account number.

G/L Reference: A description of the old reference number. This is an optional item and used only to help in being able to search for accounts by the description used in the external system

Account#: The SGA chart of the account number that the item gets applied to.

SGA Description: Description of the SGA Account (auto-populated)

__________________________________________________________________________________________________________________

Cross Reference Imports

Settings > Accounts > Cross Reference Imports

Cross reference mapping can be defined when there is a need to translate one GL account number from an outside system to a different GL number in SGA. Cross reference accounts are used when importing files from systems like payroll, membership or the like. Settings > Accounts > Cross Reference Imports. 

 Name: The name that will be displayed as the name of the import.

General

Connector type: See import connections for help with setting up a connection to a file to import.

Connection string: See import connections for help with setting up a connection to a file to import.

Reference columns by: See import connections.

Use schema: In certain situations, the import setup may require a way to name the individual items being imported and/or the type of information (text, decimal, etc.) contained in each column.

Account: You can either import the account# as just one column or multiple columns. You can add one or multiple rows to define all parts and order of the SGA account. 

Relative Account: Defines what account number to relate to in SGA. This can either by the SGA GL Account or the Alias. 

Columns

Format: Define what column in the external file contains the name of the cross reference format to use when adding the mapping. If the designated format does not exist, a new one will be created with the name given in the imported file.

Reference: Define what column in the external file contains the GL account number from the outside system.

G/L Reference: Define what column in the external file contains the GL account number’s description from the outside system. This is an optional item and used only to help in being able to search for accounts by the description used in the external system.