• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 42 views
  • Users 0 members are here
Related

GL reporting by performance

Steven Jirjis
$organization

Hi everyone - We have a performance that is using multiple GL's. Is there a canned report that will tell me how much money has gone into each GL? If there is not a report that can provide that specific of data, is there a report that comes to mind that can be manipulated in Excel? 

 

Thanks!

  • $organization

    Hi Steven,

    I can't think of a canned report that does exactly what you are looking for, but I would recommend Transactions by Posting.  It's in the Finance folder and gets into the nitty gritty of when and where money moves around.

    The report let's you filter by GL number but not by performance.  The report produces a lot of detail rows so it might be easier to work with if you save it to Excel and create a pivot table.  You can organize by GL number or GL description.  There is also a column called Bucket which, for tickets, is the name of the price map used.

    Hopefully between the GL and the price map you can narrow things down to your performance.  Good luck!

    Jared

  • $organization

    Hi Jared – This worked out perfect! We very distinctly named the price map for this performance, which made it super easy to find and manipulate in Excel.

     

    Thanks so much!

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Jared Mollenkopf
    Sent: Tuesday, July 15, 2014 8:58 AM
    To: Steven Jirjis
    Subject: Re: [Tessitura Ticketing Forum] GL reporting by performance

     

    Hi Steven,

    I can't think of a canned report that does exactly what you are looking for, but I would recommend Transactions by Posting.  It's in the Finance folder and gets into the nitty gritty of when and where money moves around.

    The report let's you filter by GL number but not by performance.  The report produces a lot of detail rows so it might be easier to work with if you save it to Excel and create a pivot table.  You can organize by GL number or GL description.  There is also a column called Bucket which, for tickets, is the name of the price map used.

    Hopefully between the GL and the price map you can narrow things down to your performance.  Good luck!

    Jared

    From: Steven Jirjis <bounce-stevenjirjis4325@tessituranetwork.com>
    Sent: 7/10/2014 7:30:30 PM

    Hi everyone - We have a performance that is using multiple GL's. Is there a canned report that will tell me how much money has gone into each GL? If there is not a report that can provide that specific of data, is there a report that comes to mind that can be manipulated in Excel? 

     

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • $organization in reply to Steven Jirjis

    Performance Transaction Detail in Ticketing Box Office reports will show performance revenue by GL Account for selected performances in various groupings.

  • $organization in reply to Jared Mollenkopf

    Does anyone know of a report that will do this same thing only use Price Type description instead of price map for v12? We are finding now that the 'Bucket' Column only uses the layer name rather than breaking it down by price type which we need for different marketing offers where we need to pay this amount to a 3rd party seller.