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?

Improve this question
2
  • 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
    Commented Jun 28, 2017 at 23:42
  • Up-voted because of your video demo. Wow!
    – Sean
    Commented Aug 31, 2017 at 1:46

1 Answer 1

Reset to default
1

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.

Improve this answer
1
  • 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
    Commented Sep 7, 2017 at 3:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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