Connectors

/

DonorPerfect

/

DonorPerfect donor giving and NetSuite receivables profile
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
DonorPerfect donor giving and NetSuite receivables profile
Build a profile for DonorPerfect donor 10482 with their NetSuite billing.
Donor 10482, Contoso Foundation, has 14 gifts and one open pledge, and one open NetSuite invoice for the same amount. - Giving: 14 gifts, 25,000.00 total, last gift 2026-08-30 - Open pledge: 5,000.00 balance - NetSuite: customer balance 5,000.00, invoice INV-1042 open for 5,000.00 - Recent payments: 2 payments, latest 2026-09-02 Want the recent gifts listed?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-donor
donorperfect-get-gift
netsuite-get-customer
netsuite-get-invoice
netsuite-get-customerpayment

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

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.

Prompt
**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.

Your AI tool

02

Giving

It reads the donor summary, recent gifts and open pledges from DonorPerfect.

donorperfect-get-donor
donorperfect-get-gift

03

Billing

It finds the NetSuite customer by email and reads open invoices and payments.

netsuite-get-customer
netsuite-get-invoice
netsuite-get-customerpayment

04

Report

You get one profile, ending with whether pledges and invoices look like the same obligation.

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-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.
get-data

netsuite-get-customer

Returns NetSuite customers read from the NetSuite connector, with the fields people use most. Read-only.
get-data

netsuite-get-invoice

Returns NetSuite invoices read from the NetSuite connector, with the fields people use most. Read-only.
get-data

netsuite-get-customerpayment

Returns NetSuite customer payments read from the NetSuite connector, with the fields people use most. Read-only.
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

Giving, pledges and receivables in one profile

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