9.2 Create an Accounting Template

Purpose:  Use this document to create an accounting template in ctcLink.

Audience:  Finance staff

Creating the Template

Navigation:  NavBar > Navigator > Cash Management > Treasury Accounting > Accounting Templates

The accounting template depicts the correct accounting and debit and credit configuration for a given treasury transaction and business event.

The accounting template contains the following characteristics:

  • A unique template ID.
  • Options that determine how the correct ChartField Combination is selected.
  • An attribute (calculation type) that describes how the accounting monetary amount is calculated or derived.

An attribute that designates whether the accounting build requires review.

  1. The Accounting Templates search page displays.  It defaults to the Find an Existing Value tab.  In this example, we'll create a new template.
  2. Select Add a New Value
  3. Enter SetID.
  4. Enter Accounting Template ID.
  5. Enter Source Type = "BSP".
  6. Select Add.
Accounting Templates Add a New Value tab
  1. The Accounting Templates page displays.
  2. Enter description in the Description field.
  3. Check the checkbox Requires Review.  Note: Select the Requires Review check box to force a review of the accounting transactions that use this template. When selected, the system assigns error-free accounting entries that use this template a Provisional status. You can then use the View/Approve Entries page to review and change the status to Final.
  4. Select Status = "Active".
  5. Enter (or look up) information in the Journal Template field. (*For banking, this template should be TR_ENTRIES).
  6. In Line 1, enter Calc Type = "01".
  7. Select Sign type "Credit" or "Debit" or "Keep Sign" or "Reverse Sign".
  8. Select Determined By as "Bank Account" or "Explicit Chartfield".
  9. Select the Add a New Row [+] icon.
Accounting Templates page
  1. Add Line 2.
  2. Enter Calc Type = "01".
  3. Select the IU Anchor option.  Note: You can select the IU Anchor (interunit anchor) check box to specify one line of the template as the anchor. This field is required because the centralized processor uses it to generate interunit entries.
  4. Select Sign type "Credit" or "Debit" or "Keep Sign" or "Reverse Sign".
  5. Select Determined By as "Bank Account" or "Explicit Chartfield".
  6. Select the Chartfields tab.
Accounting Templates page
  1. Enter the ChartField string: Operating Unit, Account, Fund, Appropriation (optional), Class, and State Purpose etc.
  2. Select Save.
Chartfields tab
  1. Process complete.