Currency & FX Rate Management
Network Planning & Scheduling › Pricing & Fare Management · 16 L4 steps · 5 phases · 5 decision gates · Updated 2026-03-18 19:44
📊
Process Flow Diagram (BPMN)
📋
L4 Process Steps
| Step | Step Name | Role / Swim Lane | System | Input | Output | KPI | Dec? | Exc? |
|---|---|---|---|---|---|---|---|---|
Phase 1 1.1 |
Ingest daily FX rate feed from Reuters Refinitiv | FX Rates Analyst | Reuters Refinitiv Eikon | Daily FX rate file covering 150+ currency pairs | Raw FX rate dataset staged for validation | Rate feed received by 06:00 local time on 100% of trading days | N | Y |
| 1.2 | Cross-validate rates against IATA published ROEs | FX Rates Analyst | ATPCO Rate Desk | Reuters Refinitiv FX dataset; IATA Resolution 024 ROE table | Variance report flagging deviations >0.5% from current IATA ROE | Variance detection accuracy 100%; processing time <30 minutes | N | N |
| 1.3 | Approve or escalate FX rate set for filing | Pricing Manager | ATPCO Rate Desk | Variance report; escalation threshold policy (>1% triggers Revenue Director review) | Approved rate set or formal escalation to Revenue Director | Escalation decision completed within 2 hours of rate receipt | Y | N |
Phase 2 2.1 |
Submit ROE update to ATPCO Rate Desk | Tariff Filing Analyst | ATPCO Rate Desk | Approved FX rate set; IATA Resolution 024 ROE filing template | ATPCO ROE filing submission with Transaction Identification Number (TIN) | ROE filed ≥24 hours before effective date per IATA Resolution 024; 0 late filings per quarter | N | Y |
| 2.2 | Confirm ROE acceptance and GDS distribution trigger | Tariff Filing Analyst | ATPCO Rate Desk | ATPCO filing confirmation; GDS distribution schedule | ROE effective date confirmed; GDS distribution job triggered | ROE active in all GDS channels within 4 hours of ATPCO acceptance | Y | N |
| 2.3 | Distribute updated ROEs to NDC and direct channels | Distribution Systems Analyst | NDC API Gateway | Confirmed ATPCO ROE; NDC offer/order schema for connected OTAs and TMCs | Updated ROE broadcast to all NDC-connected distributors; acknowledgement log | NDC distribution complete within 1 hour of ATPCO acceptance; 100% connected-channel coverage | N | Y |
Phase 3 3.1 |
Recalculate local-currency published fares in PSS | Pricing Analyst | Amadeus Altéa PSS | Updated ROE; published base fares in NUC/USD | Recalculated fare tables across 50+ local currencies | Fare recalculation completed within 2 hours of ROE update; 0 pricing calculation errors | N | N |
| 3.2 | Validate converted fares against competitive price bands | Pricing Analyst | Amadeus Revenue Management (NRM) | Recalculated local fares; OAG Schedule Analyser competitive fare benchmarks | Fare validation report; outlier flags for commercially unviable currency conversions | <2% of fare basis codes flagged as outliers; validation cycle completed within 4 hours | Y | N |
| 3.3 | Override floor/ceiling fares for distressed currencies | Regional Pricing Manager | ATPCO Rate Desk | Outlier-flagged fares; local market floor price policy; SME sign-off | Manual fare floor/ceiling override filed in ATPCO; exception documented in audit log | Floor override filed within 4 hours of outlier flag; 100% of overrides carry documented SME approval | N | Y |
| 3.4 | Publish final fare tables to GDS channels and PSS | Distribution Systems Analyst | Sabre GDS | Validated and overridden fare tables; ATPCO distribution schedule | Live fare availability across Sabre, Travelport, and Amadeus GDS; Altéa PSS fare cache refreshed | 100% GDS channel parity achieved within 6 hours of ROE effective date | N | Y |
Phase 4 4.1 |
Revalue foreign-currency ticket revenue in SAP FI | Revenue Accountant | SAP S/4HANA Finance (FI/CO) | Daily ticket settlement data from IATA BSP; current ROE | FX revaluation journal entries; updated AR balances in base currency | Revaluation completed by T+1 period close; FX variance <0.1% versus BSP settlement amount | N | N |
| 4.2 | Assess net FX exposure against Treasury hedge ratio | Treasury Analyst | SAP S/4HANA Finance (FI/CO) | Net open FX exposure by currency pair; approved hedge ratio policy (60-80% of 12-month forward revenue) | Hedge gap analysis report; trigger notification if exposure outside approved band | Hedge ratio maintained within 60-80% for top-10 currency exposures; monthly review cycle | Y | N |
| 4.3 | Execute hedge adjustment via Treasury instruments | Treasury Manager | SAP S/4HANA Finance (FI/CO) | Hedge gap analysis; approved bank counterparties; ISDA master agreements | Forward contract or FX option trade booked in SAP TRM; IFRS 9 hedge effectiveness documentation | Hedge execution within 24 hours of gap identification; hedge effectiveness ≥80% per IFRS 9 | N | Y |
Phase 5 5.1 |
Identify tickets issued at superseded exchange rates | Revenue Accounting Analyst | Amadeus Altéa PSS | Ticketed transaction log; ROE change history with effective timestamps | Exception list of tickets priced at outdated ROE; total value-at-risk by currency | Exception identification completed within 24 hours of each ROE change; 100% ticket population audited | N | Y |
| 5.2 | Determine ADM issuance or waiver for out-of-rate tickets | Pricing Manager | Amadeus Altéa PSS | Out-of-rate ticket list; FX variance threshold policy (>2% triggers ADM); agency relationship tier | Agency Debit Memo (ADM) issued or waiver granted per ticket; decision documented in audit trail | ADM issued or waiver granted within 5 business days of identification; affected ticket volume <0.5% of monthly issuance | Y | Y |
| 5.3 | Publish monthly FX P&L impact dashboard | FP&A Analyst | SAP S/4HANA Finance (FI/CO) | SAP FX revaluation journal entries; hedge effectiveness report; ADM totals; Altéa ticketing data | FX P&L dashboard by route and currency market; variance commentary for CFO pack | Dashboard published by 5th business day of following month; FX impact reported to ±$100K accuracy | N | N |
📋