How to Find Pledges That Need a Follow-Up
The pledge list says a payment is overdue. A gift arrived last week under a slightly different name. Check the gift reference before sending a reminder.
What to pull
Use Excel pledges and gift logs or export installment schedules and gift allocations from your fundraising system. Keep donor or household ID, pledge ID, due date and allocation.
How to check it
Match by pledge reference and account for partial payments and revised schedules. Flag uncertain matches separately, especially where one gift could cover multiple pledges.
Select the relevant sheets in Jolene.pro and run this check.
Which installments are due and still unmatched? Show due dates, partial payments and source rows.
What to do with the result
Give the fundraiser the confirmed follow-up list. Route ambiguous gifts to donor services before contacting anyone.
Use authorized donor records and confirm pledge terms before outreach.