We are trying to compare our Tessitura daily transactions to Windcave and Elavon (Payments Insider reporting), but the transactions are settled at different times of the day.
Does anyone else have this issue? Have you found an easy way to deal with it?
Best,Angela
I have attempted this, with nominal success: I imported some transaction reports from Windcave, then used references stored in V_PAYMENT_GATEWAY_ACTIVITY to try and match the transactions. This doesn't match all transactions, unfortunately. Also, these references seem to be recycled on some basis, so you want to be sure you're restricting the time period on both sides of the equation.
It's tedious, but we run the CaptBatchDetail report from FirstView. It has 2 columns, AuthDate which corresponds to the sales date in Tessitura, and CaptureDate which corresponds to when it hits the bank. I basically tie out the AuthDate column to what we posted in the GL, the tie out the CaptureDate to what hit the bank. There's overages/shortages which I book to the Over/Short account. Then there's a few AuthDate items that hit the bank at the ends of the month and I post those to a clearing account since it needs to be reversed the following day. I just got finished doing July, took a couple hours.
We used to matchup Windcave and Tessitura when we had an issue with cart timeouts during payment processing online and I'd compare DpsTxnRef and ccref_no in Windcaves Full transaction report and Tessitura's T_PAYMENT table respectively
If you're trying to get the end of day batch postings for both systems to match, below are the two steps we did (choose the time you want):
One reconciliation item our Windcave rep let us know before changing is that this caused an extra day increase in the time for Windcave to send our money, but postings and $ from both systems are now spot on.
Cheers!
Danny