/
/
Check every Harvest client has a Rillet customer
For finance teams who want Harvest clients and Rillet customers matched by name, invoicing name and email, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Client lists that drift away from the ledger
Harvest clients and Rillet customers are entered separately and slowly diverge. Finding a client never set up for invoicing means comparing names by eye, trading names and all.
Without PopdockAI
- Export clients from Harvest and customers from Rillet
- Compare names by eye
- Miss clients known by a different invoicing name
- Discover the unset client when an invoice fails
With PopdockAI
- Both customer lists are read for you
- Matching uses name, invoicing name and email
- The rule behind each match is shown
- Ambiguous cases are listed, never decided
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check that every Harvest client has a Rillet customer and every Rillet customer has a Harvest client, looking at active Harvest clients only unless `{include-inactive}` is yes (default no), and only clients whose name contains `{name-contains}` if given.
**Step 1: Read Harvest (harvest server)**
Call `harvest-get-clients` with `active` set to true (omit it when `{include-inactive}` is yes) and `name.contains` set to `{name-contains}` if given. Keep `id`, `name`, `currency` and `address`. Call `harvest-get-contacts` and keep `client-name` and `email`.
**Step 2: Read Rillet (rillet server)**
Call `rillet-get-customers` and keep `customer-id`, `name`, `invoicing-name` and `country`. Call `rillet-get-customer-emails` and keep `customer-id` and `email`.
**Step 3: Match**
Match in this order and record which rule matched: exact `name` ignoring case and punctuation; Harvest `name` equal to Rillet `invoicing-name`; a contact email shared by a Harvest client and a Rillet customer. If a client could match more than one customer, list the candidates and do not choose.
**Step 4: Report**
Show matched clients with the rule used, then Harvest clients with no Rillet customer, then Rillet customers with no Harvest client, then ambiguous matches.
**Rules & Guidelines:**
* `harvest-get-clients` and `harvest-get-contacts` are on the harvest server. `rillet-get-customers` and `rillet-get-customer-emails` are on the rillet server.
* This is read-only. Do not call `harvest-clients-create`, `harvest-clients-update`, `rillet-add-customer` or `rillet-update-customer`.
**Validation:**
* If `{name-contains}` matches no Harvest client, say so and stop.
* If either system returns no records, report that and do not mark everything on the other side as missing without saying why.
Who it's for
One answer, three teams that use it
Accounts receivable
Find clients not yet set up for invoicing
See Harvest clients with no Rillet customer before the first invoice has to be raised.
Which active Harvest clients have no matching customer in Rillet?
Finance operations
Keep the ledger in line with delivery
Check Rillet customers that have no Harvest client, which may be dormant or never connected to tracked work.
List Rillet customers that have no Harvest client, and show how the others matched.
Controllers
Review ambiguous matches before close
Get a list of clients that could belong to more than one customer, so someone decides instead of a guess.
Match Harvest clients containing Contoso to Rillet customers and list any ambiguous candidates.
How it works
What PopdockAI does when you ask
You say which clients to check and your AI assistant matches Harvest to Rillet in a fixed order. It lists what it cannot match and edits nothing in either system.
Ask
You choose whether to include inactive clients or filter by part of a name.
Read
It reads Harvest clients and contacts and Rillet customers and emails.
Match
It matches by name, invoicing name, then shared contact email, and notes the rule used.
Report
You see matches, gaps on both sides and ambiguous candidates.
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-clients
harvest-get-contacts
rillet-get-customers
rillet-get-customer-emails
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
A customer list you can trust on both sides
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)
