/
/
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.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
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.
**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.
Harvest
It reads billable, invoiced and uninvoiced work for that client.
Rillet
It finds the matching customer and reads contracts, invoices and ARR.
Report
You get a short table and a plain explanation of the differences, 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-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
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
One client, two systems, one clear answer
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)
