Example 3 - Defining the GL number using Sub-accounts and custom mapping:

iTracer gives you the flexibility of combining data fields from Spectrum and custom mapping Main GL Numbers in defining your GL number.

For example, your general ledger system uses an 18-digit GL number, which uses a 9-digit Main GL Number associated with MCCs as the first half of the GL number and the 9-digit employee ID field from Spectrum as the second half of the GL number. Your Allocation setup would use the Employee ID field as Sub-account 1 and Merchant Category Code as Priority 1 in custom mapping the Main GL Number. You would have to edit the Chart of Accounts to assign a Main GL Number to each MCC. Each transaction would have a Main GL Number and an Employee ID associated with it.

The Allocation setup would appear as follows:

You would assign the appropriate Main GL Number to all MCCs in the Chart of Accounts.

After you set the transaction date range, both the Employee ID field from Spectrum and the Main GL Number from the Chart of Accounts would be associated with each transaction.

When you build your interface file, you would then specify that the Main GL Number would be the first nine digits of the GL number and the Employee ID would be the last nine digits of the GL number.

For example, the GL number associated with the USAIR transaction above would be 320000789020210010.