Add Mapping for Adjustments

In order to generate GL distributions for adjustments at your organization, you can map the transactions to GL accounts or account codes. For adjustments, the debit comes from the bank account.

Here are examples of an account and account code mapping for adjustments:

Transaction Type

Credit #

Deposit adjustment

01-4000-00 (revenue)

Payment adjustment

5000 (expense)

When you specify account code, other segments are derived from selected characteristics of the transaction. For more information about how to define segment mappings, see Define Segment Mappings.

Add mapping for an adjustment

  1. From the Treasury Office page, select the Adjustments tab. The Adjustments tab appears.

  2. Select Add. The Define mapping screen appears.

  3. In the Credit column, select the accounts or account code to use when generating GL distributions. To locate an account, you can use the Account Search. For information about the Account Search screen, see Account Search Screen.

    You create accounts on the GL Accounts page of the General ledger setup section in Administration.

    Note: The GL distribution is based on the type of adjustment you select. You do not need to select a cash account because the adjustment is linked to a bank account which is already associated with a GL cash account. For example, a deposit adjustment of $5.00 is mapped to Account code 4003. The adjustment is linked to a bank account that is associated with GL cash account 1001. Once processed, the GL distribution will show that $5.00 has been debited to cash account 1001 and credited to account 4003.

  4. Under Generation criteria, select the arrow to access the Adjustment types screen.

  5. Under Adjustment type, select the type of adjustments you want to include when the program generates GL distributions. For example, you can select “Deposit” or “Payment.”

  6. Select OK. You return to the Define mapping screen.

  7. Select Save. You return to the Adjustments tab.