Hello,
I have a question from my finance team. If anyone is able to help it would be greatly appreciated.
I have tried a number of reports and so far I have not been able to look at total ticket income for an event split by ticket price, VAT and fees, and cut by payment type (Visa, Mastercard, Amex etc).
Currently, I think the only way I’ll be able to get the info I need to reconcile the receipts which are hitting our bank account to Tess, is to go back and unpost those batches I posted with the prevailing date as opposed to the batch date. And even then I’m not sure the GL posting report will give me a daily summary splitting total box office sales by event split by ticket value, VAT and fees, and shown by card type....
To reconcile the bank receipts to Tess I need essentially this:
Batch date
Event name
Payment type
Ticket sales £
VAT £
Booking fees £
TOTAL SALES £
01/01/2018
North
Amex
Visa
Mastercard
Cash
Other
TOTAL
Summer Series
F4SS
Also, has anyone got any finance reports they use that they can recommend?
Thank you,
Kyle
Hi Kyle,
I am having the same issue! I am trying to use the GL Summary report to enter ticket sales into our accounting package and reconcile with what is received in our bank account daily, however this, nor any other report I have found reconciles. Have you had any luck or do you have any suggestions as to how I can pull this information from Tessitura? I assume perhaps there is a timing issue?
Any feedback you have would be wonderful...Sorry I couldn't be any help to you
Thanks, Jacqui
We are able to tie out our Tessitura G/L cash postings by day to our bank statements. I'm not sure we could do this by event, but we can do it by credit card type, cash, ach, etc. A few things that make it possible are to be sure that your business end of day in your merchant services coincides with your Tessitura end of day posting. They are not always till midnight of the day, but can often be designated by you. So be sure your reports are run at a time when they match up with your merchant services plan. Also, payment types are identified as Cash/Cks, VISA/MC, Amex, Discover, etc. These are then mapped to our G/L account with a separate "sub acct" designation at the end of the account. (.001, .002) that are not used when making the G/L entry, but help to separate the type of deposit into cash into a separate line item. This will greatly help with the reconciliation to bank deposits. There is still some differences when one or two credit card items are actually deposited, but those are usually easier to reconcile because it will be under on one day, then over on the next, zeroing itself out over time. And cash deposits become easy to identify.