AWB Reconciliation

In this article, you will learn how to upload invoices, identify missing/pending ones, mark them as complete, and compare estimated vs. real charges for freight, handling, and duties from the AWB Reconciliation screen.

Roles enabled to perform this action: Admin and Accounts Payable.

Once the new AWB freight charges are applied, the system re-calculates the per unit landed cost of all the products that are in the Staging Area, Inventory or already invoiced , regardless whether the product is in units or boxes.


AWB Reconciliation Summary Screen

On the summary screen, users can review their AWBs, check if they have an invoice, and view the invoice status on the system. The columns visible on this screen are explained below:

  • AWB. The AWB number assigned to that shipment

  • Ship Date. The date that the product was sent from the vendor.

  • Arrival Date. The date that the product arrives at the warehouse.

  • Origin. The origin port where the product was shipped from.

  • Total Cost. Combined total freight, handling, and duties cost. 

  • Boxes. Total boxes shipped on that AWB.

  • FBE. Full box equivalence of boxes column.

  • Freight, Handling, and Duties. Here, the user will see the status for each charge type. There are five statuses: Pending Approval, Approved, Send to External System, Synchronized, and Failed.

  • Process. This option is used to mark the AWB as Completed; there is also the option to unmark the AWB as "Not Completed."

To learn how to set the real AWB costs, read Set the AWB Cost.

Back to top


AWB Cost Status

As the AWB costs are entered with the corresponding invoices, you can check the status of each cost from the AWB reconciliation screen. The gray icon means the invoice is pending approval, while the green means it is already approved.

Back to top


Related Articles

Peacock