- Before
- Codes each agreement with the PDF on one screen and the proration engine on the other, tests a few hand-built tickets, and answers “why was this coupon valued at that?” months later.
- Now
- Opens an agreement already read, coded in test and replayed on 2,000 real trips, with the odd results on top and the question already with Commercial.
One special prorate agreement, from PDF to signed go-live
Corvane Airways has signed a new special prorate agreement with Halden Air, SPA HD-CV-2026: 18 pages and two annexes, for tickets issued from Nov 15, 2026 to Nov 14, 2028. It reached Revenue Accounting on Mon Oct 12, 34 days ahead. Here is how it goes live, screen by screen, in the working solution.
- 01Thursday morning
The agents have done the night's work; she sees what needs her
Leah Corrigan · SPA AnalystLeah's Today screen shows 13 agreements in force, about $62.5M a year to Corvane, 2 in test, 2 questions with Commercial and 1 ending within 60 days. At the top of what needs her: Halden Air's new agreement tested on 2,000 real trips, +$66,905.66 for the quarter, with clause 6 pulled to the top at −$11,780.00 on 310 coupons. She can ask the agents in plain words — what they did overnight, whether Halden is ready to go live, which agreements expire soon.
Replay agent: “Clause 6 pays less than today on 310 coupons, so I pulled it to the top and asked Commercial.”
- 02Mon Oct 12
Fourteen clauses in plain words, each with its page and its coded rule
Agreement reader and rule coderThe agreement reader turns the PDF into 14 clauses, each cited to its page, and the rule coder writes each one as a prorate rule in the test engine, filed under the IATA SPA coding checklist. Three findings come up instead of being guessed: clause 1 says issue date where the Annex A header says travel date (clause 14 makes the body govern), premium economy is not mentioned, and Annex A note 3 puts a 25% child discount on top of the agreed amounts. Celia Navarro answers the last two on Oct 14.
The agreement reader never resolves an ambiguity silently; it raises it as a finding.
- 03The replay
2,000 real trips replayed, and one clause that pays $38 a coupon less
Replay agent and checkerThe replay agent runs 2,000 itineraries with both airlines from Jul 1 to Sep 30, 2026 — 4,126 coupons — through today's general method and the new agreement: Corvane's share goes from $558,613.43 to $625,519.09, +$66,905.66 for the quarter (12.0%), and thirteen clauses behave as written. Clause 6 fixes Corvane's Chicago–New York sector at $212 in economy and $598 in business when the trip goes on to Athens, “in lieu of mileage proration”, where the general method gives $250 on average in economy: −$11,780.00 a quarter on 310 coupons, about −$47,120 a year. The checker recomputes all 310 from the clause text by a different method, gets the same values and confirms every coupon is above the minimum prorate. So the question is not whether it is coded right, but whether it was meant.
Commercial liaison to Celia Navarro, Alliances: “Was this intended?”
- 04One trip
Every value opens its calculation
Replay agentLeah opens Halden ticket 419-2101184426, ORD–JFK–ATH in economy, issued Jul 14, fare after taxes and fees $1,145.95. Prorate factors of 1,012 for ORD–JFK and 3,601 for JFK–ATH give Corvane's sector $251.40 today; clause 6 makes it $212.00. With the service charge Halden keeps falling from 9% to 7%, Corvane's share goes from $228.77 to $197.16: −$31.61 on this coupon.
“A replayed trip is never billed. It shows what the agreement would have done to a ticket Corvane already settled.”
- 05The question
The money, the trips and what the agents checked, in one question
Commercial liaisonThe question to Commercial carries the clause and its page, what the agents checked — 254 of the 310 coupons lower than today, $38.00 a coupon on average, the checker in agreement, above the minimum prorate — and three example trips. It is due Mon Oct 19, three business days after it was asked. Leah can remind Celia or escalate to Owen Prescott, but she cannot answer it.
“Only Commercial says whether a clause was intended.”
- 06Answered
Intended — and the answer becomes the reason on the rule
Celia Navarro · Alliances Commercial ManagerCelia chooses from three answers: intended, keep $212 and $598; not intended, ask Halden to correct it; or intended at a different amount, which re-runs the replay. She picks the first, with the reason “Agreed in negotiation; deliberate trade-off” — in the demo, a trade for clause 7, which gives Corvane 18% of the through fare on its feeder flights into JFK. She signs, and the rule coder marks clause 6 confirmed with her answer as its reason.
- 07Go-live
Seven checks met, then a signature with a reason
Owen Prescott · Interline Revenue ManagerThe go-live screen lists what must be true before anyone signs: received at least 4 weeks ahead, every clause read and coded with its page, findings settled, replayed on last quarter's trips, the checker in agreement, every question answered, and the value within the approver's limit — +$267,623 a year against the general method, inside Owen's $300,000. Owen picks the reason “Test results reviewed; odd values confirmed by Commercial” and confirms his decision.
“SPA Analysts do not approve go-lives: Owen Prescott does.”
- 08Signed
Test to production, dated, with the reviews already booked
Owen Prescott and the agentsThe rules move from test to production for tickets issued from Nov 15, 2026, and the billing team and the outsourced billing desk are told what changes. The 1-month review of billings against the replay is set for Dec 15, 2026, the 6-month review with Halden for May 15, 2027 and the 12-month review for Nov 15, 2027. The expiry warning to Commercial is set for Sep 15, 2028, 60 days before the agreement ends.
“Signed into the audit trail with the test results attached.”
- 09The same morning
An expiry nobody answered, and a renewal signed late
Expiry and renewal watchSelkirk Airways' agreement ends Dec 1, 2026, 47 days away. The 60-day alert went to Commercial on Oct 2 with no answer in 13 days, so the watch has escalated it to Owen: about $3.4M a year runs under it, and on the general method Corvane would get about $61,300 a year less. Kestrel Air's agreement lapsed Sep 30; renewal v3 was signed Oct 9 from Oct 1, so 412 coupons issued Oct 1–14 went out on the general method. Re-prorated at v3 they give Corvane +$18,640.20, once Ruth Abernathy approves the go-live.
The expiry and renewal watch never extends or ends an agreement on its own.
- 10After go-live
Billings checked against what the replay predicted
Partner value monitorEvery month the monitor compares each live agreement's billings with its replay. Northmere Airways billed 11.0% below in September, −$89,950.00 against $817,720 expected. The monitor found one coding cause: Corvane began Minneapolis–Reykjavik on Aug 3, the route is not in the agreement's route list, and 218 coupons settled under the general method, −$10,120.40 against the agreement's rates. The rest is lower traffic, not coding, and the question of adding the route at renewal is with Celia.