PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Best Way to Audit Transactions

  1. 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 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 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 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, 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?)

    Posted 11 years ago on Tuesday December 11, 2012 | Permalink
  2. I will bring this to the attention of the development team to see if they have any ideas for you.

    Posted 11 years ago on Wednesday December 12, 2012 | Permalink