Hi,
Our finance department has been having trouble reconciling the bank against our sales ever since we switched to Payment Express.
Prior to using Payment Express, we used Transcend. Transcend batches all sales for the entire 24 hour period and that data could be matched dollar for dollar to our bank deposits on a daily basis.
However, since using Payment Express, it's very difficult for them to reconcile. Payment Express records transactions as they happen (host-capture) and if we just take 24 hours of data from Payment Express (midnight to midnight) it doesn't match the bank because FirstData actually posts the transactions for our several MIDs at different times around midnight. For example, our WEB transactions may post at 11:41 PM and our EDU transactions may post at 12:21 AM, etc.
We need help in understanding how any other organizations that use Payment Express have set up their reporting and/or workflows to be able to make sure that the sales we made in Tessitura end up in the correct accounts and amounts on a daily reconciliation.
Thanks in advance!
Hi Gerald,
We are new to Tessitura and to payment express. Our CFO was having the same issues this week. She determined that our Payment express closes sales at 10:30pm and not midnight. We got the following as a response from our trainor to changing the closing of the web batches.
There is a Batch Rollover time setting for Tessitura web (your TNEW site) in T_Defaults. Do you want to try updating that to 10:30pm? (save changes and clear cache). It’s currently set to 00:00 which is midnight. I think you’ll need to write it out as 22:30 though.
We are going to try this today and see if it helps our reconciling issues. Not sure if it will solve your issues.
Thanks,
Sally