Connectors

/

Harvest

/

Compare Harvest client billing with Rillet contracts
Report
Cross-Connector

See where Harvest billing and Rillet contracts disagree

For finance teams who want one client's tracked work compared with its contract, invoices and recurring revenue, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Harvest client billing with Rillet contracts
Compare what we billed Fabrikam in Harvest from July 1 to September 30 with their contract and invoices in Rillet.
Fabrikam's tracked work is higher than what Rillet shows invoiced, by about USD 5,200. - Harvest: 410 billable hours, USD 61,500 billable, USD 56,300 invoiced, USD 5,200 uninvoiced - Rillet: USD 56,300 invoiced, USD 0 due - Contract: total value USD 60,000, usage commitment USD 15,000 a quarter - Note: work runs slightly over the contract value Want the project by project breakdown?
Harvest
Sample figures. Your results come from your own account.
harvest-get-clients
harvest-get-time-reports-projects
harvest-get-uninvoiced-report
harvest-get-invoices
rillet-get-customers
rillet-get-contracts
rillet-get-invoices
rillet-get-arr-waterfall

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

Tracked work and the ledger tell different stories

To check one client you pull time and invoice reports from Harvest and contract and invoice data from Rillet. Rebuilding the comparison by hand makes it easy to overlook unbilled work or a contract overrun.

Without PopdockAI

  • Pull billable and uninvoiced reports in Harvest
  • Find the same customer in Rillet by name
  • Collect contracts, invoices and ARR separately
  • Rebuild the comparison in a spreadsheet

With PopdockAI

  • Both sides are read for the same client and period
  • The Rillet customer is matched by name
  • Differences are explained in plain words
  • Currencies are never converted or added together

The prompt

Use this prompt

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

Prompt
**Objective:** For the Harvest client `{client-name}`, compare the work billed in Harvest from `{period-start}` to `{period-end}` with the contracts, invoices and recurring revenue Rillet holds for the same customer.

**Step 1: Harvest side (harvest server)**

Call `harvest-get-clients` with `name` set to `{client-name}`. If it returns none or more than one, list the matches and stop. Then call `harvest-get-time-reports-projects` with `client-id` set to that client's `id`, `period-start` set to `{period-start}` and `period-end` set to `{period-end}`; keep `project-name`, `total-hours`, `billable-hours` and `billable-amount`. Call `harvest-get-uninvoiced-report` with the same client and period for the uninvoiced hours and amount. Call `harvest-get-invoices` with `client-id` and the issue date window for the invoiced total.

**Step 2: Carry the client across to Rillet (rillet server)**

Call `rillet-get-customers` and find the customer whose `name` or `invoicing-name` equals the Harvest client name, ignoring case. If none matches, report the client as present in Harvest and absent from Rillet, show the Harvest figures and stop. If several match, list them and stop.

**Step 3: Rillet side**

With that `customer-id` call `rillet-get-contracts` (filter `customer-id`), `rillet-get-invoices` (keep invoices with that `customer-id` dated in the period) and `rillet-get-arr-waterfall` (filter `customer-id`).

**Step 4: Report**

Show a short table with Harvest billable amount, Harvest invoiced, Harvest uninvoiced, Rillet invoiced (`total`), Rillet amount due, and active contract `total-value` and `usage-commitment`. Then state in plain words where the figures disagree (for example billed in Harvest but no matching Rillet invoice, or work well above the contract value) and by how much, per currency.

**Rules & Guidelines:**

* `harvest-get-clients`, `harvest-get-time-reports-projects`, `harvest-get-uninvoiced-report` and `harvest-get-invoices` are on the harvest server. `rillet-get-customers`, `rillet-get-contracts`, `rillet-get-invoices` and `rillet-get-arr-waterfall` are on the rillet server.
* This is read-only. Do not call any Harvest action tool such as `harvest-invoices-create`, or any Rillet action tool such as `rillet-add-invoice` or `rillet-update-customer`.
* Never add together amounts in different currencies.

**Validation:**

* If the Harvest and Rillet currencies differ, report both and do not convert.
* If `{period-start}` or `{period-end}` is empty, ask for them and stop.

Who it's for

One answer, three teams that use it

Revenue accountants

Check billed work against the contract

See whether tracked and invoiced work stays within the contract value and usage commitment held in Rillet.

Compare Contoso's Harvest billing for Q3 with their Rillet contract and invoices.

Billing managers

Find work that was never invoiced

Spot uninvoiced Harvest hours that have no matching Rillet invoice, so billing catches up before month end.

Is there uninvoiced Harvest work for Northwind Traders that does not appear in Rillet invoices for August?

Finance directors

Review a key account before renewal

Get the billing, contract and recurring revenue view of one client in a single answer.

Give me Harvest billing versus Rillet ARR and contract value for Fabrikam from January to June.

How it works

What PopdockAI does when you ask

You name the client and the period, and your AI assistant carries the client across from Harvest to Rillet. It stops if the client or customer is unclear and changes nothing.

Ask

You name the Harvest client and the period to compare.

Your AI tool

Harvest

It reads billable, invoiced and uninvoiced work for that client.

harvest-get-clients
harvest-get-time-reports-projects
harvest-get-uninvoiced-report
harvest-get-invoices
rillet-get-customers
rillet-get-contracts
rillet-get-invoices
rillet-get-arr-waterfall

Rillet

It finds the matching customer and reads contracts, invoices and ARR.

No items found.

Report

You get a short table and a plain explanation of the differences, 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-clients

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

harvest-get-time-reports-projects

Returns time reports by project from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-uninvoiced-report

Returns uninvoiced report from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
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-customers

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

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-invoices

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

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month 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

One client, two systems, one clear answer

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