/
/
Match DonorPerfect gifts to NetSuite receipts
For nonprofit finance teams who want to tie a donor's gifts to NetSuite payments and deposits by asking their AI assistant.
On this page
Connector
Connect DonorPerfect, pick your AI tool and paste the prompt.
The problem
Missing receipts surface only at audit
A gift in DonorPerfect should show up in NetSuite as a payment or deposit on the same donor, but finance compares the lists by hand. Missing receipts, differing amounts and pledges get mixed together until an audit.
Without PopdockAI
- Export the donor's gifts
- Find the NetSuite customer
- Compare payments and deposits by eye
- Count pledges as missing cash
With PopdockAI
- The donor's gifts and email are read
- The single NetSuite customer is found by email
- Gifts pair with receipts of the same amount within 5 days
- Pledges skipped, gaps and totals listed, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For donor `{donor-id}`, compare gifts in DonorPerfect from `{date-from}` to `{date-to}` with customer payments and deposits in NetSuite and report what does not line up.
**Step 1: Read the gifts (DonorPerfect)**
Call `donorperfect-get-gift` with `donor-id` = `{donor-id}`, `gift-date.from` = `{date-from}` and `gift-date.to` = `{date-to}`. Call `donorperfect-get-donor` with the same donor id for the email. If there are no gifts, say so and stop.
**Step 2: Find the customer (NetSuite)**
Call `netsuite-get-customer` with `email` set to the donor's email. If there is not exactly one match, report that and stop.
**Step 3: Read the receipts (NetSuite)**
Using the customer `internal-id` as `customer-id`, call `netsuite-get-customerpayment` and `netsuite-get-customerdeposit` with `date.from` = `{date-from}` and `date.to` = `{date-to}`.
**Step 4: Match and report**
Pair each gift with a payment or deposit on equal amount (`amount` vs `total`) and a date within 5 days. Report: matched pairs, gifts with no NetSuite receipt, NetSuite receipts with no gift, and the total on each side with the difference. Skip gifts whose `gift-type` is a pledge; they are not cash.
**Rules & Guidelines:**
* `donorperfect-get-gift` and `donorperfect-get-donor` are on the donorperfect server; the `netsuite-get-customer`, `netsuite-get-customerpayment` and `netsuite-get-customerdeposit` tools are on the netsuite server.
* Read-only. Do not call any `donorperfect-save-*` tool, `donorperfect-set-flag`, or any `netsuite-add-*` or `netsuite-update-*` tool. Never change either system.
**Validation:**
* Dates default to the last 90 days when `{date-from}` or `{date-to}` is empty.
* If amounts match but dates differ by more than 5 days, report them as a date mismatch rather than unmatched.Who it's for
One answer, three teams that use it
Nonprofit accountants
Find gifts with no receipt
Unmatched gifts and receipts are listed with totals on each side.
Compare DonorPerfect donor 30122's gifts this year with their NetSuite payments and deposits.
Auditors
Test a donor's giving trail
Matched pairs show where each gift landed.
Pair the gifts for donor 51007 from Q2 with NetSuite receipts.
Donor services
Answer did you get my gift
See quickly whether a gift has a matching receipt.
Did the October gifts from DonorPerfect donor 22014 reach NetSuite?
How it works
What PopdockAI does when you ask
You give a donor and a date range and your AI assistant pairs DonorPerfect gifts with NetSuite payments and deposits. It only reads and stops if the customer match is not exact.
01
Ask
You give a donor ID and a date range.
02
Read
It reads the donor's gifts and email in DonorPerfect.
03
Match
It finds the single NetSuite customer by email and pairs gifts with payments or deposits on amount and date.
04
Report
It lists matched pairs, gaps and totals, and skips pledges.
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.
donorperfect-get-gift
donorperfect-get-donor
netsuite-get-customer
netsuite-get-customerpayment
netsuite-get-customerdeposit
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.
The outcome
Every gift without a receipt, found
Related use cases
More ways to put this data to work
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.

.webp)
