/
/
See where money went across Rillet vendors and accounts
For finance teams who want Rillet spend by vendor and GL account across bills, card charges and reimbursements for a period.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Spend spread across bills, cards and reimbursements
Knowing where money went means combining vendor bills, card charges and reimbursements from different places in Rillet, then totalling by vendor and GL account. In spreadsheets, miscoded spend and large unexplained lines rarely surface.
Without PopdockAI
- Export bill lines, card charges and reimbursements
- Combine them by vendor in a spreadsheet
- Total spend by GL account
- Miss miscoded and unexplained lines
With PopdockAI
- Bill lines, card charges and reimbursements read for the period
- Top vendors with spend split by source
- Spend by GL account with its share of the period
- Miscoded, oversized and undescribed lines flagged, 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:** Show where money went between `{from-date}` and `{to-date}`: spend by vendor and by GL account, across bills, card charges and reimbursements, optionally limited to the vendor `{vendor-name}`.
**Step 1: Resolve the vendor (only if one was given)**
If `{vendor-name}` is not empty, call `rillet-get-vendors` and find the vendor whose `name` matches. If more than one matches, list them and stop.
**Step 2: Gather the spend**
* Bills: `rillet-get-bill-lines` with `bill-date.from` = `{from-date}` and `bill-date.to` = `{to-date}` (and `vendor-id` if resolved).
* Card charges: `rillet-get-charge-items` with `charge-date.from` and `charge-date.to` set the same way (and `vendor-id` if resolved).
* Reimbursements: `rillet-get-reimbursement-items` takes no filters. Keep rows whose `reimbursement-date` falls in the period (and the `vendor-id` if resolved).
* Names: `rillet-get-vendors` for vendor names and `rillet-get-accounts` for account names.
**Step 3: Report**
* Top vendors by spend: vendor, bills, charges, reimbursements, total.
* Spend by GL account: account code, account name, total, share of the period.
* Anything notable: a vendor whose spend lands in several unrelated accounts, a single line over 10 percent of the period total, line items with no description.
* Per currency throughout; never add currencies together.
**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-.
* Use `amount` for spend and report `tax-amount` separately; do not blend them.
**Validation:**
* If the dates are missing or `{from-date}` is after `{to-date}`, ask for them again in YYYY-MM-DD form.
* If nothing is returned, say the period has no recorded spend.Who it's for
One answer, three teams that use it
Finance managers
Know your top vendors
Spend by vendor across bills, cards and reimbursements, in one ranked answer.
Who were our top 10 vendors by spend in Rillet last quarter?
Controllers
Catch miscoded spend
Vendors coded to several unrelated accounts are flagged for a coding review.
Show Rillet spend by GL account for October and flag anything that looks miscoded.
Budget owners
Check spend with one vendor
See everything paid to one vendor in a period, from every source.
How much did we spend with Contoso in Rillet this year, across bills and cards?
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant totals Rillet spend by vendor and GL account across every source. It only reads, and it reports per currency with tax shown apart.
01
Ask
You give a date range, and optionally a vendor.
02
Read
It reads bill lines, card charges and reimbursements in the period.
03
Report
You get top vendors, spend by GL account and notable items.
04
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-vendors
rillet-get-bill-lines
rillet-get-charge-items
rillet-get-reimbursement-items
rillet-get-accounts
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
See where spend really goes
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)
