Reconciling Merchant services transactions against Tess reports

Hello,

when identifying variances between bank deposit listed in the merchant service web and Tess posting reports what is the best way to search for those transaction in Tess. using the last 4 of the cc from merchant services results in numerous names. We have also tries using the EPS transaction summary report. Any other ideas to search for a transaction using last 4 of credit card, amount etc which is the only info in the merchant services site? 

Best,

Marco

Parents
  • Hi Marco, if you have the auth code form the the Payment Gateway you can look up the payment that way.  I wrote a little report for our accountant who plugs in the Auth Code form Payment express and it tells her ... (it was my 1st ever report :) 
    Cust no
    First name
    Last name
    Transactor
    Order no
    Seq. no
    Pmt amt
    Pmt date
    Description
    Trans type
    Season
    Performance
    Fee
    Fund

  • Thanks Heath, we use the invoice number in the Tessitura EPS transaction report to find the transactions. We do have the Auth Code, where do you plug the number in Tessitura?  We are trying to use the search mode in Tess but I do not see any option for Auth code or anything other than name, cc #, Customer ID, address etc...

    Best,

    Marco

Reply
  • Thanks Heath, we use the invoice number in the Tessitura EPS transaction report to find the transactions. We do have the Auth Code, where do you plug the number in Tessitura?  We are trying to use the search mode in Tess but I do not see any option for Auth code or anything other than name, cc #, Customer ID, address etc...

    Best,

    Marco

Children