/
/
Plan the next payment run from Rillet bills due
For accounts payable teams who want Rillet bills due soon and already overdue listed with unpaid balances, ready for a payment run.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Planning a payment run without knowing what is really unpaid
Planning a payment run means finding every bill due soon or overdue and working out what is unpaid. Rillet bills carry no total, so for each one you add up lines and tax and subtract earlier payments.
Without PopdockAI
- Filter Rillet bills by due date
- Add up each bill's lines and tax
- Subtract payments already made
- Sort overdue from due soon by hand
With PopdockAI
- Bills due in your window and anything overdue read together
- Each unpaid balance built from lines, tax and payments
- Overdue first, then by due date, with totals per currency
- Drafts and voids counted and left out, nothing paid
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List every vendor bill due in the next `{days-ahead}` days (default 14), plus anything already overdue, with the unpaid balance of each, optionally limited to the vendor `{vendor-name}`, so a payment run can be planned.
**Step 1: Resolve the vendor (only if one was given)**
If `{vendor-name}` is not empty, call `rillet-get-vendors` (it takes no filters) and find the vendor whose `name` matches. If more than one matches, list them with their `vendor-id` and stop. If none match, say so and stop.
**Step 2: Pull the bills**
Call `rillet-get-bills` with `due-date.to` set to today plus `{days-ahead}` days, and `vendor-id` if Step 1 ran. Do not set `due-date.from`, so overdue bills come back too.
**Step 3: Work out what is unpaid**
* Bills carry no total. For each bill, call `rillet-get-bill-lines` filtered by `expense-number` and sum `amount` plus `tax-amount` across its lines.
* Call `rillet-get-bill-payments` filtered by `bill-id` and sum `amount`.
* Unpaid = bill total minus payments. Drop bills with nothing unpaid.
**Step 4: Report**
* Overdue first, then by `due-date`: vendor name, expense number, bill date, due date, days until due (negative if overdue), total, paid, unpaid, currency.
* Totals of unpaid per currency, split into overdue and due-soon.
* Call `rillet-get-vendors` if you have not already, to put a name on every `vendor-id`.
**Rules & Guidelines:**
* This is read-only. Do not call any tool whose name starts with rillet-add-, rillet-update-, rillet-apply-, rillet-unapply-, rillet-record-, rillet-set- or rillet-setup-. In particular do not call `rillet-add-bill-payment`.
* Leave out bills whose `status` shows they are draft or void, and say how many.
* Never add amounts in different currencies together.
**Validation:**
* If nothing is due in the window, say so and give the next due date you can see, if any.Who it's for
One answer, three teams that use it
Accounts payable
Build the payment run in one question
Overdue and upcoming bills with real unpaid balances, ready to schedule.
What Rillet bills are due in the next 7 days or already overdue, with unpaid amounts?
Finance managers
Plan cash for bills coming up
Totals per currency split into overdue and due soon show what cash you need.
How much do we owe vendors in Rillet over the next 30 days, by currency?
Vendor managers
Check what one vendor is owed
Filter to one vendor before a call so you know what is open and overdue.
What do we still owe Contoso Cleaning in Rillet, and is any of it overdue?
How it works
What PopdockAI does when you ask
You choose how far ahead to look and your AI assistant works out what is unpaid on every bill due. It only reads, so nothing is paid or changed.
01
Ask
You choose how many days ahead to look, and optionally a vendor.
02
Read
It reads bills due in that window and anything already overdue.
03
Work out
It builds each unpaid balance from lines, tax and payments.
04
Report
Overdue bills come first, with totals per currency.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-vendors
rillet-get-bills
rillet-get-bill-lines
rillet-get-bill-payments
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
A payment run built on accurate balances
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)
