Hello hive mind,
I am trying to rack my head around how to track total amounts charged to credit cards for donations we take online that get put into an on-account payment method to be later processed by our Devo team. Right now, this payment method, Contributions On-Account, is used to move money for contributions everywhere, so it is not exclusive to web donations, but also use internally for other purposes.
Is there a way to link a credit card charge that then gets moved to an on-account payment method?
We also want to make sure that if there is a case where an order is charged say $500 and $100 of that goes into Contributions On-Account and $400 is for tickets, that those numbers get allocated correctly in reporting to show $400 in ticketing credit sales and $100 in donation credit sales.
My end goal is to track all donations by credit card vs ticket sales by credit card to determine the approximate breakdown for our credit card fees for each category.
Thanks!
Jeff
Not sure how much this helps, but we created an on account payment method called "Online Gifts" which all online gifts now go to (whether tied to a purchase or not), so we could separated it from our On Account Development payment method (which is used to gift adjustments and holding funds that we need to determine placement for).
Hi Jeff!
Like Colleen Miller we keep separate on account methods for client and web use (but you probably remember that!) But as to pulling this data, it's always going to be hard, as there is no explicit connection in Tessitura between payment methods and the things they're paying for. I think your best bet is going to be in the Analytics Finance Cube. Fortunately, you can only use one credit card for a TNEW order, so assuming you're using TNEW you at least have that going for you when it comes to trying to filter data out by card type. Then you would need to filter by MOS (or MOS Category) to get all web transactions. Then it gets to the edge of my Analytics bucketing skills. You'd want for each order, to have columns where you subtracted the On Account part of the order's payment from the Credit Card payment to show the non-contribution part. But you might also need to be subtracting any Gift Certificate payment methods as well, and any On Account methods that you allow for online payment. The part I have trouble with is how to then organize this by "orders that used Payment Method X for some or all of the order".
The next "analytics Coffee!" is on November 15th, you might want to bring that to them:
community.tessituranetwork.com/.../1399
Thanks Gawain! I thought I remembered we had that setup at Cal. I am going to be doing some deep Analytics learning for a few different reports so hopefully I may pick something up that can help me along with this one!