Julia,,
I reconcile PayFlowPro to cvent each day there are transactions.
My cvent report filters by looking at yesterday.
Every GL code is listed. For our controller, I sort by GL Code and subtotal everything.
My PayPal reports looks at yesterday, although I set the time range off by 3 hours.
I sort my PayPal report by credit card type and subtotal each credit card type.
At least that is how our accounting wants it.
I have the first name and last name of the person making the payment.
I'm not familiar with group registrations, and I guess that is what I can't follow.
Can you explain it differently for me?
I do have a gripe that GL Codes are not available in cross reports. This makes it difficult for me when I have multiple event registration going on at the same time.
------------------------------
Steven Schlossman
Jack of all trades. Master of none.
BMW Car Club of America
------------------------------
Original Message:
Sent: 01-21-2022 09:43
From: Julia Shellhouse
Subject: Financial Reporting Woes!!!
We've are entering our fifth year with Cvent and have been thrilled with the improvements it's made to our event management....with one HUGE exception. The Achilles Heel is reporting - specifically reconciling transactions with our PayPalPro account. Unbelievably, it is not an option to export a list of actual transaction amounts with assigned GL codes. If 10 people register as a group at $10 each, we get a list of 10 transactions for $10 each - But what we need, and what our finance manager needs to match it up with in PayPalPro, is one transaction for $100. Yes, we can see that all 10 orders have the same transaction number and the same cardholder name - but we have to go through the list every month and consolidate those transactions as the one $100 amount under the group leader's record. AND - GL codes can only be displayed as an individual order detail, and are associated with transaction reports at all?! Both order amount and transaction amount are options for fields to display - but they are the same number. Basically, Cvent jumps right to allocating the sub-amounts of a transaction to individual orders, but it cannot report on the actual transaction? Is this a matter of limited access in the integration between Cvent and payment processors? It doesn't make any sense and I have a hard time believing that we are the only organization for which this is a painful design flaw. How do finance managers out there reconcile their payment processor transactions, both charges and refunds, for bookkeeping??? We basically have to manually build a spreadsheet for importing into Quickbooks every month. With the level of sophistication in every other feature in Cvent, and the "top-rail" cost, we just can't accept this situation any longer. I am getting pressure from above to find another platform and the thought of migrating gives me chest pains.....
#ReportingandInsights
------------------------------
Julia Shellhouse
Administration Manager
Lean Construction Institute
------------------------------