Audits
Recent audits
All the spreadsheets you've checked, and how CargoPilot reaches each result.
How CargoPilot decides
How each check and recommendation is worked out, in plain terms.
Who decides pass or fail?
Fixed rules in the code, never the AI. The same booking always gets the same result. The AI only reads what you type and writes the replies.
R-02: what does “within 1%” mean?
We add up quantity × unit price for every item. The declared value can be at most 1% above or below that total. If the items add up to £0, the check fails and asks for prices.
R-05: which carrier is checked?
The carrier that best matches your priority (for example, the cheapest), unless you pick one yourself. If that carrier can't take your pallet weight, the check fails and you can either add pallets or switch to a carrier that fits.
R-06: how are restricted goods found?
We scan item descriptions. Clear matches like lithium, aerosol or petrol fail straight away. Unclear ones like batteries, sprays, perfume or electronics ask you to confirm. This is a quick screen, not an official dangerous-goods check.
R-10: what counts as “today”?
Today's date in the UK. A ready date of today passes.
Missing details
If a check can't run because something is missing, it shows as waiting, never as passed. The booking stays at Needs Attention until the details are added.
Booking status
Grounded means at least one critical (Red) problem. Needs Attention means warnings, items to confirm or missing details. Cleared for Dispatch means every check passed. You can keep a warning with a note, but critical problems always block shipping.
Corrections
Suggested fixes are only applied when you click them. Every change records the old value, the new value and the time. Your uploaded spreadsheet is never changed.
Balanced priority
Each carrier on the route gets a score out of 100 for cost, speed and reliability, compared with the other carriers on that route. Cost counts for 40%, speed for 30% and reliability for 30%. If two carriers tie, the cheaper one wins.
When carriers tie
Cheapest: lower cost, then better on-time record, then faster. Fastest: fewer days, then better on-time record, then lower cost. Most reliable: better on-time record, then fewer days, then lower cost.
Spreadsheet checks
The template's grey example row is skipped when you add your own rows. We also flag repeated Booking IDs, items with no matching booking, bookings with no items, and numbers or dates we can't read. Nothing unreadable is ever treated as 0.
What “confirmed” means
You have approved the booking CargoPilot prepared. CargoPilot does not book the carrier or clear customs for you.
Rulebook (fixed)
| R-01 | Every item must have an HS code of at least 6 digits | Red |
| R-02 | Total declared value must equal the sum of quantity × unit price across all items (within 1%) | Red |
| R-03 | For each item, units per carton × cartons must equal quantity | Red |
| R-04 | Total cartons on the booking must equal the sum of cartons across all items | Red |
| R-05 | Weight per pallet (total gross weight ÷ pallets) must not exceed the chosen carrier's max weight per pallet | Red |
| R-06 | No lithium batteries, aerosols or flammable liquids | Red |
| R-07 | Total gross weight must be at least the sum of unit weight × quantity across all items | Amber |
| R-08 | Shipments to a warehouse must have a delivery appointment booked | Amber |
| R-09 | Every item must have a country of origin | Amber |
| R-10 | Ready to ship date must not be in the past | Amber |
Carrier rate card (fixed)
| Carrier · service | Route | £/pallet | Transit | On time | Max kg/pallet |
|---|---|---|---|---|---|
| Carrier A · Road economy | UK → Germany | £180 | 5 days | 92% | 500 |
| Carrier B · Road standard | UK → Germany | £220 | 3 days | 95% | 750 |
| Carrier C · Road express | UK → Germany | £340 | 2 days | 98% | 400 |
| Carrier A · Road economy | UK → France | £170 | 5 days | 92% | 500 |
| Carrier B · Road standard | UK → France | £210 | 3 days | 95% | 750 |
| Carrier C · Road express | UK → France | £330 | 2 days | 98% | 400 |
| Carrier A · Road economy | UK → Netherlands | £160 | 5 days | 92% | 500 |
| Carrier B · Road standard | UK → Netherlands | £200 | 3 days | 95% | 750 |
| Carrier C · Road express | UK → Netherlands | £320 | 2 days | 98% | 400 |