Blog · Board and management reporting · Shipping and logistics
The complete customs hold calculation on ten entries from two customers on one lane, small enough to check by hand: each entry's filed and cleared dates, held flag, reason code and correction source, hold rate per customer against the lane norm, days held, the cause split into customer data, broker entry and authority selection, the two fields on one customer's invoices behind most of its holds, the cost in storage and delay, and the assertion that entries equal cleared plus held, so a reader can reproduce every figure and then run it on their own entry data.
A customs hold is a state per entry with a reason, and on ten entries the whole cause split can be done by hand. This page works the entries, the hold rate against norm, the cause split, the fields, the cost and the assertion. Lane norm: 5 percent.
| Entry | Customer | Filed | Cleared | Held? | Days held | Reason code | Correction source | Cause |
|---|---|---|---|---|---|---|---|---|
| 1 | A | 1 Sep | 1 Sep | No | 0 | |||
| 2 | A | 2 Sep | 6 Sep | Yes | 4 | HS missing | Customer supplied code | Customer data |
| 3 | A | 3 Sep | 3 Sep | No | 0 | |||
| 4 | A | 4 Sep | 9 Sep | Yes | 5 | Valuation query | Customer supplied invoice detail | Customer data |
| 5 | A | 5 Sep | 7 Sep | Yes | 2 | Value keyed wrong | Broker re-keyed | Broker entry |
| 6 | A | 8 Sep | 8 Sep | No | 0 | |||
| 7 | B | 2 Sep | 2 Sep | No | 0 | |||
| 8 | B | 4 Sep | 7 Sep | Yes | 3 | Physical inspection | None; no error found | Authority |
| 9 | B | 6 Sep | 6 Sep | No | 0 | |||
| 10 | B | 9 Sep | 9 Sep | No | 0 |
entries = cleared without hold + held: 6 + 4 = 10. Holds. Every held entry has a reason code.
| Customer | Entries | Held | Hold rate | Lane norm | Multiple | Median days held |
|---|---|---|---|---|---|---|
| A | 6 | 3 | 50% | 5% | 10× | 4 |
| B | 4 | 1 | 25% | 5% | 5× | 3 |
On four entries B's 25 percent is one hold; on a quarter's entries the count is what makes the rate mean something, and it is on the row.
| Customer | Customer data | Broker entry | Authority |
|---|---|---|---|
| A | 2 of 3 (67%) | 1 of 3 | 0 |
| B | 0 | 0 | 1 of 1 |
A's holds are mostly A's own documents. B's one hold is the authority's choice.
| Reason | Holds | Field on A's commercial invoice |
|---|---|---|
| HS code missing | 1 | Commodity code column blank |
| Valuation query | 1 | Declared value did not match invoice total |
Two fields on one template. Entry 5 was the broker's own keying and belongs on the broker's list.
Storage at $80 a day per entry; delay at a stated $150 a day for A's inventory.
| Customer | Days held | Storage | Delay | Cost |
|---|---|---|---|---|
| A | 11 | $880 | $1,650 | $2,530 this fortnight; the quarter's figure is the conversation |
| B | 3 | $240 | $450 | $690 |
Holds firefought, never rolled up. Entry 2 and entry 4 are the same template problem, handled twice.
No cause attribution. Entry 5 blamed on A; entry 8 blamed on B.
Norm ignored. On a lane held at 40 percent for everyone, A's 50 is nearly normal.
Cost not summed. Storage in one file, delay nowhere.
The same state and cause per entry, per customer and lane, against the lane norm, with the cost, every month. Covirage runs it on the entry data and the charges. The customs holds guide covers the measure, and the export preparation guide covers the same discipline on the analytics side.
By who corrected the entry: the customer supplied the missing code, so it is customer data; the broker re-keyed a value, so it is broker entry; the authority selected the entry for inspection and found nothing, so it is authority. The correction source field carries it, and the mapping is written once.
Because some lanes are held at a high rate for every customer under the authority's regime. A customer at ten times the lane norm is the finding; a customer at the norm on a hard lane is not. The norm is the broker's own hold rate on the lane and commodity group.
Storage charges while held, from the charges file, plus delay days at a stated rate for the customer's inventory. It is the customer's own cost, arriving as separate charges nobody adds up, and it is the number that makes the invoice template conversation happen.