So, my finance department has a dilemma. We need a way to audit all of the transactions in bulk. We take donations all year long. Some are one-time donations and some are repeating donations (set up as ARB with authorize.net). But, those donations have custom information associated with them (to support a particular person or program).
Exporting from GF entries works fine for the one-time donations, but I can't extract the individual transactions from the subscriptions (the subsequent charges show up as added notes on that one entry). Exporting from authorize.net works great for amounts, but I can't pass enough metadata to identify which donations went to which person or program.
We came up with the idea of a reconciling those two exports with some fancy Excel work, but that's still not enough since the only way to reconcile those transactions is with the authorize.net transaction ID. But, GF subscriptions don't record the initial transaction ID and subsequent transactions IDs are stored in the notes and are not exportable. So, those can only be reconciled manually (not a scalable process).
So, any ideas on how to get a clean list of all charges with the metadata to identify which account we should credit them to?
BTW, while it would be spiffy to be able to transfer more metadata to authorize.net, it's not clear to me that those custom fields would be included when the data is exported from their portal.
Any suggestions would be much appreciated. (Have we outgrown GF?)