Split Journal Entry for Donor Covered Fees

The idea is to split the journal entries when a donor selects to pay for fees. Ex: instead of a journal entry showing $518.45 as one entry, show a split of $500.00 and $18.45. With the current process, my organization has to delete and recreate journal entries when a donor pays the fees, as the fee payment was not part of their initial donation and we want to keep our records clean.

This is especially helpful to not inflate payment amounts and when reviewing revenues, especially when the journal entry is for a payment. Ex: the sponsorship was not for $518.45, it was for $500, and we do not want to recognize the fees as part of their sponsorship when it is a fee payment and in two different buckets.

  • Guest
  • Apr 25 2023
  • Attach files
  • Betsy Rubenstein commented
    09 Apr 17:06

    Another year of begging for this functionality. We just ran an event, $125k raised, plus fees on top, all done via a DIY form. I had to export all of the campaign's data, duplicate the account information to create a second line for fees covered for each transaction, then go through and adjust all of the transaction totals and label with the correct campaign, to then import everything as two separate transactions, since I can't import split transactions. Before I imported everything, I had to change all of the original transactions to a different campaign so that they didn't get double counted, and now I'm running a report and manually deleting 749 transactions because they are duplicate information and I can't mass delete. And I'm losing my payment processing and donor covered fees flags. If not this, then please add the ability to split a transaction after it's been entered!

  • Admin
    Kimberly Hammer commented
    May 30, 2023 17:03

    Thank you for providing this clarity Betsy.

    At this time we are planning to add more flexibility for reporting on donor covered fees, but that won't include the ability for these transactions to come in as split gifts. I'm going to change the status from "Planned" to "Future Consideration" so we can continue to collect votes and feedback.

  • Betsy Rubenstein commented
    May 24, 2023 18:06

    Kimberly, IF that split is also shown on the transaction page, and the campaign is not for the total amount of the received but the original transaction amount, then it should work for us. The issue is that we need to split the fees out of the original campaign into a separate "fees covered" campaign. It's more than just a view on the journal or a report.

  • Admin
    Kimberly Hammer commented
    May 24, 2023 17:49

    Here's a screenshot of what we were thinking, the ability to report on Donor Cover Fees, and the Received Amount (minus the fees) on Reports, Query Preview, Journal pages.

    Could this meet your needs?

  • Betsy Rubenstein commented
    May 24, 2023 16:17

    Kimberly, no, just seeing this on a report isn't helpful, if I'm understanding what you're suggesting, because the fees covered don't apply to the campaign on which they were covered. We use a different campaign for each of our annual events, and I need to split the fees which were covered out so that it doesn't affect our event totals. The same with our Annual Giving - our HQ doesn't count fees covered as a donation towards our Annual Giving. If I don't split the fees out of the transaction, my home page tiles will be inaccurate and not match reporting, yes?

  • Admin
    Kimberly Hammer commented
    May 24, 2023 14:34

    We're thinking of making it possible to report on the Donor Cover Fees Amount and the Received - Donor Cover Fees Amount. Would offering this level of detail in reports eliminate the need to enter the transaction as a split gift?

  • Danelle Slater commented
    May 09, 2023 22:49

    I just use a Split Transaction and setup a Fund name Processing Fees, that way you can pull them out you if need to.