/
/
Tie Bloomerang fund revenue to the Business Central GL
For nonprofit finance teams who need fund totals in Bloomerang to agree with Dynamics 365 Business Central at period end.
On this page
Connector
Connect Bloomerang, pick your AI tool and paste the prompt.
The problem
Fund totals and G/L credits rarely agree at first
At period end each Bloomerang fund total should agree with its Business Central G/L account, but it rarely does at first. Tracking down the gap means listing gifts and ledger entries side by side for every fund.
Without PopdockAI
- Export gifts by fund from Bloomerang
- Pull G/L entries for each fund account
- Line them up side by side
- Chase every gap entry by entry
With PopdockAI
- Gifts are totalled by fund from designations, refunds kept apart
- Each fund is compared with net credits on its G/L account
- Each fund is marked matched, higher on one side or unmapped
- Entries behind each gap 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.
**Objective:** For gifts dated `{date-from}` to `{date-to}`, compare the total Bloomerang gives each fund with what Business Central company `{company}` (blank means the connector's default company) shows on that fund's G/L account, and explain the gaps.
**Step 1: Read the gifts (Bloomerang)**
Call `bloomerang-get-transaction` with `date.from` = `{date-from}` and `date.to` = `{date-to}`. Keep `id`, `transaction-number`, `date`, `amount` and `refunded`. If more than 200 come back, report the count and ask for a shorter period before going on.
For each transaction, call `bloomerang-get-designation` with `transaction-id` set to the transaction's `id`, and keep `fund-name` and `amount`. Total the designation amounts by fund. Keep refunded transactions in a separate total per fund.
**Step 2: Map funds to accounts (Bloomerang)**
Call `bloomerang-get-fund` once and map each fund `name` to its `general-ledger-class`.
**Step 3: Read the ledger (Business Central)**
For each GL class, call `business-central-get-general-ledger-entry` with `gl-account-number` set to it, `posting-date.from` = `{date-from}` and `posting-date.to` = `{date-to}`. Pass `{company}` as `company`; omit it when blank. Total `credit-amount` minus `debit-amount` for the account.
**Step 4: Report**
A table with one row per fund: fund, GL account, Bloomerang gift total, Bloomerang refunded total, Business Central net credits, difference, and status (Matched, Bloomerang higher, Business Central higher, Unmapped).
For each fund that differs, list the Business Central entries (posting date, document number, external document number, description, amount) and the Bloomerang transactions (transaction number, date, amount) so the user can see where the gap sits. Gift journal entries posted by the post-gifts-to-journal prompt carry the document number `BLM` followed by the Bloomerang transaction number, which lets you pair them one to one.
**Rules & Guidelines:**
* `bloomerang-get-transaction`, `bloomerang-get-designation` and `bloomerang-get-fund` are on the bloomerang server. `business-central-get-general-ledger-entry` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-journal-line`, `business-central-update-journal-line`, `bloomerang-update-transaction` or `bloomerang-add-refund`, or any other create, update or add tool.
* A G/L account can carry non-gift income too. When Business Central is higher and the extra entries have no `BLM` document number, say they are probably not gifts rather than calling them errors.
**Validation:**
* If Bloomerang returns no transactions for the period, say so and stop.
* A fund with a blank GL class, or a GL class that matches no Business Central account, is Unmapped. Report its Bloomerang total and skip the ledger call.
* Gifts dated near the period's edges can post to Business Central a day or two later. Mention entries just outside the period only if they would close a gap.Who it's for
One answer, three teams that use it
Nonprofit accountants
Tie out funds at period end
A status per fund shows which agree and which need work.
Reconcile Bloomerang fund revenue to the Business Central GL for October.
Finance directors
Explain gaps to the auditors
The gifts and entries behind each gap are listed, ready to show.
Which Bloomerang funds disagree with Business Central for Q3, and what is behind each gap?
Controllers
Find unmapped funds
Funds with no G/L mapping are flagged, so revenue is not left out of the ledger.
Are any Bloomerang funds unmapped to a Business Central G/L account this year?
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant reconciles Bloomerang fund revenue to the Business Central GL. Entries without a BLM number are called probable non-gift income, not errors.
01
Ask
You give a date range, and optionally a company.
02
Total
It totals Bloomerang gifts by fund, keeping refunds separate.
03
Compare
It compares each with net credits on the fund's G/L account.
04
Report
You get a status per fund and the entries behind each gap.
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.
bloomerang-get-transaction
bloomerang-get-designation
bloomerang-get-fund
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.
The outcome
Fund revenue tied out, every variance explained
Related use cases
More ways to put this data to work
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.

.webp)
