File-based delivery for Billing Package
Billing Package is a report specifically designed to ensure alignment between loyalty points redeemed by travelers and the corresponding booking details. The report includes five tabs. It is generated every Monday but will be sent to you weekly, biweekly or monthly, depending on your billing cycle.
Billing detail recon file tab
The billing detail recon file tab includes all transactions, regardless of the settlement line of business. It provides field-level details that support reconciliation and invoicing activities.
| Field | Definition | Example |
|---|---|---|
| Partner Name | White label travel platform individual partner name for the transaction. | Partner name |
| Flag | Reconciliation flag: • Y indicates successful reconciliation for all points and split-pay transactions. • Blank indicates a full cash transaction with no reconciliation flag. | Y |
| Transaction Date | Booking creation date. | 2025-06-13 |
| Recon Date | Reconciliation processed date. | 2025-07-14 |
| Potential Invoice Date | When a transaction is reconciled, a potential invoice date is assigned, indicating when it will be invoiced. | 2025-07-16 |
| Order ID | This is the same as the booking reference. | -9999999999999999999 |
| POS Order Reference Number | Identifier for a booking. This number is the same as the itinerary number. | 77777777777777 |
| Partner Point Transaction ID | May be the same as the Order ID. Populated for all points and split-pay transactions. Can be customized on request. | -9999999999999999999 |
| Consumer Payment Method | Indicates how the transaction is paid. Values: All Points, Split-Pay, Cash. | All Points |
| Settlement Line of Business (LOB) | Indicates specific travel product. Values: Air, Lodging (hotel), Car, Destination Service (cruise, activities, transportation, etc.), Package, Insurance (car only, paid with cash). | Air |
| Transaction Type Event | Type of transaction event. Values: Purchase, Cancel, Change (booking modification). | Cancel |
| Partner Confirmation ID | Identifying number for any transaction involving points. Sourced from SVG (settlement file). | 1x1xx1x-1x1x-11xx-x1x1-x111xxxx11xx |
| Original Partner Confirmation ID | Custom field used by some partners for reconciliation purposes. | xxxx |
| Settlement Business Model Name | Defines business model. Values: Agency = Air, Merchant = Lodging, Car, Destination Services, Insurance (Air can be Merchant depending on contract). | Agency |
| TPID Currency Code | Contractual currency. Varies by partner. | USD |
| Gross Booking Amount TPID | Also known as GBV. • All Points = GBV • Split-Pay = Points + Cash = GBV • Cash = GBV. | -128.49 |
| Points Amount TPID - Allocated | Points redeemed/refunded in cash value. | -128.49 |
| Cash Amount TPID - Allocated | Cash value allocated. | 0 |
| Point Count TPID - Allocated | Count of points redeemed/refunded. | -10279 |
| Package Agency Booking TPID | Used when Settlement LOB = Package. Invoice amount is calculated using this column. | -128.49 |
Finance regular billing file tab
The finance regular billing file tab is a detailed transaction report used for the AR invoice. It provides full booking-level information required for reconciliation and invoicing.
| Field | Definition | Example |
|---|---|---|
| Partner Name | White label travel platform individual partner name for the transaction. | Partner name |
| Flag | Reconciliation flag: • Y indicates successful reconciliation for all points and split-pay transactions. • Blank indicates a full cash transaction with no reconciliation flag. | Y |
| Transaction Date | Booking creation date. | 2025-06-13 |
| Reconciliation Date | Reconciliation processed date. | 2025-07-14 |
| Potential Invoice Date | When a transaction is reconciled, a potential invoice date is assigned, indicating when it will be invoiced. | 2025-07-16 |
| Order ID | This is the same as the booking reference. | -9999999999999999999 |
| POS Order Reference Number | Identifier for a booking. This number is the same as the itinerary number. | 77777777777777 |
| Partner Point Transaction ID | May be the same as the Order ID. Populated for all points and split-pay transactions. Can be customized on request. | -9999999999999999999 |
| Consumer Payment Method | Indicates how the transaction is paid. Values: All Points, Split-Pay, Cash. | Cash |
| Settlement Line of Business (LOB) | Indicates specific travel product. Values: Air, Lodging (hotel), Car, Destination Service (cruise, activities, transportation, etc.), Package, Insurance (car only, paid with cash). | Air |
| Transaction Type Event | Type of transaction event. Values: Purchase, Cancel, Change (booking modification). | Cancel |
| Partner Confirmation ID | Identifying number for any transaction involving points; sourced from SVG (settlement file). | 1x1xx1x-1x1x-11xx-x1x1-x111xxxx11xx |
| Original Partner Confirmation ID | Custom field used by some partners for reconciliation purposes. | xxxx |
| Business Model Name | Defines business model. Values: Agency = Air; Merchant = Lodging, Car, Destination Services, Insurance (Air can be Merchant depending on contract). | Merchant |
| TPID Currency Code | Contractual currency. Varies by partner. | USD |
| Gross Booking Amount TPID | Also known as GBV. • All Points = GBV • Split-Pay = Points + Cash = GBV • Cash = GBV. | -362.43 |
| Points Amount TPID - Allocated | Points redeemed/refunded in cash value. | 0.00 |
| Cash Amount TPID - Allocated | Cash value allocated. | -362.43 |
| Point Count TPID - Allocated | Count of points redeemed/refunded. | 0 |
| Package Agency Booking TPID | Used when Settlement LOB = Package. Invoice amount is calculated using this column. | 0.00 |
| Pivot | Excel formula to differentiate between redeemed and refunded amounts, and calculate the corresponding value in the Summary tab. | Amount Refunded |
Finance off-cycle billing file tab
The finance off-cycle billing file tab is a detailed transaction report used for the AR invoice. It captures transactions that could not be reconciled in the regular billing cycle and ensures they are included in subsequent invoicing.
Purpose
Any transaction that is not reconciled within 30 days is included in this report. When a transaction is created but, due to discrepancies between SVG (settlement data) and your daily recon file, the reconciliation flag remains N for 30 days the transaction is added to off-cycle billing.
| Field | Definition | Example |
|---|---|---|
| Partner Name | White label travel platform individual partner name for the transaction. | Partner Name |
| Flag | Reconciliation flag: Y indicates successful reconciliation for all points and split-pay transactions. Blank indicates a full cash transaction with no reconciliation flag. | Y |
| Transaction Date | Booking creation date. | 2025-06-13 |
| Reconciliation Date | Reconciliation processed date. | 2025-07-14 |
| Potential Invoice Date | When a transaction is reconciled, a potential invoice date is assigned, indicating when it will be invoiced. | 2025-07-16 |
| Order ID | This is the same as the booking reference. | -9999999999999999999 |
| POS Order Reference Number | Identifier for a booking. This is the same as itinerary number. | 77777777777777 |
| Partner Point Transaction ID | May be the same as Order ID. Populated for all points and split-pay transactions. Can be customized on request. | -9999999999999999999 |
| Consumer Payment Method | Indicates how the transaction is paid. Values: All Points, Split-Pay, Cash. | Cash |
| Settlement Line of Business (LOB) | Indicates specific travel product. Values: Air, Lodging (hotel), Car, Destination Service (cruise, activities, transportation, etc.), Package, Insurance (car only, paid with cash). | Air |
| Transaction Type Event | Type of transaction event. Values: Purchase, Cancel, Change (booking modification). | Cancel |
| Partner Confirmation ID | Identifying number for any transaction involving points. This is sourced from SVG (settlement file). | 1x1xx1x-1x1x-11xx-x1x1-x111xxxx11xx |
| Original Partner Confirmation ID | Custom field used by some partners for reconciliation purposes. | xxxx |
| Settlement Business Model Name | Defines business model. Values: Agency = Air; Merchant = Lodging, Car, Destination Services, Insurance (Air can be Merchant depending on contract). | Merchant |
| TPID Currency Code | Contractual currency. Varies by partner. | USD |
| Gross Booking Amount TPID | Also known as GBV. • All Points = GBV • Split-Pay = Points + Cash = GBV • Cash = GBV. | -362.43 |
| Points Amount TPID - Allocated | Points redeemed/refunded in cash value. | 0.00 |
| Cash Amount TPID - Allocated | Cash value allocated. | -362.43 |
| Point Count TPID - Allocated | Count of points redeemed/refunded. | 0 |
| Package Agency Booking TPID | Used when Settlement LOB = Package. Invoice amount is calculated using this column. | 0.00 |
| Pivot | Excel formula to differentiate between redeemed and refunded amounts, and calculate the corresponding value in the Summary tab. | Amount Refunded |
Reg exception file tab
The reg exception file tab provides detailed transaction-level data highlighting exceptions identified during the regular reconciliation process. It captures transactions where mismatches or missing data prevented successful reconciliation within the current billing cycle.
This file specifically includes transactions where discrepancies exist between SVG settlement data and BDE data. For example, when a corresponding transaction appears in the SVG settlement file but is missing from, or mismatched in, the BDE dataset.
The report supports controllership and finance teams in identifying, analyzing, and resolving these exceptions before final billing, ensuring data accuracy and completeness across the reconciliation process.
| Field | Definition | Example |
|---|---|---|
| Payment Instrument Sub Method | White label travel platform individual partner name for the transaction. | Partner name |
| Recon Flag | Indicates whether the transaction was successfully reconciled. • Y = Reconciled • N = Not Reconciled. | Y |
| Transaction Date | Booking creation date. | 2025-06-13 |
| Recon Date | Reconciliation processed date. | 2025-07-14 |
| Potential Invoice Date | When a transaction is reconciled, a potential invoice date is assigned, indicating when it will be invoiced. | 2025-07-16 |
| Order ID | This is the same as the booking reference. | -9999999999999999999 |
| POS Order Reference Number | Identifier for a booking. This is the same as the itinerary number. | 77777777777777 |
| Provider Ref ID | Identifier provided by the external partner or supplier for reference. If no specific instruction is given, the default value will be the same as the Order ID. | ABC123456 |
| Payment Instrument Method | Indicates how the transaction is paid. Values: All Points, Split-Pay, Cash. | Cash |
| Product SKU | Indicates specific travel product. Values: Air, Lodging (hotel), Car, Destination Service (cruise, activities, transportation, etc.), Package, Insurance (car only, paid with cash). | Air |
| Oper Type | Type of transaction event. Values: Purchase, Cancel, Change (booking modification). | Purchase |
| Partner Confirmation ID | Identifying number for any transaction involving points. Sourced from SVG (settlement file). | 1x1xx1x-1x1x-11xx-x1x1-x111xxxx11xx |
| Original Partner Confirmation ID | Custom field used by some partners for reconciliation purposes. | xxxx |
| Settlement Business Model Name | Defines business model. Values: Agency = Air; Merchant = Lodging, Car, Destination Services, Insurance (Air can be Merchant depending on contract). | Merchant |
| Order Currency Code | Contractual currency. Varies by partner. | USD |
| Exception Type | Static value = Regular Exception. | Regular Exception |
| Points Value TPID | Points redeemed/refunded in cash value. | 0.00 |
| Customer Cash Amount | Cash value allocated. | -362.43 |
| Points Paid | Count of points redeemed/refunded. | 0 |
| Package Agency Booking TPID | Used when Settlement LOB = Package. Invoice amount is calculated using this column. | 0.00 |
| Pivot | Excel formula to differentiate between redeemed and refunded amounts, and calculate the corresponding value in the Summary tab. | Amount Refunded |
Off-cycle exception file tab
The off-cycle exception file tab provides detailed transaction-level data highlighting exceptions identified during the off-cycle reconciliation process. It captures transactions that were not successfully reconciled within the standard 30-day window and therefore are included in off-cycle billing.
This file specifically includes transactions where discrepancies exist between your settlement data and our internal transaction data.
The report helps controllership and finance teams identify, analyze, and resolve these exceptions to ensure billing accuracy and data completeness throughout the reconciliation process.
| Field | Definition | Example |
|---|---|---|
| Payment Instrument Sub Method | White label travel platform individual partner name for the transaction. | Partner name |
| Recon Flag | Indicates whether the transaction was successfully reconciled. • Y = Reconciled • N = Not Reconciled. | N |
| Transaction Date | Booking creation date. | 2025-06-13 |
| Recon Date | Reconciliation processed date. | 2025-07-14 |
| Potential Invoice Date | When a transaction is reconciled, a potential invoice date is assigned, indicating when it will be invoiced. | 2025-07-16 |
| Order ID | This is the same as the booking reference. | -9999999999999999999 |
| POS Order Reference Number | Identifier for a booking. This is the same as the itinerary number. | 77777777777777 |
| Provider Ref ID | Identifier provided by the external partner or supplier for reference. If no specific instruction is given, the default value will be the same as the Order ID. | ABC123456 |
| Payment Instrument Method | Indicates how the transaction is paid. Values: All Points, Split-Pay, Cash. | Cash |
| Product SKU | Indicates specific travel product. Values: Air, Lodging (hotel), Car, Destination Service (cruise, activities, transportation, etc.), Package, Insurance (car only, paid with cash). | Air |
| Oper Type | Type of transaction event. Values: Purchase, Cancel, Change (booking modification). | Purchase |
| Partner Confirmation ID | Identifying number for any transaction involving points. Sourced from SVG (settlement file). | 1x1xx1x-1x1x-11xx-x1x1-x111xxxx11xx |
| Original Partner Confirmation ID | Custom field used by some partners for reconciliation purposes. | xxxx |
| Settlement Business Model Name | Defines business model. Values: Agency = Air; Merchant = Lodging, Car, Destination Services, Insurance (Air can be Merchant depending on contract). | Merchant |
| Order Currency Code | Contractual currency. Varies by partner. | USD |
| Exception Type | Static value = Regular Exception. | Regular Exception |
| Points Value TPID | Points redeemed/refunded in cash value. | 0.00 |
| Customer Cash Amount | Cash value allocated. | -362.43 |
| Points Paid | Count of points redeemed/refunded. | 0 |
| Package Agency Booking TPID | Used when Settlement LOB = Package. Invoice amount is calculated using this column. | 0.00 |
| Pivot | Excel formula to differentiate between redeemed and refunded amounts, and calculate the corresponding value in the Summary tab. | Amount Refunded |