Connectors

/

DonorPerfect

/

Reconcile DonorPerfect gift revenue to the Dynamics 365 Business Central GL
Report
Cross-Connector

Reconcile DonorPerfect gift revenue to Business Central in one pass

For nonprofit accountants closing the month who want gift revenue tied out to the Business Central GL, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile DonorPerfect gift revenue to the Dynamics 365 Business Central GL
Reconcile September 2026 DonorPerfect gift revenue to the Business Central general ledger.
5 of 7 GL codes agree for September 2026, and 2 have differences. - 4100 General Fund: DonorPerfect 42,300, Business Central 41,800, 500 short - 4200 Events: DonorPerfect 8,750, Business Central 9,250, 500 over - Likely match: a 500 gift appears posted to 4200 instead of 4100 Want the gifts and entries behind each difference?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-gift

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

Month-end gift reconciliation chased item by item

Proving DonorPerfect gift revenue matches the Business Central ledger means totalling gifts by code, pulling posted entries and chasing every difference. Pledges and soft credits make totals look wrong even when they are not.

Without PopdockAI

  • Total gifts by GL code in a spreadsheet
  • Pull ledger entries for each account
  • Strip out pledges and soft credits by hand
  • Chase differences one item at a time

With PopdockAI

  • Cash gifts are totalled per code, pledges and soft credits excluded
  • Net credits are summed per account, reversals ignored
  • Codes with no account or postings are named
  • Items behind the three largest differences 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 gifts dated `{from-date}` to `{to-date}`, compare what DonorPerfect recorded per GL code with what Business Central posted to the matching G/L account, and report every difference. If `{gl-code}` is given, reconcile only that code. If `{company}` is given, pass it as `company` on every Business Central call.

**Step 1: Total the gifts in DonorPerfect**

Call `donorperfect-get-gift` with `gift-date.from` = `{from-date}` and `gift-date.to` = `{to-date}` (and `gl-code` = `{gl-code}` when given). Raise `max-records` until the result stops growing.

Count only cash gifts: record type G, which includes pledge payments. Exclude pledge headers (record type P), because a pledge is a promise and posts nothing to the ledger, and exclude soft credits (record type S), because they duplicate a gift already counted under another donor. If other record-type values appear, list them and ask the user whether to include them before totalling.

Group the remaining gifts by `gl-code` and sum `amount`. Keep the gift count per code. Gifts with a blank `gl-code` go in their own "No GL code" row.

**Step 2: Total the postings in Business Central**

For each GL code from Step 1, call `business-central-get-general-ledger-entry` with `gl-account-number` = that code, `posting-date.from` = `{from-date}` and `posting-date.to` = `{to-date}`. Revenue posts as a credit, so the comparable figure is the sum of `credit-amount` minus the sum of `debit-amount`. Leave out rows where `reversed` is true.

If a GL code returns no entries, call `business-central-get-account` with `account-number` = that code. If the account does not exist, report "no such G/L account in Business Central". If it exists, report "nothing posted in the period".

**Step 3: Report**

A table with one row per GL code: GL code, G/L account name (from `business-central-get-account`), DonorPerfect gift count, DonorPerfect total, Business Central net credits, difference (DonorPerfect minus Business Central). Sort by the absolute difference, largest first, and mark any row where the difference is not zero.

Below the table, for the three largest differences, list the DonorPerfect gifts (`gift-id`, `gift-date`, `donor-id`, `amount`) and the Business Central entries (`entry-number`, `posting-date`, `document-number`, `description`, net amount) so the user can see which side is missing what. Treat a gift and an entry with the same amount within 5 days of each other as a likely match and say so.

**Rules & Guidelines:**

* `donorperfect-get-gift` is on the donorperfect server. `business-central-get-general-ledger-entry` and `business-central-get-account` are on the business-central server.
* This prompt is read-only. Do not call `donorperfect-save-gift`, `business-central-create-journal-line`, `business-central-update-journal-line` or any other save, create or update tool on either server.
* Compare amounts rounded to 2 decimal places.

**Validation:**

* If `{from-date}` or `{to-date}` is missing, ask for it. Do not guess a period.
* If DonorPerfect returns no gifts for the period, say so and stop.
* A DonorPerfect GL code may carry formatting that Business Central does not (spaces, dashes, a fund suffix). If a code finds no account, retry once with spaces and dashes removed, and report which form matched.

Who it's for

One answer, three teams that use it

Nonprofit accountants

Close the month faster

Differences by code, with the items behind the largest ones identified.

Reconcile October DonorPerfect gift revenue to the Business Central GL.

Controllers

Explain the variance

Likely matches are pointed out for the biggest differences.

Why does GL code 4010 in DonorPerfect differ from Business Central for Q3?

Auditors

Test revenue completeness

Codes with no account or no postings are named.

Which DonorPerfect GL codes had gifts in 2026 but no postings in Business Central?

How it works

What PopdockAI does when you ask

You give a date range and your AI assistant compares DonorPerfect gift totals with the Business Central ledger by code. It only reads and asks for the period rather than guessing.

01

Ask

You give a date range and optionally one GL code.

Your AI tool

02

Total

It totals DonorPerfect cash gifts per code, excluding pledges and soft credits.

donorperfect-get-gift

03

Compare

It sums net credits on each Business Central account, ignoring reversed entries.

No items found.

04

Report

You see differences by code with the items behind the three largest.

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

Gift revenue reconciled in one pass

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