/
/
Find payments recorded in only one system
For finance teams who want Harvest payments checked against Rillet payments for a date range, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Payments that only one system knows about
Harvest and Rillet each hold a list of payments, and finance compares them by hand. A payment missing from one side, or recorded with another amount or date, can go unnoticed until close.
Without PopdockAI
- Export payments from Harvest and from Rillet
- Line up invoice numbers in a spreadsheet
- Check amounts and dates row by row
- Find the missing payment at month end
With PopdockAI
- Both payment lists are read for the same date range
- Matches use invoice number, amount and date
- One-sided and mismatched payments are listed
- Nothing is created, edited or deleted
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find payments that are recorded in one of Harvest and Rillet but not the other, for payments dated from `{paid-date-from}` to `{paid-date-to}` (default today).
**Step 1: Read Harvest payments (harvest server)**
Call `harvest-get-invoice-payments` with `paid-date.from` set to `{paid-date-from}` and `paid-date.to` set to `{paid-date-to}` if given. Keep `invoice-number`, `invoice-client-name`, `amount`, `paid-date` and `transaction-id`.
**Step 2: Read Rillet payments (rillet server)**
Call `rillet-get-invoice-payments`. It has no filters, so keep only payments whose `date` is in the same window. Call `rillet-get-invoices` and use `invoice-id` to look up the `invoice-number` and `customer-id` of each payment.
**Step 3: Match**
Match a Harvest payment to a Rillet payment when the invoice number is the same, the `amount` is equal and the dates are within 3 days. Each payment may be matched only once, so two equal payments on one invoice need two matches.
**Step 4: Report**
List: Harvest payments with no Rillet payment; Rillet payments with no Harvest payment; matched pairs where the date differs by more than 3 days or the amounts differ. Finish with counts and the total value of each unmatched group per currency.
**Rules & Guidelines:**
* `harvest-get-invoice-payments` is on the harvest server. `rillet-get-invoice-payments` and `rillet-get-invoices` are on the rillet server.
* This is read-only. Do not call `harvest-invoice-payments-create`, `harvest-invoice-payments-delete`, `rillet-add-invoice-payment` or `rillet-update-invoice-payment`.
**Validation:**
* If `{paid-date-from}` is empty, ask for it and stop.
* If a Rillet payment points at an invoice id that is not in `rillet-get-invoices`, list it as unresolved rather than dropping it.
* If one system has no payments in the window, say so and report all of the other system's payments as unmatched.
Who it's for
One answer, three teams that use it
Accounts receivable
Confirm each payment landed in both systems
See payments recorded in Harvest that never reached the ledger, so cash is applied correctly.
Which Harvest payments from last week have no matching payment in Rillet?
Controllers
Clear payment differences before close
Review matched payments with date or amount differences and unresolved invoice links as part of the close routine.
Reconcile Harvest and Rillet payments for September and list any amounts or dates that differ.
Finance analysts
Get a count and value of unmatched cash
Receive totals per currency for each unmatched group, ready to hand to the controller.
Show unmatched Harvest and Rillet payments from Oct 1 to Oct 31 with totals per currency.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant reads payments from Harvest and Rillet. It reports differences only, and leaves every correction to your team.
Ask
You give the payment date range to check.
Read
It reads payments from Harvest and Rillet and ties Rillet payments to invoice numbers.
Match
It pairs payments by invoice number, amount and date, using each one once.
Report
You get unmatched and mismatched payments with counts and totals per currency.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-invoice-payments
rillet-get-invoice-payments
rillet-get-invoices
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
Cash application checked before the books close
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)
