{
  "metric": "recon_variance",
  "label": "Booking against folio",
  "note": "Every stay where the folio differs from what was booked, largest first.",
  "table": "recon_item",
  "sort": null,
  "dir": "desc",
  "filters": {},
  "total": 205,
  "sums": {
    "nights": 439,
    "booking_amount": 128331.84,
    "folio_amount": 167863.06,
    "variance": 53376.13
  },
  "rows": [
    {
      "item_id": "RI-8854236",
      "period": "2026-08",
      "booking_id": "RS-8854236",
      "duty_id": "D-514236",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Maes",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-16",
      "check_out": "2026-08-20",
      "nights": 4,
      "booking_amount": 1198.05,
      "card_auth": 1223.05,
      "card_settled": 2507.86,
      "folio_amount": 1253.93,
      "variance": 1253.93,
      "variance_pct": 104.66,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-19",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853437",
      "period": "2026-08",
      "booking_id": "RS-8853437",
      "duty_id": "D-513437",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Fitzgerald",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-03",
      "check_out": "2026-08-07",
      "nights": 4,
      "booking_amount": 1131.53,
      "card_auth": 1156.53,
      "card_settled": 2336.74,
      "folio_amount": 1168.37,
      "variance": 1168.37,
      "variance_pct": 103.26,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-12T11:00:00Z",
      "final_at": "2026-09-06T00:01:00Z",
      "final_due_at": "2026-09-06",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854272",
      "period": "2026-08",
      "booking_id": "RS-8854272",
      "duty_id": "D-514272",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. Wouters",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-23",
      "check_out": "2026-08-26",
      "nights": 3,
      "booking_amount": 1082.29,
      "card_auth": 1107.29,
      "card_settled": 2196.86,
      "folio_amount": 1098.43,
      "variance": 1098.43,
      "variance_pct": 101.49,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-02T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 6,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854540",
      "period": "2026-08",
      "booking_id": "RS-8854540",
      "duty_id": "D-514540",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "D. Lambert",
      "station": "CDG",
      "property_id": "P-128",
      "hotel": "Ibis Paris CDG",
      "check_in": "2026-08-13",
      "check_out": "2026-08-16",
      "nights": 3,
      "booking_amount": 871.22,
      "card_auth": 896.22,
      "card_settled": 1742.44,
      "folio_amount": 871.22,
      "variance": 871.22,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": "2026-08-23T11:00:00Z",
      "final_at": "2026-09-15T00:01:00Z",
      "final_due_at": "2026-09-15",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853612",
      "period": "2026-08",
      "booking_id": "RS-8853612",
      "duty_id": "D-513612",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Kavanagh",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-27",
      "check_out": "2026-08-30",
      "nights": 3,
      "booking_amount": 831.59,
      "card_auth": 856.59,
      "card_settled": 1710.54,
      "folio_amount": 855.27,
      "variance": 855.27,
      "variance_pct": 102.85,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-01T11:00:00Z",
      "final_at": "2026-09-29T00:01:00Z",
      "final_due_at": "2026-09-29",
      "age_days": 39,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854676",
      "period": "2026-08",
      "booking_id": "RS-8854676",
      "duty_id": "D-514676",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "N. Lefevre",
      "station": "TLS",
      "property_id": "P-133",
      "hotel": "Pullman Toulouse Airport",
      "check_in": "2026-08-26",
      "check_out": "2026-08-29",
      "nights": 3,
      "booking_amount": 754.35,
      "card_auth": 779.35,
      "card_settled": 1508.7,
      "folio_amount": 754.35,
      "variance": 754.35,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-29T02:10:00Z",
      "resolved_at": "2026-09-06T11:00:00Z",
      "final_at": "2026-09-28T00:01:00Z",
      "final_due_at": "2026-09-28",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854998",
      "period": "2026-08",
      "booking_id": "RS-8854998",
      "duty_id": "D-514998",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "G. Berger",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-28",
      "check_out": "2026-08-30",
      "nights": 2,
      "booking_amount": 595.41,
      "card_auth": 620.41,
      "card_settled": 1262.34,
      "folio_amount": 631.17,
      "variance": 631.17,
      "variance_pct": 106.01,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 2,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855007",
      "period": "2026-08",
      "booking_id": "RS-8855007",
      "duty_id": "D-515007",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "P. Fontaine",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-23",
      "check_out": "2026-08-25",
      "nights": 2,
      "booking_amount": 629.25,
      "card_auth": 654.25,
      "card_settled": 1258.5,
      "folio_amount": 629.25,
      "variance": 629.25,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 12,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854778",
      "period": "2026-08",
      "booking_id": "RS-8854778",
      "duty_id": "D-514778",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "H. Moreau",
      "station": "BRU",
      "property_id": "P-119",
      "hotel": "Sheraton Brussels Airport",
      "check_in": "2026-08-15",
      "check_out": "2026-08-17",
      "nights": 2,
      "booking_amount": 625.15,
      "card_auth": 650.15,
      "card_settled": 1250.3,
      "folio_amount": 625.15,
      "variance": 625.15,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855099",
      "period": "2026-08",
      "booking_id": "RS-8855099",
      "duty_id": "D-515099",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "A. Moreau",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-19",
      "check_out": "2026-08-21",
      "nights": 2,
      "booking_amount": 591.12,
      "card_auth": 616.12,
      "card_settled": 1239.78,
      "folio_amount": 619.89,
      "variance": 619.89,
      "variance_pct": 104.87,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-20",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855011",
      "period": "2026-08",
      "booking_id": "RS-8855011",
      "duty_id": "D-515011",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "H. Moreau",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 588.48,
      "card_auth": 613.48,
      "card_settled": 1214.18,
      "folio_amount": 607.09,
      "variance": 607.09,
      "variance_pct": 103.16,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-08T11:00:00Z",
      "final_at": "2026-09-06T00:01:00Z",
      "final_due_at": "2026-09-06",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854854",
      "period": "2026-08",
      "booking_id": "RS-8854854",
      "duty_id": "D-514854",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "M. Delacroix",
      "station": "TLS",
      "property_id": "P-134",
      "hotel": "Ibis Toulouse Blagnac",
      "check_in": "2026-08-08",
      "check_out": "2026-08-12",
      "nights": 4,
      "booking_amount": 1080.36,
      "card_auth": 530.87,
      "card_settled": 530.87,
      "folio_amount": 1124.47,
      "variance": 593.6,
      "variance_pct": 54.94,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": "2026-09-11T00:01:00Z",
      "final_due_at": "2026-09-11",
      "age_days": 30,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852840",
      "period": "2026-08",
      "booking_id": "RS-8852840",
      "duty_id": "D-512840",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Brennan",
      "station": "BHX",
      "property_id": "P-113",
      "hotel": "Novotel Birmingham Airport",
      "check_in": "2026-08-24",
      "check_out": "2026-08-26",
      "nights": 2,
      "booking_amount": 555.26,
      "card_auth": 580.26,
      "card_settled": 1110.52,
      "folio_amount": 555.26,
      "variance": 555.26,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-09T11:00:00Z",
      "final_at": "2026-09-25T00:01:00Z",
      "final_due_at": "2026-09-25",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853545",
      "period": "2026-08",
      "booking_id": "RS-8853545",
      "duty_id": "D-513545",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "A. Quinn",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-09",
      "check_out": "2026-08-11",
      "nights": 2,
      "booking_amount": 554.28,
      "card_auth": 579.28,
      "card_settled": 554.28,
      "folio_amount": 998.79,
      "variance": 444.51,
      "variance_pct": 80.2,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 9,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854324",
      "period": "2026-08",
      "booking_id": "RS-8854324",
      "duty_id": "D-514324",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "N. Wouters",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-06",
      "check_out": "2026-08-09",
      "nights": 3,
      "booking_amount": 826.26,
      "card_auth": 400.24,
      "card_settled": 400.24,
      "folio_amount": 826.26,
      "variance": 426.02,
      "variance_pct": 51.56,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852845",
      "period": "2026-08",
      "booking_id": "RS-8852845",
      "duty_id": "D-512845",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "J. Doyle",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-11",
      "check_out": "2026-08-12",
      "nights": 1,
      "booking_amount": 256.68,
      "card_auth": 281.68,
      "card_settled": 256.68,
      "folio_amount": 671.65,
      "variance": 414.97,
      "variance_pct": 161.67,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-11",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853649",
      "period": "2026-08",
      "booking_id": "RS-8853649",
      "duty_id": "D-513649",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. Mulligan",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-14",
      "check_out": "2026-08-15",
      "nights": 1,
      "booking_amount": 261.87,
      "card_auth": 286.87,
      "card_settled": 710.18,
      "folio_amount": 710.18,
      "variance": 413.53,
      "variance_pct": 157.91,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853758",
      "period": "2026-08",
      "booking_id": "RS-8853758",
      "duty_id": "D-513758",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. Mulligan",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-11",
      "check_out": "2026-08-14",
      "nights": 3,
      "booking_amount": 781.38,
      "card_auth": 806.38,
      "card_settled": 1223.91,
      "folio_amount": 1223.91,
      "variance": 410.42,
      "variance_pct": 52.53,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-13",
      "age_days": 15,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855138",
      "period": "2026-08",
      "booking_id": "RS-8855138",
      "duty_id": "D-515138",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "V. Marchand",
      "station": "MAD",
      "property_id": "P-135",
      "hotel": "Melia Barajas",
      "check_in": "2026-08-21",
      "check_out": "2026-08-22",
      "nights": 1,
      "booking_amount": 292.28,
      "card_auth": 317.28,
      "card_settled": 700.75,
      "folio_amount": 700.75,
      "variance": 408.47,
      "variance_pct": 139.75,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-22T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": "2026-09-21T00:01:00Z",
      "final_due_at": "2026-09-21",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853958",
      "period": "2026-08",
      "booking_id": "RS-8853958",
      "duty_id": "D-513958",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Lambert",
      "station": "DXB",
      "property_id": "P-123",
      "hotel": "Le Meridien Dubai",
      "check_in": "2026-08-06",
      "check_out": "2026-08-07",
      "nights": 1,
      "booking_amount": 295.73,
      "card_auth": 320.73,
      "card_settled": 727.41,
      "folio_amount": 727.41,
      "variance": 407.38,
      "variance_pct": 137.75,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853366",
      "period": "2026-08",
      "booking_id": "RS-8853366",
      "duty_id": "D-513366",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "Y. Doyle",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-01",
      "check_out": "2026-08-02",
      "nights": 1,
      "booking_amount": 296.98,
      "card_auth": 321.98,
      "card_settled": 703.2,
      "folio_amount": 703.2,
      "variance": 406.22,
      "variance_pct": 136.78,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-02T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": "2026-09-01T00:01:00Z",
      "final_due_at": "2026-09-01",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854795",
      "period": "2026-08",
      "booking_id": "RS-8854795",
      "duty_id": "D-514795",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Moreau",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-11",
      "check_out": "2026-08-15",
      "nights": 4,
      "booking_amount": 1173.88,
      "card_auth": 1198.88,
      "card_settled": 1597.21,
      "folio_amount": 1597.21,
      "variance": 402.38,
      "variance_pct": 34.28,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 13,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855194",
      "period": "2026-08",
      "booking_id": "RS-8855194",
      "duty_id": "D-515194",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Bernard",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-06",
      "check_out": "2026-08-09",
      "nights": 3,
      "booking_amount": 978.99,
      "card_auth": 1003.99,
      "card_settled": 1400.07,
      "folio_amount": 1400.07,
      "variance": 401.2,
      "variance_pct": 40.98,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 8,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854247",
      "period": "2026-08",
      "booking_id": "RS-8854247",
      "duty_id": "D-514247",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. Willems",
      "station": "HKG",
      "property_id": "P-120",
      "hotel": "Regal Airport Hotel",
      "check_in": "2026-08-13",
      "check_out": "2026-08-15",
      "nights": 2,
      "booking_amount": 628.75,
      "card_auth": 263.75,
      "card_settled": 263.75,
      "folio_amount": 658.88,
      "variance": 395.13,
      "variance_pct": 62.84,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854569",
      "period": "2026-08",
      "booking_id": "RS-8854569",
      "duty_id": "D-514569",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. Dubois",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-26",
      "check_out": "2026-08-29",
      "nights": 3,
      "booking_amount": 724.41,
      "card_auth": 749.41,
      "card_settled": 1117.67,
      "folio_amount": 1117.67,
      "variance": 393.26,
      "variance_pct": 54.29,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-29T02:10:00Z",
      "resolved_at": "2026-08-30T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-28",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854730",
      "period": "2026-08",
      "booking_id": "RS-8854730",
      "duty_id": "D-514730",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "J. Delacroix",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-17",
      "check_out": "2026-08-18",
      "nights": 1,
      "booking_amount": 296.64,
      "card_auth": 321.64,
      "card_settled": 716.58,
      "folio_amount": 716.58,
      "variance": 390.9,
      "variance_pct": 131.78,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-18T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-17",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854713",
      "period": "2026-08",
      "booking_id": "RS-8854713",
      "duty_id": "D-514713",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "J. Girard",
      "station": "TLS",
      "property_id": "P-133",
      "hotel": "Pullman Toulouse Airport",
      "check_in": "2026-08-09",
      "check_out": "2026-08-10",
      "nights": 1,
      "booking_amount": 239.84,
      "card_auth": 264.84,
      "card_settled": 650.73,
      "folio_amount": 650.73,
      "variance": 388.4,
      "variance_pct": 161.94,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-10T02:10:00Z",
      "resolved_at": "2026-08-12T11:00:00Z",
      "final_at": "2026-09-09T00:01:00Z",
      "final_due_at": "2026-09-09",
      "age_days": 6,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853544",
      "period": "2026-08",
      "booking_id": "RS-8853544",
      "duty_id": "D-513544",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Byrne",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-03",
      "check_out": "2026-08-06",
      "nights": 3,
      "booking_amount": 941.96,
      "card_auth": 966.96,
      "card_settled": 1355.09,
      "folio_amount": 1355.09,
      "variance": 388.01,
      "variance_pct": 41.19,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": "2026-08-14T11:00:00Z",
      "final_at": "2026-09-05T00:01:00Z",
      "final_due_at": "2026-09-05",
      "age_days": 34,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854448",
      "period": "2026-08",
      "booking_id": "RS-8854448",
      "duty_id": "D-514448",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "A. Peeters",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-28",
      "check_out": "2026-08-30",
      "nights": 2,
      "booking_amount": 572.42,
      "card_auth": 597.42,
      "card_settled": 975.35,
      "folio_amount": 975.35,
      "variance": 382.88,
      "variance_pct": 66.89,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 26,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854871",
      "period": "2026-08",
      "booking_id": "RS-8854871",
      "duty_id": "D-514871",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Roussel",
      "station": "MRS",
      "property_id": "P-132",
      "hotel": "Holiday Inn Marseille",
      "check_in": "2026-08-03",
      "check_out": "2026-08-04",
      "nights": 1,
      "booking_amount": 276.01,
      "card_auth": 301.01,
      "card_settled": 655.79,
      "folio_amount": 655.79,
      "variance": 379.78,
      "variance_pct": 137.6,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-08-04T02:10:00Z",
      "resolved_at": "2026-08-08T11:00:00Z",
      "final_at": "2026-09-03T00:01:00Z",
      "final_due_at": "2026-09-03",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854152",
      "period": "2026-08",
      "booking_id": "RS-8854152",
      "duty_id": "D-514152",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. Dubois",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-26",
      "check_out": "2026-08-27",
      "nights": 1,
      "booking_amount": 278.92,
      "card_auth": 303.92,
      "card_settled": 676.69,
      "folio_amount": 676.69,
      "variance": 375.36,
      "variance_pct": 134.58,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-27T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-26",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853864",
      "period": "2026-08",
      "booking_id": "RS-8853864",
      "duty_id": "D-513864",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "P. Janssens",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-02",
      "check_out": "2026-08-05",
      "nights": 3,
      "booking_amount": 1017.28,
      "card_auth": 1042.28,
      "card_settled": 1448.31,
      "folio_amount": 1448.31,
      "variance": 374.43,
      "variance_pct": 36.81,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-05T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-04",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853412",
      "period": "2026-08",
      "booking_id": "RS-8853412",
      "duty_id": "D-513412",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "E. Brennan",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-11",
      "check_out": "2026-08-13",
      "nights": 2,
      "booking_amount": 628.73,
      "card_auth": 273.07,
      "card_settled": 273.07,
      "folio_amount": 645.59,
      "variance": 372.52,
      "variance_pct": 59.25,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854649",
      "period": "2026-08",
      "booking_id": "RS-8854649",
      "duty_id": "D-514649",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "A. Dubois",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-13",
      "check_out": "2026-08-15",
      "nights": 2,
      "booking_amount": 521.72,
      "card_auth": 546.72,
      "card_settled": 892.45,
      "folio_amount": 892.45,
      "variance": 370.73,
      "variance_pct": 71.06,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854695",
      "period": "2026-08",
      "booking_id": "RS-8854695",
      "duty_id": "D-514695",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Moreau",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-19",
      "check_out": "2026-08-20",
      "nights": 1,
      "booking_amount": 296.28,
      "card_auth": 321.28,
      "card_settled": 675.59,
      "folio_amount": 675.59,
      "variance": 370.29,
      "variance_pct": 124.98,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-21T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-19",
      "age_days": 25,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854279",
      "period": "2026-08",
      "booking_id": "RS-8854279",
      "duty_id": "D-514279",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "G. Maes",
      "station": "HKG",
      "property_id": "P-120",
      "hotel": "Regal Airport Hotel",
      "check_in": "2026-08-10",
      "check_out": "2026-08-13",
      "nights": 3,
      "booking_amount": 889.83,
      "card_auth": 914.83,
      "card_settled": 1259.51,
      "folio_amount": 1259.51,
      "variance": 369.68,
      "variance_pct": 41.55,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854322",
      "period": "2026-08",
      "booking_id": "RS-8854322",
      "duty_id": "D-514322",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "Y. Verhoeven",
      "station": "HKG",
      "property_id": "P-120",
      "hotel": "Regal Airport Hotel",
      "check_in": "2026-08-11",
      "check_out": "2026-08-15",
      "nights": 4,
      "booking_amount": 1408.78,
      "card_auth": 1433.78,
      "card_settled": 1816.94,
      "folio_amount": 1816.94,
      "variance": 369.36,
      "variance_pct": 26.22,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-14T00:01:00Z",
      "final_due_at": "2026-09-14",
      "age_days": 34,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854246",
      "period": "2026-08",
      "booking_id": "RS-8854246",
      "duty_id": "D-514246",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. Peeters",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-07",
      "check_out": "2026-08-11",
      "nights": 4,
      "booking_amount": 961.48,
      "card_auth": 986.48,
      "card_settled": 1341.82,
      "folio_amount": 1341.82,
      "variance": 366.56,
      "variance_pct": 38.12,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 27,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852858",
      "period": "2026-08",
      "booking_id": "RS-8852858",
      "duty_id": "D-512858",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-08",
      "check_out": "2026-08-11",
      "nights": 3,
      "booking_amount": 712.68,
      "card_auth": 737.68,
      "card_settled": 1078.71,
      "folio_amount": 1078.71,
      "variance": 366.03,
      "variance_pct": 51.36,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854949",
      "period": "2026-08",
      "booking_id": "RS-8854949",
      "duty_id": "D-514949",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Lefevre",
      "station": "TLS",
      "property_id": "P-134",
      "hotel": "Ibis Toulouse Blagnac",
      "check_in": "2026-08-12",
      "check_out": "2026-08-14",
      "nights": 2,
      "booking_amount": 541.22,
      "card_auth": 566.22,
      "card_settled": 904.28,
      "folio_amount": 904.28,
      "variance": 363.06,
      "variance_pct": 67.08,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": "2026-09-13T00:01:00Z",
      "final_due_at": "2026-09-13",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853647",
      "period": "2026-08",
      "booking_id": "RS-8853647",
      "duty_id": "D-513647",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-12",
      "check_out": "2026-08-13",
      "nights": 1,
      "booking_amount": 291.96,
      "card_auth": 316.96,
      "card_settled": 648.52,
      "folio_amount": 648.52,
      "variance": 356.56,
      "variance_pct": 122.13,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 28,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854548",
      "period": "2026-08",
      "booking_id": "RS-8854548",
      "duty_id": "D-514548",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "D. Declerck",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-13",
      "check_out": "2026-08-17",
      "nights": 4,
      "booking_amount": 1155.08,
      "card_auth": 1180.08,
      "card_settled": 1538.99,
      "folio_amount": 1538.99,
      "variance": 354.6,
      "variance_pct": 30.7,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854146",
      "period": "2026-08",
      "booking_id": "RS-8854146",
      "duty_id": "D-514146",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "S. Declerck",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-05",
      "check_out": "2026-08-09",
      "nights": 4,
      "booking_amount": 1198.34,
      "card_auth": 1223.34,
      "card_settled": 1579.13,
      "folio_amount": 1579.13,
      "variance": 354.29,
      "variance_pct": 29.57,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853023",
      "period": "2026-08",
      "booking_id": "RS-8853023",
      "duty_id": "D-513023",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Byrne",
      "station": "DUB",
      "property_id": "P-103",
      "hotel": "Radisson Blu Dublin Airport",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 570.27,
      "card_auth": 595.27,
      "card_settled": 944.77,
      "folio_amount": 944.77,
      "variance": 350.98,
      "variance_pct": 61.55,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 34,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854139",
      "period": "2026-08",
      "booking_id": "RS-8854139",
      "duty_id": "D-514139",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "A. Peeters",
      "station": "HKG",
      "property_id": "P-120",
      "hotel": "Regal Airport Hotel",
      "check_in": "2026-08-30",
      "check_out": "2026-08-31",
      "nights": 1,
      "booking_amount": 293.41,
      "card_auth": 318.41,
      "card_settled": 652.14,
      "folio_amount": 652.14,
      "variance": 347.7,
      "variance_pct": 118.5,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-31T02:10:00Z",
      "resolved_at": "2026-09-12T11:00:00Z",
      "final_at": "2026-09-30T00:01:00Z",
      "final_due_at": "2026-09-30",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853051",
      "period": "2026-08",
      "booking_id": "RS-8853051",
      "duty_id": "D-513051",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "Y. Mulligan",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-17",
      "check_out": "2026-08-20",
      "nights": 3,
      "booking_amount": 952.68,
      "card_auth": 977.68,
      "card_settled": 1330.56,
      "folio_amount": 1330.56,
      "variance": 347.2,
      "variance_pct": 36.44,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-19",
      "age_days": 17,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854885",
      "period": "2026-08",
      "booking_id": "RS-8854885",
      "duty_id": "D-514885",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "L. Fontaine",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-25",
      "check_out": "2026-08-27",
      "nights": 2,
      "booking_amount": 642.47,
      "card_auth": 667.47,
      "card_settled": 1038.4,
      "folio_amount": 1038.4,
      "variance": 342.94,
      "variance_pct": 53.38,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-27T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-26T00:01:00Z",
      "final_due_at": "2026-09-26",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854343",
      "period": "2026-08",
      "booking_id": "RS-8854343",
      "duty_id": "D-514343",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "M. Willems",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-06",
      "check_out": "2026-08-09",
      "nights": 3,
      "booking_amount": 876.54,
      "card_auth": 901.54,
      "card_settled": 1299.31,
      "folio_amount": 1299.31,
      "variance": 342.61,
      "variance_pct": 39.09,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854470",
      "period": "2026-08",
      "booking_id": "RS-8854470",
      "duty_id": "D-514470",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "O. Maes",
      "station": "LGG",
      "property_id": "P-112",
      "hotel": "Husa de la Couronne",
      "check_in": "2026-08-13",
      "check_out": "2026-08-15",
      "nights": 2,
      "booking_amount": 669.55,
      "card_auth": 357.06,
      "card_settled": 357.06,
      "folio_amount": 699.42,
      "variance": 342.36,
      "variance_pct": 51.13,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853487",
      "period": "2026-08",
      "booking_id": "RS-8853487",
      "duty_id": "D-513487",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Brennan",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-24",
      "check_out": "2026-08-25",
      "nights": 1,
      "booking_amount": 364.56,
      "card_auth": 389.56,
      "card_settled": 705.29,
      "folio_amount": 705.29,
      "variance": 340.73,
      "variance_pct": 93.46,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854770",
      "period": "2026-08",
      "booking_id": "RS-8854770",
      "duty_id": "D-514770",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Chevalier",
      "station": "TLS",
      "property_id": "P-133",
      "hotel": "Pullman Toulouse Airport",
      "check_in": "2026-08-14",
      "check_out": "2026-08-16",
      "nights": 2,
      "booking_amount": 539.76,
      "card_auth": 564.76,
      "card_settled": 879.84,
      "folio_amount": 879.84,
      "variance": 340.08,
      "variance_pct": 63.01,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-15",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853071",
      "period": "2026-08",
      "booking_id": "RS-8853071",
      "duty_id": "D-513071",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. Nolan",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-14",
      "check_out": "2026-08-15",
      "nights": 1,
      "booking_amount": 291.07,
      "card_auth": 316.07,
      "card_settled": 630.38,
      "folio_amount": 630.38,
      "variance": 339.31,
      "variance_pct": 116.57,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 12,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853656",
      "period": "2026-08",
      "booking_id": "RS-8853656",
      "duty_id": "D-513656",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Brennan",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-29",
      "check_out": "2026-08-30",
      "nights": 1,
      "booking_amount": 279.42,
      "card_auth": 304.42,
      "card_settled": 616.61,
      "folio_amount": 616.61,
      "variance": 337.19,
      "variance_pct": 120.67,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-10T11:00:00Z",
      "final_at": "2026-09-29T00:01:00Z",
      "final_due_at": "2026-09-29",
      "age_days": 19,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854023",
      "period": "2026-08",
      "booking_id": "RS-8854023",
      "duty_id": "D-514023",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "T. Maes",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-11",
      "check_out": "2026-08-12",
      "nights": 1,
      "booking_amount": 389.66,
      "card_auth": 414.66,
      "card_settled": 746.46,
      "folio_amount": 746.46,
      "variance": 337.09,
      "variance_pct": 86.51,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": "2026-08-14T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-11",
      "age_days": 4,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854952",
      "period": "2026-08",
      "booking_id": "RS-8854952",
      "duty_id": "D-514952",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "O. Lefevre",
      "station": "TLS",
      "property_id": "P-133",
      "hotel": "Pullman Toulouse Airport",
      "check_in": "2026-08-11",
      "check_out": "2026-08-14",
      "nights": 3,
      "booking_amount": 975.94,
      "card_auth": 1000.94,
      "card_settled": 1333.65,
      "folio_amount": 1333.65,
      "variance": 333.9,
      "variance_pct": 34.21,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": "2026-08-27T11:00:00Z",
      "final_at": "2026-09-13T00:01:00Z",
      "final_due_at": "2026-09-13",
      "age_days": 6,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854010",
      "period": "2026-08",
      "booking_id": "RS-8854010",
      "duty_id": "D-514010",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "Y. Lambert",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-13",
      "check_out": "2026-08-14",
      "nights": 1,
      "booking_amount": 327.96,
      "card_auth": 352.96,
      "card_settled": 661.62,
      "folio_amount": 661.62,
      "variance": 333.66,
      "variance_pct": 101.74,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-13T00:01:00Z",
      "final_due_at": "2026-09-13",
      "age_days": 1,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853257",
      "period": "2026-08",
      "booking_id": "RS-8853257",
      "duty_id": "D-513257",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Byrne",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-12",
      "check_out": "2026-08-15",
      "nights": 3,
      "booking_amount": 856.77,
      "card_auth": 881.77,
      "card_settled": 1218.43,
      "folio_amount": 1218.43,
      "variance": 333.24,
      "variance_pct": 38.89,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854621",
      "period": "2026-08",
      "booking_id": "RS-8854621",
      "duty_id": "D-514621",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Verhoeven",
      "station": "BRU",
      "property_id": "P-118",
      "hotel": "NH Brussels Airport",
      "check_in": "2026-08-22",
      "check_out": "2026-08-25",
      "nights": 3,
      "booking_amount": 978.06,
      "card_auth": 1003.06,
      "card_settled": 1320.6,
      "folio_amount": 1320.6,
      "variance": 331.62,
      "variance_pct": 33.91,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 1,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854709",
      "period": "2026-08",
      "booking_id": "RS-8854709",
      "duty_id": "D-514709",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "M. Chevalier",
      "station": "CDG",
      "property_id": "P-128",
      "hotel": "Ibis Paris CDG",
      "check_in": "2026-08-17",
      "check_out": "2026-08-18",
      "nights": 1,
      "booking_amount": 333.64,
      "card_auth": 358.64,
      "card_settled": 663.55,
      "folio_amount": 663.55,
      "variance": 329.91,
      "variance_pct": 98.88,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-18T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-17",
      "age_days": 22,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855020",
      "period": "2026-08",
      "booking_id": "RS-8855020",
      "duty_id": "D-515020",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Lefevre",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-08",
      "check_out": "2026-08-09",
      "nights": 1,
      "booking_amount": 293.88,
      "card_auth": 318.88,
      "card_settled": 631.99,
      "folio_amount": 631.99,
      "variance": 329.83,
      "variance_pct": 112.23,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": "2026-09-08T00:01:00Z",
      "final_due_at": "2026-09-08",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853038",
      "period": "2026-08",
      "booking_id": "RS-8853038",
      "duty_id": "D-513038",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "S. Brennan",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-11",
      "check_out": "2026-08-12",
      "nights": 1,
      "booking_amount": 254.22,
      "card_auth": 279.22,
      "card_settled": 578.04,
      "folio_amount": 578.04,
      "variance": 323.82,
      "variance_pct": 127.38,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": "2026-08-23T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-11",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854250",
      "period": "2026-08",
      "booking_id": "RS-8854250",
      "duty_id": "D-514250",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. De Smet",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-19",
      "check_out": "2026-08-21",
      "nights": 2,
      "booking_amount": 552.98,
      "card_auth": 577.98,
      "card_settled": 871.54,
      "folio_amount": 871.54,
      "variance": 318.56,
      "variance_pct": 57.61,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": "2026-08-30T11:00:00Z",
      "final_at": "2026-09-20T00:01:00Z",
      "final_due_at": "2026-09-20",
      "age_days": 40,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854727",
      "period": "2026-08",
      "booking_id": "RS-8854727",
      "duty_id": "D-514727",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "L. Roussel",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 591.84,
      "card_auth": 616.84,
      "card_settled": 908.19,
      "folio_amount": 908.19,
      "variance": 316.35,
      "variance_pct": 53.45,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-18T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853413",
      "period": "2026-08",
      "booking_id": "RS-8853413",
      "duty_id": "D-513413",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "E. Healy",
      "station": "EMA",
      "property_id": "P-105",
      "hotel": "Holiday Inn Castle Donington",
      "check_in": "2026-08-26",
      "check_out": "2026-08-27",
      "nights": 1,
      "booking_amount": 298.01,
      "card_auth": 323.01,
      "card_settled": 630.18,
      "folio_amount": 315.09,
      "variance": 315.09,
      "variance_pct": 105.73,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-27T02:10:00Z",
      "resolved_at": "2026-09-02T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-26",
      "age_days": 25,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853562",
      "period": "2026-08",
      "booking_id": "RS-8853562",
      "duty_id": "D-513562",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. Quinn",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-22",
      "check_out": "2026-08-24",
      "nights": 2,
      "booking_amount": 544.36,
      "card_auth": 569.36,
      "card_settled": 866.5,
      "folio_amount": 866.5,
      "variance": 313.5,
      "variance_pct": 57.59,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-24T02:10:00Z",
      "resolved_at": "2026-08-27T11:00:00Z",
      "final_at": "2026-09-23T00:01:00Z",
      "final_due_at": "2026-09-23",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852994",
      "period": "2026-08",
      "booking_id": "RS-8852994",
      "duty_id": "D-512994",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-11",
      "check_out": "2026-08-12",
      "nights": 1,
      "booking_amount": 277.76,
      "card_auth": 302.76,
      "card_settled": 590.7,
      "folio_amount": 590.7,
      "variance": 312.94,
      "variance_pct": 112.67,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": "2026-09-11T00:01:00Z",
      "final_due_at": "2026-09-11",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852842",
      "period": "2026-08",
      "booking_id": "RS-8852842",
      "duty_id": "D-512842",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "E. Kavanagh",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-18",
      "check_out": "2026-08-19",
      "nights": 1,
      "booking_amount": 312.6,
      "card_auth": 337.6,
      "card_settled": 625.2,
      "folio_amount": 312.6,
      "variance": 312.6,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": "2026-09-18T00:01:00Z",
      "final_due_at": "2026-09-18",
      "age_days": 17,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853882",
      "period": "2026-08",
      "booking_id": "RS-8853882",
      "duty_id": "D-513882",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "L. Janssens",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-11",
      "check_out": "2026-08-14",
      "nights": 3,
      "booking_amount": 719.76,
      "card_auth": 450.89,
      "card_settled": 450.89,
      "folio_amount": 762.82,
      "variance": 311.93,
      "variance_pct": 43.34,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-13",
      "age_days": 2,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854034",
      "period": "2026-08",
      "booking_id": "RS-8854034",
      "duty_id": "D-514034",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "T. Maes",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-13",
      "check_out": "2026-08-15",
      "nights": 2,
      "booking_amount": 580.9,
      "card_auth": 605.9,
      "card_settled": 949.32,
      "folio_amount": 949.32,
      "variance": 310.08,
      "variance_pct": 53.38,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": "2026-08-23T11:00:00Z",
      "final_at": "2026-09-14T00:01:00Z",
      "final_due_at": "2026-09-14",
      "age_days": 39,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853593",
      "period": "2026-08",
      "booking_id": "RS-8853593",
      "duty_id": "D-513593",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Doyle",
      "station": "BHX",
      "property_id": "P-113",
      "hotel": "Novotel Birmingham Airport",
      "check_in": "2026-08-24",
      "check_out": "2026-08-26",
      "nights": 2,
      "booking_amount": 648.61,
      "card_auth": 673.61,
      "card_settled": 957.27,
      "folio_amount": 957.27,
      "variance": 308.66,
      "variance_pct": 47.59,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 25,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853014",
      "period": "2026-08",
      "booking_id": "RS-8853014",
      "duty_id": "D-513014",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Nolan",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-17",
      "check_out": "2026-08-21",
      "nights": 4,
      "booking_amount": 1344.38,
      "card_auth": 1369.38,
      "card_settled": 1651.68,
      "folio_amount": 1651.68,
      "variance": 307.3,
      "variance_pct": 22.86,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-20",
      "age_days": 12,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854464",
      "period": "2026-08",
      "booking_id": "RS-8854464",
      "duty_id": "D-514464",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "C. Vermeulen",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-22",
      "check_out": "2026-08-26",
      "nights": 4,
      "booking_amount": 1042.04,
      "card_auth": 1067.04,
      "card_settled": 1348.89,
      "folio_amount": 1348.89,
      "variance": 306.85,
      "variance_pct": 29.45,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854855",
      "period": "2026-08",
      "booking_id": "RS-8854855",
      "duty_id": "D-514855",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "O. Delacroix",
      "station": "LYS",
      "property_id": "P-129",
      "hotel": "NH Lyon Airport",
      "check_in": "2026-08-14",
      "check_out": "2026-08-17",
      "nights": 3,
      "booking_amount": 800.4,
      "card_auth": 523.7,
      "card_settled": 523.7,
      "folio_amount": 828.63,
      "variance": 304.93,
      "variance_pct": 38.1,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855183",
      "period": "2026-08",
      "booking_id": "RS-8855183",
      "duty_id": "D-515183",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Marchand",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-20",
      "check_out": "2026-08-23",
      "nights": 3,
      "booking_amount": 921.14,
      "card_auth": 946.14,
      "card_settled": 1255.23,
      "folio_amount": 1255.23,
      "variance": 304.65,
      "variance_pct": 33.07,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-23T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": "2026-09-22T00:01:00Z",
      "final_due_at": "2026-09-22",
      "age_days": 15,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855206",
      "period": "2026-08",
      "booking_id": "RS-8855206",
      "duty_id": "D-515206",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "M. Fontaine",
      "station": "MAD",
      "property_id": "P-135",
      "hotel": "Melia Barajas",
      "check_in": "2026-08-23",
      "check_out": "2026-08-24",
      "nights": 1,
      "booking_amount": 277.22,
      "card_auth": 302.22,
      "card_settled": 604.92,
      "folio_amount": 302.46,
      "variance": 302.46,
      "variance_pct": 109.1,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-24T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": "2026-09-23T00:01:00Z",
      "final_due_at": "2026-09-23",
      "age_days": 27,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854201",
      "period": "2026-08",
      "booking_id": "RS-8854201",
      "duty_id": "D-514201",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "D. Declerck",
      "station": "DXB",
      "property_id": "P-123",
      "hotel": "Le Meridien Dubai",
      "check_in": "2026-08-28",
      "check_out": "2026-09-01",
      "nights": 4,
      "booking_amount": 1266.79,
      "card_auth": 1291.79,
      "card_settled": 1605.73,
      "folio_amount": 1605.73,
      "variance": 302.24,
      "variance_pct": 23.86,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-11T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 17,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855185",
      "period": "2026-08",
      "booking_id": "RS-8855185",
      "duty_id": "D-515185",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "G. Marchand",
      "station": "LYS",
      "property_id": "P-130",
      "hotel": "Comfort Hotel Lyon",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 274.42,
      "card_auth": 299.42,
      "card_settled": 575.26,
      "folio_amount": 575.26,
      "variance": 300.84,
      "variance_pct": 109.63,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-03T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 4,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852891",
      "period": "2026-08",
      "booking_id": "RS-8852891",
      "duty_id": "D-512891",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-19",
      "check_out": "2026-08-20",
      "nights": 1,
      "booking_amount": 350.89,
      "card_auth": 375.89,
      "card_settled": 648.89,
      "folio_amount": 648.89,
      "variance": 298,
      "variance_pct": 84.93,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-30T11:00:00Z",
      "final_at": "2026-09-19T00:01:00Z",
      "final_due_at": "2026-09-19",
      "age_days": 1,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853938",
      "period": "2026-08",
      "booking_id": "RS-8853938",
      "duty_id": "D-513938",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "L. Claes",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-07",
      "check_out": "2026-08-09",
      "nights": 2,
      "booking_amount": 588.94,
      "card_auth": 613.94,
      "card_settled": 588.94,
      "folio_amount": 882.11,
      "variance": 293.17,
      "variance_pct": 49.78,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 13,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853408",
      "period": "2026-08",
      "booking_id": "RS-8853408",
      "duty_id": "D-513408",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. Nolan",
      "station": "STN",
      "property_id": "P-116",
      "hotel": "Hampton by Hilton Stansted",
      "check_in": "2026-08-07",
      "check_out": "2026-08-08",
      "nights": 1,
      "booking_amount": 302.85,
      "card_auth": 327.85,
      "card_settled": 595.1,
      "folio_amount": 595.1,
      "variance": 292.25,
      "variance_pct": 96.5,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-07",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853494",
      "period": "2026-08",
      "booking_id": "RS-8853494",
      "duty_id": "D-513494",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "A. Devlin",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-08",
      "check_out": "2026-08-12",
      "nights": 4,
      "booking_amount": 1117,
      "card_auth": 1142,
      "card_settled": 1419.17,
      "folio_amount": 1419.17,
      "variance": 290.43,
      "variance_pct": 26,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-11",
      "age_days": 17,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853308",
      "period": "2026-08",
      "booking_id": "RS-8853308",
      "duty_id": "D-513308",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Healy",
      "station": "EMA",
      "property_id": "P-105",
      "hotel": "Holiday Inn Castle Donington",
      "check_in": "2026-08-02",
      "check_out": "2026-08-06",
      "nights": 4,
      "booking_amount": 1241.41,
      "card_auth": 1266.41,
      "card_settled": 1628.83,
      "folio_amount": 1628.83,
      "variance": 289.78,
      "variance_pct": 23.34,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": "2026-08-08T11:00:00Z",
      "final_at": "2026-09-05T00:01:00Z",
      "final_due_at": "2026-09-05",
      "age_days": 30,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855211",
      "period": "2026-08",
      "booking_id": "RS-8855211",
      "duty_id": "D-515211",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "G. Marchand",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-28",
      "check_out": "2026-08-29",
      "nights": 1,
      "booking_amount": 294.23,
      "card_auth": 319.23,
      "card_settled": 577.73,
      "folio_amount": 577.73,
      "variance": 283.5,
      "variance_pct": 96.35,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-29T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-28",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854614",
      "period": "2026-08",
      "booking_id": "RS-8854614",
      "duty_id": "D-514614",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "O. Declerck",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-17",
      "check_out": "2026-08-19",
      "nights": 2,
      "booking_amount": 690.83,
      "card_auth": 715.83,
      "card_settled": 1006.42,
      "folio_amount": 1006.42,
      "variance": 282.8,
      "variance_pct": 40.94,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-18T00:01:00Z",
      "final_due_at": "2026-09-18",
      "age_days": 6,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852951",
      "period": "2026-08",
      "booking_id": "RS-8852951",
      "duty_id": "D-512951",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-02",
      "check_out": "2026-08-03",
      "nights": 1,
      "booking_amount": 257.81,
      "card_auth": 282.81,
      "card_settled": 550.89,
      "folio_amount": 550.89,
      "variance": 281.61,
      "variance_pct": 109.23,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-03T02:10:00Z",
      "resolved_at": "2026-08-14T11:00:00Z",
      "final_at": "2026-09-02T00:01:00Z",
      "final_due_at": "2026-09-02",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855079",
      "period": "2026-08",
      "booking_id": "RS-8855079",
      "duty_id": "D-515079",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "V. Roussel",
      "station": "TLS",
      "property_id": "P-134",
      "hotel": "Ibis Toulouse Blagnac",
      "check_in": "2026-08-28",
      "check_out": "2026-08-30",
      "nights": 2,
      "booking_amount": 539.78,
      "card_auth": 564.78,
      "card_settled": 831.3,
      "folio_amount": 831.3,
      "variance": 277.8,
      "variance_pct": 51.47,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 2,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854057",
      "period": "2026-08",
      "booking_id": "RS-8854057",
      "duty_id": "D-514057",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "L. Declerck",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-24",
      "check_out": "2026-08-26",
      "nights": 2,
      "booking_amount": 571.14,
      "card_auth": 596.14,
      "card_settled": 584.51,
      "folio_amount": 860.73,
      "variance": 276.22,
      "variance_pct": 48.36,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-02T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853401",
      "period": "2026-08",
      "booking_id": "RS-8853401",
      "duty_id": "D-513401",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. Mulligan",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-16",
      "check_out": "2026-08-18",
      "nights": 2,
      "booking_amount": 532.12,
      "card_auth": 557.12,
      "card_settled": 805.28,
      "folio_amount": 805.28,
      "variance": 273.16,
      "variance_pct": 51.33,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-18T02:10:00Z",
      "resolved_at": "2026-08-27T11:00:00Z",
      "final_at": "2026-09-17T00:01:00Z",
      "final_due_at": "2026-09-17",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853574",
      "period": "2026-08",
      "booking_id": "RS-8853574",
      "duty_id": "D-513574",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "E. Doyle",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-10",
      "check_out": "2026-08-11",
      "nights": 1,
      "booking_amount": 273.04,
      "card_auth": 298.04,
      "card_settled": 546.08,
      "folio_amount": 273.04,
      "variance": 273.04,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": "2026-08-18T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 8,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852921",
      "period": "2026-08",
      "booking_id": "RS-8852921",
      "duty_id": "D-512921",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Cassidy",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-25",
      "check_out": "2026-08-28",
      "nights": 3,
      "booking_amount": 1016.9,
      "card_auth": 1041.9,
      "card_settled": 1340.68,
      "folio_amount": 1340.68,
      "variance": 271.18,
      "variance_pct": 26.67,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-28T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-27",
      "age_days": 25,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852861",
      "period": "2026-08",
      "booking_id": "RS-8852861",
      "duty_id": "D-512861",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Kavanagh",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-03",
      "check_out": "2026-08-06",
      "nights": 3,
      "booking_amount": 815.88,
      "card_auth": 840.88,
      "card_settled": 1116.03,
      "folio_amount": 1116.03,
      "variance": 270.83,
      "variance_pct": 33.19,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-05",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854876",
      "period": "2026-08",
      "booking_id": "RS-8854876",
      "duty_id": "D-514876",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "B. Chevalier",
      "station": "LYS",
      "property_id": "P-130",
      "hotel": "Comfort Hotel Lyon",
      "check_in": "2026-08-03",
      "check_out": "2026-08-04",
      "nights": 1,
      "booking_amount": 296.45,
      "card_auth": 321.45,
      "card_settled": 588.39,
      "folio_amount": 588.39,
      "variance": 269.56,
      "variance_pct": 90.93,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-04T02:10:00Z",
      "resolved_at": "2026-08-18T11:00:00Z",
      "final_at": "2026-09-03T00:01:00Z",
      "final_due_at": "2026-09-03",
      "age_days": 39,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854395",
      "period": "2026-08",
      "booking_id": "RS-8854395",
      "duty_id": "D-514395",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "O. Maes",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-10",
      "check_out": "2026-08-12",
      "nights": 2,
      "booking_amount": 546,
      "card_auth": 276.66,
      "card_settled": 276.66,
      "folio_amount": 546,
      "variance": 269.34,
      "variance_pct": 49.33,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-12T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": "2026-09-11T00:01:00Z",
      "final_due_at": "2026-09-11",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854861",
      "period": "2026-08",
      "booking_id": "RS-8854861",
      "duty_id": "D-514861",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "S. Aubert",
      "station": "TLS",
      "property_id": "P-134",
      "hotel": "Ibis Toulouse Blagnac",
      "check_in": "2026-08-15",
      "check_out": "2026-08-16",
      "nights": 1,
      "booking_amount": 268.97,
      "card_auth": 293.97,
      "card_settled": 537.94,
      "folio_amount": 268.97,
      "variance": 268.97,
      "variance_pct": 100,
      "variance_category": "unexplained",
      "match_state": "duplicate",
      "exception_type": "duplicate_charge",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-15T00:01:00Z",
      "final_due_at": "2026-09-15",
      "age_days": 13,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853304",
      "period": "2026-08",
      "booking_id": "RS-8853304",
      "duty_id": "D-513304",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Healy",
      "station": "CGN",
      "property_id": "P-109",
      "hotel": "Novotel Koln City",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 583.65,
      "card_auth": 608.65,
      "card_settled": 883.04,
      "folio_amount": 883.04,
      "variance": 267.13,
      "variance_pct": 45.77,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 29,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853514",
      "period": "2026-08",
      "booking_id": "RS-8853514",
      "duty_id": "D-513514",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "DUB",
      "property_id": "P-103",
      "hotel": "Radisson Blu Dublin Airport",
      "check_in": "2026-08-02",
      "check_out": "2026-08-06",
      "nights": 4,
      "booking_amount": 1128.71,
      "card_auth": 1153.71,
      "card_settled": 1437.22,
      "folio_amount": 1437.22,
      "variance": 263.55,
      "variance_pct": 23.35,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": "2026-08-18T11:00:00Z",
      "final_at": "2026-09-05T00:01:00Z",
      "final_due_at": "2026-09-05",
      "age_days": 19,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853747",
      "period": "2026-08",
      "booking_id": "RS-8853747",
      "duty_id": "D-513747",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "V. Devlin",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-18",
      "check_out": "2026-08-19",
      "nights": 1,
      "booking_amount": 309.13,
      "card_auth": 334.13,
      "card_settled": 567.4,
      "folio_amount": 567.4,
      "variance": 258.27,
      "variance_pct": 83.55,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-30T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-18",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852867",
      "period": "2026-08",
      "booking_id": "RS-8852867",
      "duty_id": "D-512867",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "R. Cassidy",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-16",
      "check_out": "2026-08-19",
      "nights": 3,
      "booking_amount": 884.49,
      "card_auth": 909.49,
      "card_settled": 1168.13,
      "folio_amount": 1168.13,
      "variance": 255.55,
      "variance_pct": 28.89,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-18",
      "age_days": 3,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853194",
      "period": "2026-08",
      "booking_id": "RS-8853194",
      "duty_id": "D-513194",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "V. Devlin",
      "station": "STN",
      "property_id": "P-115",
      "hotel": "Radisson Blu Stansted",
      "check_in": "2026-08-23",
      "check_out": "2026-08-27",
      "nights": 4,
      "booking_amount": 1277.2,
      "card_auth": 1302.2,
      "card_settled": 1553.46,
      "folio_amount": 1553.46,
      "variance": 252.92,
      "variance_pct": 19.8,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-27T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-26",
      "age_days": 27,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853671",
      "period": "2026-08",
      "booking_id": "RS-8853671",
      "duty_id": "D-513671",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "L. Cassidy",
      "station": "STN",
      "property_id": "P-115",
      "hotel": "Radisson Blu Stansted",
      "check_in": "2026-08-09",
      "check_out": "2026-08-13",
      "nights": 4,
      "booking_amount": 1272.48,
      "card_auth": 1297.48,
      "card_settled": 1521.65,
      "folio_amount": 1521.65,
      "variance": 249.17,
      "variance_pct": 19.58,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": "2026-09-12T00:01:00Z",
      "final_due_at": "2026-09-12",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855216",
      "period": "2026-08",
      "booking_id": "RS-8855216",
      "duty_id": "D-515216",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Moreau",
      "station": "MRS",
      "property_id": "P-131",
      "hotel": "Best Western Marseille Airport",
      "check_in": "2026-08-14",
      "check_out": "2026-08-17",
      "nights": 3,
      "booking_amount": 811.29,
      "card_auth": 836.29,
      "card_settled": 1082.56,
      "folio_amount": 1082.56,
      "variance": 245.19,
      "variance_pct": 30.22,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-30T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 16,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854766",
      "period": "2026-08",
      "booking_id": "RS-8854766",
      "duty_id": "D-514766",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "S. Bernard",
      "station": "BRU",
      "property_id": "P-119",
      "hotel": "Sheraton Brussels Airport",
      "check_in": "2026-08-10",
      "check_out": "2026-08-14",
      "nights": 4,
      "booking_amount": 1628.53,
      "card_auth": 1653.53,
      "card_settled": 1908.8,
      "folio_amount": 1908.8,
      "variance": 244.28,
      "variance_pct": 15,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": "2026-08-21T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-13",
      "age_days": 16,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854302",
      "period": "2026-08",
      "booking_id": "RS-8854302",
      "duty_id": "D-514302",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "G. Maes",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-12",
      "check_out": "2026-08-14",
      "nights": 2,
      "booking_amount": 520.34,
      "card_auth": 317.95,
      "card_settled": 317.95,
      "folio_amount": 555.85,
      "variance": 237.9,
      "variance_pct": 45.72,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": "2026-08-22T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-13",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854984",
      "period": "2026-08",
      "booking_id": "RS-8854984",
      "duty_id": "D-514984",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "E. Aubert",
      "station": "LYS",
      "property_id": "P-130",
      "hotel": "Comfort Hotel Lyon",
      "check_in": "2026-08-19",
      "check_out": "2026-08-23",
      "nights": 4,
      "booking_amount": 1100.92,
      "card_auth": 1125.92,
      "card_settled": 1389.89,
      "folio_amount": 1389.89,
      "variance": 237.26,
      "variance_pct": 21.55,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-23T02:10:00Z",
      "resolved_at": "2026-09-03T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-22",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855091",
      "period": "2026-08",
      "booking_id": "RS-8855091",
      "duty_id": "D-515091",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "E. Berger",
      "station": "MRS",
      "property_id": "P-131",
      "hotel": "Best Western Marseille Airport",
      "check_in": "2026-08-01",
      "check_out": "2026-08-02",
      "nights": 1,
      "booking_amount": 272.11,
      "card_auth": 297.11,
      "card_settled": 508.3,
      "folio_amount": 508.3,
      "variance": 236.19,
      "variance_pct": 86.8,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-02T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-01",
      "age_days": 7,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853359",
      "period": "2026-08",
      "booking_id": "RS-8853359",
      "duty_id": "D-513359",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Kavanagh",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 262.17,
      "card_auth": 287.17,
      "card_settled": 497.77,
      "folio_amount": 497.77,
      "variance": 235.6,
      "variance_pct": 89.87,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-07T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854792",
      "period": "2026-08",
      "booking_id": "RS-8854792",
      "duty_id": "D-514792",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "H. Chevalier",
      "station": "MAD",
      "property_id": "P-135",
      "hotel": "Melia Barajas",
      "check_in": "2026-08-14",
      "check_out": "2026-08-17",
      "nights": 3,
      "booking_amount": 884.7,
      "card_auth": 909.7,
      "card_settled": 1160.94,
      "folio_amount": 1160.94,
      "variance": 234.92,
      "variance_pct": 26.55,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-23T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855162",
      "period": "2026-08",
      "booking_id": "RS-8855162",
      "duty_id": "D-515162",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Perrin",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-12",
      "check_out": "2026-08-15",
      "nights": 3,
      "booking_amount": 890.04,
      "card_auth": 915.04,
      "card_settled": 1116.63,
      "folio_amount": 1116.63,
      "variance": 226.59,
      "variance_pct": 25.46,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853971",
      "period": "2026-08",
      "booking_id": "RS-8853971",
      "duty_id": "D-513971",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "L. Lambert",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-10",
      "check_out": "2026-08-13",
      "nights": 3,
      "booking_amount": 790.98,
      "card_auth": 576.36,
      "card_settled": 576.36,
      "folio_amount": 799.1,
      "variance": 222.74,
      "variance_pct": 28.16,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": "2026-09-12T00:01:00Z",
      "final_due_at": "2026-09-12",
      "age_days": 28,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853301",
      "period": "2026-08",
      "booking_id": "RS-8853301",
      "duty_id": "D-513301",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Fitzgerald",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-23",
      "check_out": "2026-08-26",
      "nights": 3,
      "booking_amount": 894.3,
      "card_auth": 919.3,
      "card_settled": 1138.09,
      "folio_amount": 1138.09,
      "variance": 220.71,
      "variance_pct": 24.68,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-06T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853980",
      "period": "2026-08",
      "booking_id": "RS-8853980",
      "duty_id": "D-513980",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "P. Vermeulen",
      "station": "HKG",
      "property_id": "P-120",
      "hotel": "Regal Airport Hotel",
      "check_in": "2026-08-04",
      "check_out": "2026-08-06",
      "nights": 2,
      "booking_amount": 593.44,
      "card_auth": 618.44,
      "card_settled": 813.12,
      "folio_amount": 813.12,
      "variance": 219.68,
      "variance_pct": 37.02,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": "2026-08-09T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-05",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853901",
      "period": "2026-08",
      "booking_id": "RS-8853901",
      "duty_id": "D-513901",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "K. Dubois",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-23",
      "check_out": "2026-08-25",
      "nights": 2,
      "booking_amount": 606.44,
      "card_auth": 631.44,
      "card_settled": 844.91,
      "folio_amount": 844.91,
      "variance": 218.85,
      "variance_pct": 36.09,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": "2026-09-02T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 28,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854040",
      "period": "2026-08",
      "booking_id": "RS-8854040",
      "duty_id": "D-514040",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "M. De Smet",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 339.55,
      "card_auth": 364.55,
      "card_settled": 568.25,
      "folio_amount": 568.25,
      "variance": 217.48,
      "variance_pct": 64.05,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-13T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-10-01",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855098",
      "period": "2026-08",
      "booking_id": "RS-8855098",
      "duty_id": "D-515098",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Chevalier",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 653.93,
      "card_auth": 678.93,
      "card_settled": 882.29,
      "folio_amount": 882.29,
      "variance": 217.46,
      "variance_pct": 33.25,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 19,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854587",
      "period": "2026-08",
      "booking_id": "RS-8854587",
      "duty_id": "D-514587",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. Wouters",
      "station": "BRU",
      "property_id": "P-118",
      "hotel": "NH Brussels Airport",
      "check_in": "2026-08-24",
      "check_out": "2026-08-27",
      "nights": 3,
      "booking_amount": 1260.22,
      "card_auth": 1285.22,
      "card_settled": 1477.53,
      "folio_amount": 1477.53,
      "variance": 217.31,
      "variance_pct": 17.24,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-27T02:10:00Z",
      "resolved_at": "2026-09-09T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-26",
      "age_days": 1,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854570",
      "period": "2026-08",
      "booking_id": "RS-8854570",
      "duty_id": "D-514570",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "N. Dubois",
      "station": "BRU",
      "property_id": "P-117",
      "hotel": "Thon Hotel EU",
      "check_in": "2026-08-04",
      "check_out": "2026-08-05",
      "nights": 1,
      "booking_amount": 387.76,
      "card_auth": 412.76,
      "card_settled": 597.79,
      "folio_amount": 597.79,
      "variance": 210.03,
      "variance_pct": 54.16,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-05T02:10:00Z",
      "resolved_at": "2026-08-11T11:00:00Z",
      "final_at": "2026-09-04T00:01:00Z",
      "final_due_at": "2026-09-04",
      "age_days": 13,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853080",
      "period": "2026-08",
      "booking_id": "RS-8853080",
      "duty_id": "D-513080",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. Fitzgerald",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-02",
      "check_out": "2026-08-03",
      "nights": 1,
      "booking_amount": 250.56,
      "card_auth": 275.56,
      "card_settled": 282.92,
      "folio_amount": 492.84,
      "variance": 209.92,
      "variance_pct": 83.78,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-03T02:10:00Z",
      "resolved_at": "2026-08-12T11:00:00Z",
      "final_at": "2026-09-02T00:01:00Z",
      "final_due_at": "2026-09-02",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854073",
      "period": "2026-08",
      "booking_id": "RS-8854073",
      "duty_id": "D-514073",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Verhoeven",
      "station": "BRU",
      "property_id": "P-117",
      "hotel": "Thon Hotel EU",
      "check_in": "2026-08-15",
      "check_out": "2026-08-16",
      "nights": 1,
      "booking_amount": 307.17,
      "card_auth": 332.17,
      "card_settled": 516.13,
      "folio_amount": 516.13,
      "variance": 208.96,
      "variance_pct": 68.03,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": "2026-08-27T11:00:00Z",
      "final_at": "2026-09-15T00:01:00Z",
      "final_due_at": "2026-09-15",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853809",
      "period": "2026-08",
      "booking_id": "RS-8853809",
      "duty_id": "D-513809",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "A. Cassidy",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-09",
      "check_out": "2026-08-11",
      "nights": 2,
      "booking_amount": 474.56,
      "card_auth": 499.56,
      "card_settled": 692.56,
      "folio_amount": 692.56,
      "variance": 206,
      "variance_pct": 43.41,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": "2026-09-10T00:01:00Z",
      "final_due_at": "2026-09-10",
      "age_days": 28,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852930",
      "period": "2026-08",
      "booking_id": "RS-8852930",
      "duty_id": "D-512930",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "STN",
      "property_id": "P-116",
      "hotel": "Hampton by Hilton Stansted",
      "check_in": "2026-08-16",
      "check_out": "2026-08-19",
      "nights": 3,
      "booking_amount": 905.25,
      "card_auth": 702.97,
      "card_settled": 702.97,
      "folio_amount": 905.25,
      "variance": 202.28,
      "variance_pct": 22.35,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-18",
      "age_days": 26,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854436",
      "period": "2026-08",
      "booking_id": "RS-8854436",
      "duty_id": "D-514436",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "J. De Smet",
      "station": "LGG",
      "property_id": "P-112",
      "hotel": "Husa de la Couronne",
      "check_in": "2026-08-21",
      "check_out": "2026-08-22",
      "nights": 1,
      "booking_amount": 274.92,
      "card_auth": 299.92,
      "card_settled": 477.16,
      "folio_amount": 477.16,
      "variance": 202.24,
      "variance_pct": 73.56,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-22T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-21",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854171",
      "period": "2026-08",
      "booking_id": "RS-8854171",
      "duty_id": "D-514171",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Lambert",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-16",
      "check_out": "2026-08-17",
      "nights": 1,
      "booking_amount": 276.65,
      "card_auth": 301.65,
      "card_settled": 477.71,
      "folio_amount": 477.71,
      "variance": 201.06,
      "variance_pct": 72.68,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853055",
      "period": "2026-08",
      "booking_id": "RS-8853055",
      "duty_id": "D-513055",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "A. Healy",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-22",
      "check_out": "2026-08-24",
      "nights": 2,
      "booking_amount": 528.92,
      "card_auth": 553.92,
      "card_settled": 725.53,
      "folio_amount": 725.53,
      "variance": 196.61,
      "variance_pct": 37.17,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-24T02:10:00Z",
      "resolved_at": "2026-09-04T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-23",
      "age_days": 16,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853318",
      "period": "2026-08",
      "booking_id": "RS-8853318",
      "duty_id": "D-513318",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. O Conaill",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-29",
      "check_out": "2026-09-01",
      "nights": 3,
      "booking_amount": 804.08,
      "card_auth": 829.08,
      "card_settled": 1027.65,
      "folio_amount": 1027.65,
      "variance": 196.19,
      "variance_pct": 24.4,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-09T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853563",
      "period": "2026-08",
      "booking_id": "RS-8853563",
      "duty_id": "D-513563",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "T. Quinn",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-15",
      "check_out": "2026-08-17",
      "nights": 2,
      "booking_amount": 550.13,
      "card_auth": 575.13,
      "card_settled": 745.31,
      "folio_amount": 745.31,
      "variance": 195.18,
      "variance_pct": 35.48,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-17T02:10:00Z",
      "resolved_at": "2026-08-22T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-16",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853676",
      "period": "2026-08",
      "booking_id": "RS-8853676",
      "duty_id": "D-513676",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-03",
      "check_out": "2026-08-07",
      "nights": 4,
      "booking_amount": 1092.41,
      "card_auth": 1117.41,
      "card_settled": 1305.36,
      "folio_amount": 1305.36,
      "variance": 195.05,
      "variance_pct": 17.86,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-11T11:00:00Z",
      "final_at": "2026-09-06T00:01:00Z",
      "final_due_at": "2026-09-06",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855044",
      "period": "2026-08",
      "booking_id": "RS-8855044",
      "duty_id": "D-515044",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "L. Moreau",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-06",
      "check_out": "2026-08-08",
      "nights": 2,
      "booking_amount": 546.16,
      "card_auth": 571.16,
      "card_settled": 740.05,
      "folio_amount": 740.05,
      "variance": 193.89,
      "variance_pct": 35.5,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": "2026-08-18T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-07",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853074",
      "period": "2026-08",
      "booking_id": "RS-8853074",
      "duty_id": "D-513074",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "P. O Conaill",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-27",
      "check_out": "2026-08-28",
      "nights": 1,
      "booking_amount": 328.16,
      "card_auth": 353.16,
      "card_settled": 519.99,
      "folio_amount": 519.99,
      "variance": 191.83,
      "variance_pct": 58.46,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-28T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-27",
      "age_days": 15,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852946",
      "period": "2026-08",
      "booking_id": "RS-8852946",
      "duty_id": "D-512946",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "C. Devlin",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-01",
      "check_out": "2026-08-03",
      "nights": 2,
      "booking_amount": 516.81,
      "card_auth": 356.9,
      "card_settled": 356.9,
      "folio_amount": 546.03,
      "variance": 189.13,
      "variance_pct": 36.6,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-03T02:10:00Z",
      "resolved_at": "2026-08-15T11:00:00Z",
      "final_at": "2026-09-02T00:01:00Z",
      "final_due_at": "2026-09-02",
      "age_days": 8,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852848",
      "period": "2026-08",
      "booking_id": "RS-8852848",
      "duty_id": "D-512848",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "T. Fitzgerald",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-20",
      "check_out": "2026-08-22",
      "nights": 2,
      "booking_amount": 591.76,
      "card_auth": 405.55,
      "card_settled": 405.55,
      "folio_amount": 591.76,
      "variance": 186.21,
      "variance_pct": 31.47,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-08-22T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-21T00:01:00Z",
      "final_due_at": "2026-09-21",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854679",
      "period": "2026-08",
      "booking_id": "RS-8854679",
      "duty_id": "D-514679",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "M. Bernard",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-14",
      "check_out": "2026-08-16",
      "nights": 2,
      "booking_amount": 587.36,
      "card_auth": 612.36,
      "card_settled": 782.69,
      "folio_amount": 782.69,
      "variance": 184.26,
      "variance_pct": 31.37,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-15",
      "age_days": 12,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854532",
      "period": "2026-08",
      "booking_id": "RS-8854532",
      "duty_id": "D-514532",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "S. Vermeulen",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-19",
      "check_out": "2026-08-22",
      "nights": 3,
      "booking_amount": 896.7,
      "card_auth": 921.7,
      "card_settled": 1146.5,
      "folio_amount": 1146.5,
      "variance": 182.42,
      "variance_pct": 20.34,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-08-22T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": "2026-09-21T00:01:00Z",
      "final_due_at": "2026-09-21",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854219",
      "period": "2026-08",
      "booking_id": "RS-8854219",
      "duty_id": "D-514219",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "R. Lambert",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-20",
      "check_out": "2026-08-23",
      "nights": 3,
      "booking_amount": 827.46,
      "card_auth": 852.46,
      "card_settled": 1058.13,
      "folio_amount": 1058.13,
      "variance": 181.9,
      "variance_pct": 21.98,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-23T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-22",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855003",
      "period": "2026-08",
      "booking_id": "RS-8855003",
      "duty_id": "D-515003",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "T. Perrin",
      "station": "TLS",
      "property_id": "P-134",
      "hotel": "Ibis Toulouse Blagnac",
      "check_in": "2026-08-29",
      "check_out": "2026-08-31",
      "nights": 2,
      "booking_amount": 536.85,
      "card_auth": 561.85,
      "card_settled": 729.75,
      "folio_amount": 729.75,
      "variance": 181.62,
      "variance_pct": 33.83,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-31T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": "2026-09-30T00:01:00Z",
      "final_due_at": "2026-09-30",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853096",
      "period": "2026-08",
      "booking_id": "RS-8853096",
      "duty_id": "D-513096",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. O Conaill",
      "station": "EMA",
      "property_id": "P-105",
      "hotel": "Holiday Inn Castle Donington",
      "check_in": "2026-08-03",
      "check_out": "2026-08-04",
      "nights": 1,
      "booking_amount": 323.43,
      "card_auth": 178.78,
      "card_settled": 178.78,
      "folio_amount": 357.12,
      "variance": 178.34,
      "variance_pct": 55.14,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-04T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": "2026-09-03T00:01:00Z",
      "final_due_at": "2026-09-03",
      "age_days": 16,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853263",
      "period": "2026-08",
      "booking_id": "RS-8853263",
      "duty_id": "D-513263",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "A. Quinn",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-28",
      "check_out": "2026-08-30",
      "nights": 2,
      "booking_amount": 506.28,
      "card_auth": 531.28,
      "card_settled": 713.77,
      "folio_amount": 713.77,
      "variance": 176.4,
      "variance_pct": 34.84,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-07T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 22,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853034",
      "period": "2026-08",
      "booking_id": "RS-8853034",
      "duty_id": "D-513034",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-02",
      "check_out": "2026-08-05",
      "nights": 3,
      "booking_amount": 713.91,
      "card_auth": 738.91,
      "card_settled": 888.95,
      "folio_amount": 888.95,
      "variance": 175.04,
      "variance_pct": 24.52,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-05T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-04",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854325",
      "period": "2026-08",
      "booking_id": "RS-8854325",
      "duty_id": "D-514325",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "S. Dubois",
      "station": "BRU",
      "property_id": "P-117",
      "hotel": "Thon Hotel EU",
      "check_in": "2026-08-18",
      "check_out": "2026-08-20",
      "nights": 2,
      "booking_amount": 651.06,
      "card_auth": 498.81,
      "card_settled": 498.81,
      "folio_amount": 664.2,
      "variance": 165.39,
      "variance_pct": 25.4,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-22T11:00:00Z",
      "final_at": "2026-09-19T00:01:00Z",
      "final_due_at": "2026-09-19",
      "age_days": 35,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854945",
      "period": "2026-08",
      "booking_id": "RS-8854945",
      "duty_id": "D-514945",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "B. Chevalier",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-12",
      "check_out": "2026-08-13",
      "nights": 1,
      "booking_amount": 294.52,
      "card_auth": 319.52,
      "card_settled": 468.54,
      "folio_amount": 468.54,
      "variance": 163.04,
      "variance_pct": 55.36,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853908",
      "period": "2026-08",
      "booking_id": "RS-8853908",
      "duty_id": "D-513908",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "C. Vermeulen",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-18",
      "check_out": "2026-08-20",
      "nights": 2,
      "booking_amount": 633.32,
      "card_auth": 470.3,
      "card_settled": 470.3,
      "folio_amount": 633.32,
      "variance": 163.02,
      "variance_pct": 25.74,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-19T00:01:00Z",
      "final_due_at": "2026-09-19",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853960",
      "period": "2026-08",
      "booking_id": "RS-8853960",
      "duty_id": "D-513960",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. De Smet",
      "station": "DXB",
      "property_id": "P-123",
      "hotel": "Le Meridien Dubai",
      "check_in": "2026-08-11",
      "check_out": "2026-08-14",
      "nights": 3,
      "booking_amount": 1053.32,
      "card_auth": 1078.32,
      "card_settled": 1230.49,
      "folio_amount": 1230.49,
      "variance": 162.41,
      "variance_pct": 15.42,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-14T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-13",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852928",
      "period": "2026-08",
      "booking_id": "RS-8852928",
      "duty_id": "D-512928",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "BHX",
      "property_id": "P-113",
      "hotel": "Novotel Birmingham Airport",
      "check_in": "2026-08-05",
      "check_out": "2026-08-06",
      "nights": 1,
      "booking_amount": 281,
      "card_auth": 306,
      "card_settled": 461.07,
      "folio_amount": 461.07,
      "variance": 161.89,
      "variance_pct": 57.61,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-06T02:10:00Z",
      "resolved_at": "2026-08-14T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-05",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854844",
      "period": "2026-08",
      "booking_id": "RS-8854844",
      "duty_id": "D-514844",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "O. Lefevre",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 276.83,
      "card_auth": 138.27,
      "card_settled": 138.27,
      "folio_amount": 299.74,
      "variance": 161.47,
      "variance_pct": 58.33,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-03T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 27,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854151",
      "period": "2026-08",
      "booking_id": "RS-8854151",
      "duty_id": "D-514151",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "O. Wouters",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-11",
      "check_out": "2026-08-13",
      "nights": 2,
      "booking_amount": 518.34,
      "card_auth": 543.34,
      "card_settled": 678.84,
      "folio_amount": 678.84,
      "variance": 160.5,
      "variance_pct": 30.96,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-16T11:00:00Z",
      "final_at": "2026-09-12T00:01:00Z",
      "final_due_at": "2026-09-12",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854535",
      "period": "2026-08",
      "booking_id": "RS-8854535",
      "duty_id": "D-514535",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "H. Claes",
      "station": "DXB",
      "property_id": "P-123",
      "hotel": "Le Meridien Dubai",
      "check_in": "2026-08-24",
      "check_out": "2026-08-25",
      "nights": 1,
      "booking_amount": 381.04,
      "card_auth": 406.04,
      "card_settled": 540.93,
      "folio_amount": 540.93,
      "variance": 159.89,
      "variance_pct": 41.96,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 15,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854009",
      "period": "2026-08",
      "booking_id": "RS-8854009",
      "duty_id": "D-514009",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "M. Janssens",
      "station": "BRU",
      "property_id": "P-118",
      "hotel": "NH Brussels Airport",
      "check_in": "2026-08-10",
      "check_out": "2026-08-11",
      "nights": 1,
      "booking_amount": 364.02,
      "card_auth": 389.02,
      "card_settled": 522.91,
      "folio_amount": 522.91,
      "variance": 158.89,
      "variance_pct": 43.65,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853530",
      "period": "2026-08",
      "booking_id": "RS-8853530",
      "duty_id": "D-513530",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Byrne",
      "station": "BHX",
      "property_id": "P-113",
      "hotel": "Novotel Birmingham Airport",
      "check_in": "2026-08-21",
      "check_out": "2026-08-22",
      "nights": 1,
      "booking_amount": 280.37,
      "card_auth": 305.37,
      "card_settled": 437.24,
      "folio_amount": 437.24,
      "variance": 156.87,
      "variance_pct": 55.95,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-22T02:10:00Z",
      "resolved_at": "2026-08-27T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-21",
      "age_days": 32,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854099",
      "period": "2026-08",
      "booking_id": "RS-8854099",
      "duty_id": "D-514099",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "J. De Smet",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-10",
      "check_out": "2026-08-11",
      "nights": 1,
      "booking_amount": 296.7,
      "card_auth": 321.7,
      "card_settled": 446.57,
      "folio_amount": 446.57,
      "variance": 149.87,
      "variance_pct": 50.51,
      "variance_category": "currency",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-10",
      "age_days": 38,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853050",
      "period": "2026-08",
      "booking_id": "RS-8853050",
      "duty_id": "D-513050",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "C. Kavanagh",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-30",
      "check_out": "2026-09-01",
      "nights": 2,
      "booking_amount": 529.02,
      "card_auth": 554.02,
      "card_settled": 675.35,
      "folio_amount": 675.35,
      "variance": 146.33,
      "variance_pct": 27.66,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-10-01",
      "age_days": 26,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853716",
      "period": "2026-08",
      "booking_id": "RS-8853716",
      "duty_id": "D-513716",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. Cassidy",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-01",
      "check_out": "2026-08-04",
      "nights": 3,
      "booking_amount": 869,
      "card_auth": 894,
      "card_settled": 1054.76,
      "folio_amount": 1054.76,
      "variance": 144.02,
      "variance_pct": 16.57,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-04T02:10:00Z",
      "resolved_at": "2026-08-09T11:00:00Z",
      "final_at": "2026-09-03T00:01:00Z",
      "final_due_at": "2026-09-03",
      "age_days": 8,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854043",
      "period": "2026-08",
      "booking_id": "RS-8854043",
      "duty_id": "D-514043",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "C. Vermeulen",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-22",
      "check_out": "2026-08-25",
      "nights": 3,
      "booking_amount": 874.68,
      "card_auth": 899.68,
      "card_settled": 1013.86,
      "folio_amount": 1013.86,
      "variance": 139.18,
      "variance_pct": 15.91,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-25T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-24",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853325",
      "period": "2026-08",
      "booking_id": "RS-8853325",
      "duty_id": "D-513325",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. Nolan",
      "station": "STN",
      "property_id": "P-115",
      "hotel": "Radisson Blu Stansted",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 318.05,
      "card_auth": 179.14,
      "card_settled": 179.14,
      "folio_amount": 318.05,
      "variance": 138.91,
      "variance_pct": 43.68,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-10-01",
      "age_days": 19,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853651",
      "period": "2026-08",
      "booking_id": "RS-8853651",
      "duty_id": "D-513651",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "M. Fitzgerald",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-18",
      "check_out": "2026-08-21",
      "nights": 3,
      "booking_amount": 820.11,
      "card_auth": 845.11,
      "card_settled": 954.08,
      "folio_amount": 954.08,
      "variance": 133.97,
      "variance_pct": 16.34,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": "2026-09-20T00:01:00Z",
      "final_due_at": "2026-09-20",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853723",
      "period": "2026-08",
      "booking_id": "RS-8853723",
      "duty_id": "D-513723",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "EMA",
      "property_id": "P-106",
      "hotel": "Premier Inn Kegworth",
      "check_in": "2026-08-09",
      "check_out": "2026-08-11",
      "nights": 2,
      "booking_amount": 610.53,
      "card_auth": 635.53,
      "card_settled": 610.53,
      "folio_amount": 743.28,
      "variance": 132.75,
      "variance_pct": 21.74,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-11T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": "2026-09-10T00:01:00Z",
      "final_due_at": "2026-09-10",
      "age_days": 24,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854212",
      "period": "2026-08",
      "booking_id": "RS-8854212",
      "duty_id": "D-514212",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "D. Lambert",
      "station": "LGG",
      "property_id": "P-112",
      "hotel": "Husa de la Couronne",
      "check_in": "2026-08-03",
      "check_out": "2026-08-07",
      "nights": 4,
      "booking_amount": 1271.94,
      "card_auth": 1296.94,
      "card_settled": 1403.85,
      "folio_amount": 1403.85,
      "variance": 131.91,
      "variance_pct": 10.37,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": "2026-09-06T00:01:00Z",
      "final_due_at": "2026-09-06",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854642",
      "period": "2026-08",
      "booking_id": "RS-8854642",
      "duty_id": "D-514642",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "E. Maes",
      "station": "HKG",
      "property_id": "P-121",
      "hotel": "Hong Kong SkyCity Marriott",
      "check_in": "2026-08-13",
      "check_out": "2026-08-16",
      "nights": 3,
      "booking_amount": 890.13,
      "card_auth": 915.13,
      "card_settled": 1021.38,
      "folio_amount": 1021.38,
      "variance": 131.25,
      "variance_pct": 14.75,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-15",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854611",
      "period": "2026-08",
      "booking_id": "RS-8854611",
      "duty_id": "D-514611",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "O. Wouters",
      "station": "DXB",
      "property_id": "P-122",
      "hotel": "Millennium Airport Hotel Dubai",
      "check_in": "2026-08-25",
      "check_out": "2026-08-26",
      "nights": 1,
      "booking_amount": 288.95,
      "card_auth": 157.95,
      "card_settled": 157.95,
      "folio_amount": 288.95,
      "variance": 131,
      "variance_pct": 45.34,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-09T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-25",
      "age_days": 7,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854739",
      "period": "2026-08",
      "booking_id": "RS-8854739",
      "duty_id": "D-514739",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "O. Lefevre",
      "station": "LYS",
      "property_id": "P-130",
      "hotel": "Comfort Hotel Lyon",
      "check_in": "2026-08-03",
      "check_out": "2026-08-04",
      "nights": 1,
      "booking_amount": 275,
      "card_auth": 148.29,
      "card_settled": 148.29,
      "folio_amount": 275,
      "variance": 126.71,
      "variance_pct": 46.08,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "legitimate",
      "opened_at": "2026-08-04T02:10:00Z",
      "resolved_at": "2026-08-07T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-03",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852884",
      "period": "2026-08",
      "booking_id": "RS-8852884",
      "duty_id": "D-512884",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "E. Doyle",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-18",
      "check_out": "2026-08-19",
      "nights": 1,
      "booking_amount": 273.83,
      "card_auth": 171.54,
      "card_settled": 171.54,
      "folio_amount": 297.58,
      "variance": 126.04,
      "variance_pct": 46.03,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-21T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-18",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854018",
      "period": "2026-08",
      "booking_id": "RS-8854018",
      "duty_id": "D-514018",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "J. De Smet",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-05",
      "check_out": "2026-08-08",
      "nights": 3,
      "booking_amount": 790.02,
      "card_auth": 815.02,
      "card_settled": 936.67,
      "folio_amount": 936.67,
      "variance": 124.98,
      "variance_pct": 15.82,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-07",
      "age_days": 38,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854274",
      "period": "2026-08",
      "booking_id": "RS-8854274",
      "duty_id": "D-514274",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. Dubois",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-06",
      "check_out": "2026-08-08",
      "nights": 2,
      "booking_amount": 547.18,
      "card_auth": 434.41,
      "card_settled": 434.41,
      "folio_amount": 555.24,
      "variance": 120.83,
      "variance_pct": 22.08,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": "2026-09-07T00:01:00Z",
      "final_due_at": "2026-09-07",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853466",
      "period": "2026-08",
      "booking_id": "RS-8853466",
      "duty_id": "D-513466",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Byrne",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-28",
      "check_out": "2026-08-30",
      "nights": 2,
      "booking_amount": 522.74,
      "card_auth": 547.74,
      "card_settled": 669.6,
      "folio_amount": 669.6,
      "variance": 120.42,
      "variance_pct": 23.04,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 28,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853372",
      "period": "2026-08",
      "booking_id": "RS-8853372",
      "duty_id": "D-513372",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "M. Devlin",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-05",
      "check_out": "2026-08-08",
      "nights": 3,
      "booking_amount": 765.36,
      "card_auth": 790.36,
      "card_settled": 775.85,
      "folio_amount": 895.1,
      "variance": 119.25,
      "variance_pct": 15.58,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-07",
      "age_days": 7,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853829",
      "period": "2026-08",
      "booking_id": "RS-8853829",
      "duty_id": "D-513829",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Quinn",
      "station": "BHX",
      "property_id": "P-113",
      "hotel": "Novotel Birmingham Airport",
      "check_in": "2026-08-22",
      "check_out": "2026-08-23",
      "nights": 1,
      "booking_amount": 279.87,
      "card_auth": 304.87,
      "card_settled": 395.9,
      "folio_amount": 395.9,
      "variance": 116.03,
      "variance_pct": 41.46,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-23T02:10:00Z",
      "resolved_at": "2026-08-26T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-22",
      "age_days": 23,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853845",
      "period": "2026-08",
      "booking_id": "RS-8853845",
      "duty_id": "D-513845",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "A. Vermeulen",
      "station": "CDG",
      "property_id": "P-128",
      "hotel": "Ibis Paris CDG",
      "check_in": "2026-08-13",
      "check_out": "2026-08-15",
      "nights": 2,
      "booking_amount": 629.98,
      "card_auth": 654.98,
      "card_settled": 774.14,
      "folio_amount": 774.14,
      "variance": 113.25,
      "variance_pct": 17.98,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-15T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-14",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854660",
      "period": "2026-08",
      "booking_id": "RS-8854660",
      "duty_id": "D-514660",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "M. Delacroix",
      "station": "CDG",
      "property_id": "P-127",
      "hotel": "Pullman Paris CDG",
      "check_in": "2026-08-19",
      "check_out": "2026-08-21",
      "nights": 2,
      "booking_amount": 592.14,
      "card_auth": 617.14,
      "card_settled": 737.99,
      "folio_amount": 737.99,
      "variance": 110.74,
      "variance_pct": 18.7,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": "2026-08-23T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-20",
      "age_days": 38,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852964",
      "period": "2026-08",
      "booking_id": "RS-8852964",
      "duty_id": "D-512964",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Fitzgerald",
      "station": "STN",
      "property_id": "P-116",
      "hotel": "Hampton by Hilton Stansted",
      "check_in": "2026-08-19",
      "check_out": "2026-08-20",
      "nights": 1,
      "booking_amount": 355.87,
      "card_auth": 380.87,
      "card_settled": 355.87,
      "folio_amount": 463.91,
      "variance": 108.04,
      "variance_pct": 30.36,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "resolved",
      "resolution": "written_off",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-21T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-19",
      "age_days": 30,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853972",
      "period": "2026-08",
      "booking_id": "RS-8853972",
      "duty_id": "D-513972",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. Dubois",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-18",
      "check_out": "2026-08-19",
      "nights": 1,
      "booking_amount": 275.97,
      "card_auth": 300.97,
      "card_settled": 383.27,
      "folio_amount": 383.27,
      "variance": 107.3,
      "variance_pct": 38.88,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-18T00:01:00Z",
      "final_due_at": "2026-09-18",
      "age_days": 20,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854179",
      "period": "2026-08",
      "booking_id": "RS-8854179",
      "duty_id": "D-514179",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "B. De Smet",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-26",
      "check_out": "2026-08-28",
      "nights": 2,
      "booking_amount": 550.94,
      "card_auth": 575.94,
      "card_settled": 654.41,
      "folio_amount": 654.41,
      "variance": 103.47,
      "variance_pct": 18.78,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-28T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": "2026-09-27T00:01:00Z",
      "final_due_at": "2026-09-27",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853811",
      "period": "2026-08",
      "booking_id": "RS-8853811",
      "duty_id": "D-513811",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Byrne",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-05",
      "check_out": "2026-08-07",
      "nights": 2,
      "booking_amount": 569.11,
      "card_auth": 594.11,
      "card_settled": 690.5,
      "folio_amount": 690.5,
      "variance": 100.5,
      "variance_pct": 17.66,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-07T02:10:00Z",
      "resolved_at": "2026-08-21T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-06",
      "age_days": 13,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853500",
      "period": "2026-08",
      "booking_id": "RS-8853500",
      "duty_id": "D-513500",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Quinn",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-19",
      "check_out": "2026-08-20",
      "nights": 1,
      "booking_amount": 264.48,
      "card_auth": 289.48,
      "card_settled": 361.03,
      "folio_amount": 361.03,
      "variance": 96.55,
      "variance_pct": 36.51,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-19T00:01:00Z",
      "final_due_at": "2026-09-19",
      "age_days": 40,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853011",
      "period": "2026-08",
      "booking_id": "RS-8853011",
      "duty_id": "D-513011",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Kavanagh",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-20",
      "check_out": "2026-08-23",
      "nights": 3,
      "booking_amount": 848.76,
      "card_auth": 873.76,
      "card_settled": 976.26,
      "folio_amount": 976.26,
      "variance": 96.12,
      "variance_pct": 11.32,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-23T02:10:00Z",
      "resolved_at": "2026-08-28T11:00:00Z",
      "final_at": "2026-09-22T00:01:00Z",
      "final_due_at": "2026-09-22",
      "age_days": 31,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852866",
      "period": "2026-08",
      "booking_id": "RS-8852866",
      "duty_id": "D-512866",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "C. Kavanagh",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-30",
      "check_out": "2026-09-01",
      "nights": 2,
      "booking_amount": 591.18,
      "card_auth": 616.18,
      "card_settled": 591.18,
      "folio_amount": 682.16,
      "variance": 90.98,
      "variance_pct": 15.39,
      "variance_category": "extra_night",
      "match_state": "unmatched",
      "exception_type": "off_platform_modification",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-05T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-10-01",
      "age_days": 22,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854704",
      "period": "2026-08",
      "booking_id": "RS-8854704",
      "duty_id": "D-514704",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "B. Aubert",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-15",
      "check_out": "2026-08-16",
      "nights": 1,
      "booking_amount": 296.83,
      "card_auth": 207.74,
      "card_settled": 207.74,
      "folio_amount": 296.83,
      "variance": 89.09,
      "variance_pct": 30.01,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": "2026-09-15T00:01:00Z",
      "final_due_at": "2026-09-15",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853521",
      "period": "2026-08",
      "booking_id": "RS-8853521",
      "duty_id": "D-513521",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "S. Nolan",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-07",
      "check_out": "2026-08-09",
      "nights": 2,
      "booking_amount": 583.34,
      "card_auth": 608.34,
      "card_settled": 705.4,
      "folio_amount": 705.4,
      "variance": 85.14,
      "variance_pct": 14.6,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 4,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854442",
      "period": "2026-08",
      "booking_id": "RS-8854442",
      "duty_id": "D-514442",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "V. Maes",
      "station": "JNB",
      "property_id": "P-125",
      "hotel": "InterContinental OR Tambo",
      "check_in": "2026-08-20",
      "check_out": "2026-08-24",
      "nights": 4,
      "booking_amount": 958,
      "card_auth": 983,
      "card_settled": 1030.77,
      "folio_amount": 1030.77,
      "variance": 72.77,
      "variance_pct": 7.6,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-24T02:10:00Z",
      "resolved_at": "2026-09-07T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-23",
      "age_days": 15,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853749",
      "period": "2026-08",
      "booking_id": "RS-8853749",
      "duty_id": "D-513749",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "M. Fitzgerald",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-31",
      "check_out": "2026-09-01",
      "nights": 1,
      "booking_amount": 345.71,
      "card_auth": 370.71,
      "card_settled": 429.03,
      "folio_amount": 429.03,
      "variance": 70.63,
      "variance_pct": 20.43,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-06T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-10-01",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852970",
      "period": "2026-08",
      "booking_id": "RS-8852970",
      "duty_id": "D-512970",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "S. Fitzgerald",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-25",
      "check_out": "2026-08-26",
      "nights": 1,
      "booking_amount": 240.08,
      "card_auth": 170.16,
      "card_settled": 170.16,
      "folio_amount": 240.08,
      "variance": 69.92,
      "variance_pct": 29.12,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-25T00:01:00Z",
      "final_due_at": "2026-09-25",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854684",
      "period": "2026-08",
      "booking_id": "RS-8854684",
      "duty_id": "D-514684",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "R. Bernard",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-29",
      "check_out": "2026-09-01",
      "nights": 3,
      "booking_amount": 990.04,
      "card_auth": 1015.04,
      "card_settled": 1090.06,
      "folio_amount": 1090.06,
      "variance": 69.59,
      "variance_pct": 7.03,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-08T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 5,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854933",
      "period": "2026-08",
      "booking_id": "RS-8854933",
      "duty_id": "D-514933",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "A. Roussel",
      "station": "CDG",
      "property_id": "P-126",
      "hotel": "Novotel Paris CDG",
      "check_in": "2026-08-08",
      "check_out": "2026-08-10",
      "nights": 2,
      "booking_amount": 588.98,
      "card_auth": 613.98,
      "card_settled": 664.17,
      "folio_amount": 664.17,
      "variance": 67.1,
      "variance_pct": 11.39,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-10T02:10:00Z",
      "resolved_at": "2026-08-17T11:00:00Z",
      "final_at": "2026-09-09T00:01:00Z",
      "final_due_at": "2026-09-09",
      "age_days": 27,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855170",
      "period": "2026-08",
      "booking_id": "RS-8855170",
      "duty_id": "D-515170",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "G. Marchand",
      "station": "LYS",
      "property_id": "P-129",
      "hotel": "NH Lyon Airport",
      "check_in": "2026-08-02",
      "check_out": "2026-08-05",
      "nights": 3,
      "booking_amount": 973.07,
      "card_auth": 998.07,
      "card_settled": 1051.69,
      "folio_amount": 1051.69,
      "variance": 66.58,
      "variance_pct": 6.84,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-05T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-04",
      "age_days": 10,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854874",
      "period": "2026-08",
      "booking_id": "RS-8854874",
      "duty_id": "D-514874",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "E. Aubert",
      "station": "MAD",
      "property_id": "P-136",
      "hotel": "Novotel Madrid Barajas",
      "check_in": "2026-08-08",
      "check_out": "2026-08-10",
      "nights": 2,
      "booking_amount": 538.83,
      "card_auth": 563.83,
      "card_settled": 604.52,
      "folio_amount": 604.52,
      "variance": 65.69,
      "variance_pct": 12.19,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-10T02:10:00Z",
      "resolved_at": "2026-08-15T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-09",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8855175",
      "period": "2026-08",
      "booking_id": "RS-8855175",
      "duty_id": "D-515175",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "D. Aubert",
      "station": "MRS",
      "property_id": "P-132",
      "hotel": "Holiday Inn Marseille",
      "check_in": "2026-08-25",
      "check_out": "2026-08-29",
      "nights": 4,
      "booking_amount": 1060.84,
      "card_auth": 1085.84,
      "card_settled": 1125.29,
      "folio_amount": 1125.29,
      "variance": 64.45,
      "variance_pct": 6.08,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-29T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-28",
      "age_days": 17,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853713",
      "period": "2026-08",
      "booking_id": "RS-8853713",
      "duty_id": "D-513713",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Brennan",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-22",
      "check_out": "2026-08-26",
      "nights": 4,
      "booking_amount": 1171.36,
      "card_auth": 1196.36,
      "card_settled": 1234.99,
      "folio_amount": 1234.99,
      "variance": 63.63,
      "variance_pct": 5.43,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "written_off",
      "opened_at": "2026-08-26T02:10:00Z",
      "resolved_at": "2026-09-01T11:00:00Z",
      "final_at": "2026-09-25T00:01:00Z",
      "final_due_at": "2026-09-25",
      "age_days": 18,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853891",
      "period": "2026-08",
      "booking_id": "RS-8853891",
      "duty_id": "D-513891",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "M. Wouters",
      "station": "BRU",
      "property_id": "P-117",
      "hotel": "Thon Hotel EU",
      "check_in": "2026-08-18",
      "check_out": "2026-08-19",
      "nights": 1,
      "booking_amount": 399.46,
      "card_auth": 424.46,
      "card_settled": 462.87,
      "folio_amount": 462.87,
      "variance": 63.41,
      "variance_pct": 15.87,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-09-01T11:00:00Z",
      "final_at": "2026-09-18T00:01:00Z",
      "final_due_at": "2026-09-18",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853748",
      "period": "2026-08",
      "booking_id": "RS-8853748",
      "duty_id": "D-513748",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "K. Nolan",
      "station": "DUB",
      "property_id": "P-102",
      "hotel": "Maldron Hotel Dublin Airport",
      "check_in": "2026-08-29",
      "check_out": "2026-08-30",
      "nights": 1,
      "booking_amount": 241.47,
      "card_auth": 179.28,
      "card_settled": 179.28,
      "folio_amount": 241.47,
      "variance": 62.19,
      "variance_pct": 25.75,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "explained",
      "resolution": null,
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-29",
      "age_days": 7,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852843",
      "period": "2026-08",
      "booking_id": "RS-8852843",
      "duty_id": "D-512843",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "H. Kavanagh",
      "station": "DUB",
      "property_id": "P-101",
      "hotel": "Clayton Hotel Dublin Airport",
      "check_in": "2026-08-05",
      "check_out": "2026-08-08",
      "nights": 3,
      "booking_amount": 799.14,
      "card_auth": 824.14,
      "card_settled": 890.61,
      "folio_amount": 890.61,
      "variance": 60.82,
      "variance_pct": 7.61,
      "variance_category": "extra_night",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-08T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-07",
      "age_days": 33,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852910",
      "period": "2026-08",
      "booking_id": "RS-8852910",
      "duty_id": "D-512910",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "G. Doyle",
      "station": "BHX",
      "property_id": "P-114",
      "hotel": "Ibis Birmingham Airport",
      "check_in": "2026-08-11",
      "check_out": "2026-08-13",
      "nights": 2,
      "booking_amount": 560.88,
      "card_auth": 585.88,
      "card_settled": 621.53,
      "folio_amount": 621.53,
      "variance": 60.65,
      "variance_pct": 10.81,
      "variance_category": "incidentals",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-14T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 6,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853771",
      "period": "2026-08",
      "booking_id": "RS-8853771",
      "duty_id": "D-513771",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "N. O Conaill",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-29",
      "check_out": "2026-08-30",
      "nights": 1,
      "booking_amount": 256.22,
      "card_auth": 196.55,
      "card_settled": 196.55,
      "folio_amount": 256.22,
      "variance": 59.67,
      "variance_pct": 23.29,
      "variance_category": "unexplained",
      "match_state": "unmatched",
      "exception_type": "partial_authorization",
      "state": "final",
      "resolution": "charged_to_crew",
      "opened_at": "2026-08-30T02:10:00Z",
      "resolved_at": "2026-09-04T11:00:00Z",
      "final_at": "2026-09-29T00:01:00Z",
      "final_due_at": "2026-09-29",
      "age_days": 26,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854962",
      "period": "2026-08",
      "booking_id": "RS-8854962",
      "duty_id": "D-514962",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "J. Fontaine",
      "station": "MRS",
      "property_id": "P-131",
      "hotel": "Best Western Marseille Airport",
      "check_in": "2026-08-08",
      "check_out": "2026-08-09",
      "nights": 1,
      "booking_amount": 270.69,
      "card_auth": 295.69,
      "card_settled": 327.97,
      "folio_amount": 327.97,
      "variance": 57.28,
      "variance_pct": 21.16,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "absorbed",
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": "2026-08-13T11:00:00Z",
      "final_at": "2026-09-08T00:01:00Z",
      "final_due_at": "2026-09-08",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853450",
      "period": "2026-08",
      "booking_id": "RS-8853450",
      "duty_id": "D-513450",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "O. Healy",
      "station": "CGN",
      "property_id": "P-108",
      "hotel": "Leonardo Hotel Koln",
      "check_in": "2026-08-16",
      "check_out": "2026-08-19",
      "nights": 3,
      "booking_amount": 867.81,
      "card_auth": 892.81,
      "card_settled": 944.3,
      "folio_amount": 944.3,
      "variance": 54.32,
      "variance_pct": 6.26,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "disputed_recovered",
      "opened_at": "2026-08-19T02:10:00Z",
      "resolved_at": "2026-08-20T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-18",
      "age_days": 29,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853652",
      "period": "2026-08",
      "booking_id": "RS-8853652",
      "duty_id": "D-513652",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "M. Fitzgerald",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-29",
      "check_out": "2026-09-01",
      "nights": 3,
      "booking_amount": 830.64,
      "card_auth": 855.64,
      "card_settled": 916.44,
      "folio_amount": 916.44,
      "variance": 53.45,
      "variance_pct": 6.43,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-09-01T02:10:00Z",
      "resolved_at": "2026-09-09T11:00:00Z",
      "final_at": "2026-10-01T00:01:00Z",
      "final_due_at": "2026-10-01",
      "age_days": 21,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853507",
      "period": "2026-08",
      "booking_id": "RS-8853507",
      "duty_id": "D-513507",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "V. Doyle",
      "station": "LGG",
      "property_id": "P-111",
      "hotel": "Ibis Liege Centre",
      "check_in": "2026-08-23",
      "check_out": "2026-08-24",
      "nights": 1,
      "booking_amount": 278.32,
      "card_auth": 303.32,
      "card_settled": 328.93,
      "folio_amount": 328.93,
      "variance": 50.61,
      "variance_pct": 18.18,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "open",
      "resolution": null,
      "opened_at": "2026-08-24T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-23",
      "age_days": 36,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852926",
      "period": "2026-08",
      "booking_id": "RS-8852926",
      "duty_id": "D-512926",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "R. Cassidy",
      "station": "EMA",
      "property_id": "P-105",
      "hotel": "Holiday Inn Castle Donington",
      "check_in": "2026-08-19",
      "check_out": "2026-08-21",
      "nights": 2,
      "booking_amount": 659.12,
      "card_auth": 684.12,
      "card_settled": 703.12,
      "folio_amount": 703.12,
      "variance": 44,
      "variance_pct": 6.68,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-08-21T02:10:00Z",
      "resolved_at": "2026-08-29T11:00:00Z",
      "final_at": "2026-09-20T00:01:00Z",
      "final_due_at": "2026-09-20",
      "age_days": 38,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8852927",
      "period": "2026-08",
      "booking_id": "RS-8852927",
      "duty_id": "D-512927",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "C. Kavanagh",
      "station": "EMA",
      "property_id": "P-104",
      "hotel": "Hilton East Midlands",
      "check_in": "2026-08-15",
      "check_out": "2026-08-16",
      "nights": 1,
      "booking_amount": 298.37,
      "card_auth": 323.37,
      "card_settled": 342.01,
      "folio_amount": 342.01,
      "variance": 43.64,
      "variance_pct": 14.63,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-16T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-15",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854940",
      "period": "2026-08",
      "booking_id": "RS-8854940",
      "duty_id": "D-514940",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "E. Berger",
      "station": "BRU",
      "property_id": "P-118",
      "hotel": "NH Brussels Airport",
      "check_in": "2026-08-12",
      "check_out": "2026-08-13",
      "nights": 1,
      "booking_amount": 366.12,
      "card_auth": 391.12,
      "card_settled": 428.56,
      "folio_amount": 428.56,
      "variance": 40.41,
      "variance_pct": 11.04,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "final",
      "resolution": "legitimate",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-25T11:00:00Z",
      "final_at": "2026-09-12T00:01:00Z",
      "final_due_at": "2026-09-12",
      "age_days": 37,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853287",
      "period": "2026-08",
      "booking_id": "RS-8853287",
      "duty_id": "D-513287",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "B. Brennan",
      "station": "CGN",
      "property_id": "P-107",
      "hotel": "Ibis Koln Messe",
      "check_in": "2026-08-16",
      "check_out": "2026-08-20",
      "nights": 4,
      "booking_amount": 1012.68,
      "card_auth": 1037.68,
      "card_settled": 1063.8,
      "folio_amount": 1063.8,
      "variance": 39.84,
      "variance_pct": 3.93,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-20T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-19",
      "age_days": 14,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8853478",
      "period": "2026-08",
      "booking_id": "RS-8853478",
      "duty_id": "D-513478",
      "entity": "ASL Airlines Ireland",
      "legal_entity": "ASL Airlines (Ireland) Ltd",
      "crew_name": "D. Nolan",
      "station": "LGG",
      "property_id": "P-110",
      "hotel": "Van der Valk Liege",
      "check_in": "2026-08-08",
      "check_out": "2026-08-09",
      "nights": 1,
      "booking_amount": 262.54,
      "card_auth": 287.54,
      "card_settled": 320.4,
      "folio_amount": 320.4,
      "variance": 38.1,
      "variance_pct": 14.51,
      "variance_category": "rate_change",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-09T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-08",
      "age_days": 11,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854717",
      "period": "2026-08",
      "booking_id": "RS-8854717",
      "duty_id": "D-514717",
      "entity": "ASL Airlines France",
      "legal_entity": "ASL Airlines France SA",
      "crew_name": "H. Delacroix",
      "station": "MAD",
      "property_id": "P-135",
      "hotel": "Melia Barajas",
      "check_in": "2026-08-10",
      "check_out": "2026-08-13",
      "nights": 3,
      "booking_amount": 881.28,
      "card_auth": 906.28,
      "card_settled": 915.29,
      "folio_amount": 915.29,
      "variance": 34.01,
      "variance_pct": 3.86,
      "variance_category": "tax_fees",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "resolved",
      "resolution": "absorbed",
      "opened_at": "2026-08-13T02:10:00Z",
      "resolved_at": "2026-08-19T11:00:00Z",
      "final_at": null,
      "final_due_at": "2026-09-12",
      "age_days": 8,
      "auto_resolved": 0
    },
    {
      "item_id": "RI-8854441",
      "period": "2026-08",
      "booking_id": "RS-8854441",
      "duty_id": "D-514441",
      "entity": "ASL Airlines Belgium",
      "legal_entity": "ASL Airlines Belgium NV",
      "crew_name": "T. Maes",
      "station": "BRU",
      "property_id": "P-118",
      "hotel": "NH Brussels Airport",
      "check_in": "2026-08-17",
      "check_out": "2026-08-18",
      "nights": 1,
      "booking_amount": 326.9,
      "card_auth": 351.9,
      "card_settled": 357.27,
      "folio_amount": 357.27,
      "variance": 30.37,
      "variance_pct": 9.29,
      "variance_category": "early_departure",
      "match_state": "variance",
      "exception_type": "amount_variance",
      "state": "investigating",
      "resolution": null,
      "opened_at": "2026-08-18T02:10:00Z",
      "resolved_at": null,
      "final_at": null,
      "final_due_at": "2026-09-17",
      "age_days": 28,
      "auto_resolved": 0
    }
  ]
}