We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software. A key piece of data from that report is the 'Credit Account' column since that tells our accounting software which fund the donation should go to.
We've recently started testing Recurring Contributions. The contributions themselves are being processed correctly via iATS (we've done credit cards only thus far). However, we did our first accounting batch export with recurring contributions yesterday, and the Credit Account column is blank for all subsequent recurring contributions. The one-time donations and the initial recurring contribution for a contact show the Credit Account correctly.
After looking through the database to see where the disconnect might be, it appears that recurring contributions are not creating records in the
civicrm_financial_item table. I can track/match a completed recurring contribution through the
civicrm_line_item tables. The
civicrm_entity_financial_trxn table has the recurring transaction records with
civicrm_contribution in the
entity_table column, but that table does not have a corresponding record for the transaction with
civicrm_financial_item in the
I found iATS Github Issue 134, but that was specifically asking about Civi 4.7, so I don't know if the same issue would apply (I'm going to cross post there as well). I also don't know if I might have setup things incorrectly in the backend for accounting, so that's a possibility as well (and I'm not sure what to look for there).
According to CiviAccounts Data Flow:
IPN payment processors processing a contribution do NOT create civicrm_financial_item, civicrm_financial_trxn, or civicrm_entity_financial_trxn records at the time the transaction is posted to the payment processor. They are only created at the time of the IPN call back.
Since iATS doesn't use IPN, I didn't know if that might be the reason for the lack of records in the
civicrm_financial_item table. The other tables in the above quote have records for subsequent recurring contributions, so I'm not sure if this applies to iATS.
For the sake of our Accounting Export, I don't see a way in the database to get the Credit Account for a contribution (
civicrm_financial_account.accounting_code) for a recurring contribution without a record in the
Does anyone knows how to either a) correct the recurring contributions not ending up in
civicrm_financial_item table or b) how to query the database to get the Credit Account without the financial item record? I'd sure appreciate the help!
Civi 4.6.14 (will be updating to 4.6.20 before go-live); Drupal 7.44; iATS Payments extension 1.5.3