/
/
See which Rillet contracts renew soon and what is at stake
For finance and customer success teams who want Rillet contracts ending soon ranked by ARR, with open balances and products.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Renewals slip because nobody sees them coming
Getting ahead of renewals means listing Rillet contracts ending soon, checking what is on each, finding current ARR and spotting unpaid balances. It all lives on separate screens, so the renewal call often comes too late.
Without PopdockAI
- Filter Rillet contracts by end date
- Open each one to see its products
- Look up the customer's ARR
- Check for unpaid invoices before the call
With PopdockAI
- Contracts ending in your window read with their items
- Latest ARR and open balance added for each customer
- A list ranked by ARR with days left and a short note
- Ended contracts counted and left out, nothing changed
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 customer contract ending in the next `{days-ahead}` days (default 90), optionally only for `{customer-name}`, ranked by the recurring revenue at stake.
**Step 1: Resolve the customer (only if one was given)**
If `{customer-name}` is not empty, call `rillet-get-customers` and find the matching customer. If more than one matches, list them and stop.
**Step 2: Pull the contracts**
Call `rillet-get-contracts` with `end-date.from` = today and `end-date.to` = today plus `{days-ahead}` days (and `customer-id` if resolved). Then call `rillet-get-contract-items` filtered by each `contract-id`.
**Step 3: Size what is at stake**
* Call `rillet-get-arr-waterfall` filtered by each `customer-id` and take the latest `year-month`.
* Call `rillet-get-invoices` (no filters) and note any open `amount-due` for the customer; a renewal conversation with an unpaid balance needs to know that.
**Step 4: Report**
Sorted by current ARR, highest first: customer, contract name, end date, days left, total value, current ARR, items (product and quantity), open balance, and a short note (for example usage commitment, or ARR falling).
**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-record-contract-usage`.
* Leave out contracts whose `status` shows they are already cancelled or ended, and say how many.
* Never add amounts in different currencies together.
**Validation:**
* If nothing ends in the window, say so and give the next contract end date you can see.Who it's for
One answer, three teams that use it
Account executives
Plan renewal calls ahead of time
See days left, products and open balance for every renewal on your list.
Which Rillet contracts renew in the next 60 days, ranked by ARR?
Sales leaders
Forecast renewal revenue
A ranked list with total value per currency shows how much is up for renewal.
How much ARR comes up for renewal in Rillet this quarter?
Customer success
Know about unpaid balances before renewing
Open balances and falling ARR are noted, so the renewal conversation starts informed.
When does the Fabrikam contract end in Rillet, and do they have anything unpaid?
How it works
What PopdockAI does when you ask
You choose how far ahead to look and your AI assistant lists every Rillet renewal coming up, ranked by revenue at stake. It only reads.
01
Ask
You choose how many days ahead to look, and optionally a customer.
02
Read
It reads Rillet contracts ending in that window with their items.
03
Size
It adds each customer's latest ARR and open invoice balance.
04
Report
You get a list ranked by ARR, with currencies kept separate.
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-customers
rillet-get-contracts
rillet-get-contract-items
rillet-get-arr-waterfall
rillet-get-invoices
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
Every upcoming renewal ranked by what is at stake
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)
