Connectors

/

Harvest

/

Reconcile Harvest invoices with Rillet invoices
Report
Cross-Connector

Reconcile Harvest and Rillet invoices at month end

For finance teams who want invoices matched across Harvest and Rillet by number, with every difference listed, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Harvest invoices with Rillet invoices
Reconcile all Harvest invoices issued in October against Rillet and show me what is missing or does not agree.
Most October invoices agree, but 2 are missing from Rillet and 1 has a different total. - In Harvest only: INV-1042 (Contoso, USD 3,600) and INV-1048 (Fabrikam, USD 1,150) - Total differs: INV-1036, Harvest USD 2,400 and Rillet USD 2,040 - Status differs: INV-1031 paid in Harvest, USD 800 due in Rillet - Drafts skipped: 3 Want the Rillet-only invoices listed too?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
rillet-get-invoices
rillet-get-customers

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

Month end invoice matching by spreadsheet

Finance exports invoices from Harvest and the ledger and compares them line by line. Missing or mismatched invoices slip through, especially when totals, currencies or paid statuses differ.

Without PopdockAI

  • Export invoices from Harvest and from the ledger
  • Match invoice numbers line by line
  • Compare totals, amounts due and currency
  • Miss the invoice open in one system and paid in the other

With PopdockAI

  • Both invoice lists are read for the same window
  • Drafts are skipped and counted separately
  • Differences are shown with both values
  • Duplicates are listed and nothing is written

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Reconcile Harvest invoices issued from `{issue-date-from}` to `{issue-date-to}` (default today) against the Rillet invoices, optionally for one client `{client-name}`.

**Step 1: Read Harvest (time tracking system)**

Call `harvest-get-invoices` with `issue-date.from` set to `{issue-date-from}`, `issue-date.to` set to `{issue-date-to}` if given, and `client-name` set to `{client-name}` if given. Skip draft invoices (state `draft`) and report their count separately. Keep `number`, `client-name`, `issue-date`, `amount`, `due-amount`, `state` and `currency`.

**Step 2: Read Rillet (accounting system)**

Call `rillet-get-invoices`. It has no filters, so filter the result yourself to the same date window using `invoice-date`. Call `rillet-get-customers` and keep `customer-id` and `name` so a Rillet invoice can be tied to a client name through `customer-id`.

**Step 3: Match**

Match each Harvest invoice to a Rillet invoice by `number` (Harvest) equal to `invoice-number` (Rillet), ignoring case and leading or trailing spaces. If nothing matches on number, try the same client (Harvest `client-name` equal to Rillet customer `name`) with the same amount and an invoice date within 3 days, and mark it as a probable match. For each matched pair compare `amount` with `total`, `due-amount` with `amount-due`, and `currency`.

**Step 4: Report**

Give four short tables: invoices in Harvest and not in Rillet; invoices in Rillet and not in Harvest; matched invoices where the total, amount due or currency differ (show both values and the difference); matched invoices where one system shows paid and the other shows an amount due. End with counts and the total difference per currency.

**Rules & Guidelines:**

* `harvest-get-invoices` is on the harvest server. `rillet-get-invoices` and `rillet-get-customers` are on the rillet server.
* This is read-only. Do not call any Harvest action tool such as `harvest-invoices-update`, `harvest-invoices-create` or `harvest-invoice-payments-create`. Do not call any Rillet action tool such as `rillet-add-invoice`, `rillet-update-invoice` or `rillet-add-invoice-payment`.
* Never add together amounts in different currencies.

**Validation:**

* If `{issue-date-from}` is empty, ask for it and stop.
* If either system returns no invoices for the window, say so and report everything from the other system as unmatched.
* If more than one Rillet invoice has the same invoice number, list them and do not guess.

Who it's for

One answer, three teams that use it

Accounts receivable

Find invoices missing from the ledger

See Harvest invoices that never reached Rillet, so receivables are complete before you chase payment.

Which Harvest invoices issued in September are missing from Rillet?

Controllers

Close the month with matched invoices

Review total, amount due and currency differences in one report before the ledger is locked.

Reconcile Harvest and Rillet invoices from Oct 1 to Oct 31 and give me the net difference per currency.

Finance analysts

Check one client quickly

Limit the reconciliation to a single client when a customer queries a balance.

Compare Northwind Traders invoices in Harvest and Rillet for this quarter.

How it works

What PopdockAI does when you ask

You set the issue date window and your AI assistant reads both systems and matches by invoice number. It reports only, and totals are kept separate for each currency.

Ask

You give the issue date window and, if you like, one client.

Your AI tool

Read

It reads non-draft Harvest invoices and Rillet invoices for the window.

harvest-get-invoices
rillet-get-invoices
rillet-get-customers

Match

It pairs by invoice number, with a flagged fallback on client, amount and date.

No items found.

Report

You get four lists with counts and the difference 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-invoices

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

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) 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

Invoice differences found 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