Excuse me if I don't use the perfect terminology here, but we have just started using Tessitura and our accounting team is having a good bit of trouble matching up the income received from Tess with what is appearing as deposits on our WorldPay account. Apparently, they don't match up because the different credit card companies deposit the funds at different times creating staggered deposits that don't match cleanly with when payments are posted in Tessitura.
Have any other organizations had this problem? How has it been rectified?
We wrote custom routines to import the World Pay settlement report into Tessitura, used some logic to match the WP settlement records with the data in T_PAYMENT_GATEWAY_ACTIVITY and wrote some reports to highlight exceptions.