Connectors

/

Harvest

/

Match Harvest clients to Rillet customers
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Harvest clients to Rillet customers
Check that all our active Harvest clients have a customer in Rillet, and tell me which Rillet customers have no client in Harvest.
Most clients matched, but 2 Harvest clients have no Rillet customer and 1 match is ambiguous. - Matched by name: 41 clients - Matched by invoicing name: Contoso (Harvest) to Contoso Holdings Ltd (Rillet) - Harvest only: Tailspin Toys, Fabrikam Studio - Ambiguous: Northwind could be two Rillet customers Shall I include inactive Harvest clients too?
Harvest
Sample figures. Your results come from your own account.
harvest-get-clients
harvest-get-contacts
rillet-get-customers
rillet-get-customer-emails

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

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.

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

Your AI tool

Read

It reads Harvest clients and contacts and Rillet customers and emails.

harvest-get-clients
harvest-get-contacts
rillet-get-customers
rillet-get-customer-emails

Match

It matches by name, invoicing name, then shared contact email, and notes the rule used.

No items found.

Report

You see matches, gaps on both sides and ambiguous candidates.

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-clients

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

harvest-get-contacts

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

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location 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

A customer list you can trust on both sides

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