Connectors

/

Rillet

/

Rillet contract renewals review
Report

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.

Try PopdockAI free
Get a live demo
Rillet contract renewals review
Which Rillet contracts end in the next 90 days?
18 contracts end in the next 90 days, carrying 1.4 million USD in ARR. - Largest: Contoso, 240,000 USD ARR, 41 days left - Open balance: Fabrikam has 8,200 USD unpaid - Note: Northwind Traders ARR has been falling Want the full list ranked by ARR?
Rillet
Sample figures. Your results come from your own account.
rillet-get-customers
rillet-get-contracts
rillet-get-contract-items
rillet-get-arr-waterfall
rillet-get-invoices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads Rillet contracts ending in that window with their items.

rillet-get-contracts
rillet-get-contract-items

03

Size

It adds each customer's latest ARR and open invoice balance.

rillet-get-arr-waterfall
rillet-get-invoices

04

Report

You get a list ranked by ARR, with currencies kept separate.

Your AI tool

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.

get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-contract-items

Returns contract line items (product, quantity, price, term) from Rillet.
get-data

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
Read only.Nothing in Rillet 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

Every upcoming renewal ranked by what is at stake

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