• Replies 3 replies
  • Subscribers 187 subscribers
  • Views 159 views
  • Users 0 members are here
Options
Related

Adyen Reports and Tessitura

Michael Dorsey
$organization

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

  • $organization

    Hi Michael,

    This is David Struyf with the Tessitura Network Payments Specialist team. I know we have reached out to you regarding this question in our support ticket but I am posting the reply here for visibility for other members:

    Regarding reconciling Adyen Fees, the Settlement Details Report includes all fees that have been deducted from that Adyen batch. Adyen payout batches and Tessitura batches are not connected. The transactions included in the Adyen payout batch will be all of a single days transactions lumped together. We are now recommending the Income by Payment Method report in Tessitura using the same transaction dates as the transactions in your Adyen payout batch for reconciliation, versus using your Tessitura Posting reports for reconciliation against Adyen reports which was our previous recommendation.

    Thanks,

    David

  • $organization in reply to David Struyf

    Thank you, David! I was having trouble figuring out how to word the question in this post yesterday. 

    It's helpful to get clarification on the batches in Adyen vs batches in Tessitura. Thank you for suggesting the Income by Payment Method report. 

    We are aware that the fees are deducted already on the Adyen side. What we're trying to figure out is if there is a way to "connect" the two (Adyen and Tessitura). Do we simply trust that Tessitura and Adyen are always going to line up and the fees are the only variance? The post was to see if any other orgs have developed a method for reconciling the two sources.

    I'll bring an example to the ticket. I appreciate you following up here, too!

    Michael

  • $organization

    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!