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
Sure, I will send them to you directly.
Thanks
Jeanette
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
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!
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