Connectors

/

Bloomerang

/

Reconcile Bloomerang gifts to Intacct deposits
Report
Cross-Connector

Prove every Bloomerang gift reached the bank in Sage Intacct

For nonprofit finance teams who need gifts matched to receipts and deposits, with processor fees and differences called out.

Try PopdockAI free
Get a live demo
Reconcile Bloomerang gifts to Intacct deposits
Reconcile Bloomerang gifts to Intacct deposits for the first week of September.
312 of 320 gifts matched money in Sage Intacct. - Gifts with no money: 5, including a 250 check from Jordan Lee - Money with no gift: 2 receipts, one looks like a grant - Implied card fees: 412.80 - Unexplained difference: 125.00 Want the unmatched items in detail?
Bloomerang
Sample figures. Your results come from your own account.
bloomerang-get-transaction
bloomerang-get-refund
sage-intacct-get-other-receipt
sage-intacct-get-ar-payment
sage-intacct-get-deposit
sage-intacct-get-deposit-line

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Bloomerang

Bloomerang
Run it on your own Bloomerang data.

Connect Bloomerang, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Proving every gift reached the bank rarely gets finished

Bloomerang gifts should match money arriving in Sage Intacct, but processors pay out in batches net of fees, checks are bundled and payment methods are named differently. Proving every gift reached the bank rarely gets finished.

Without PopdockAI

  • Export gifts from Bloomerang
  • Pull receipts and deposits from Intacct
  • Match checks and card batches by hand
  • Work out fees from shortfalls

With PopdockAI

  • Gifts, refunds, receipts, payments and deposits are read with settlement time
  • Checks match on number or amount and date, cards by daily batch
  • Shortfalls are shown as implied fees, and money is counted once
  • Unmatched gifts and money are listed, and nothing is 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:** Reconcile the gifts Bloomerang recorded from `{start-date}` to `{end-date}` (default: the same day as the start date) against the money Sage Intacct shows arriving, limited to Intacct bank account `{bank-account}` if one is given (default: all bank accounts). Report what matches, what is only in Bloomerang, and what is only in Intacct. Change nothing.

**Step 1: Read the gifts (Bloomerang)**

Call `bloomerang-get-transaction` with `date.from` and `date.to` set to the window. Keep `id`, `transaction-number`, `date`, `amount`, `method`, `check-number`, `fee-amount` and `refunded`. Keep refunded gifts in the match: the original payment still reached the bank.

Call `bloomerang-get-refund` for the same window and list refunds separately, since they leave the bank as their own outflow.

**Step 2: Read the money in (Intacct)**

Extend the end of the Intacct window by 3 business days, because card and EFT gifts settle after the gift date.

* `intacct-get-other-receipt` with `transaction-date.from` / `transaction-date.to`, and `bank-account` if given.
* `intacct-get-ar-payment` with `receipt-date.from` / `receipt-date.to`, for gifts paid against an Intacct invoice such as a sponsorship or a grant.
* `intacct-get-deposit` with `deposit-date.from` / `deposit-date.to`, and `bank-account` if given. For each deposit, call `intacct-get-deposit-line` with `deposit-record-number` set to its `record-number`.

Match at the most detailed level first. Other receipts and AR payments are individual items; a deposit can bundle items that were already recorded as receipts. Use a deposit line only for money no receipt or payment accounts for, and never count the same money twice.

**Step 3: Match**

* **Checks:** match a gift with `method` Check to an Intacct item of the same amount whose `document-or-check-number` (AR payments) or description carries the same check number. With no check number to compare, match on amount within 5 days of the gift date.
* **Cards and EFT:** processors pay out in batches, net of their fees. Total the card and EFT gifts per gift date and compare each day's total with receipts or deposit lines over the next 3 business days. A shortfall that looks like processing fees (a few percent of the batch) is a fee, not a missing gift; report the implied fee.
* **Cash:** match on amount within 5 days of the gift date.

**Step 4: Report**

* **Matched:** transaction number, gift date, amount, method, and the Intacct item it matched (type, number, date).
* **In Bloomerang, not in Intacct:** gifts with no matching money, with the nearest candidate if one was close.
* **In Intacct, not in Bloomerang:** receipts and deposit lines with no matching gift, with payer or description and account. Say whether each looks like a gift entered only in finance, or non-gift income, judging by its account and description.
* **Refunds in the window,** listed on their own.

End with one line: Bloomerang total, Intacct total, implied fees, and the unexplained difference.

**Rules & Guidelines:**

* Tools named bloomerang- are on the Bloomerang MCP server; tools named intacct- are on the Sage Intacct MCP server. Both servers must be connected.
* Read only. Do not call `bloomerang-add-transaction`, `bloomerang-update-transaction`, `bloomerang-add-refund`, `intacct-create-journal-entry` or any other add, create or update tool on either server.
* Pass dates to both servers as YYYY-MM-DD. Omit `company` on Intacct calls unless the user names a company.

**Validation:**

* If Bloomerang has no gifts in the window, say so and stop.
* If Intacct has nothing in the window, say so, report the Bloomerang total as unmatched, and suggest checking the bank account and the Intacct company.
* If a call returns exactly `max-records` rows, the list is truncated: narrow the window and read again rather than reconcile a partial list.
* The two systems name payment methods differently (Credit card, Visa, Printed Check, Record Transfer). Match on meaning, not spelling.

Who it's for

One answer, three teams that use it

Nonprofit accountants

Reconcile gifts to deposits

Matched and unmatched items end with the unexplained difference.

Reconcile Bloomerang gifts to Intacct deposits for October.

Finance directors

See processor fees clearly

Card batch shortfalls are reported as implied fees, so cost of fundraising is visible.

What were the implied card processing fees on Bloomerang gifts last month?

Auditors

Check gifts with no money

Gifts with no matching deposit are listed for follow-up.

Which Bloomerang gifts in Q3 have no matching deposit in the Intacct operating account?

How it works

What PopdockAI does when you ask

You give a date range and your AI assistant matches Bloomerang gifts to Sage Intacct deposits. It warns when a record limit means a list is partial.

01

Ask

You give a date range, and optionally a bank account.

Your AI tool

02

Read

It reads gifts and refunds, and Sage Intacct receipts and deposits.

bloomerang-get-transaction
bloomerang-get-refund
sage-intacct-get-other-receipt
sage-intacct-get-ar-payment
sage-intacct-get-deposit
sage-intacct-get-deposit-line

03

Match

It matches checks, daily card batches and cash, counting money once.

No items found.

04

Report

You get matched and unmatched items and the unexplained difference.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Bloomerang and one secure connection to your AI tool. No code, no exports.

get-data

bloomerang-get-transaction

Returns gift transactions from Bloomerang. Filter by date range, amount range, payment method, transaction number, or whether the gift has been refunded.
get-data

bloomerang-get-refund

Returns gift refunds from Bloomerang. Filter by date range, amount range, or the transaction that was refunded.
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-ar-payment

Returns AR payments from Sage Intacct.
get-data

sage-intacct-get-deposit

Returns deposits from Sage Intacct. The record-number links to the Get deposit lines tool.
get-data

sage-intacct-get-deposit-line

Returns deposit lines from Sage Intacct. Filter by deposit record number (the record-number from Get deposits) to get one deposit's lines.
Read only.Nothing in Bloomerang 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 every gift reached the bank

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