IAR Reconciliation Report in Tres

The IAR Reconciliation Report allows users to run a comparison of ARC tickets to ARC's IAR Ticket list in Tres. A list of exceptions will be displayed that need to be addressed.

Step 1. Download the Back Office Sales (BOS) File from ARC.  Click here for directions.

Step 2. Run the IAR Reconciliation Report.

• Navigate to Reconciliations > IAR Reconciliation Report
  • Click on the IAR File filter and choose the file you wish to upload from your computer. Add additional filter data as needed, and click Search.

• Choose the correct ARC Number (if you have more than 1 ARC number to process).
• Set the date range or week you are reconciling.
• Upload/select the IAR file you downloaded.
• Click Search.
• The system will generate a report of exceptions (tickets in mismatch between Tres and IAR). If the report is blank, it means there are no exceptions. 
  • A report of exceptions will generate. Clicking on the ticket number hyperlink will open the reservation in a new tab if it has been entered into Tres.
  • Email, export to pdf, or print a physical copy of the report by clicking the appropriate buttons. 

Step 3. Review the Exceptions

• The table below shows common exception types and their meanings:

Message	Meaning
Missing Tres Ticket	The Sales Summary reported a ticket entered in IAR and not entered in Tres. The Ticket is Voided in IAR, but is not recorded in Tres.
Missing IAR Ticket	Duplicate Ticket in Tres There is more than one Tres reservation using the same ticket number. How to resolve: Search Tres for the ticket number. If multiple reservations exist for the same ticket, cancel or delete the duplicate reservation. (Optional) Enable Prevent Duplicate Ticket Number in Agency Settings to prevent duplicate tickets from interfacing in the future. ARC Number Applied to a Non‑ARC Ticket The Tres booking includes the agency’s ARC number even though the ticket was not issued through ARC. How to resolve: Remove the ARC number from the Tres reservation.
Net remits do not match	Scenario 1: Tres Ticket: $0.00, IAR Ticket: $xxxx.xx This usually indicates one of the following: The commission amount in Tres is incorrect, or A client credit card payment was applied to a cash ticket, causing a mismatch. How to resolve: Verify that the commission amount in Tres is correct. Review payments and void the incorrect client credit card payment in Tres. Scenario 2: Tres Ticket: $xxxx.xx, IAR Ticket: $0.00 This usually indicates one of the following: The commission amount in Tres is incorrect, or A client payment has not been applied to the booking. How to resolve: Verify that the commission amount in Tres is correct. Confirm that a client is associated with the trip. Add the appropriate payment: Paid by Client to Supplier by Credit Card
Ticket is Voided in Tres, but not in IAR	Single Tres Ticket is voided in Tres, but not in IAR.
Ticket is Voided in IAR but not in Tres	Single Tres Ticket is voided in IAR, but not in Tres.
Total Fares Do Not Match	The total fare in Tres is not the same as the total in IAR. Update the reservation to reflect the correct total fare.

• For each exception: identify ticket number, compare the status and amounts, determine discrepancy.

ARC is always the final source of truth since ticket data flows directly from the GDS to ARC. Tres does not affect the ARC report itself; it simply needs to match ARC for accurate internal reporting and record keeping.

Step 4: Fix the Differences

Here’s how to handle each typical exception:

1. Missing Tres Ticket
   • Investigate: Why wasn’t the ticket in Tres?
     • Check your Import Trips list for an error.
     • If it should have been imported, create the Trip, Reservation and Payment /Invoice with proper ticket details.

• Reference Articles:
  • Add a New Trip in Tres
  • Add a Reservation in Tres

2. Ticket Voided in IAR but not in Tres

• Find the ticket in Tres.
• Follow the directions on how to Void an ARC Ticket in Tres below.
• Reference Article:
  • Voiding an ARC Ticket in Tres

3. Ticket Voided in Tres but not in IAR

• Review: If Tres shows void but IAR doesn’t, determine which is correct.
• If IAR is wrong, correct via the ARC/IAR site. If Tres is wrong, fix in Tres.

4. Net Remits Do Not Match

• Compare fare, tax, commission, net remit between Tres and IAR.
• Adjust the invoice in Tres so the net remit equals the Sales Summary amount (per your agency policy).
• Check to ensure there is a Client Payment on the Reservation.
•  Reference Article:
  • Client Payments in Tres

After each correction, you can re-run the IAR Reconciliation report to confirm that those exceptions are resolved.

---

Reference Resources:

Knowledge Base Articles:

• Client Payments in Tres
• Void a Payment in Tres
• Voiding an ARC Ticket in Tres
• Residual Value MCO in Tres
• Add a New Trip in Tres
• Add a Reservation in Tres
• IAR Reconciliation Report in Tres
• Adding an ARC Settlement Payment in Tres

Recorded Trainings:

• Back Office: Import Trips - Interface Warnings and Errors
• Back Office: IAR Reconciliation

Download the Back Office Sales (BOS) file from ARC.

If you are not familiar with downloading the IAR report from ARC, log into your ARC account.  

• Click on 'Create a BOS File'.
• Select 'Create a Summary File (IL)'.
• Select 'PED' and enter the appropriate date range.
• Select 'Create'.

• Select 'Download BOS File'.
• Select the File to download.