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

 


  

PO Number             Below the invoice number on the check remittance is our PO number.  This number is constructed from the VISION transaction code (TC) and the number of transactions processed by the concession that period.   There are 2 VISION transactions involved in this process. They are:

 

                                                     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 Sunday, 31 October 1999.  The PO indicates the facility had one CHARGE transaction (TC150).  The amount reimbursed (transaction value less our merchant fee) is $68.31.

 

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:  01/11/99                                   CONCESSION REIMBURSEMENT REPORT                                                  

                                                  FROM 25 OCT 1999 TO 31 OCT 1999                                                   

 

 

VENDOR NO.:  11111111                                                                                                              

                                                                                                                                    

FACILITY:  1234 1501 00    Buy On Line

                                                                                                                                   

PO NUMBER       INVOICE NUMBER SFFX         TXN AMOUNT                 FEE      INVOICE AMOUNT                                     

                                                                                                                                   

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

                                                                                                                                   

PO NUMBER       INVOICE NUMBER SFFX         TXN AMOUNT                 FEE      INVOICE AMOUNT                                     

                                                                                                                                   

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

                                                                                                                                   

PO NUMBER       INVOICE NUMBER SFFX         TXN AMOUNT                 FEE      INVOICE AMOUNT                                     

                                                                                                                                   

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

                                                                                                                                    

PO NUMBER       INVOICE NUMBER SFFX         TXN AMOUNT                 FEE      INVOICE AMOUNT                                     

                                                                                                                                    

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

                                                                                                                                    

PO NUMBER       INVOICE NUMBER SFFX         TXN AMOUNT                 FEE      INVOICE AMOUNT                                     

                                                                                                                                    

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

 

 

 

 

 Go Back to Home