Reconciliation Tips
The following pages show an example of a check for reimbursement of Exchange Credit program charges to a concessionaire. They provide an explanation of the information printed on the check remittance advice. The credit card system we use is the “VISION” system. All our customer charges are processed through the “Vision” system.
On page 3 a sample check for $1,017.03. On the remittance portion of the check, you can see the invoice numbers. The invoice number is constructed from the facility number, the year and the date MMDD then a suffix number. For this example, the first item on the remittance is:
Facility #. Year Date (MMDD) Facility no./name Gross Invoice Amount Discount Net Invoice Amount
Suffix #
12341501 19991031-001 1234150100/Buy On Line 68.21 0.00 68.21 TC150 0001
TC 150 = CHARGE TC
400 = RETURN TRANSACTION
The suffix is used to generate multiple invoices for the same facility for those facilities that have more than one VISION transaction type (code) posted during the reimbursement period.
EXPLANATION
OF THE REMITTANCE INFORMATION ON THE SAMPLE CHECK BELOW:
In the above remittance line example
(the first item on the sample check), the facility is Buy On Line
, 12341501. The date is 19991031, the 31st day of October). That is the last day of the weekly period for
this reimbursement. It indicates this check is for sales from the period
Monday, 25 October through
The next two invoices on the remittance are:
12345570
19991031-001 1234557000/ Buy On Line 364.29 0.00 364.29
TC150-0011
12345570
19991031-002 1234557000/ Buy On Line 27.44- 0.00 27.44-
TC400-0001
Buy On Line , facility 1234 5570 00 had 11 VISION charge transactions (TC150-0011) for which the reimbursed amount (transaction value less our merchant fee) is $ 364.29.
This facility also had 1 VISION Return transaction processed (TC400). This reduces the reimbursement by $27.44. The transaction value was $28.00 less our merchant fee equals a credit amount of $27.44.
The next two invoices are:
12341502
19991031-001 1234150200/ Buy On Line 352.97 0.00 352.97
TC150-0008
Buy On Line , facility 1234 1502 00, had 8 VISION charges (TC150’s) for which the reimbursed amount is $ 352.97.
12341501
19991031-001 1234150100/ Buy On Line 86.69 0.00 86.69
TC150-0001
Buy On Line , facility 1234 1501 00 shows 1 on line VISION charge for which the reimbursed amount is $ 86.69
The last invoice is:
12341509
19991031-001 1234150900/ Buy On Line 172.31 0.00 172.31
TC150-0005
The last entry on this check is for Buy On Line, facility 1234 1509 00. The facility had 5 on line VISION charge transactions, reimbursed at $ 172.31.
The check total shows at the bottom of the remittance attached to the check. The total of this check is $1,017.03.
The gross amount and the net amount are the same amount after our merchant fee has been taken.
The following report shows the summary of the VISION transactions that comprise
the reimbursement check. The report is sorted and keyed on RMDS by vendor code.
The report shows the total of the VISION transactions, the fees that were calculated and subtracted from the total, and the amount reimbursed on the check.
If a vendor had multiple facilities at many exchanges, the report would list them all by facility number under concessions vendor code. The last page for the vendor will show the vendor totals, which will match to the check.
PCN: VIBCONC2
EXCHANGE CREDIT PROGRAM PAGE:
1
DATE:
FROM
VENDOR
NO.: 11111111
FACILITY: 1234 1501 00 Buy On Line
TC150-0001 12341501 19991031 001 $
69.70 $ 1.49 $
68.21
FACILITY
TOTAL: $ 69.70 $
1.49 $ 68.21
FACILITY: 1234 5570 00 Buy On Line
TC150-0011 12345570 19991031 001 $
371.72 $ 7.43 $ 364.29
TC400-0001 12341570 19991031 002 $
28.00- $ .56- $ 27.44-
FACILITY
TOTAL: $ 343.72 $
6.87 $ 336.85
FACILITY: 1234 1502 00 Buy On Line
TC150-0008 12341502 19991031 001 $ 360.07
$ 7.20 $
52.87
FACILITY
TOTAL: $
360.07 $ 7.20 $
352.87
FACILITY: 1234 1501 00 Buy On Line
TC150-0002 37211501 19991031 001 $
88.46 $ 1.77 $
86.69
FACILITY
TOTAL: $ 88.46 $
1.77 $ 86.69
FACILITY: 1234 1509 00 Buy On Line
TC150-0005 12341509 19991031 001 $
175.83 $ 3.52 $
172.31
FACILITY
TOTAL: $ 175.83 $
3.52 $ 172.31
VENDOR 11111111 TOTAL: $ 1,037.78 $
21.75 $ 1,017.03