Weekly Checklist
ARC/BSP Sales Report/Reconciliation
- 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. - 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.” - Enter any missing Refunds, Debit Memos, Voids, etc.
- Once completed, submit the ARC/BSP report.
- 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
-
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.) -
Enter any missing Refunds, Debit Memos, Voids, etc. so Trams Back Office agrees with IAR Sales Report.
-
Submit the IAR Sales Report.
-
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: