Trams Back Office (TBO) Weekly Checklist (ARC/BSP Sales Report/Reconciliation)

Weekly Checklist

ARC/BSP Sales Report/Reconciliation

1. Run a list of all invoices captured in Trams Back Office by going into Reports|Invoice|Analysis and
   verifying that all invoices for the week are accounted for in TBO.
2. Run a list of all tickets captured in Trams Back Office by going into Reports|Invoice|ARC/BSP.
3. Reconciliation and verifying that all tickets issued for the week are accounted for in TBO. Be sure to
   set ticket status to “ALL.”
4. Enter any missing Refunds, Debit Memos, Voids, etc.
5. Once completed, submit the ARC/BSP report.
6. Enter and balance the ARC/BSP Settlement for the week under Payments|ARC Settlement. Do this by comparing the amount withdrawn to the amount Trams Back Office calculated as the Net Remittance amount for that ARC/BSP week. If the two numbers do not balance exactly, review the ARC/BSP Settlement section of the manual.

IAR Sales Report/Reconciliation

1. Check that the data in the IAR Sales Report matches the data in Trams Back Office by one of three methods:
   a) Method One: Run a list of all invoices captured in Trams Back Office by going into
   Reports|Invoice|Analysis and verifying that all invoices for the week are accounted for in TBO.. Then, run
   a list of all tickets captured in Trams Back Office by going into Reports|Invoice|ARC/BSP Reconciliation and
   verifying that all tickets issued for the week are accounted for in TBO. Be sure to set ticket status to “ALL.”
   b) Method Two: Download the IAR file from the IAR website. Go to Reports|Invoice|IAR Reconciliation
   and click on the IAR File button to point to the path of the downloaded .txt file obtained from the IAR
   website.
   Print out an Exception Report which points out differences between what is in IAR and Trams Back Office.
   Fix the discrepancies, either in IAR or TBO.
   c) Method Three: Download the IAR file from the IAR website. Go to Payments|ARC Settlement. Query
   for the week’s ARC tickets. Click on IAR Reconciliation to find the downloaded IAR file. (More details can
   be found in Help files.)

2. Enter any missing Refunds, Debit Memos, Voids, etc. so Trams Back Office agrees with IAR Sales Report.

3. Submit the IAR Sales Report.

4. Enter and balance the ARC/BSP Settlement for the week under Payments|ARC Settlement. Do this by
   comparing the amount withdrawn to the amount Trams Back Office calculated as the Net Remittance amount
   for that ARC/BSP week. If the two numbers do not balance exactly, review the ARC/BSP Settlement section
   of this manual.

Related Articles:

Trams Back Office (TBO) Daily Check List

Trams Back Office (TBO) Monthly Check List