/
/
Find Ramp bills that are not booked in Rillet
For finance teams who ask their AI assistant to match Ramp bills to Rillet bills and show what is missing or different.
On this page
Connector
Connect Ramp, pick your AI tool and paste the prompt.
The problem
Unbooked Ramp bills leave Rillet payables misstated
Matching Ramp bills to Rillet bills by hand means comparing invoice numbers and totals across two screens. Bills never booked, or booked for a different amount, slip through and payables are misstated at close.
Without PopdockAI
- List Ramp bills due in the period
- Find each one in Rillet by invoice number
- Add up Rillet bill lines to get a total
- Miss the unbooked bill before close
With PopdockAI
- Ramp bills read, rejected and deleted ones skipped
- Rillet bills and lines read and totalled
- Matched by invoice number, close matches marked Probable
- Problems first with the value not in Rillet, 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:** For bills due between `{due-from}` and `{due-to}` (ISO dates, both required), find Ramp bills that are not booked in Rillet and booked bills whose amounts differ.
**Step 1: Read Ramp bills**
Call `ramp-get-bill` (ramp server) with `due-date.from` = `{due-from}` and `due-date.to` = `{due-to}`. Keep `id`, `invoice-number`, `vendor-name`, `amount`, `currency-code`, `due-date`, `approval-status`. Skip bills whose `approval-status` is rejected or deleted.
**Step 2: Read Rillet bills and lines**
Call `rillet-get-bills` (rillet server) with `due-date.from` and `due-date.to` set to the same range, widened by 7 days each side. Then call `rillet-get-bill-lines` with the matching bill-date range and sum `amount` by `expense-number` to get each bill total. Call `rillet-get-vendors` and map `vendor-id` to `name`.
**Step 3: Match**
Match a Ramp `invoice-number` to a Rillet `expense-number` (exact, then case and whitespace insensitive). If there is no number match, try same vendor name plus same total plus due dates within 3 days and mark it Probable. Compare totals only when currencies are equal.
**Step 4: Report**
Table with Ramp invoice number, vendor, Ramp amount, Rillet total, difference, status (Matched, Amount differs, Not in Rillet, Only in Rillet, Probable). Put problems first, largest difference first. Finish with counts and the total value not in Rillet.
**Rules & Guidelines:**
* Tools starting ramp- are on the ramp server and tools starting rillet- are on the rillet server. Both servers must be connected.
* Read only. Never call any Ramp or Rillet write tool: not `ramp-bill-add`, `ramp-bill-update`, `ramp-vendor-add`, `ramp-vendor-update`, `ramp-accounting-sync-ready`, `rillet-add-bill`, `rillet-add-vendor`, `rillet-update-bill`, `rillet-add-bill-payment`, nor any other tool whose name contains add, update, delete, archive or upload.
**Validation:**
* If either date is missing or not an ISO date, ask for it and stop.
* If currencies differ for a matched pair, report both and do not compute a difference.
* If either side returns nothing, say which and stop.Who it's for
One answer, three teams that use it
Accounts payable
Book every Ramp bill in Rillet
Bills not in Rillet are listed largest first, so you book the big ones first.
Which Ramp bills due in November are not booked in Rillet?
Accountants
Find amount differences
Bills booked for a different amount are shown with the size of the gap.
Reconcile Ramp and Rillet bills due in October and show amount differences.
Controllers
Size the payables gap at close
The total value not in Rillet tells you how far payables are understated.
What is the total value of Ramp bills due this quarter that are not in Rillet?
How it works
What PopdockAI does when you ask
You give a due-date range and your AI assistant matches Ramp bills to Rillet. Amounts are compared only in the same currency and nothing is changed.
01
Ask
You give the due-date range.
02
Read
It reads the Ramp bills, and the Rillet bills and lines for the same period.
03
Match
It matches by invoice number and marks close vendor, total and date matches Probable.
04
Report
It lists problems first, with counts and the value not in Rillet.
What PopdockAI provides
The tools behind the answer
Ready made tools for Ramp and one secure connection to your AI tool. No code, no exports.
ramp-get-bill
rillet-get-bills
rillet-get-bill-lines
rillet-get-vendors
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
Unbooked bills found before close
Related use cases
More ways to put this data to work
Book an approved Ramp bill in Rillet
Ask your AI to book an approved Ramp bill in Rillet. It checks the vendor, account and duplicates, confirms the line totals, and books only after you say yes.
Learn More
Record a Ramp bill payment in Rillet
Ask your AI to record a Ramp bill payment in Rillet. It checks the bill is paid, not already recorded and the amounts agree, then records it after you confirm.
Learn More
Reconcile Ramp bill payments with Rillet
Ask your AI to check Ramp bills paid in a date range against Rillet payments. It lists the exceptions, largest first, and changes nothing.
Learn More
Compare Ramp GL accounts with the Rillet chart of accounts
Ask your AI to compare Ramp GL codes with the Rillet chart of accounts. It reports missing codes, name differences and inactive accounts, and changes nothing.
Learn More
Reconcile Ramp reimbursements with Rillet
Ask your AI to match Ramp reimbursements to Rillet over a date range. It lists unbooked and differing ones, and adds nothing to either system.
Learn More
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.