ElyxAI

Excel for a customs broker: which entry does not match the invoice

The customs workbook on this page is the list you open before the morning read of declared values. One row is one entry. You type the entry, the client, the invoice value, the declared value, and the duty amount copied from the document you already hold. The gap is invoice minus declared while the row is still open. The window says under when that gap is above zero, over when it is below zero, and match when the two values are equal. This file is not an export price grid. That grid answers a selling price. This list answers which declared value does not match the invoice you typed. It is not a supplier invoice register, and it is not a delivery tracker. You type both values. The sheet does not look up a duty rate. The guide below builds that value list. Elyx writes the gap and the window in the workbook you already keep. You still type the invoice, the declared value, and the duty. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What goes on a customs value list?

One row per entry: invoice value, declared value, and a window of under, over, or match.

Does the sheet calculate the duty?

No. You type the duty amount. The gap is only invoice minus declared.

Is this a delivery tracker?

No. A delivery tracker uses a promised date and an actual date. This sheet uses the two values you typed.

Essential
Popular