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
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.