/
/
One donor profile from DonorPerfect and NetSuite
For development and finance leaders who want a donor's giving and billing in one view, just by asking their AI assistant.
On this page
Connector
Connect DonorPerfect, pick your AI tool and paste the prompt.
The problem
Is that open pledge the same as the open invoice
Preparing for a donor conversation means opening DonorPerfect for gifts and pledges and NetSuite for invoices and payments. Then you have to guess whether an open pledge and an open invoice are the same obligation.
Without PopdockAI
- Look up gifts and pledges in DonorPerfect
- Find the customer in NetSuite
- Read invoices and payments separately
- Guess whether pledge and invoice overlap
With PopdockAI
- Giving summary, recent gifts and open pledges are read
- The NetSuite customer is found by email
- Open invoices, balance and recent payments are added
- One line on whether they look like the same obligation, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a combined profile for donor `{donor-id}`: giving in DonorPerfect, and billing and open balance in NetSuite.
**Step 1: Donor and giving (DonorPerfect)**
Call `donorperfect-get-donor` with `donor-id` = `{donor-id}` for gift count, `gift-total`, `year-to-date` and last contribution. Call `donorperfect-get-gift` with the same `donor-id` and list the most recent `{gift-limit}` gifts (default 10) using `max-records`. Note any gift with a `balance` above zero (an open pledge).
**Step 2: Customer (NetSuite)**
Call `netsuite-get-customer` with `email` from the donor. If there is not exactly one match, say so and report only the DonorPerfect side.
**Step 3: Billing (NetSuite)**
With the customer `internal-id` as `customer-id`, call `netsuite-get-invoice` with `unpaid-amount.min` = 0.01 to list open invoices, and `netsuite-get-customerpayment` for recent payments.
**Step 4: Report**
Sections: Donor summary, Recent gifts, Open pledges, NetSuite customer balance, Open invoices (number, date, total, unpaid), Recent payments. Finish with one line saying whether open pledges and open invoices look like the same obligation (same amount) or separate.
**Rules & Guidelines:**
* `donorperfect-get-donor` and `donorperfect-get-gift` are on the donorperfect server; `netsuite-get-customer`, `netsuite-get-invoice` and `netsuite-get-customerpayment` 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:**
* If the donor is not found, stop.
* If no customer matches, say the donor has no NetSuite customer and still show the DonorPerfect sections.Who it's for
One answer, three teams that use it
Executive directors
Meet a donor fully informed
Know what they gave, what they pledged and what they owe.
Profile DonorPerfect donor 22051 with their NetSuite balance before my lunch meeting.
Finance managers
Avoid chasing the same money twice
A clear line on whether a pledge and an invoice are the same obligation.
Does donor 18840 have an open pledge in DonorPerfect that matches an open NetSuite invoice?
Development directors
Coordinate fundraising and billing
See recent gifts next to payments in one view.
Show the last 10 gifts and NetSuite payments for DonorPerfect donor 30012.
How it works
What PopdockAI does when you ask
You give a donor ID and your AI assistant combines DonorPerfect giving with NetSuite receivables. It only reads, and reports one side only if the customer match is not exact.
01
Ask
You give a donor ID and optionally how many recent gifts to show.
02
Giving
It reads the donor summary, recent gifts and open pledges from DonorPerfect.
03
Billing
It finds the NetSuite customer by email and reads open invoices and payments.
04
Report
You get one profile, ending with whether pledges and invoices look like the same obligation.
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-donor
donorperfect-get-gift
netsuite-get-customer
netsuite-get-invoice
netsuite-get-customerpayment
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
Giving, pledges and receivables in one profile
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)
