Transportation Spend Management (TSM)

View Rate Audit Results

After adding contracts to the system, use Rate Audit Results to analyze discrepancies between agreed rates and invoices.

🎥

Watch this YouTube video explaining Rate Audit results: https://youtu.be/3xW1SZf8vkY.

The following instructions explain how to view Rate Audit results:

  1. Click Contract Management>Rate Audit Results.

  2. To view specific details:

    1. Select Date Range for the invoice date.

    2. Apply filters refer to PSI Apply Filters.

Filters do not change Actionable Insights data. Data Type options will be available in the future.

  1. The following numbered graphic and table explain key features:

Rate Audit Results.png
Rate Audit Results

Feature

Description

1

Date and Applied filters

Select date type and date range to narrow data. Use applied filters refer to PSI Apply Filters.

2

Total packages

Total amount of shipments that have been rated.

3

Total rate spend

Total amount of carrier charges billed to customer. What you were billed.

4

Total bill spend

Total amount of carrier charges rated by TransImpact. What you should have been billed.

5

Total variance %

Percentage (of the rated amount) of the variance between rated and billed amounts

6

Accounts with discrepancies

Use the bar graph to compare account's billed amount to the rated amount.

7

Service level

Use the bar graph to compare the service billed amount to the rated amount.

8

Surcharges

Use the bar graph to compare the surcharged billed amount to the rated amount

9

All shipments grid

Displays every line item that went through the rate audit process. Click the tracking number to view parcel details.

Parcel Details.png
View Parcel Details


10

Billing discrepancies grid

Click tab to view only records with a variance exceeding the configured threshold.

  • No discrepancy (variance = $0 or < threshold). Indicated by green checkmark.

  • Discrepancy found (variance > threshold). Indicated by red exclamation mark.

Threshold Indicators.png
Threshold Indicators
  • Threshold can be adjusted via the Edit variance threshold feature.

11

Export Data

Click to download excel file of data.

12

Edit variance thresholds

The variance between billed and rated spends over this value will be flagged as discrepancies. Click to Edit Variance Thresholds:

  1. Select either Percentage or Dollars.

  2. Enter value.

  3. Click Save Changes.