Connectors

/

DonorPerfect

/

Trace a DonorPerfect gift into Intacct
Read
Cross-Connector

Show exactly where a gift landed in Sage Intacct

For finance teams and auditors who need to trace one DonorPerfect gift into Sage Intacct, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace a DonorPerfect gift into Intacct
Trace DonorPerfect gift 88213 into Sage Intacct for our auditors.
Gift 88213, 750 from Jordan Lee on 2026-08-14, is confirmed in Sage Intacct. - Account: 4100 General Fund contributions - Confirmed: deposit on 2026-08-15 with check 4471 - Possible: 1 other receipt of 750 on 2026-08-16 Want the details of the possible match too?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-gift
donorperfect-get-donor
donorperfect-get-code
sage-intacct-get-account
sage-intacct-get-ar-payment
sage-intacct-get-general-ledger-detail
sage-intacct-get-other-receipt
sage-intacct-get-other-receipt-line

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

One gift that is surprisingly hard to find in the ledger

When a donor asks whether a gift arrived, or an auditor picks one to test, someone has to search Sage Intacct for a matching receipt, payment or entry. Batch deposits and mismatched check numbers make one gift hard to find.

Without PopdockAI

  • Look up the gift and its GL code
  • Search Intacct by check number
  • Scan ledger rows around the date
  • Guess whether a batch deposit includes it

With PopdockAI

  • The gift and donor are read, soft credits and pledges explained
  • The GL code is mapped to its Sage Intacct account
  • Check reference, ledger amount and receipts are searched
  • Hits graded confirmed or possible, 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:** Trace DonorPerfect gift {gift-id} into Sage Intacct and report every place it appears, searching {date-window-days} days either side of the gift date (default 5).

**Step 1: Read the gift in DonorPerfect**

Call `donorperfect-get-gift` with `gift-id` {gift-id}. If nothing comes back, say the gift does not exist and stop. Note `amount`, `gift-date`, `gl-code`, `gift-type`, `reference` (often the check number), `record-type`, `pledge-payment` and `donor-id`. Call `donorperfect-get-donor` with that `donor-id` for the donor's name or organization name.

* If `record-type` is S (a soft credit), say it carries no money, so there is nothing to trace, and stop.
* If `record-type` is P (a pledge), say it is a commitment rather than cash: it appears in Intacct only if the organization books pledges, so search as below but expect no receipt.

**Step 2: Find the Intacct account**

Call `donorperfect-get-code` with `field-name` GL_CODE and `code` set to the GL code (if that returns nothing, call it with `code` alone and use the row from the GL code list). Its `account-number` is DonorPerfect's own mapping of that GL code to the accounting system. Confirm the account with `intacct-get-account` filtered by `account-number`. If `account-number` is blank, try the GL code itself as the Intacct account number. If neither exists in Intacct, say the GL code is not mapped and run Step 3 without the account filter.

**Step 3: Search Intacct around the gift date**

Search in this order and stop at the first confirmed match:

1. If the gift has a `reference`, call `intacct-get-ar-payment` with `document-or-check-number` set to it.
2. Call `intacct-get-general-ledger-detail` with `account-number`, `entry-date.from` and `entry-date.to` spanning the window, and `amount.min` and `amount.max` both set to the gift amount. Rows repeat once per reporting method, so filter `reporting-method` to one method (accrual unless the user says otherwise). If you are unsure of the exact value, call once without it, read the values the rows carry, then filter. If this returns nothing, repeat without the amount filters and look for the amount in `credit-amount` yourself.
3. Call `intacct-get-other-receipt` with `transaction-date.from` and `transaction-date.to` spanning the window and `total-base-amount.min` and `total-base-amount.max` set to the amount. For each hit, call `intacct-get-other-receipt-line` with its `record-number` as `receipt-record-number` to see which account it credited.

A match is Confirmed when the amount agrees and the payer, customer name, memo or document number matches the donor's name or the gift's reference. It is Possible when only the amount agrees.

If nothing matches, the organization may deposit gifts in batches. List the rows from step 2 (without amount filters) that are larger than the gift, as possible batches that could contain it.

**Step 4: Report**

A gift summary (id, donor, date, amount, GL code, reference, record type) and the mapped Intacct account. Then each Intacct match: the tool it came from, date, amount, document or transaction number, account, payer, and Confirmed or Possible. If nothing matched, say the gift is recorded in DonorPerfect but was not found in Intacct in the window, and suggest widening the window.

**Rules & Guidelines:**

* Tools whose names start with donorperfect- are on the donorperfect server; tools whose names start with intacct- are on the intacct server. If either set is missing from your tool list, stop and say which server is not connected.
* This prompt is read-only. Do not call `donorperfect-save-gift`, `intacct-create-journal-entry` or any other save, create or update tool on either server.
* Pass dates to both servers as YYYY-MM-DD.

**Validation:**

* If more than one Confirmed match appears, list them all and say which one is most likely and why; do not pick one silently.
* The two systems may store amounts at different precision: treat a difference of a cent or less as equal.
* Never report a Possible match as Confirmed.

Who it's for

One answer, three teams that use it

Auditors

Test a sample gift quickly

Each hit is graded, with batch deposits suggested when nothing matches.

Trace DonorPerfect gift 77104 into Sage Intacct within 7 days.

Donor services

Answer did my gift arrive

Confirm where a donor's gift landed while they are on the phone.

Was Sam Patel's October 12 gift, DonorPerfect gift 90233, received in Intacct?

Nonprofit accountants

Find a gift inside a batch deposit

Larger rows that could be batch deposits are listed when there is no direct match.

Find DonorPerfect gift 65012 in Sage Intacct, it may be part of a deposit.

How it works

What PopdockAI does when you ask

You give a gift id and your AI assistant traces it into Sage Intacct around the gift date. It only reads and never reports a possible match as confirmed.

01

Ask

You give a DonorPerfect gift id and a window, 5 days by default.

Your AI tool

02

Read

It reads the gift and donor and maps the GL code to its Sage Intacct account.

donorperfect-get-gift
donorperfect-get-donor
donorperfect-get-code
sage-intacct-get-account

03

Search

It searches by check reference, ledger amount and receipts around the date.

sage-intacct-get-ar-payment
sage-intacct-get-general-ledger-detail
sage-intacct-get-other-receipt
sage-intacct-get-other-receipt-line

04

Report

Each hit is graded confirmed or possible, with batch deposits suggested if nothing matches.

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

donorperfect-get-code

Returns the configuration code values behind DonorPerfect's drop-down fields, such as campaign, solicitation, gift type and GL codes. Use it to validate a code before writing a gift, pledge or donor record.
get-data

sage-intacct-get-account

Returns accounts from Sage Intacct. One row per general ledger account.
get-data

sage-intacct-get-ar-payment

Returns AR payments from Sage Intacct.
get-data

sage-intacct-get-general-ledger-detail

Returns general ledger details from Sage Intacct. One row per posted GL entry. Rows repeat per reporting method (for example accrual and cash), so filter by reporting method before totalling.
get-data

sage-intacct-get-other-receipt

Returns other receipts from Sage Intacct. The record-number links to the Get other receipt lines tool.
get-data

sage-intacct-get-other-receipt-line

Returns other receipt lines from Sage Intacct. Filter by receipt record number (the record-number from Get other receipts) to get one receipt's lines.
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

Show exactly where a gift landed

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