/
/
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.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads non-draft Harvest invoices and Rillet invoices for the window.
Match
It pairs by invoice number, with a flagged fallback on client, amount and date.
Report
You get four lists with counts and the difference 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-invoices
rillet-get-invoices
rillet-get-customers
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
Invoice differences found 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)
