Connectors

/

Rillet

/

Rillet customer account review
Report

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.

Try PopdockAI free
Get a live demo
Rillet customer account review
Give me an account review of Northwind Traders in Rillet.
Northwind Traders: ARR 96,000 USD, up 8 percent over the year, with 4,200 USD open. - Contracts: 2 active, one ends in 64 days - Billed this year: 104,000 USD, paid 99,800 USD - Flag: 1 overdue invoice, INV-1042 Want the full one-page review?
Rillet
Sample figures. Your results come from your own account.
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

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

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.

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

Your AI tool

02

Find

It finds the one matching record, or lists matches.

rillet-get-customers

03

Read

It reads contracts, twelve months of ARR, invoices, payments and credits.

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

04

Report

You get one page with flags, and nothing is changed.

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-products

Returns products (name, status, pricing, revenue account) 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.
get-data

rillet-get-invoice-payments

Returns payments received against customer invoices from Rillet.
get-data

rillet-get-credit-memos

Returns customer credit memos (number, customer, invoice, totals) 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

One customer, one page, before any conversation

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