Connectors

/

DonorPerfect

/

Reconcile DonorPerfect gifts to NetSuite receipts
Read
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile DonorPerfect gifts to NetSuite receipts
Compare the gifts for DonorPerfect donor 48213 from 1 July to 30 September with their NetSuite payments and deposits.
4 of 5 cash gifts for donor 48213 have a NetSuite receipt. - Matched: 4 gifts, 1,900.00 in total - No NetSuite receipt: gift of 500.00 on 14 Aug - Receipts with no gift: none - Difference: DonorPerfect 2,400.00, NetSuite 1,900.00 Shall I also list the matched pairs with their dates?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-gift
donorperfect-get-donor
netsuite-get-customer
netsuite-get-customerpayment
netsuite-get-customerdeposit

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

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.

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

Your AI tool

02

Read

It reads the donor's gifts and email in DonorPerfect.

donorperfect-get-gift
donorperfect-get-donor

03

Match

It finds the single NetSuite customer by email and pairs gifts with payments or deposits on amount and date.

netsuite-get-customer
netsuite-get-customerpayment
netsuite-get-customerdeposit

04

Report

It lists matched pairs, gaps and totals, and skips pledges.

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-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

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

netsuite-get-customer

Returns NetSuite customers 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.
get-data

netsuite-get-customerdeposit

Returns NetSuite customer deposits 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

Every gift without a receipt, found

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