- Before
- “The format checker tells me it failed. It never tells me what the right value is.” Every FNA for tonight's US and EU departures lands on her desk.
- Now
- Opens each waybill already checked against five records, approves or edits each correction with its source, sends the drafted question and accepts when every field agrees.
One consolidation, from received to accepted — air waybill data validation screen by screen
Thursday, October 15, at São Paulo Guarulhos (GRU). Corvane Airways flight CV 950 to New York JFK leaves at 23:10, with acceptance cut-off at 19:10. Andara Freight Brasil has sent master 951-48213395 with four houses. Here is what happens next in the working solution.
- 0114:52
What needs her today, closest cut-off first
Renata Alves · Cargo Acceptance Agent, GRUSince 06:00 the agents have checked 64 master waybills and 212 houses for tonight's five departures; 41 are clean. Fourteen need Renata, with 18 corrections proposed, six are waiting on forwarders and three are held. The first cut-off is CV 126 to Madrid at 16:55. At the top of her list: 951-48213395 on CV 950 to JFK, master 16 pieces, houses 18, four corrections.
House Reconciler: “951-48213395: the four houses add up to 18 pieces, the master says 16. One house arrived after the master.”
- 02One click
The waybill as the familiar form, with an x-ray over it
Renata Alves · Cargo Acceptance AgentThe e-AWB opens laid out as the IATA air waybill form. Each field carries a quiet tick where it agrees with the booking, the houses and the shipper's history, and a question mark where it does not. The strip above shows the flight, a 787-9 into the US, 16 pieces on the master, 2,612.0 kg, the CBP ACAS filing that goes on acceptance and four corrections. Beside the form is the conversation with the agents.
“Fields marked with a tick agree with the booking, the houses and the shipper's history.”
- 0314:46 to 14:47
Master and houses, added up
Message Reader and House ReconcilerThe Message Reader read the master FWB, four house FHLs, booking FFR and commercial invoice CI-SA-20931: 41 fields to check. In the Houses view the sum is plain: 5 + 7 + 4 + 2 = 18 pieces and 2,840.0 kg, against 16 pieces and 2,612.0 kg on the master. House ANDGRU-77143 arrived at 13:05, after the master was sent at 11:52, and the master was never updated.
The House Reconciler never adds or deletes a house; it reports the difference.
- 04Every number
The source passage, one click away
Renata Alves · Cargo Acceptance AgentEach correction carries numbered sources. A click opens the passage itself: here the FHL for house ANDGRU-77143, with 2 pieces and 228.0 kg highlighted, received at 13:05:41. Renata can trust the correction without opening the messaging hub, the booking system and the invoice herself.
“Messaging hub · received 13:05:41 · the master FWB (11:52) was not re-sent.”
- 0514:48 to 14:51
Four corrections, and a second agent checks each one
Booking Matcher, Code Checker, History Checker and ChallengerThe booking says 18 pieces and 2,850 kg, so the houses are within 0.4%; corrected, the weight charge at the booked Q rate of $2.85 per kg rises from $7,444.20 to $8,094.00. House 77142 says only “SPARE PARTS” with no HS code; the invoice reads hydraulic pump assemblies, so 8413.60 fits, but the shipper classifies its own goods. House 77141 has no consignee telephone; three past filings give +1 937-555-0147. The Challenger re-derived all four from the sources and agrees.
Challenger: “On 77142, 8413.60 is likely; 8413.70 if the pumps are centrifugal, so the forwarder must say.”
- 0614:53 to 14:56
She approves two fixes and sends one question
Renata Alves and the Forwarder LiaisonRenata approves the master's pieces and weight at 98% confidence and the charge that follows, $649.80 more. The Forwarder Liaison has already drafted one question to Luiza Costa at Andara covering houses 77142 and 77141: what is wrong, the value the agents propose and why. Renata sends it and holds the shipment with reason H2, awaiting forwarder data.
The Forwarder Liaison never sends without a person and never accepts a shipment.
- 0715:40
Andara answers; the agents re-check on their own
Forwarder LiaisonLuiza Costa replies and re-sends the two FHLs. The agents read them and re-check step by step: “HYDRAULIC PUMP ASSEMBLIES FOR AGRICULTURAL TRACTORS” with HTS 841360, precise and six digits; the consignee telephone, matching three past filings. The Challenger agrees: gear pumps, so 8413.60. The customs filing is ready with 18 pieces, 2,840.0 kg and four complete houses.
Forwarder Liaison: “Every field now agrees. Accept, and clear the H2 hold?”
- 0815:44 · Accepted
Accepted and signed: the RCS goes, the ACAS filing goes right
Renata Alves · Cargo Acceptance AgentRenata accepts and signs. The H2 hold clears, because the data it waited for arrived and was re-checked; the RCS goes to the cargo management system and the ACAS filing goes to CBP with 18 pieces and both house corrections. Four errors were fixed before acceptance, while the FWB could still change, and $649.80 of freight was billed that would have flown free.
“After this, the FWB can no longer change.”
- 09Meanwhile
Holds closest to cut-off, with the agents' advice
Tomás Ibarra · Cargo Operations Supervisor, GRUThree other shipments are held. On 951-48209910 to Madrid, Pinehurst has not answered a question about Verified Known Consignor status since 11:05, and the Forwarder Liaison suggests offloading to tomorrow's CV 126 if there is no answer by 15:55. Release and offload take a reason code and need the supervisor role: an acceptance agent sends the request to Tomás, and he decides.
“The agents never release, accept or offload a shipment; at 60 minutes before cut-off they alert Tomás Ibarra.”
- 10This week
Fixing it at the source: a coaching letter for the forwarder
Daniel Whitcombe · Cargo Data Quality LeadAndara Freight Brasil is at 84.1% first time right over 30 days, against a 97% goal. The Data Quality Coach found its masters sent before their last house 41 times, including 951-48213395 today, and drafts a plain letter to Luiza Costa with three repeat mistakes, each with a real example and the fix. Nothing is sent until Daniel approves.
Data Quality Coach: “Suggest Andara sends the master last.”