Hi all,
I am working on putting together written procedures for a monthly Tessitura/Transcend/credit card statement reconciliation process here at Yale. I would love to hear from anyone who is currently doing this. What reports do you pull from Tessitura and Transcend? Have you created any custom reports? Any pitfalls I need to be aware of? Any advice would be greatly appreciated!
Looking forward to hearing from you.
Best,
Mara
Mara –
I reconcile Tessitura and Transcend for each day to find irregularities, which we seem to have more of than before Transcend. Right now I’m working on a charge that went through twice in Transcend, but only once in Tess. I compare the Tess posting reports to Transcend’s Batch Details by Card Type report. We sometimes have temporary variances with our web sales due, I assume, to timing differences in when the batches close, so I wait a day or two to see if those correct themselves before putting time into investigating them.
Leslie
Leslie Fillingham, Finance Director
Milwaukee Repertory Theater
414-224-1761
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Mara Hazzard-Wallingford Sent: Monday, November 16, 2009 1:12 PM To: Leslie Fillingham Subject: [Tessitura Finance Forum] Transcend/Tessitura Reconciliation Procedures
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!
We also compare the Batch Details by Card Type report in Transcend daily with the posting report.We created a excel settlement sheet that we use to enter the totals from both reports and through a simple "EXACT" formula compare the two.
Mara-
I created to custom reports that find trx that were rolled back in Tessitura, but were still in Trandscend, and to find credits that look like they went through to Trandscend via Tessitura but did not. Our account department runs those daily, to see if there are any issues, along with checking the CC balances between Tessitura, Trandscend.
Jeanette
Hi Jeanette,
Would you be willing to share that report? I was thinking about putting together something like that to look for discrepancies only on a daily basis, and then creating some additional reports that summarize activity on a monthly basis for the business offices. We are a consortium, so we have a huge number of merchant accounts, and looking at everything daily is really not an option for us.
Thanks so much!
Mara Hazzard-Wallingford Director, Yale Tessitura Consortium mara.hazzard-wallingford@yale.edu
(203) 432-8822
Sure, I will send them to you directly.
Thanks
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Mara Hazzard-Wallingford Sent: Wednesday, November 18, 2009 10:42 AM To: jboudjouk@smm.org Subject: RE: [Tessitura Finance Forum] Transcend/Tessitura Reconciliation Procedures
Spam Not spam Forget previous vote
Mara,
Hi couldn't believe your message the other day as I was working on the exact same report at the exact same moment. We don't necessarily have too many merchant accounts (about nine--is that normal?) but we've enough ***daily distractions*** to make a weekly/monthly reconciliation report more than useful.
I was pulled away but expect to get back to it on Friday; can we compare notes one day next week?
(forgot to mention I got my start on this with the Transcend and Tessitura_Setup Doc. See page 15 for some sample table joins and queries)
Warren Evans
Director Business Applications
Shakespeare Theatre Company
Jeanette,
Would you be willing to send me a copy of your reports as well?
Thanks in advance.
-steve carlock
Information Technology Manager
The Granada
jsc@granadasb.org
(805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01
(805) 899-3002 (fax)
(562) 239-7075 (cell)
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Jeanette Boudjouk Sent: Wednesday, November 18, 2009 7:47 AM To: Steve Carlock Subject: Re: [Tessitura Finance Forum] Transcend/Tessitura Reconciliation Procedures
From: Mara Hazzard-Wallingford <bounce-marahazzard4013@tessituranetwork.com> Sent: 11/16/2009 1:11:03 PM
I would also love to see those reports. Thanks for sharing!
I think that is a report many of us would like to take a look at.You may want to consider submitting it as a shared report.
I agree with the request that many of us would like to see this report, and submitting as a shared report seems the way to go.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Ryan Rowell Sent: Thursday, November 19, 2009 2:17 PM To: Terry Schomburg Subject: Re: [Tessitura Finance Forum] RE: Transcend/Tessitura Reconciliation Procedures
I think that is a report many of us would like to take a look at. You may want to consider submitting it as a shared report.
From: Jonathan Dickey <bounce-jonathandickey3855@tessituranetwork.com> Sent: 11/19/2009 3:58:32 PM
I'm happy to report that Jeanette's reports are now available in solution #310 of the Reference Materials project in TASK Online.
Thanks Jeanette and SMoM!