4

I ran into an issue the other day on a client site with how transactions with fees show up in batches. I wanted to be sure it wasn't unique to their instance so I deployed a fresh CiviCRM 4.7.20 instance to test it out. It appears related to this ticket. What happens is that when you enter a transaction with a fee it shows in the batch as two separate transactions. One for the full (not net) amount of the transaction and one for the fee amount. Meaning that the batch total is more than the actual cash received. I've created a short video demonstrating it here. Am I doing something wrong here or is this just a bug?

  • 1
    I have the same issue on my install. It was happening on 4.7.17 and i just upgraded to .20 and it's still happening. You would think that one of 2 things would happen. 1) Add the 35.00 transaction to a batch and it would include the .35 fee that woudl get assigned to an expense category or 2) include the 35 transaction and the .35 fee and the fee line item would associate with the bank fee financial account thus giving you the correct amount. – frTommy Jun 28 '17 at 23:42
  • Up-voted because of your video demo. Wow! – Sean Colsen Aug 31 '17 at 1:46
2

The current batch total in CiviCRM is confusing as it is summing the amounts for all of the bookkeeping entries in the batch, NOT the total payments received for the contributions included or the total expected revenue from them.

To see this clearly, if you edit a contribution and change most fields this results in reversing and reposting a corrected copy of the transaction. Putting all of the relevant bookkeeping transactions into a batch results in a 'batch total' significantly larger than the contribution, even if you haven't changed the contribution amount.

We're finalizing (Sep 2017) some new functionality in core and extensions that will allow some batches to be used to more easily track batches of payments, and other ones to deal with non-payment bookkeeping entries.

  • Thanks for the explanation. Doesn't 100% answer my question but I'm looking forward to see what ~Sep 2017 functionality has to offer. – Nathan Porter Sep 7 '17 at 3:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.