/
/
Match 2Checkout payments to Rillet payments for the month
For finance teams who reconcile billing receipts to the ledger, by asking their AI assistant to compare 2Checkout and Rillet for a date range.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Cash reconciliation with no shared payment number
Month end cash reconciliation between 2Checkout and Rillet is usually done by eye across two exports. There is no shared payment number, so unmatched payments are found late, if at all.
Without PopdockAI
- Export payments from 2Checkout
- Export invoice payments from Rillet
- Pair amounts and dates in a spreadsheet
- Find the unmatched payment weeks later
With PopdockAI
- Payments read from both systems for the window
- Paired on currency, amount and dates within 3 days
- Several candidates listed instead of a guess
- Every pair labelled heuristic, 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 payments paid from `{from-date}` to `{to-date}` (format YYYY-MM-DD) with Rillet invoice payments in the same window and list what does not reconcile, limited to currency `{currency}` if given.
**Step 1: Read 2Checkout payments**
Call `2checkout-get-accountingpayment` with `paid-on.from` set to `{from-date}`, `paid-on.to` set to `{to-date}` and, if `{currency}` is given, `currency` set to it. Keep `invoice-type`, `status`, `amount`, `currency`, `paid-on` and `balance`.
**Step 2: Read Rillet payments**
Call `rillet-get-invoice-payments` (no filters, read all rows) and keep rows with `date` in the window, and if `{currency}` is given only that currency. Keep `payment-id`, `invoice-id`, `amount`, `currency`, `date`, `status` and `account-code`.
**Step 3: Match**
Pair a 2Checkout payment with a Rillet payment when currency is equal, amount is equal and dates are within 3 days of each other. Use each row once. These are heuristic matches, so label them as such.
**Step 4: Report**
Give: totals by currency on each side and the difference, 2Checkout payments with no Rillet payment, Rillet payments with no 2Checkout payment, and the count of matched pairs.
**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.
* There is no shared payment id, so the join is amount, currency and date only. Say this in the report.
* 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 either side returns nothing for the window, report that and still show the other side's total.
* If one amount could pair with several rows, list the candidates instead of choosing.Who it's for
One answer, three teams that use it
Accountants
Close cash faster at month end
Get totals by currency, the difference and what is unmatched on each side.
Match 2Checkout payments to Rillet invoice payments for October 2026.
Controllers
Know the size of the gap
See the difference between the two systems per currency before you sign off.
What is the difference between 2Checkout and Rillet payments in EUR for Q3 2026?
Accounts receivable
Find payments that were never applied
Unmatched 2Checkout payments may need applying to an invoice in Rillet.
List 2Checkout payments from last week with no matching Rillet invoice payment.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant pairs 2Checkout payments with Rillet invoice payments. Every match is labelled as a best guess.
01
Ask
You give a date range and, if you like, a currency.
02
Read
It reads 2Checkout payments and Rillet invoice payments for the window.
03
Match
It pairs equal amounts and currencies within 3 days and lists candidates when unsure.
04
Report
It gives totals, the difference, unmatched payments on each side and matched pairs.
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-accountingpayment
rillet-get-invoice-payments
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 what does not reconcile for the period
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)
