Connectors

/

Harvest

/

Reconcile Harvest payments with Rillet payments
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Harvest payments with Rillet payments
Reconcile Harvest and Rillet payments received between October 1 and October 31 and show me anything that does not match.
Of the October payments, 2 are in Harvest only, 1 is in Rillet only and 1 pair differs. - Harvest only: INV-1042 payment of USD 2,400 on Oct 9 - Harvest only: INV-1047 payment of USD 950 on Oct 21 - Rillet only: INV-1039 payment of USD 1,200 on Oct 14 - Date gap: INV-1033, paid Oct 3 in Harvest and Oct 11 in Rillet Want the unresolved invoice links as well?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoice-payments
rillet-get-invoice-payments
rillet-get-invoices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Harvest

Harvest
Run it on your own Harvest data.

Connect Harvest, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

Read

It reads payments from Harvest and Rillet and ties Rillet payments to invoice numbers.

harvest-get-invoice-payments
rillet-get-invoice-payments
rillet-get-invoices

Match

It pairs payments by invoice number, amount and date, using each one once.

No items found.

Report

You get unmatched and mismatched payments with counts and totals per currency.

Your AI tool

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.

get-data

harvest-get-invoice-payments

Returns invoice payments from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

rillet-get-invoice-payments

Returns payments received against customer invoices from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
Read only.Nothing in Harvest 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

Cash application checked before the books close

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation