Provide a query field linking a pledge payment to a specific pledge

I’m continually frustrated by the fact that Raisers Edge does not have a way to link pledges and their pledge payments through a standard query. Blackbaud recommends a multi-step process of creating a Pledge Payment import file: https://kb.blackbaud.com/knowledgebase/Article/75198.


A more intuitive process would be to assign each pledge a Pledge identifier, and attach that pledge identifier to each pledge payment and scheduled installment. That pledge identifier could then be available for queries in the gift record for each pledge transaction and for each Pay-Cash, etc. transaction, adjustment and writeoff transaction, so that a report by pledge identifier could be produced to show pledges, pledge payments, writeoffs, remaining payments and balance due by individual pledge.


This would allow us to produce much more informative pledge reminders and pledge histories when researching individual pledges, and help us immensely in managing our pledge receivables. We have donors making multiple pledges to multiple funds with schedules that overlap in time, so we and our donors would benefit from the ability to produce detailed payment data for individual pledges.



  • Guest
  • Nov 30 2023
  • Reviewed: Voting Open
  • Attach files
  • Thomas DeMerit commented
    10 Jun 21:48

    We need the same for Write-offs, as well. Notably, the SKY API simply ignores that a Write-Off transaction exists. So, we're looking to NXT query to supplement and it comes-up short. It's maddening, because the NXT UI proves that the Link value exists inside the system, just not exposed to, ya know, those who work with data outside RE.

  • Catherine Burns commented
    June 10, 2025 22:03

    We need the same for recurring gifts too.