Air traffic liability reconciliation every day, with each difference explained and breakage backed by evidence
A liability reconciled every day, with breakage estimates backed by evidence.
See one case, screen by screen ↓Air traffic liability reconciliation proves that the balance in the general ledger's air traffic liability account — account 2160 under 14 CFR Part 241 — equals the unflown tickets and open coupons behind it, with every difference explained. Air Traffic Liability Reconciliation does it every night: seven agents tie the open-coupon ledger to GL 2160, explain each difference by cause, propose the breakage release and the refunds reclass, and draft the close entries for the Controller to approve and sign.
How to choose AI for airlines: a buyer's guide to agentic AI solutions →
Updated
Air traffic liability reconciliation starts from a simple fact: every ticket an airline sells is cash for a flight not yet flown. Until it is flown, refunded, exchanged or expires, it sits in the air traffic liability — unearned transportation revenue, the airline's contract liability for unflown tickets under ASC 606 — and revenue accounting has to prove that GL 2160, account 2160 under 14 CFR Part 241, equals the open coupon liability behind it. Today that sales-lift match is often built at quarter-end from the passenger revenue accounting system's open-coupon file, the e-ticket database, the ERP and spreadsheets: interline coupons flown by partners sit unmatched until their IATA SIS billings arrive, refunds paid are not yet posted, and exchanges move value between sale months.
The judgment calls are worse. The breakage estimate is usually reset once a year, so a rate that is wrong by a point stays in the books until then, while expired sale months linger in the balance long after their claims window closes. Refunds owed under the DOT automatic refund rule sit in the liability instead of refunds payable. After a merger, the acquired airline's tickets get swept under the buyer's validity rule even though their own conditions of carriage still honor them. Auditors test breakage every quarter, and a one-point miss moves revenue by millions.
Estimated split of working days for a revenue accounting team closing the ticket liability of a large network carrier, by hand at quarter-end and with the solution reconciling every night.
Seven agents reconcile the liability nightly, back-test breakage and draft entries a second agent recomputes; the Controller signs.
It is Thursday, October 15, 2026, business day 11 of Corvane Airways' Q3 close; the books lock Monday at 17:00 ET. GL 2160 stands at $2,310,418,206.14. Here is how Diane Whitaker, the Controller, works with the agents on her air traffic liability reconciliation, screen by screen, in the working solution.
The agents reconciled the liability at 02:00 ET. Diane's morning shows three numbers — the liability at $2.31B across 19 sale months, a $1.28M difference to GL 2160 already explained, five entries waiting for $25.8M — and the agents' notes in order. The Coupon matcher tied every day of the quarter; the Ticket status tracer classified 6.1 million open coupons; the Acquired-ticket agent held some tickets and says it needs a person.
Acquired-ticket agent: “Held $1,104,880.00 of Halden Air tickets in the same layer: Halden tickets are valid 24 months. I need a person to decide.”
Diane asks in plain words. The answer comes back with its sources: one layer, March 2025. Its tickets expired in March 2026 and the 180-day claims window closed on Sep 30. $14,206,318.42 of Corvane tickets has nothing pending; $1,104,880.00 of Halden Air tickets is still valid under Halden's 24-month rule. Every numbered marker opens the record it came from.
Every answer cites its source, and offers the next step: “Open the liability.”
One layer per sale month, newest on top: September 2026 at $598.6M with 1,918,420 coupons, down to March 2025 at $15.3M. Two lines cross the strata — where 12-month validity ends, and where the claims window closed on Sep 30. The agents' notes are pinned to the old layers: July 2025 keeps $0.9M for 412 open refund claims; September 2025 moved $2.4M with 1,180 exchanges.
At the foot of the strata sits the breakage release: debit 2160 Air traffic liability, credit 4120 Passenger revenue — ticket breakage, $14,206,318.42. The Entry drafter explains why: 21,906 tickets, none with a refund claim, an exchange or a partner billing pending; breakage of $27.6M was recognized at the travel dates at 2.0%, and actual unused value was $41.8M. Diane approves with the reason code “Expired past claims window” and her signature, and the decision goes to the audit trail.
“Checked by a second agent. The Coupon matcher recomputed $14,206,318.42 from the 38,412 coupons on its own: agrees to the cent. Halden Air tickets excluded ($1,104,880.00).”
Corvane bought Halden Air on Feb 2, 2026. Halden's conditions of carriage make a ticket valid 24 months from issue, so these 214 tickets can still be flown or refunded until March 2027. At the Jun 14 cutover the tickets kept the Halden flag, but the sweep was never told — it would have released them with Corvane's. They are part of the $88.0M acquired liability.
“I propose JE-26-Q3-018: keep $1,104,880.00 in the liability under the Halden sub-account, and a rule that holds every pre-cutover Halden ticket to 24 months.”
The Halden Air screen sets the two airlines' rules side by side and ties the acquired opening balance: $88.0M at fair value on Feb 2, less $21.3M flown, $2.9M refunded and $0.4M exchanged, leaves $63.4M at Sep 30, signed by Sofia Lindgren on Oct 9. Diane approves JE-26-Q3-018 with the reason “Acquired-carrier rule applies”. The total liability does not change; the tickets move to account 2161.
The Acquired-ticket agent never releases an acquired ticket under Corvane's rules; it asks a person.
JE-26-Q3-016, the breakage estimate catch-up, cannot be approved yet. The Entry drafter computed $5,384,000.00 converting Canadian-dollar sales at the September average rate; the Coupon matcher, recomputing on its own, got $5,342,800.00 at the Sep 30 closing rate. The screen shows both workings and the choice.
“The agents disagree by $41,200.00. A person decides; it cannot be approved until then.”
Twelve Main Cabin international cohorts in a row expired above the 2.0% rate in use — 2.6% on average, 3.1% for March 2025. The point estimate is 2.4%; to keep a significant reversal improbable under the ASC 606 constraint, the Breakage estimator proposes the 20th percentile, 2.2%, and drafts memo TA-26-07 in four sections. Sofia signs it: “Back-test supports the change.”
The Breakage estimator never changes a rate; it proposes the constrained value and a person signs.
Diane chooses the Coupon matcher's closing-rate working for JE-016, then approves it with the refunds reclass and the partner-coupon entry under one signature. Every close item is done with its evidence attached, so the certification opens: GL 2160 and 2161 agree with the open-coupon ledger after the close entries at $2,285,738,246.97. She signs at 08:59.
“Certified by Diane Whitaker · 08:59 ET, Oct 15.”
The same Q3 close, seen by five of the people who carry it — what their quarter-end looked like, and what it looks like now.
Seven agents reconcile the liability nightly, back-test breakage and draft entries a second agent recomputes; the Controller signs.
Ties the open-coupon ledger to GL 2160 every night, the way 14 CFR 241 asks for at a month-end cut-off, and recomputes every drafted entry on its own.
Gives every unflown coupon a status and a sale month — valid, in claims window, expired, refund owed, exchanged, flown not matched, acquired — and explains each difference to the ledger by cause.
Estimates breakage by fare family from 36 months of expiry history, back-tests the rate in use against what actually expired, applies the ASC 606 constraint and drafts the technical accounting memo.
Watches every refund owed under the DOT automatic refund rule against its clock — 7 business days to a card, 20 days otherwise — and proposes the reclass from 2160 to 2185 Refunds payable.
Keeps Halden Air's pre-cutover tickets on Halden's conditions of carriage and ties the acquired opening balance through to today.
Drafts each close entry with its lines, amounts, the reasoning in plain words and its support.
Builds the evidence pack for each entry and each auditor request as the work happens, and traces the auditor's sample to source.
Approves, edits or rejects every entry with a reason code; Technical Accounting signs the breakage memo. The agents propose; a named person decides.
The conversation sits beside every working screen. Ask in plain words, or tell the agents what to check — each answer cites its source and can act: filter a list, open an entry, open a pack.
Is GL 2160 tied to the tickets?
At Sep 30 the ledger is $2,309,133,575.94 and GL 2160 is $2,310,418,206.14: a difference of $1,284,630.20, all of it 2,316 coupons flown by five partners and billed through IATA SIS. JE-26-Q3-017 clears it.
Why not use the point estimate?
Because ASC 606 lets us include variable consideration only to the extent a significant reversal is not probable. 2.4% is the central forecast for the cohorts still open; 2.2% is the 20th percentile the policy uses. If redemption patterns shift back, 2.2% still holds.
Why is this not just liability?
Because the passenger is no longer owed a flight — they are owed cash, by a date. Leaving it in air traffic liability would also let it be swept as breakage later, which the rule forbids.
What if we had released them?
$1,104,880.00 of revenue would have been recognized for tickets Halden passengers can still fly or refund until March 2027. Any later refund would have had to be paid out of revenue already booked — a reversal the auditor tests for.
13 screens from the working solution, on its sample data. Pick one to see it large.
The rules the agents reconcile against are settings. The Revenue Systems Administrator changes the settings, the Technical Accounting Manager changes the rules, and every save is logged on the audit trail.
| Setting | Default | Choose from |
|---|---|---|
| Corvane ticket validity | 12 months from issue | Months from issue, per carrier |
| Halden Air validity (tickets issued before Jun 14, 2026) | 24 months from issue | Months from issue, per acquired carrier |
| Claims window after validity | 180 days | Days after validity ends |
| Breakage constraint | 20th percentile of the back-test | Percentile of the back-test |
| Daily difference to explain | $50,000 | Dollars per day |
| Cumulative difference to explain | $250,000 | Dollars cumulative |
| Controller approval limit | $25,000,000 | Dollars per entry; the CFO approves above |
| Director approval limit | $5,000,000 | Dollars per entry; above it routes to the Controller |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample data · “estimated” = our estimate (0.5% × an $8 billion liability; the split of close days) · “typical” = published figures (a US carrier's Q2 2026 10-Q — breakage estimate revised from 23% to 20%, $285 million reversed; a US network carrier's filings — air traffic liability of $7.16 billion at Dec 31, 2025). Rules named for context: 14 CFR Part 241 §2-5 (air traffic liability, account 2160); 14 CFR Part 260 (refunds within 7 business days to a card, 20 days otherwise, from Oct 28, 2024); ASC 606 variable consideration and breakage. Corvane Airways, Halden Air, the partner airlines, the auditor and the people named on this page are fictional — characters and sample data in the working solution.
Air traffic liability reconciliation proves that the balance in the general ledger's air traffic liability account — account 2160 under 14 CFR Part 241 — equals the unflown tickets and open coupons behind it, with every difference explained. Air Traffic Liability Reconciliation does it every night: seven agents tie the open-coupon ledger to GL 2160, explain each difference by cause, propose the breakage release and the refunds reclass, and draft the close entries for the Controller to approve and sign.
The Breakage estimator sets the ticket breakage estimate by fare family: it reads 36 months of expiry history, back-tests the rate in use for each fare family against what actually expired and computes a point estimate. Because ASC 606 limits variable consideration to what will not probably reverse, it proposes the constrained rate — the 20th percentile in the policy setting — and drafts the technical accounting memo. A person signs any rate change.
Every night. The Coupon matcher ties the open-coupon ledger to GL 2160 at 02:00 ET, the way 14 CFR 241 asks for at a month-end cut-off, but every day. A difference over the daily threshold — $50,000 by default — must be explained by cause, so nothing waits for quarter-end.
No. When the passenger is owed cash rather than a flight, the Refund clock tracks the refund against the DOT automatic refund rule (14 CFR Part 260) — 7 business days to a card, 20 days otherwise — and proposes the reclass from air traffic liability to refunds payable. It never issues a refund or offers a voucher instead of cash; a person approves the reclass.
The Acquired-ticket agent keeps them on their own conditions of carriage. In the working solution it held 214 Halden Air tickets the sweep would have released under the buyer's 12-month rule, explained that Halden tickets are valid 24 months, proposed moving them to a Halden sub-account and tied the acquired opening balance, recorded at fair value under ASC 805, through to today.
No. The agents draft entries with their reasoning and support; the Coupon matcher recomputes each one, and a disagreement holds it for a person. Only an approved, signed entry goes to the ledger, and the approval limits by role decide who signs.
Yes. Every entry, rate change, reclass and evidence pack is approved, edited or rejected by a named person with a reason code and a signature. Only the Controller certifies the quarter, and only after every close item is done with its evidence. Every step is on a chained audit trail.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your revenue policy, conditions of carriage, chart of accounts and a sample of your open-coupon file — and it goes live once every quality gate has passed. The first-time setup runs one month in parallel with your spreadsheet before the daily reconciliation becomes the control of record.
Yesterday's flights earned by morning, and the revenue lost in suspense back on the books.
1-min demoInterline Billing and SettlementEvery rejection answered inside its time limit, with every coupon tied to its agreement.
1-min demoSpecial Prorate Agreement ManagementEvery agreement tested on real trips before it bills; no partner billed on a lapsed one.
1-min demoWe'll run Air Traffic Liability Reconciliation on a month of your own open-coupon file, ledger and refund data.