/
/
Get the whole Rillet account picture for one customer
For finance and account teams who want one page on a Rillet customer's contracts, ARR trend, billing, payments and open balance.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
A full picture of one customer takes an afternoon
Seeing one customer in full means opening their Rillet contracts, items, ARR history, invoices, payments and credit memos one at a time. Simple questions about what they owe and what they are worth take an afternoon to answer.
Without PopdockAI
- Open each contract and its items
- Pull a year of ARR history
- List invoices, payments and credit memos
- Piece together the balance per currency
With PopdockAI
- The one matching customer found, or the matches listed
- Contracts, a year of ARR, invoices, payments and credits read
- Billed, paid, credited and open balance per currency
- Flags for overdue invoices, renewals, falling ARR and loose credits
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Give a complete account review of the customer `{customer-name}`: what they are contracted for, what they are worth in recurring revenue, what they have been billed, what they have paid, and what they still owe.
**Step 1: Resolve the customer**
Call `rillet-get-customers` (it takes no filters) and find the customer whose `name` or `invoicing-name` matches `{customer-name}`. If more than one matches, list them with city, country and `customer-id`, and stop. If none match, say so and stop.
**Step 2: Contracts**
Call `rillet-get-contracts` filtered by `customer-id`, then `rillet-get-contract-items` filtered by `customer-id`. Call `rillet-get-products` to name each `product-id`.
**Step 3: Recurring revenue trend**
Call `rillet-get-arr-waterfall` filtered by `customer-id`. Take the last twelve `year-month` values.
**Step 4: Billing and cash**
* Call `rillet-get-invoices` (no filters) and keep this `customer-id`.
* Call `rillet-get-invoice-payments` (no filters) and keep payments whose `invoice-id` is one of those invoices.
* Call `rillet-get-credit-memos` filtered by `customer-id`.
**Step 5: Report**
* Header: name, location, payment terms, whether invoices send automatically.
* Contracts: name, status, start and end date, total value, and the items under each (product, quantity, price, revenue pattern).
* ARR: current ARR, ARR twelve months ago, and the change, with the months listed.
* Billing: invoice count and total billed per currency, total paid, total credited, and the open balance (sum of `amount-due`).
* Flags: overdue invoices, a contract ending in the next 90 days, ARR that fell in the last three months, credit memos not tied to an invoice.
**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-update-customer`.
* Never add amounts in different currencies together.
* Report what the data says. Do not speculate on why a customer is paying late.
**Validation:**
* If a section returns nothing, say "none" for it and continue; a customer with no contracts is still worth reviewing.Who it's for
One answer, three teams that use it
Finance managers
Answer account questions fast
What a customer owes, what they are worth and what looks wrong, on one page.
Give me a full Rillet account review for Contoso, including anything overdue.
Account managers
Prepare for a renewal or QBR
Contracts, ARR trend and open balance in one view before you meet the customer.
Summarize Fabrikam's contracts, ARR over the last year and open balance in Rillet.
Billing specialists
Investigate a billing dispute
Invoices, payments and credit memos side by side, with unlinked credits flagged.
Show every invoice, payment and credit memo for Northwind Traders in Rillet this year.
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant brings their whole Rillet account onto one page. It reports what the data says without speculating, and changes nothing.
01
Ask
You name the customer.
02
Find
It finds the one matching record, or lists matches.
03
Read
It reads contracts, twelve months of ARR, invoices, payments and credits.
04
Report
You get one page with flags, and nothing is changed.
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-products
rillet-get-arr-waterfall
rillet-get-invoices
rillet-get-invoice-payments
rillet-get-credit-memos
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
One customer, one page, before any conversation
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)
