- Before
- Checks 212 handler invoices a month by sampling lines in spreadsheets and writes dispute emails by hand. “I can't prove a GPU wasn't plugged in, so I pay it.”
- Now
- Opens each invoice with every line stitched or left loose, confirms groups in one tap, keeps paying where the Verifier says the handler is right, and signs a letter built from her own decisions.
Ground handling invoice reconciliation on one Denver invoice, screen by screen
Corvane Airways contracts handlers at 118 stations under 64 agreements. SkyRamp Services' September invoice for Denver — SRS-DEN-260930, $412,880.00, 678 lines, received through IATA SIS on Oct 3 with 41 scanned ad hoc service records, due Nov 2. Here is what happens next, in the working solution.
- 01Friday, 6:02 am
The agents worked overnight; four things need her
Megan Alvarez · Ground Handling Cost ControllerMegan's Today screen shows 198 of 212 September invoices checked on every line — 186,400 lines — and $468,210.00 without proof across the network, 1.48% of $31.62M billed. The agents also found $7,940.00 the handlers forgot to bill, and listed it. The biggest item is SkyRamp at DEN: 119 lines hang loose, and the Verifier agrees on 118.
“Good morning, Megan. The most valuable thing today is SkyRamp's DEN invoice: $18,640.00 with no matching turn or approval. Want me to open it?”
- 02Review the lines
Every line stitched to its proof — or hanging loose
Megan Alvarez · Ground Handling Cost ControllerThe invoice opens as plain lines grouped by service. Each one is tied by a thread to its turn record, the Annex B rate of the day and, for ad hoc work, its signed record. 559 lines, $394,240.00, are stitched. The loose ones are greyed: 46 ground power lines ($9,200), 62 A321neo turns at the new rate ($2,790), 5 delay standby ($2,725), 4 extra-agent shifts ($1,520) and 2 turn handling lines ($2,405).
“I drafted a short-pay with a reason on each of the 119 lines. You decide; the letter only carries lines you confirm.”
- 03Watch the agents check
Each agent works on its own, and shows it
The agentsThe Invoice reader read 678 lines from IATA SIS and 41 scanned records at 99.4% confidence. The Turn matcher tied each line to one of 296 operated turns and found 1 canceled flight and 1 duplicate. The Rate checker priced every line from the Annex B of its service date: Amendment 3 takes effect Sep 15, and 62 lines used the new rate too early. The Ad hoc approval finder found 4 extra-agent shifts with no request and asked the station.
“Nothing is withheld or sent until a person confirms. Every finding cites its source.”
- 04CV 1422 · Sep 17
Ground power on a turn that ran on the APU
Turn matcherLine 0412 bills 2 × 30 minutes of ground power, $200.00. The turn timeline shows the aircraft at gate B31 for 49 minutes, the APU running 13:54–14:51, the gate meter reading 0.0 kWh and GPU on and off left blank on SkyRamp's turn log. The same pattern shows on 45 other turns at gates B29–B35, all with fixed power. Megan confirms all 46 GPU lines in one tap.
Verifier, on its own: “A GPU can run while the APU runs, so the APU alone would not prove it; the blank turn log and 0.0 kWh together do.”
- 05One dissent
A second agent argues the handler's side
VerifierFive delay standby lines were drafted as handler-caused. The Verifier re-derived each one from the records without seeing the first working, and disagrees on one: CV 1290 on Sep 25 was coded 41, aircraft defect — Corvane's own cause — for 72 minutes, and Annex B item 11 makes that billable. Both workings sit side by side. Megan keeps paying the $545.00 and confirms the other four.
“CV 1290 was coded 41, aircraft defect — Corvane's own cause, 72 minutes. Item 11 makes it billable. I would pay $545.00.”
- 065:58 am, answered later
One plain question to the station
Tom Brandt · Station Manager, DENAnnex B pays extra ramp agents only on the station's written request. The service records say “per station call”, so the agent asked Tom one question. He answers yes and attaches his email of Sep 22, 04:52 asking for 2 agents. Lines 0502 and 0503 are stitched to his email and $760.00 will be paid. Sep 8 has no request and the Corvane signature is blank, so those two shifts stay on the short-pay.
“Did DEN request 2 extra ramp agents for the 05:30–09:30 bank on Sep 22?”
- 07Build the letter
A short-pay built only from confirmed lines
Short-pay drafterShort-pay letter SP-DEN-2609 withholds $17,335.00 on 116 lines and pays $395,545.00 by Nov 2, under item 14 of Annex B. Each group carries its clause and examples: ground power billed where no GPU was connected (item 7), a flight canceled more than 2 hours before arrival (item 1.4), a turn billed twice, the A321neo rate before Amendment 3 took effect, delay standby not caused by Corvane (item 11) and extra agents without a written request (item 9). The two lavatory and water services SkyRamp did not bill, $180.00, are listed and not claimed.
Not in this letter: “Every loose line is decided.” Paid after review: CV 1290, and lines 0502 and 0503 with proof attached.
- 08Signed
She signs with a reason code
Megan Alvarez · Ground Handling Cost ControllerMegan signs with the reason code “Not supported by turn record or approval” and the statement that she has reviewed each line and its records. The letter is under the $25,000 co-sign threshold, so one signature is enough. It goes out as an IATA SIS rejection memo and an email to SkyRamp billing, and a hold is placed in the finance system.
“I have reviewed each line in this letter and its records.”
- 09Oct 30 payment run
The undisputed amount pays on time
Andre Collins · Accounts Payable AnalystOn Payments, Andre sees SkyRamp DEN with $17,335.00 held and $395,545.00 to pay — the short-pay is sent and the undisputed amount is due Nov 2. Harborline's MIA invoice is held for a Procurement co-sign, and SLC, NRT and SFO are clean, every line stitched to proof. He releases; the agents never do.
“I prepared every hold; nothing is released without Accounts Payable.”
- 10The month after
The pattern goes to the handler review
Hannah Okafor · Procurement Manager, Ground ServicesStations keeps the record Procurement and the VP Ground Operations negotiate from: $3,862,400 found without proof January to September, and $3,118,250 credited by handlers. DEN has grown every month since June, and 49% of September's DEN findings are GPU on APU turns at fixed-power gates. The agent offers to draft the SkyRamp talking points.
“The pattern, in one line: Bills GPU on APU turns at fixed-power gates (B29–B35).”