GL Account Selectors

General Ledger (GL) account selectors accept a GL transaction profile as input, and use decision tables that you create to apply the profile parameters to specific subscriber accounts.

You can create account selectors in My MATRIXX or import and export account selectors in CSV format.

Importing account selectors allows you to configure different target accounts based on different criteria, such as:
  • Tax Authority — A numeric string representing the tax authority for a given tax (such as 8334 = US CA SANTA CLARA COUNTY).
  • Tax Category — A two character string representing a tax category (such as 03 = commercial customers, 04 = residential customers, 01 = general merchandise, and so forth).
  • Tax Type — A two character string representing a tax type (such as 00 = federal excise tax, 01 = state sales tax, and so forth).
If you import account selectors from a CSV file, the format must follow these rules:
  • The first row of the file must define the columns with the normalizers listed first and the account selectors listed second.
  • For normalizers, identify the column name as a normalizer in the format normalizer_name=Normalizer, where normalizer_name is the name of the normalizer as defined in My MATRIXX. For example, TaxType=Normalizer.
  • For account selectors, identify the column name in the format account_selector_name=GLAccountSelector, where account_selector_name is the name of the account selector that populates the GL Account Selector List in My MATRIXX.
  • The account type must be appended with a semi-colon (;) after the account selector as an attribute For example, account_selector_name=GLAccountSelector;AccountType=Debit.
In the following example, there are three normalizers and two account selectors, one with an account type of debit and one with an account type of credit.
TaxType=Normalizer,TaxCategory=Normalizer,TaxAuthority=Normalizer,DebitGLAccountSelector=GLAccountSelector;AccountType=Debit,CreditGLAccountSelector=GLAccountSelector;AccountType=Credit
The Account Selectors table describes one possible version with values:
Table 1. Account Selectors
TaxType=

Normalizer

 TaxCategory=

Normalizer

 TaxAuthority=

Normalizer

 DebitGLAccountSelector=

GLAccountSelector

;AccountType=

Debit

 CreditGLAccountSelector=

GLAccountSelector

;AccountType=

Credit
82 01 8334 120131 224013
82 01 8332 120131 224013
1 05 8334 120132 224014
1 05 8332 120132 224014
When you import account selectors, the following happens:
  • A new decision table is created with a unique name.
  • For each normalizer column in the CSV file:
    • The normalizer is identified in the pricing file. If the normalizer does not exist, the import is cancelled and an error displays in My MATRIXX.
    • A column is added to the decision table for this normalizer.
  • If the column is an account selector:
    • If an account selector already exists in the pricing file with the same name, a new revision of the account selector is created in My MATRIXX. Any existing GL account tables are deleted in the new revision.
    • If the account selector does not exist in pricing, a new account selector is created in My MATRIXX. A new GL account table is created in this account selector, to which a decision table is assigned.
  • For each row in the CSV file:
    • A row is added to the decision table.
    • For each normalizer column, the each value in a row for this normalizer is matched to a row in the decision table. A new cell is added to the decision table with ID of this value.
    • For each account selector column, the GL account table for the GL account selector is identified and a result for each row is added to the account selector table.