Connectors

/

2Checkout

/

Reconcile 2Checkout customers with Rillet customers
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile 2Checkout customers with Rillet customers
Reconcile up to 50 2Checkout customers with Rillet customers and tell me who is missing from Rillet.
Of 50 2Checkout customers, 46 are in Rillet and 4 are missing. - Matched: 46 customers, 1 with a country mismatch - Missing from Rillet: dana@northwindtraders.com, amy@fabrikam.com, plus 2 more - Rillet only, outside the sample: 12 customers - Skipped, no email: 1 customer Want the full lists?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-customer
rillet-get-customer-emails
rillet-get-customers

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

2Checkout

2Checkout
Run it on your own 2Checkout data.

Connect 2Checkout, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Read

It reads 2Checkout customers and the Rillet customer list with email addresses.

2checkout-get-customer
rillet-get-customer-emails
rillet-get-customers

03

Match

It pairs customers on email and notes name or country differences.

No items found.

04

Report

It gives four lists with counts, noting the 2Checkout side is a sample.

Your AI tool

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.

get-data

2checkout-get-customer

Returns customers records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
Read only.Nothing in 2Checkout 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

No invoice held up by a missing customer

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