Transcend/Tessitura Reconciliation Procedures

Former Member
Former Member $organization

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.

     

    Best,

    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

     

    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




    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.

  • Former Member
    Former Member $organization

    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

  • Former Member
    Former Member $organization

    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

     

    Mara Hazzard-Wallingford
    Director, Yale Tessitura Consortium
    mara.hazzard-wallingford@yale.edu

    (203) 432-8822

     

     

  • Former Member
    Former Member $organization in reply to Former Member

    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

     

    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

     

    Mara Hazzard-Wallingford
    Director, Yale Tessitura Consortium
    mara.hazzard-wallingford@yale.edu

    (203) 432-8822

     

     




    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!

  • Former Member
    Former Member $organization in reply to Former Member

    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

     

     

     



    [edited by: Warren Evans at 12:13 AM (GMT -6) on 19 Nov 2009]
  • Former Member
    Former Member $organization in reply to Former Member

    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

     

    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

    From: Mara Hazzard-Wallingford <bounce-marahazzard4013@tessituranetwork.com>
    Sent: 11/16/2009 1:11:03 PM

    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




    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!

  • Jeanette,

    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

    Jeanette,

    I would also love to see those reports. Thanks for sharing!




    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!

  • I'm happy to report that Jeanette's reports are now available in solution #310 of the Reference Materials project in TASK Online.