Reconcile freight in transportation management

Completed

Freight reconciliation can be done manually, or it can be set up to happen automatically. To use automatic freight reconciliation, you must set up an audit master where you can define criteria that determine which freight bills are matched automatically.

Freight rates are calculated by the rate engine that is associated with the relevant shipping carrier. When a load is confirmed, a freight bill is generated, and the freight rates are transferred to it. The freight rates are apportioned as miscellaneous charges to the relevant source document (purchase order, sales order, and/or transfer order), depending on the setup that is used for the regular billing process.

The freight reconciliation process (which is also known as the matching process) can start as soon as the freight invoice arrives from the shipping carrier. The invoice can be received electronically or on paper. If the invoice is received on paper, you can generate an electronic invoice by using the freight bill as a template.

Diagram of the freight reconciliation process.

Manual reconciliation

If you're reconciling freight manually, make sure that you match each invoice line with the freight bill line or lines for the load that is being invoiced. You can complete this matching on the Freight bill and invoice matching page. If the amount on the invoice line doesn't match the freight bill amount, you must select a reconciliation reason for the difference.

If multiple reasons exist for reconciliation, you can split the unmatched amount across them. The reconciliation reason determines how the amount differences are posted in the general ledger. When reconciliation of the whole invoice amount is accounted for, it's submitted for approval and then the journal is posted.

Automatic reconciliation

To use automatic reconciliation, you must specify the schedule for reconciliation and the invoices and shipping carriers to use. The matching of the invoice lines and freight bills is done according to the setup of the audit master and freight bill type.

After you run automatic reconciliation, you must handle any invoices that the system can't match. You must then process these invoices manually before you can post all the invoices for payment.