G/L Transaction examples – A/P Load with Pro-Ration (Revenue)

Freight Bill linked to voucher for load is being transferred to Accounts Payable module.

Consider load:

Shipments on Load - Weight Distribution

Shipment

Origin

Destination

Weight (LB)

AAA

Chicago, IL

Denver, CO

5,000

BBB

Chicago, IL

Las Vegas, NV

10,000

CCC

Chicago, IL

Los Angeles, CA

25,000

Assuming Load Pro-Ration Strategy is Weight, the load level charges for load would be distributed to the shipments as follows:

Shipments on Load - Percentage of Load Weight

Shipment

Weight (LB) – Shipment

Weight (LB) – Load

Percentage of Total Weight

AAA

5,000

40,000

12.50

BBB

10,000

40,000

25.00

CCC

25,000

40,000

62.50

Total

40,000

 

100.00

The G/L Transactions generated when the voucher for this load is transferred to A/P would be:

G/L Transactions - A/P Load with Pro-ration

G/L Classification

G/L Account Type

Charge ID

Destination

Debit Amount

Credit Amount

A/P Expense – Revenue Shipment

Expense

MILE

Denver

200.00

 

A/P Control - Revenue Shipment

Liability

MILE

Denver

 

200.00

A/P Expense – Revenue Shipment

Expense

MILE

Las Vegas

400.00

 

A/P Control - Revenue Shipment

Liability

MILE

Las Vegas

 

400.00

A/P Expense – Revenue Shipment

Expense

MILE

Los Angeles

1000.00

 

A/P Control - Revenue Shipment

Liability

MILE

Los Angeles

 

1000.00

A/P Expense – Revenue Shipment

Expense

FUEL

Denver

20.00

 

A/P Control - Revenue Shipment

Liability

FUEL

Denver

 

20.00

A/P Expense – Revenue Shipment

Expense

FUEL

Las Vegas

40.00

 

A/P Control - Revenue Shipment

Liability

FUEL

Las Vegas

 

40.00

A/P Expense – Revenue Shipment

Expense

FUEL

Los Angeles

100.00

 

A/P Control - Revenue Shipment

Liability

FUEL

Los Angeles

 

100.00

Note: A separate debit and credit will be generated for each combination of shipment and charge code. Given that characteristics of the origin and destination shipping locations for each shipment are considered when creating G/L Transactions, the G/L Accounts numbers assigned to each charge could be different.

See Also

G/L Transaction examples

Load Pro-Ration example – by weight

Load Pro-Ration example – stop level charges by weight / distance