Connectors

/

Bloomerang

/

Compare Bloomerang giving with the Intacct budget
Report
Cross-Connector

Track Bloomerang fundraising against the Sage Intacct budget

For leaders and finance teams who want fundraising against budget by account, with pledges kept apart from cash, ready for the board.

Try PopdockAI free
Get a live demo
Compare Bloomerang giving with the Intacct budget
How is fundraising tracking against the FY2026 budget in Intacct, through September?
Fundraising is at 68 percent of budget to date across 6 revenue accounts. - Largest shortfall: 4200 Major Gifts, 42,000 short of budget to date - Largest overrun: 4300 Events, 9,500 over budget - Raised and booked differ by over 5 percent: 4100 Annual Fund - Open pledges still to come: 38,000 Want the full account table?
Bloomerang
Sample figures. Your results come from your own account.
bloomerang-get-fund
sage-intacct-get-budget
sage-intacct-get-budget-detail
bloomerang-get-designation
bloomerang-get-campaign
sage-intacct-get-general-ledger-detail

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

Budget, gifts and booked revenue live in three places

Boards ask how fundraising tracks against budget, but the budget is in Sage Intacct, gifts in Bloomerang and booked revenue in the ledger. Lining them up by account, with pledges apart from cash, is a monthly spreadsheet chore.

Without PopdockAI

  • Export the budget from Intacct
  • Export gifts and pledges from Bloomerang
  • Pull booked revenue from the ledger
  • Map funds to accounts in a spreadsheet

With PopdockAI

  • Active funds are mapped to their revenue accounts
  • Budget to date and full budget are read per account
  • Raised, new pledges, open pledges and booked revenue are kept apart
  • Shortfalls, overruns and gaps are flagged, 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:** Show how fundraising is tracking against Sage Intacct budget `{budget-id}` from `{start-date}` to `{end-date}` (default: today), account by account: what was budgeted, what Bloomerang has raised, what Intacct has booked, and what open pledges are still to come. Change nothing.

**Step 1: Map funds to accounts (Bloomerang)**

Call `bloomerang-get-fund` with `active` true and group the funds by `general-ledger-class`. Those account numbers are the gift revenue accounts this report covers.

**Step 2: Read the budget (Intacct)**

Call `intacct-get-budget` with `budget-id` to confirm the budget exists. Then, for each gift revenue account, call `intacct-get-budget-detail` with `budget-id` and `account-number`. Total `amount` for the periods whose `period-start-date` falls inside the date range (the budget to date), and for all periods (the full budget).

**Step 3: Read what was raised (Bloomerang)**

For each fund, call `bloomerang-get-designation` with `fund-name` and `created-date.from` / `created-date.to` set to the range. Total money received (donations, recurring donations and pledge payments) apart from new pledges, and never add a pledge to the payments made against it. Total `pledge-balance` on pledges as the open pledges still to come. Say in the report that Bloomerang is counted by entry date.

Call `bloomerang-get-campaign` with `active` true, and note any campaign that ends inside the range with its `goal` and `raised`.

**Step 4: Read what was booked (Intacct)**

For each account, call `intacct-get-general-ledger-detail` with `account-number`, `entry-date.from` / `entry-date.to` set to the range, and `reporting-method` set to Accrual (rows repeat per reporting method), and net credits minus debits.

**Step 5: Report**

A table, one row per account: account and title, funds mapped to it, budget to date, raised in Bloomerang, new pledges, booked in Intacct, raised as a percentage of budget to date, full budget, and open pledge balance. Under it:

* the largest shortfall and the largest overrun against budget to date
* any account where raised and booked differ by more than 5%, with a suggestion to run the reconcile-fund-revenue prompt for it
* the campaigns ending inside the range, with goal and raised

**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 `intacct-create-budget`, `intacct-update-budget`, `bloomerang-update-campaign`, `bloomerang-update-fund` or any other add, create or update tool.
* Pass dates to both servers as YYYY-MM-DD. Omit `company` on Intacct calls unless the user names one.

**Validation:**

* If the budget does not exist, say so, list the budgets an unfiltered `intacct-get-budget` call returns, and stop.
* If a gift revenue account has no budget lines, show it with a budget of zero and flag it rather than leaving it out.
* If a fund has a blank `general-ledger-class`, list it under the table as unmapped, with what it raised.

Who it's for

One answer, three teams that use it

Executive directors

Answer the board's budget question

Percent of budget to date per account gives a clear status update.

How is fundraising tracking against the FY2026 Intacct budget through June?

Finance directors

See raised against booked

Accounts where raised and booked revenue differ by more than five percent are flagged.

Which revenue accounts show a gap between Bloomerang giving and Intacct booked revenue this year?

Development directors

Find the biggest shortfall

The largest shortfall and overrun show where to focus the rest of the year.

Which fund is furthest behind the Intacct budget, and which campaigns end this quarter?

How it works

What PopdockAI does when you ask

You name the Sage Intacct budget and a date range, and your AI assistant compares Bloomerang giving with it account by account. Unbudgeted and unmapped items are flagged.

01

Ask

You name the Sage Intacct budget and a date range.

Your AI tool

02

Map

It maps active Bloomerang funds to their revenue accounts.

bloomerang-get-fund

03

Read

It reads budget, money raised, pledges and booked revenue.

sage-intacct-get-budget
sage-intacct-get-budget-detail
bloomerang-get-designation
bloomerang-get-campaign
sage-intacct-get-general-ledger-detail

04

Report

You get one row per account with shortfalls and gaps flagged.

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

Returns funds from Bloomerang, the accounting buckets that gifts are designated to. Filter by name or active state.
get-data

sage-intacct-get-budget

Returns budgets from Sage Intacct.
get-data

sage-intacct-get-budget-detail

Returns budget details from Sage Intacct. One row per budget amount by account and period; filter by budget ID from Get budgets.
get-data

bloomerang-get-designation

Returns transaction designations from Bloomerang: how each gift was split across funds, campaigns and appeals. Filter by fund, campaign or appeal name, designation type, amount range or created date.
get-data

bloomerang-get-campaign

Returns fundraising campaigns from Bloomerang. Filter by name, active state, start date or minimum goal.
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.
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

Fundraising against budget, ready for the board

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