Adyen Reports and Tessitura

Tessitura Merchant Services users--what procedures have you developed for using Adyen reports with Tessitura batch reports? We’re looking for the best way to:

  • Reconcile the fees from the Adyen settlement detail report. There’s information on the Adyen site for how to do this, but it doesn’t appear as though I have all of the columns or reports they are referencing.
  • Figure out what batches are included in a settlement detail report.
    • It says here that “By default, the Settlement Details report is generated every time a payable batch is closed.” Does that mean each instance of a Settlement Details report in Adyen corresponds to a Tessitura batch?

Hoping someone who has been using Tessitura Merchant Services for a while can provide a little experience for my finance team to benefit from.

Thanks!

Michael

Parents
  • Hello Michael! As it happens, we recently posted a new release of version 15 that includes the Payment Gateway Summary/Detail report, which can be used to reconcile with Merchant Services and our other providers. (Until you are on that release, you can use the Income by Payment Method report David suggested, or the Payment Gateway Activity report if you save it to a spreadsheet to filter out the extra rows it generates.)

    In coordination with that release, we have also posted Credit Card Reconciliation guidance. That page describes how to match the Adyen reports to Tessitura, and hopefully contains the guidance you are looking for to connect the two systems. The Settlement Details report contains Gross and Net amounts. The Gross amounts will match Tessitura, while the Net amounts will have the fees deducted. An individual payment can be connected to Tessitura using either the PSP Reference value or the Merchant Reference value. That is also described in more detail on the Credit Card Reconciliation topic.

    And I look forward to any suggestions from other users about reconciliation. Thanks! 

Reply
  • Hello Michael! As it happens, we recently posted a new release of version 15 that includes the Payment Gateway Summary/Detail report, which can be used to reconcile with Merchant Services and our other providers. (Until you are on that release, you can use the Income by Payment Method report David suggested, or the Payment Gateway Activity report if you save it to a spreadsheet to filter out the extra rows it generates.)

    In coordination with that release, we have also posted Credit Card Reconciliation guidance. That page describes how to match the Adyen reports to Tessitura, and hopefully contains the guidance you are looking for to connect the two systems. The Settlement Details report contains Gross and Net amounts. The Gross amounts will match Tessitura, while the Net amounts will have the fees deducted. An individual payment can be connected to Tessitura using either the PSP Reference value or the Merchant Reference value. That is also described in more detail on the Credit Card Reconciliation topic.

    And I look forward to any suggestions from other users about reconciliation. Thanks! 

Children
No Data