Connectors

/

FreshBooks

/

Overdue FreshBooks invoices with Bloomerang donor context
Report
Cross-Connector

Chase overdue invoices with donor history in view

For finance teams who want to know which overdue FreshBooks clients are Bloomerang donors, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Overdue FreshBooks invoices with Bloomerang donor context
Show me overdue FreshBooks invoices as of today and mark which clients are Bloomerang donors.
6 invoices are overdue, 1,950.00 in total, and 2 clients are Bloomerang donors. - INV-1042 Northwind Traders: 1,200.00, 41 days overdue, donor, last gift 2026-08-12 - INV-1050 Contoso: 450.00, 18 days overdue, not a donor - Unmatched: 1 client with no email Want the full table sorted by amount outstanding?
FreshBooks
Sample figures. Your results come from your own account.
freshbooks-get-invoice
freshbooks-get-client
bloomerang-get-constituent
bloomerang-get-interaction
bloomerang-get-transaction

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

FreshBooks

FreshBooks
Run it on your own FreshBooks data.

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

Try PopdockAI free

The problem

A firm reminder lands on someone who gave last month

Finance chases overdue invoices without seeing gift history or recent contact in Bloomerang. A firm reminder can land on a donor the fundraising team has worked hard to keep.

Without PopdockAI

  • Pull overdue invoices from FreshBooks
  • Search Bloomerang for each client
  • Check gifts and recent contact by hand
  • Chase a donor without knowing it

With PopdockAI

  • Unpaid invoices due before your cutoff are listed
  • Each client is looked up in Bloomerang by email
  • Donors show last gift and last interaction
  • No reminders sent and 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 unpaid FreshBooks invoices due before `{due-before}` (default today), show which clients are also Bloomerang donors and how recently the organization last contacted them. FreshBooks business: `{company}` (optional).

**Step 1: Overdue invoices**

Call `freshbooks-get-invoice` (FreshBooks server) with `due-date.to` set to the cutoff and `outstanding.min` set to 0.01. Keep `invoice-number`, `organization`, `customer-id`, `outstanding`, `due-date` and `currency-code`.

**Step 2: Clients and donors**

For each distinct `customer-id`, call `freshbooks-get-client` with `id` to get the `email`. Then call `bloomerang-get-constituent` (Bloomerang server) with `primary-email` set to it. For each match, call `bloomerang-get-interaction` with `account-id` and `date.from` set to 90 days before today, and `bloomerang-get-transaction` with `account-id`.

**Step 3: Report**

A table sorted by `outstanding` descending: invoice number, client, amount outstanding, days overdue, donor yes or no, last gift date and amount, last interaction date. Mark donors clearly so a person can decide on a gentler approach. Total the outstanding amount per currency.

**Rules & Guidelines:**

* `freshbooks-get-invoice` and `freshbooks-get-client` are FreshBooks tools; `bloomerang-get-constituent`, `bloomerang-get-interaction` and `bloomerang-get-transaction` are Bloomerang tools.
* Read only. Do not send reminders (`freshbooks-send-invoice-by-email`) and do not call any add, update or delete tool on either server.

**Validation:**

* If no invoices are overdue, say so and stop.
* A client with no email cannot be matched; list it as unmatched rather than guessing.

Who it's for

One answer, three teams that use it

Collections specialists

Adjust your tone for donors

Know which overdue clients are donors before you send a firm reminder.

Which overdue FreshBooks clients are Bloomerang donors, and when did they last give?

Development directors

Protect donor relationships

See donors with overdue invoices so fundraising can step in first.

Show donors with FreshBooks invoices overdue before October 1 and their last Bloomerang interaction.

Finance managers

Prioritize collections with context

Get overdue invoices sorted by amount with donor status and totals per currency.

List overdue FreshBooks invoices by amount outstanding and mark Bloomerang donors.

How it works

What PopdockAI does when you ask

You give a cutoff date and your AI assistant marks which overdue clients are Bloomerang donors. It reports only, so you decide how to chase.

01

Ask

You give a due date cutoff and optionally the FreshBooks business.

Your AI tool

02

Read

It lists unpaid invoices due before then.

freshbooks-get-invoice

03

Match

It looks each client up in Bloomerang and reads recent gifts and contact.

freshbooks-get-client
bloomerang-get-constituent
bloomerang-get-interaction
bloomerang-get-transaction

04

Report

You get a table sorted by amount outstanding with donors marked.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

freshbooks-get-invoice

Returns invoices from FreshBooks, including client, amounts, status and due date. Filter by client, status or date range.
get-data

freshbooks-get-client

Returns clients from FreshBooks with contact details, currency and outstanding balance. Filter by name or email.
get-data

bloomerang-get-constituent

Returns constituents from Bloomerang: the donors, prospects and contacts in your database. Filter by full name, last name, account number, primary email, city, type or status, or fetch one by id.
get-data

bloomerang-get-interaction

Returns logged interactions with constituents in Bloomerang: calls, emails, meetings and mailings. Filter by date range, channel, purpose or subject.
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.
Read only.Nothing in FreshBooks 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

Chase overdue invoices with donor history in view

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