• Replies 1 reply
  • Subscribers 216 subscribers
  • Views 42 views
  • Users 0 members are here
Related

Getting the data to make Financial Edge Cash Receipts work

Sara Nemeth
$organization

We're new to Tessitura and are struggling to get the information out of the system that we need to post to the Cash Receipts module in Financial Edge. The Posting Report doesn't provide enough detail; and to make the Income by Payment Method report work, it seems we'd need to add each credit account GL as a designation code in the TR_DESIG_CODE system table, which is less than ideal in our consortium setting (we have tons of GL numbers).

I'm told using the Cash Receipts module in Financial Edge, which is what we've done for the last 2 years, requires us to know what amount was credited to each GL based on the debit account GL. For example, if $1,000 was debited to the Credit Card asset account GL, how much of that was credited to:

  • Ticket Fees GL for Perf 1 
  • Ticket Revenue GL for Perf 1
  • Ticket Fees GL for Perf 2
  • Ticket Revenue GL for Perf 2
  • Etc.

What are others doing? Switching accounting systems isn't an option, but any advice on making Financial Edge work so we can post things to the GL would be greatly appreciated.

  • Former Member
    Former Member $organization

    We upload data from Tessitura to Financial Edge using the Posting Summary Report in the Finance folder. That method does not upload each transaction but it does provide the detail our Finance department wants.  I’d be happy to talk to you about how we do that. I’m out of the office tomorrow (July 28) but will be back on July 29, then gone again thru August 3. Call me if you would like an explanation.

     

     

    ____________________________

     

    Julie P. Hamre

    Staff Accountant

    Strathmore

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    www.strathmore.org

    301-581-5136

    jhamre@strathmore.org

    In office Monday-Thursday

     

     

     

    Support what you love. Strathmore Stars enjoy

    10% off Strathmore performance tickets, advance

    ticket purchase, discounts in the Shops at

    Strathmore and in Tea Room, and access to special events.

     

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Sara Nemeth
    Sent: Monday, July 27, 2015 5:47 PM
    To: Julie Hamre
    Subject: [Tessitura Finance Forum] Getting the data to make Financial Edge Cash Receipts work

     

    We're new to Tessitura and are struggling to get the information out of the system that we need to post to the Cash Receipts module in Financial Edge. The Posting Report doesn't provide enough detail; and to make the Income by Payment Method report work, it seems we'd need to add each credit account GL as a designation code in the TR_DESIG_CODE system table, which is less than ideal in our consortium setting (we have tons of GL numbers).

    I'm told using the Cash Receipts module in Financial Edge, which is what we've done for the last 2 years, requires us to know what amount was credited to each GL based on the debit account GL. For example, if $1,000 was debited to the Credit Card asset account GL, how much of that was credited to:

    • Ticket Fees GL for Perf 1 
    • Ticket Revenue GL for Perf 1
    • Ticket Fees GL for Perf 2
    • Ticket Revenue GL for Perf 2
    • Etc.

    What are others doing? Switching accounting systems isn't an option, but any advice on making Financial Edge work so we can post things to the GL would be greatly appreciated.




    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!