Transportation Spend Management (TSM)
Breadcrumbs

General Ledger (GL) Codes

You must have the Enterprise subscription with role for the GL Code functionality. Contact your Client Success Manager to learn more.

The GL coding functionality allows you to assign GL Codes to specific charges based on specific rules created. These rules are applied to all new charges that flow through the PSI system and can be exported from PSI to then be loaded into your General Ledger system. Use this functionality to create, manage, and apply GL codes.

  1. Click Settings>GL Codes. The existing GL codes display, toggle between Chart of Accounts 01 and Chart of Accounts 02. You are allowed two Chart of Accounts.

Toggle COAs.png
GL Codes
  1. To change the priority of the GL codes, there are two options:

Option to Change Priority

Graphic

Click the double ellipse, drag and drop row to new position. The priority number updates.

Drag and Drop Code.png
Drag and Drop Rows

Click into the priority field, type the priority number or use arrows to change the number.

Edit Priority Field.png
Priority Field
  1. To create a GL Code Rule:

    1. Click Add GL Code Rule.

    2. Complete fields refer to the following table:

Field

Description & Instructions

Chart of Accounts (COA’s)

Enter the COA (either 1 or 2). If your company only has one chart of Accounts this defaults as 1.

GL Code Value (Required)

Type the GL code associated with rule.

Carrier

Carrier associated with the rule can have all carriers or a single carrier. Select from drop-down.

Alias (Required)

Type a description that describes the rule.

Description

Allows you to type a longer description then the Alias.

Apply radio buttons

Select how to apply the conditions either all conditions must apply or any of the conditions can apply for the rule (at least one rule must be met).

Add Condition (Type, Operator, and Value)

To add a condition:

  1. Select the Type.

  2. Select the Operator that indicates how the type and value should be compared (equal, contains, etc.).

  3. Depending on the type, the value field may be a text box instead of drop-down options. You may also be able to select more than one value from the drop-down. Select or enter the Value(s). If the field is a text box:

    1. Type text.

    2. Click green checkmark to add. The text displays underneath the value field. If needed, click X to delete the value.

    3. Repeat steps a-b for as many values as are needed.

GL Code Value.png
Add a Condition Example
  1. Click +Add condition to list below. The condition displays at the bottom of the table with the associated values.

To edit, click the pencil Pencil.png . If needed, click trash Trash.png to delete.

  1. Repeat steps 1-4 to add as many conditions as needed.

c. Click Add GL Code Rule.

  1. To edit GL code rule:

    1. From the grid, click the Alias or GL Code hyperlink in the grid.

      GL Code.png
      GL Code hyperlink
    2. Edit fields as needed.

    3. Click Update GL Code Rule.

If you click cancel and have unsaved changes, a prompt displays. Click Leave if you don’t want to update. Click Cancel and then Update if this was a mistake.

Unsaved Changes.png
Unsaved Changes Confirmation



  1. To generate unmapped shipments report for transactions not associated with GL codes and run newly created rules:

    1. Click Exception Reporting.

      Exception Reporting.png
      Exception Reporting
    2. To view all columns, click Show All Columns.

    3. Click Run GL Code Rules. Depending on the number of records this process may take some time, sometimes up to an hour.

      Run GL Code Rules.png
      Run GL Code Rules
    4. Enter the Start Date and if desired an End Date (optional).

      Select Date Range.png
      Select Date Range
    5. Click Save.

    6. After a few seconds, a tooltip displays indicating that this process may take up to an hour. After a few minutes, refresh the Exception Report.

You can spot check specific tracking numbers on this screen using the search feature. The Exception Report only shows lines that HAVE NOT been GL coded. This means that if you search for one that was previously blank and it no longer shows up on the report, it has now been coded.

  1. To view GL code data associated with charges:

    1. Create a custom report using the Charge GL Codes option in the Data column. Refer to Custom Reports.

GL Codes Custom Report.png
Custom Reports
  1. To upload to your GL system. Refer to Export to CSV.

    1. For CSV format, you must select One line per Charge.

    2. The exported file’s last column contains the GL Code Value.

CSV Report Results.png
Exported GL Codes