Reconcile DonorPerfect gift revenue to Sage Intacct by GL code

**Objective:** Reconcile DonorPerfect gifts dated {date-from} to {date-to} against the revenue posted in Sage Intacct for the same period, one GL code at a time, limited to GL code {gl-code} (if blank, every GL code with gifts in the period).

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

Call `donorperfect-get-gift` with `gift-date.from` {date-from} and `gift-date.to` {date-to}, plus `gl-code` if one was given. Set `max-records` high enough to return the whole period; if the row count equals the limit, say the totals may be incomplete. Split the rows into buckets per `gl-code`:

* outright gifts: `record-type` G with `pledge-payment` not set
* pledge payments: `record-type` G with `pledge-payment` set
* pledges: `record-type` P, using `total` (the commitment)
* leave out soft credits (`record-type` S), which carry no money, and list any other record type separately as unclassified

**Step 2: Map each GL code to its 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, report the GL code as unmapped with its DonorPerfect totals and continue with the next code.

**Step 3: Read what Intacct posted**

For each mapped account, call `intacct-get-general-ledger-detail` with `account-number`, `entry-date.from` {date-from} and `entry-date.to` {date-to}. 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. Net posted revenue is the sum of `credit-amount` minus the sum of `debit-amount`.

**Step 4: Compare**

Compare the Intacct net with outright gifts first. If they differ, test whether adding pledge payments, pledges, or both closes the gap, and say which combination matches: that tells the user how their organization books pledges. A difference of a cent or less is a match.

For each GL code still out of balance, find the items behind the difference. For each DonorPerfect gift, look for an Intacct row on that account with the same amount within 3 days of the gift date, matching one to one. List the gifts with no match, then the Intacct rows no gift explains (`entry-date`, `amount`, `customer-name`, `memo`, `journal`). If the Intacct rows are batch totals rather than single gifts (few rows, large amounts, no payer names), compare DonorPerfect daily totals by gift date with Intacct daily totals by entry date instead.

**Step 5: Report**

One table row per GL code: GL code, Intacct account and title, outright gifts, pledge payments, pledges, Intacct net posted, difference, and status (Matched, Matched including pledges, Out of balance, Unmapped). Under the table, for each out-of-balance code, the unmatched items on each side. End with grand totals for both systems.

**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`, `intacct-update-journal-entry` or any other save, create or update tool on either server.
* Pass dates to both servers as YYYY-MM-DD.
* Never adjust either system's figures to make them agree; report the difference as found.

**Validation:**

* If DonorPerfect returns no gifts for the period, say so and stop.
* If Intacct returns no rows for a mapped account, report that code's whole DonorPerfect total as not posted.
* If a GL code has gifts but no account mapping, it cannot be reconciled: report it as unmapped rather than guessing an account from its description.