Skip to content
English
  • There are no suggestions because the search field is empty.

Update Load Charges in Bulk from a Weekly Rate Sheet

If a customer sends you a weekly sheet of load rates, you can now update the charges on all of those loads at once. Upload the sheet, and Truckpedia finds each load by its Reference number and updates its charges. No more opening loads one by one.

Before you start: Bulk Update Loads works for companies that are fully switched to the new load charges (Charge2). If you see the message "Only companies fully switched to Charge2 can update loads in bulk", contact us at help@truckpedia.io.

Step 1: Open Update Loads

  1. Go to Dispatch.
  2. Click Import.
  3. Choose Update Loads.

Import menu with Update Loads option

Step 2: Download the template

In the Bulk Update Loads window, click Download Template to get a sample file.

Bulk Update Loads window with Download Template button

Important: Each row replaces all existing charges on the matching load. Any charge that is not in your file will be removed from that load.

Step 3: Fill in your rate sheet

Your file needs one Reference column, plus one column for each charge you want to set. Name each charge column after the matching account item in Truckpedia, such as Hauling fee, Fuel Surcharge or Lumper.

ReferenceHauling feeFuel SurchargeLumper
900240011000200100
900240021000200
  • Each row updates the load with the same Reference number.
  • Leave a cell blank if that load shouldn't get that charge.
  • The template starts with two note lines (starting with #). Delete them before you upload.

Step 4: Upload the file and check the columns

  1. Click Click to Upload and choose your Excel or CSV file.
  2. Truckpedia lists each column with a few sample values. Check that each column in Select Type is matched to the right item: Reference for the reference column and the correct account item for each charge.

Uploaded file with Select Type mapping for each column

To change a match, open the dropdown and pick a different account item.

Select Type dropdown listing account items

Step 5: Import

When everything looks right, click Import Loads. The charges on each matching load are updated.

Import Loads button

Tip: Spot-check a couple of loads after the import to make sure the new charges look right.

💬 Need help? Contact us anytime at help@truckpedia.io.