Hi all. Our finance department has raised a good question. Our venues sell our programmes for us and deduct the commission and seller costs. Our programmes are set up as a performance and have price types for different concerts, each price type with a different GL code to correspond to the concert the programmes are sold for. We would like to put the commission and seller costs through Tessitura as a negative value against the programme sales to do the full reconciliation in Tessitura. Do any of you currently do this, and if so any suggestions would be welcome. Thank you very much!
Thank you so much for all your ideas everyone. Unfortunately our seller costs aren’t based on cost per programme, and I tried the fees approach but you can’t have a negative fee amount L Good thoughts though!
I will have a look at payment methods too. Any other suggestions would be really appreciated!
----------------------------------------------------------------------------------------------------------- Michelle Gallagher | CRM System Manager New Zealand Symphony Orchestra Te Tira Pūoro o Aotearoa Ph +64 4 801 2037 Fax +64 4 801 7887 Email MichelleG@nzso.co.nz
-----Original Message----- From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Beau Vigushin Sent: Wednesday, 18 March 2015 10:14 a.m. To: Michelle Gallagher Subject: RE: [Tessitura Finance Forum] Merchandise Sales Commission query Hey Michelle, You could use price maps / layers to do this and split the advertised price into many segments, and have each segment point to a different GL. Works well for commission, but this would only work if your staffing cost was done on a per program sold basis though. Beau. From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 3/17/2015 8:56:41 PM I’ve never done this but I would imagine you could set up a negative amount as a fee that is rule based for these type of purchases. I would imagine you could set up multiple fees that automatically are part of the transaction as needed. After I sent this I tried it and you can't do a negative fee sadly. Insert sad face. Granted, this is just me thinking this through via email but seems possible. Christopher Cuhel Senior Manager of Ticketing and Patron Services | Lyric Opera of Kansas City From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Tuesday, March 17, 2015 3:28 PM To: Chris Cuhel Subject: Re: [Tessitura Finance Forum] Merchandise Sales Commission query We don't do this but a quick thought would be that you can set up payment methods for the commission and seller costs and put each portion through each payment method. Michele From: Michelle Gallagher <bounce-michellegallagher4291@tessituranetwork.com> Sent: 3/17/2015 4:00:54 PM Hi all. Our finance department has raised a good question. Our venues sell our programmes for us and deduct the commission and seller costs. Our programmes are set up as a performance and have price types for different concerts, each price type with a different GL code to correspond to the concert the programmes are sold for. We would like to put the commission and seller costs through Tessitura as a negative value against the programme sales to do the full reconciliation in Tessitura. Do any of you currently do this, and if so any suggestions would be welcome. Thank you very much! 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! -- View this message online at http://www.tessituranetwork.com/Community/forums/p/13276/41265.aspx#41265 or reply to this message -- 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! Level 8, Alcatel Lucent House | 13 - 27 Manners Street | PO Box 6640 | Wellington 6141 | NZSO.CO.NZ NZSO | SEASON 2015 Connect With Us This email has been filtered by SMX. For more information visit smxemail.com
Hey Michelle,
You could use price maps / layers to do this and split the advertised price into many segments, and have each segment point to a different GL. Works well for commission, but this would only work if your staffing cost was done on a per program sold basis though.
Beau.
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 3/17/2015 8:56:41 PM
I’ve never done this but I would imagine you could set up a negative amount as a fee that is rule based for these type of purchases. I would imagine you could set up multiple fees that automatically are part of the transaction as needed. After I sent this I tried it and you can't do a negative fee sadly. Insert sad face.
Granted, this is just me thinking this through via email but seems possible.
Christopher Cuhel
Senior Manager of Ticketing and Patron Services | Lyric Opera of Kansas City
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Tuesday, March 17, 2015 3:28 PM To: Chris Cuhel Subject: Re: [Tessitura Finance Forum] Merchandise Sales Commission query
We don't do this but a quick thought would be that you can set up payment methods for the commission and seller costs and put each portion through each payment method.
Michele
From: Michelle Gallagher <bounce-michellegallagher4291@tessituranetwork.com> Sent: 3/17/2015 4:00:54 PM
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!
-- View this message online at http://www.tessituranetwork.com/Community/forums/p/13276/41265.aspx#41265 or reply to this message -- 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!
Level 8, Alcatel Lucent House | 13 - 27 Manners Street | PO Box 6640 | Wellington 6141 | NZSO.CO.NZ NZSO | SEASON 2015 Connect With Us
Thank you Michele and Sandra, I am going to look further into doing it via payment method and have requested the GL codes from our finance department. Thanks heaps for your help :-)