Connectors

/

2Checkout

/

Match 2Checkout payments to Rillet payments
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match 2Checkout payments to Rillet payments
Compare 2Checkout payments with Rillet invoice payments from 2026-09-01 to 2026-09-30 in USD.
41 USD payments matched, with 2 unmatched on the 2Checkout side and 1 on the Rillet side. - Totals: 2Checkout 48,210.00, Rillet 47,960.00, difference 250.00 - In 2Checkout only: 2026-09-12 for 250.00 and 2026-09-27 for 90.00 - In Rillet only: payment PAY-3318 for 90.00 dated 2026-09-30 - Note: matches are heuristic, on amount, currency and date only Want the list of matched pairs as well?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-accountingpayment
rillet-get-invoice-payments

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

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.

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

Your AI tool

02

Read

It reads 2Checkout payments and Rillet invoice payments for the window.

2checkout-get-accountingpayment
rillet-get-invoice-payments

03

Match

It pairs equal amounts and currencies within 3 days and lists candidates when unsure.

No items found.

04

Report

It gives totals, the difference, unmatched payments on each side and matched pairs.

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-accountingpayment

Returns accounting payments 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-invoice-payments

Returns payments received against customer invoices 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

See what does not reconcile for the period

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