• Replies 3 replies
  • Subscribers 216 subscribers
  • Views 157 views
  • Users 0 members are here
Related

GL Reporting

Former Member
Former Member $organization

Hi all

Greetings from a new user! This is my first post on the forums, so be gentle with me!

I am part of a project called Ticketing Network East Midlands (TNEM for short) and we are a consortium of four venues, who will be offering cross selling between venues online.

On looking at the GL reporting when it comes to testing web transactions, using a web payment method - the report does not split the Web Payment GL code down by any means e.g. season which means we cannot use this report to reconcile daily sales. Which is unfortunate as this seems to me to be the best report for displaying income by GL Code.

The Mode of Sale analysis report in Ticketing does break down the payment method into season which does mean we can account for the money using a combination of the two reports, but our auditors would not be happy to see a figure on a GL Report for web sales money that does not belong to us.

Its almost like the two reports need splicing together. Has anyone who sells for different organisations got any ideas or tips about how to split income about between a shared payment method? It would be good to hear anyone's experiences of this.

Thanks in advance, and look forward to meeting some of you at the conference.

all best

Rich

Parents
  • Former Member
    Former Member $organization
    Hi Rich
    In the Sydney consortium, each organisations' sales streams are independant.
    That is, if the Opera sells a ticket to one of their shows, it goes through their own MOS, batch type, payment methods, price maps, and fees, to their own GL codes. Their credit card payment methods link to their merchant account so the money goes straight to them.
    If we sell a ticket to that show, it goes through our MOS, batch type, payment methods, price maps, and fees, to our GL codes, and the money goes into our bank account. We collect their sales into a holding account in our GL, and return it to them (minus our charges) when the event is settled.
    Obviously, being able to use that model depends on the contracts and relationships between the consortium partners, but it works well, and eliminates the need to do complex splits of the postings based on factors that Tess doesn't know about. I would certainly recommend isolating partner financial transactions as far as you can.
    Ken
    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry

    From: Tessitura Finance Forum <forums-finance@tessituranetwork.com>
    To: Ken McSwain
    Sent: Thu Jul 01 00:53:24 2010
    Subject: RE: [Tessitura Finance Forum] GL Reporting

    Hi Rich,

     

    We have a custom payment breakdown report which may help you, would you like the files? It’s rather difficult to report on payment method GLs and ticket sales as an order can contain seats for performances in many different seasons which can also be paid for using several payment methods.

     

    In our consortium plans each organisation will have their own payment methods so we wont have the same issues with splitting the income.

     

    Hope it’s all going well,

     

    Gary

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Richard Surgay
    Sent: 30 June 2010 15:20
    To: Halliday, Gary
    Subject: [Tessitura Finance Forum] GL Reporting

     

    Hi all

    Greetings from a new user! This is my first post on the forums, so be gentle with me!

    I am part of a project called Ticketing Network East Midlands (TNEM for short) and we are a consortium of four venues, who will be offering cross selling between venues online.

    On looking at the GL reporting when it comes to testing web transactions, using a web payment method - the report does not split the Web Payment GL code down by any means e.g. season which means we cannot use this report to reconcile daily sales. Which is unfortunate as this seems to me to be the best report for displaying income by GL Code.

    The Mode of Sale analysis report in Ticketing does break down the payment method into season which does mean we can account for the money using a combination of the two reports, but our auditors would not be happy to see a figure on a GL Report for web sales money that does not belong to us.

    Its almost like the two reports need splicing together. Has anyone who sells for different organisations got any ideas or tips about how to split income about between a shared payment method? It would be good to hear anyone's experiences of this.

    Thanks in advance, and look forward to meeting some of you at the conference.

    all best

    Rich




    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!


    www.southbankcentre.co.uk

    Ticket Office: 0844 847 9910

    Southbank Centre is a Registered Charity No. 298909

    ______________________________________________________________________

    This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer.

    _______________________________________________________________________
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====



    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!
Reply
  • Former Member
    Former Member $organization
    Hi Rich
    In the Sydney consortium, each organisations' sales streams are independant.
    That is, if the Opera sells a ticket to one of their shows, it goes through their own MOS, batch type, payment methods, price maps, and fees, to their own GL codes. Their credit card payment methods link to their merchant account so the money goes straight to them.
    If we sell a ticket to that show, it goes through our MOS, batch type, payment methods, price maps, and fees, to our GL codes, and the money goes into our bank account. We collect their sales into a holding account in our GL, and return it to them (minus our charges) when the event is settled.
    Obviously, being able to use that model depends on the contracts and relationships between the consortium partners, but it works well, and eliminates the need to do complex splits of the postings based on factors that Tess doesn't know about. I would certainly recommend isolating partner financial transactions as far as you can.
    Ken
    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry

    From: Tessitura Finance Forum <forums-finance@tessituranetwork.com>
    To: Ken McSwain
    Sent: Thu Jul 01 00:53:24 2010
    Subject: RE: [Tessitura Finance Forum] GL Reporting

    Hi Rich,

     

    We have a custom payment breakdown report which may help you, would you like the files? It’s rather difficult to report on payment method GLs and ticket sales as an order can contain seats for performances in many different seasons which can also be paid for using several payment methods.

     

    In our consortium plans each organisation will have their own payment methods so we wont have the same issues with splitting the income.

     

    Hope it’s all going well,

     

    Gary

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Richard Surgay
    Sent: 30 June 2010 15:20
    To: Halliday, Gary
    Subject: [Tessitura Finance Forum] GL Reporting

     

    Hi all

    Greetings from a new user! This is my first post on the forums, so be gentle with me!

    I am part of a project called Ticketing Network East Midlands (TNEM for short) and we are a consortium of four venues, who will be offering cross selling between venues online.

    On looking at the GL reporting when it comes to testing web transactions, using a web payment method - the report does not split the Web Payment GL code down by any means e.g. season which means we cannot use this report to reconcile daily sales. Which is unfortunate as this seems to me to be the best report for displaying income by GL Code.

    The Mode of Sale analysis report in Ticketing does break down the payment method into season which does mean we can account for the money using a combination of the two reports, but our auditors would not be happy to see a figure on a GL Report for web sales money that does not belong to us.

    Its almost like the two reports need splicing together. Has anyone who sells for different organisations got any ideas or tips about how to split income about between a shared payment method? It would be good to hear anyone's experiences of this.

    Thanks in advance, and look forward to meeting some of you at the conference.

    all best

    Rich




    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!


    www.southbankcentre.co.uk

    Ticket Office: 0844 847 9910

    Southbank Centre is a Registered Charity No. 298909

    ______________________________________________________________________

    This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer.

    _______________________________________________________________________
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====



    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!
Children
No Data