Connectors

/

Sage Intacct

/

Build an Intacct AR collections worklist
Report

Start each day with a ranked Sage Intacct collections worklist

For finance and collections teams who want overdue Sage Intacct customers aged, ranked and ready to chase, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Build an Intacct AR collections worklist
Build me a collections worklist of Intacct customers at least 15 days past due as of today, top 20.
62,480 USD is overdue across 20 customers and 47 invoices as of today. - Top: Fabrikam Inc, 14,200 USD, oldest INV-1042 at 96 days - Over limit: Contoso Ltd is 3,100 USD over its credit limit - Possible unapplied cash: Northwind Traders has a 2,500 USD payment not fully applied - Suggested: credit hold review for the 3 customers over 90 days Want the full ranked table with aging buckets for all 20?
Sage Intacct
Sample figures. Your results come from your own account.
sage-intacct-get-invoice
sage-intacct-get-customer
sage-intacct-get-ar-payment
sage-intacct-get-ar-adjustment

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Sage Intacct

Sage Intacct
Run it on your own Sage Intacct data.

Connect Sage Intacct, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

The customers who need a call get buried in the aging

Building a collections list in Sage Intacct means exporting open invoices, aging them by hand and opening each customer for credit limits, payments and credits. Unapplied cash makes some look worse than they are, and the real priorities get buried.

Without PopdockAI

  • Export open invoices from Sage Intacct
  • Age them into buckets by hand
  • Open each customer for credit, terms and payments
  • Miss unapplied cash and call the wrong people

With PopdockAI

  • Every open past-due invoice aged into 30 day buckets
  • Customers ranked by what they owe, per currency
  • Credit limit, terms, rep, last payment and open credits added
  • Possible unapplied cash flagged and a next step suggested

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Build a collections worklist of the customers with invoices at least {min-days-overdue} days past due as of {as-of-date}, ranked by overdue balance, covering the top {max-customers} customers. Defaults: 1 day past due, today, 20 customers.

**Step 1: Pull the overdue invoices**

Call `intacct-get-invoice` with `total-due.min` 0.01 and `due-date.to` set to the as-of date minus the minimum days overdue. Set `max-records` to 1000.

* Drop invoices whose `state` shows they are drafts or declined. They are not receivables yet.
* Use `total-due`, never `total-amount`. A partly paid invoice only owes its balance.
* If the call returns exactly `max-records` rows, the list is truncated. Say so in the report.

**Step 2: Age and group**

* Days overdue = the as-of date minus `due-date`.
* Buckets: 1-30, 31-60, 61-90 and over 90 days.
* Group by `customer-id` and total `total-due` per bucket, separately per `transaction-currency`.
* Rank customers by total overdue and keep the top ones.

**Step 3: Add context for each ranked customer**

* Call `intacct-get-customer` with `customer-id` for `credit-limit`, `term`, `customer-rep-name` and `total-due`. Flag the customer as over limit when `credit-limit` is above zero and `total-due` exceeds it.
* Call `intacct-get-ar-payment` with `customer-id` and `receipt-date.from` 60 days before the as-of date. Note the last `receipt-date`. A payment with `amount-due` above zero may be cash that was never applied, which makes the invoices look more overdue than they are.
* Call `intacct-get-ar-adjustment` with `customer-id`. An adjustment with `total-due` not zero is an open credit that may offset an overdue invoice.

**Step 4: Report**

Start with the as-of date, the total overdue per currency, and the number of customers and invoices.

Then one table, one row per customer: customer name, customer ID, rep, terms, 1-30, 31-60, 61-90, over 90, total overdue, oldest invoice number with its days overdue, last payment date, and flags (over limit, possible unapplied cash, open credit).

End with a recommended next action per customer: a reminder email, a phone call, escalation to the rep, or a credit hold for anything over 90 days or over limit. These are recommendations only.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any create or update tool, in particular `intacct-update-customer` (which sets credit holds) or `intacct-create-order-entry-document`. If the user wants a customer put on hold, tell them to do that as a separate step.
* Never add amounts across currencies. Subtotal per `transaction-currency`.
* Pass dates to the read filters as YYYY-MM-DD.
* If the user names an Intacct company, pass it as `company` on every call; otherwise omit it.

**Validation:**

* If no invoices come back, say that no customer is overdue by the minimum number of days as of that date, and stop.
* If a customer lookup returns nothing, keep the row and mark its context as unavailable rather than dropping it.

Who it's for

One answer, three teams that use it

Collections

Start the day with a call list

Customers ranked by what they owe, with a suggested next step for each.

Give me the 10 Intacct customers I should chase today, at least 30 days past due.

AR managers

Spot unapplied cash before you chase

Open credits and recent payments are shown, so nobody gets chased for money already received.

Build an Intacct collections worklist as of month end and flag possible unapplied cash.

Sales reps

Know which of your accounts are overdue

See the rep on each customer, so account owners can help with the call.

Which customers owned by Sam Patel are past due in Intacct, and by how much?

How it works

What PopdockAI does when you ask

You set a minimum days overdue and an as-of date, and your AI assistant builds a ranked worklist from Sage Intacct. It only reads, so credit holds and other changes stay with you.

01

Ask

You set a minimum days overdue and an as-of date, or keep the defaults.

Your AI tool

02

Age

It ages every open past-due invoice into 30 day buckets, per currency.

sage-intacct-get-invoice

03

Enrich

It adds credit limit, terms, rep, last payment and open credits for each ranked customer.

sage-intacct-get-customer
sage-intacct-get-ar-payment
sage-intacct-get-ar-adjustment

04

Report

You get a ranked table with flags and a suggested next step, and nothing is changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

sage-intacct-get-invoice

Returns invoices from Sage Intacct. The record-number links to the Get invoice entries tool.
get-data

sage-intacct-get-customer

Returns customers from Sage Intacct.
get-data

sage-intacct-get-ar-payment

Returns AR payments from Sage Intacct.
get-data

sage-intacct-get-ar-adjustment

Returns AR adjustments from Sage Intacct. The record-number links to the Get AR adjustment lines tool.
Read only.Nothing in Sage Intacct 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

A ranked worklist with a next step for every customer

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