Connectors

/

Rillet

/

Rillet bills due review
Report

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.

Try PopdockAI free
Get a live demo
Rillet bills due review
What Rillet bills are due in the next two weeks, including anything overdue?
Unpaid: 86,400 USD, with 12,900 USD already overdue. - Overdue: 4 bills, oldest from Fabrikam due 18 September - Due soon: 17 bills, 73,500 USD - Excluded: 2 draft or void bills Want the list in due date order?
Rillet
Sample figures. Your results come from your own account.
rillet-get-vendors
rillet-get-bills
rillet-get-bill-lines
rillet-get-bill-payments

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

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.

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

Your AI tool

02

Read

It reads bills due in that window and anything already overdue.

rillet-get-bills
rillet-get-vendors

03

Work out

It builds each unpaid balance from lines, tax and payments.

rillet-get-bill-lines
rillet-get-bill-payments

04

Report

Overdue bills come first, with totals per currency.

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

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
get-data

rillet-get-bill-lines

Returns vendor bill line items with account codes, amounts and service periods from Rillet.
get-data

rillet-get-bill-payments

Returns payments made against vendor bills 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

A payment run built on accurate balances

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