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 Erik,
We are doing that very thing! Our money is in a special on account associated with a GL that will be a "pass through" fund.I have a GL summary report pulled for this account once everything was applied to it. I was hoping to track everything in analytics, but we were getting odd numbers that didn't match what we knew to be true in testing and we didn't have time to fiddle with the analytics filters to figure it out.
So, I'm pulling multiple reports and compiling them in a spread sheet. Daily GL Summary for the On-Account Season Cancellation Sales, Then one for the GL for 2020 Season Ticket Donations, One for Credits, and then I'm keeping a running tally of refunds daily. Each account has a special GL number for the 2020 season cancellation.
Hope that helps!
thanks. we will end us going the route of one report or multiple.
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
Erik,
In the Finance Cube, you can track both putting money on account and then applying that on account money to an order. See the example below in which the money initially came in via Credit Card, tickets got returned and money put on account (shows as a Credit). Using the On Account money would show up as in the Total Debit Amount.
You can use the Total Debit Amount to track when the On Account money is used.
I hope that helps.
Neil
yes, it does. thank you
Neil Cole It seems that your images aren't showing any longer. Would you be willing to reshare? My email address is mkeutsch@stratfordfestival.ca. We're looking for exactly this information!