We just implemented elements last week. (Thank you to those who answered my previous questions).Elements is our processor.
Question: We are on EST time and Elements is CST. Our Web Batch Roll over time 12:00 AM. Therefore when we balance we go into the Core Management System and run a transaction report from 11:00 PM CST to on the previous day to 11:00 PM CST on the current day. This corresponds to our Batch reporting. So we know for every credit card sale we have a corresponding transaction in Tessitura.
Here is our problem: If transactions come in between 12:00 AM to 1:00 AM Elements is sending a statement to our Finance department showing deposits on their on the previous day and in Tessitura we have the next.
Has anyone had success with having elements do a settlement time override? I know payment tech can do this.
Also if anyone else has encountered this issue please let me know how you resolved.
The only solution which isn't practical is to not process credit card transactions between 12:00 AM to 1:00 AM EST.
We have a spreadsheet where we enter Tess deposits and Element deposits and calculate the variances. They usually work themselves out in a day or so as we don’t have that many late night transactions. If not, we investigate them which can reveal other issues such as duplicate transactions, held transactions and unposted batches.
LESLIE FILLINGHAM | Finance Director | Milwaukee Repertory TheaterPatty & Jay Baker Theater Complex | 108 East Wells Street | Milwaukee, WI 53202414.224.1761 tel | 414.224.9097 fax | Email: lfillingham@milwaukeerep.com Website: www.milwaukeerep.com | Facebook: www.facebook.com/milwrep | Twitter: twitter.com/milwrep
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Robert TaultySent: Monday, October 13, 2014 10:28 AMTo: Leslie FillinghamSubject: [Tessitura Finance Forum] ELEMENTS - Balancing
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Just an FYI to this thread, hoping all of you are aware of the Element Data Reporting Utility (see TASK solution #32) that is available for downloading and storing your Element data in a local database table.
I can't recommend this highly enough for anyone running Element. You'll find yourself logging into the Element web portal far less often.
I agree that having the report data local is extemely useful. We have written a report off the data to help find issues. Our implementation is slightly different we have a sql job that runs nightly that pulls the data down from the Element web service into a local table that we report off of.