Apply Gift to Pledge

We have several gifts that were not entered as pledge payments and have been posted. Is there a way to adjust to the gifts and apply them to the pledge balance?

Answers

  • Unfortunately not. You'll need to either adjust the gift to zero, reenter it, apply to the pledge and then post it again. Or, alternatively, adjust the pledge amount down by the amount of the gift with a note that it is to reflect a gift that was not properly applied to it.

  • Not sure if you are in NXT or RE, however, in Raiser's Edge database view:

    —Open the gift box/transaction

    —Click on Gift at the top of the screen

    —Select Apply To from the drop-down list

    —Select Pledge or Recurring

    —Select the pledge payment is to be applied to

    —Enter Payment amount in box where indicated and then enter Amount Applied in Blue Space

    —Click on ok

  • This only works while the gift is not posted to the GL (i.e. GL Post Status is "Not Posted")

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    Tatyana is right about cannot be done. A gift that has "posted" GL Post Status cannot have its gift type be changed from "Cash" to "Pay-Cash".

    Another option is to "unpost" the cash gift (require manual change to GL affected), then apply as payment. I wouldn't recommend it though. I prefer adjust cash to $0, reenter new "cash" gift and apply to pledge.

  • Karen Diener
    Karen Diener Community All-Star
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    The answer is here, but exists in a couple of different responses. All of the work will be done in database view - I don't believe that any of these steps can be completed in webview.

    Unpost the gifts first using a plug-in in database view. Create a query of the gifts that need to be changed, and look for the UnPost Gifts utility under PlugIns on the blue bar on the right of your screen.

    I would highly recommend that this be a static query, and that you export data ahead of time because you will need to do an import to change the gifts back to "Posted". At a minimum, you will need the Gift Import ID, Post Date and Post status if I recall.

    Once the gifts are unposted, you will need to manually update each one as explained by @Beverly Day-Robinson.

    After that, import the correct post date and post status back to the gifts. The reason you want to do this via import is that if you change the post status to "Posted", the current date will be populated in the Post Date field, and not the original date of the posting.

    This doesn't, of course, address any changes that might be important for you to communicate to Finance. Even if you do not use FE, your finance department may categorize pledge payments to a different line item than Cash gifts.

    Also note that I am intentionally a little bit vague about some steps for a couple of reasons. I don't know your organization's policies is the first. Secondly, I like to point people in the right direction and give them an overview of the steps, but not do their work for them.

    I hope this gives you the guidance you need!

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply

    As mentioned unpost plug-in could be used as option - but use with extreme caution. You must have your gift in a gift query and select that query. If you hit the icon on the right without the query it will start unposting every gift in your database!!!!

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 bbcon 2025 Attendee Badge
    edited September 22

    And it will unpost your entire database with no warning in 3 min or less! The last time this happened me it took me a collective 10 hours to fix! 😬TRIPLE check you have a query listed, use a static query like Karen suggests - I usually take a screenshot so I have something to look at while it runs… always a bit paranoid about this plug-in.