/
/
One financial brief per client from Harvest and NetSuite
For leaders preparing a client call or renewal who ask their AI assistant for billing, unbilled work and account position in one place.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
A client view means stitching two systems together
Billing sits in Harvest and the account balance sits in NetSuite, so preparing for a client call means collecting both by hand. Unbilled work and open amounts that disagree are easy to miss.
Without PopdockAI
- Pull invoices and unbilled time from Harvest
- Check budgets on the active projects
- Look up balance, invoices and orders in NetSuite
- Combine them into notes for the call
With PopdockAI
- The client is found in both systems first
- Billing, unbilled work and budgets come from Harvest
- Balance, open invoices and orders come from NetSuite
- A watch list flags overdue, over budget and mismatches
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a single financial brief for `{client-name}`, covering Harvest work and billing over the last `{lookback-days}` days (default 90) and the NetSuite account position.
**Step 1: Find the client in both systems**
Call `harvest-get-clients` (Harvest server) with `name.contains` set to `{client-name}` and `netsuite-get-customer` (NetSuite server) with `name.contains` set to the same text. If either returns more than one match, list the matches and stop. If one system has no match, say so and continue with the other.
**Step 2: Harvest billing and work**
Using the client `id` as `client-id`:
* `harvest-get-invoices` for invoices in the window: amount, due-amount and state.
* `harvest-get-uninvoiced-report` for the same window: uninvoiced hours, amount and expenses.
* `harvest-get-project-budget-report` for active projects: budget remaining.
**Step 3: NetSuite account position**
Using the customer name as `customer` or the `internal-id` as `customer-id` as each tool allows:
* Customer `balance` from the customer record.
* `netsuite-get-invoice` with `unpaid-amount.min` set to 0.01 for unpaid invoices.
* `netsuite-get-salesorder` for orders in the window and their `status`.
**Step 4: Report**
Sections: Billing in Harvest, Unbilled work, NetSuite balance and open invoices, Sales orders, and a closing "Watch list" with anything overdue, over budget, or where the Harvest and NetSuite open amounts disagree by more than 1 percent.
**Rules & Guidelines:**
* `harvest-*` tools belong to the Harvest server and `netsuite-*` tools belong to the NetSuite server. Both servers must be connected.
* This is read-only. Never call a Harvest tool that creates, updates, deletes, stops or restarts anything (for example `harvest-clients-create`, `harvest-invoices-create`, `harvest-invoice-payments-create` or `harvest-invoices-update`), and never call a NetSuite add or update tool (for example `netsuite-add-customer`, `netsuite-add-invoice`, `netsuite-update-customer` or `netsuite-update-invoice`).
* Harvest rates and cost rates are sensitive: do not show them unless asked.
**Validation:**
* Show amounts in their own currency and do not add across currencies.
* If a section has no data, write "none found" for it rather than leaving it out.Who it's for
One answer, three teams that use it
Executives
Prepare for a renewal in minutes
You see what the client has been billed, what is still unbilled and what they owe, before you pick up the phone.
Give me a financial brief for Northwind Traders before the renewal meeting tomorrow.
Account managers
Know the account position before you call
Open invoices, budget left and sales orders sit beside each other, so you are not surprised by an overdue balance.
What does Fabrikam owe us, and how much work is unbilled in Harvest for the last 60 days?
Finance leads
Spot differences between the two systems
The watch list flags where Harvest and NetSuite open amounts differ by more than 1 percent, so you can investigate early.
Build a client brief for Contoso and tell me if Harvest and NetSuite open amounts disagree.
How it works
What PopdockAI does when you ask
You name the client and your AI assistant reads both systems to build the brief. Currencies stay separate and nothing is changed.
Ask
You name the client and, if you like, how many days to look back.
Find
It finds the client in Harvest and NetSuite and stops if the name is ambiguous.
Gather
It reads billing, unbilled work and budgets from Harvest and the balance, open invoices and sales orders from NetSuite.
Report
You get a section for each plus a watch list of risks.
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
netsuite-get-customer
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-project-budget-report
netsuite-get-invoice
netsuite-get-salesorder
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
Go into the client call with the full picture
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)
