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