Connectors

/

DonorPerfect

/

DonorPerfect expiring payment methods audit
Report

Reach donors before their stored card expires

For finance and donor care teams who want expiring DonorPerfect payment methods found and prioritized, by asking their AI assistant.

Try PopdockAI free
Get a live demo
DonorPerfect expiring payment methods audit
Which donors have stored cards expiring before the end of December in DonorPerfect?
23 stored payment methods expire by 2026-12-31, and 9 are urgent. - Urgent: Jordan Lee, card ending 4242, expires 2026-10, open pledge 1,800 - Call needed: 2 urgent donors have no email on file - Routine: 14 cards with no open pledge Want the full urgent list to start outreach?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-payment-method
donorperfect-get-donor
donorperfect-get-gift

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

DonorPerfect

DonorPerfect
Run it on your own DonorPerfect data.

Connect DonorPerfect, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

The first sign of an expired card is a failed instalment

Stored donor cards expire quietly, and the first sign is a failed pledge instalment. Finding them means filtering payment methods by expiry, looking up each donor and checking who still has a pledge billing against that card.

Without PopdockAI

  • Filter payment methods by expiry date
  • Look up each donor by hand
  • Check for open pledges one by one
  • Learn about it from a failed payment

With PopdockAI

  • Cards expiring by your cutoff are listed
  • Each donor's name and email are resolved
  • Open pledges and default cards mark donors as urgent
  • Only the last four digits are shown, nothing is updated

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find stored payment methods expiring on or before `{expires-before-date}` and work out which donors need contacting, prioritising anyone with a pledge still billing. This is read-only.

**Step 1: Pull the expiring methods**

Call `donorperfect-get-payment-method` with `card-expiration-date.to` set to `{expires-before-date}` (default three months from today if blank). Set `max-records` high enough to see the whole set and say what you used.

If nothing comes back, report that no stored methods expire in the window and stop.

**Step 2: Resolve the donors**

For each distinct `donor-id`, call `donorperfect-get-donor` filtered by `donor-id` to get the name, email, city and state.

**Step 3: Find out who is still billing**

For each donor, call `donorperfect-get-gift` filtered by `donor-id`. Identify pledge rows with an outstanding `balance`. A donor with an open pledge and an expiring card will fail their next instalment, and that is the whole point of this audit.

**Step 4: Report**

A table sorted by expiry date, soonest first: donor name, donor id, payment method type, last four, expiry date, whether it is the default method, open pledge balance, email.

Then two groups:

* **Urgent** - an open pledge balance, or the expiring card is the default method
* **Routine** - everyone else

For the urgent group, note which donors have no email on file, since those need a call rather than a mailing.

**Rules & Guidelines:**

* Read-only. Do not call any save tool, and do not attempt to update a card.
* Report only the last four digits and the expiry date. Never repeat, reconstruct or guess at a full card number or bank account number, even if a field appears to contain one.
* Do not draft the message to the donor unless the user asks for it.

**Validation:**

* If `{expires-before-date}` is not a clear date, state the window you used.
* If a payment method has no donor id, list it separately as unlinked rather than dropping it.

Who it's for

One answer, three teams that use it

Gift processors

Update cards before they fail

A prioritised list tells you who to contact first.

Which stored cards in DonorPerfect expire in the next 60 days?

Recurring giving managers

Protect monthly income

Donors with open pledges on an expiring card are marked urgent.

Which donors with open pledges have cards expiring before March in DonorPerfect?

Donor services

Know who needs a call

Urgent donors with no email are marked for a phone call.

List urgent expiring cards in DonorPerfect where the donor has no email on file.

How it works

What PopdockAI does when you ask

You give a cutoff date and your AI assistant lists expiring DonorPerfect cards with the donors most at risk first. It only reads.

01

Ask

You give a cutoff date, or use three months ahead.

Your AI tool

02

Read

It lists stored payment methods expiring by then and resolves each donor.

donorperfect-get-payment-method
donorperfect-get-donor

03

Check

It looks for pledges with an outstanding balance on each donor.

donorperfect-get-gift

04

Report

You get urgent and routine lists sorted by expiry, showing the last four digits only.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for DonorPerfect and one secure connection to your AI tool. No code, no exports.

get-data

donorperfect-get-payment-method

Returns the payment methods stored against donors in DonorPerfect, including card type and expiry, which is what an expiring-card audit runs on.
get-data

donorperfect-get-donor

Returns donor records from DonorPerfect: names, salutations, contact details, donor type and status, and the codes used to segment them. The starting point for almost any DonorPerfect question.
get-data

donorperfect-get-gift

Returns gift and pledge transactions from DonorPerfect, with amount, date, campaign, solicitation and GL codes, and the donor each one belongs to. Filter by donor, by date range or by campaign to build giving history and campaign totals.
Read only.Nothing in DonorPerfect Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Donors reached before their card fails

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation