Hello all.
We have used the event Cancellation Utility for the rest of our season and have moved all of the existing money to an on Account. What "we' would like to now be able to report on it, when our patrons reach out and let us know what they want us to do with their money (donation, GC, or refund).
Is there a way to look at the moeny leaving this on account and track where it goes? i dabbled a bit in the finance data source and was able to figure out ticket returns but this one eludes me.
i looked in the existing discussions and didn't see this...so , if this thread already exists please let me know.
thanks,
Erik
Hi! We are in the same boat and I'm just finishing up proofing all of our numbers. Tracking On Account movement has definitely been tricky. Our dashboard is a little complicated since we have Ticket Turnbacks, Gift Certificates and Payments towards next season to track, some of which came directly from Returned tickets and some from On Account, also because of the Event Cancellation Utility. I'm uploading my dash file if you want to take a look at some of the formulas and values I've used! It has summary widgets at the top for $ On Account, Turnbacks, Gift Certs, 20-21 Season Payments and Refunds (broken out between this Season and next), followed by a daily change section for the same buckets for our Finance team and then those numbers are broken out by Constituent at the bottom.
If you had the forethought to set up a separate On Account type/GL before you ran the Event Cancellation Utility for your season, then you could just edit my filters to be on that Payment Method. I didn't think about that early enough, so all my widgets are filtered for our Box Office On Account Payment Method and payments greater than 3/16/20, when we started processing exchanges for COVID.
1057.19-20TicketMakeGoods.dash
thanks for this. i will gladly use it and see what i can figure out for our needs. we did create a separate GL/payment method for this.
thanks again