/
/
Reconcile 2Checkout customers with Rillet customers
For finance teams who keep billing and accounting customers aligned, by asking their AI assistant to compare 2Checkout customers with Rillet.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Invoices held up by customers missing in Rillet
Finance exports customers from 2Checkout and from Rillet and compares them in a spreadsheet. Customers exist in one system and not the other, and invoices cannot be raised until someone notices.
Without PopdockAI
- Export customers from 2Checkout
- Export customers and emails from Rillet
- Match on email in a spreadsheet
- Find the gap when an invoice is held up
With PopdockAI
- Customers read from 2Checkout and Rillet
- Matched on email, ignoring case and spaces
- Name or country differences noted
- Duplicates listed, never guessed, 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:** Compare 2Checkout customers (optionally only those at company `{company}`, up to `{max-records}` customers, default 50) with Rillet customers and report who is missing from each system.
**Step 1: Read customers from 2Checkout**
Call `2checkout-get-customer` with `company` set to `{company}` if given and `max-records` set to `{max-records}` (50 if empty). Keep `customer-reference`, `first-name`, `last-name`, `company`, `email` and `enabled`. Set aside customers with no email and count them.
**Step 2: Read customers from Rillet**
Call `rillet-get-customer-emails` (it has no filters, so read all rows) and keep `customer-id`, `name` and `email`. Call `rillet-get-customers` and join on `customer-id` to add `invoicing-name`, `payment-terms` and `country`.
**Step 3: Match on email**
For each 2Checkout customer, look for a Rillet row with the same email. Mark it matched, or absent from Rillet. List Rillet emails that matched no 2Checkout customer in the sample.
**Step 4: Report**
Give four lists: matched customers (with any name or country mismatch), 2Checkout customers missing from Rillet, Rillet customers not in the 2Checkout sample, and customers skipped for having no email. End with the counts.
**Rules & Guidelines:**
* Tools whose names start with 2checkout belong to the 2checkout server and tools whose names start with rillet belong to the Rillet server. Both servers must be connected.
* The shared key is the email address: 2checkout `email` or `end-user-email` against Rillet `email` from `rillet-get-customer-emails`, which carries the Rillet `customer-id`. Compare emails case-insensitively after trimming spaces.
* This is read-only: never call any 2checkout action tool (any 2checkout tool that adds, updates, cancels, refunds, enables, disables or renews) and never call any Rillet tool that adds, updates, applies, unapplies, records or sets, such as `rillet-add-customer`, `rillet-add-invoice-ar-only`, `rillet-add-invoice-revenue-only`, `rillet-add-invoice-payment`, `rillet-add-credit-memo`, `rillet-update-customer`, `rillet-update-invoice` and `rillet-set-invoice-sent-status`.
**Validation:**
* If `2checkout-get-customer` returns nothing, say so and stop.
* If one email maps to more than one Rillet customer, list the duplicates and do not pick one.
* State that the 2Checkout side is limited to `{max-records}` customers, so Rillet-only customers are only those outside that sample.Who it's for
One answer, three teams that use it
Accounts receivable
Create missing customers before billing
2Checkout customers missing from Rillet are listed so they can be set up.
Which 2Checkout customers are missing from Rillet?
Master data analysts
Fix name and country differences
Matched customers with a different name or country are flagged.
Reconcile 2Checkout customers at Contoso with Rillet and show differences.
Controllers
Check customer coverage before close
Counts on each side show how complete the customer master is.
How many of our 2Checkout customers have a Rillet record? Check 100.
How it works
What PopdockAI does when you ask
You give an optional company and a count, and your AI assistant pairs customers on email. If one email maps to several Rillet customers it lists them rather than choosing.
01
Ask
You give an optional company and how many customers to read.
02
Read
It reads 2Checkout customers and the Rillet customer list with email addresses.
03
Match
It pairs customers on email and notes name or country differences.
04
Report
It gives four lists with counts, noting the 2Checkout side is a sample.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-customer
rillet-get-customer-emails
rillet-get-customers
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
No invoice held up by a missing customer
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)
