/
/
Find expenses that exist in Harvest but not in NetSuite
For finance teams who want to know who forgot an expense report, by asking their AI assistant to compare Harvest and NetSuite for a date range.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Expenses get logged in one system and forgotten in the other
Harvest holds the expenses for client billing and NetSuite holds the reports for reimbursement. Nobody checks the two against each other, so a missing report or a missing expense surfaces late.
Without PopdockAI
- Export expenses from Harvest
- Export expense reports from NetSuite
- Compare names across two spreadsheets by eye
- Miss people whose names are written differently
With PopdockAI
- Both systems are read for the same date range
- People are matched ignoring case and name order
- Report status is shown for each match
- Nothing is changed in either system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For `{from-date}` to `{to-date}` (default today), compare who has expenses in Harvest with who has an expense report in NetSuite, optionally only for a person whose name contains `{person-name}`.
**Step 1: Harvest expenses by person (Harvest server)**
Call `harvest-get-expense-reports-team` with `period-start` set to `{from-date}` and `period-end` set to `{to-date}`. If `{person-name}` is not empty, pass it as `user-name.contains`. Keep `user-name` and `total-amount`.
**Step 2: NetSuite expense reports (NetSuite server)**
Call `netsuite-get-expensereport` with `date.from` set to `{from-date}` and `date.to` set to `{to-date}`. Keep `employee`, `document-number`, `status` and `date`. Filter to `{person-name}` in your own reading if the tool has no matching filter.
**Step 3: Match**
Match Harvest `user-name` to NetSuite `employee` ignoring case and order of first and last name. If a NetSuite `employee-email` is available, use it to confirm borderline matches against `harvest-get-users` (Harvest server) by `email`.
**Step 4: Report**
Three lists: people with Harvest expenses and no NetSuite report, people with a NetSuite report and no Harvest expenses, and people in both with the Harvest total and the NetSuite report number and status.
**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:**
* If either system returns nothing, say so and stop.
* Do not compare amounts; the NetSuite expense report tool does not return a total, so report the Harvest total only.
* Label a NetSuite report that is not approved by its `status`.Who it's for
One answer, three teams that use it
Accounts payable
See who has not filed an expense report
Before reimbursements run, you can see which people have Harvest expenses and no NetSuite report, so nobody is paid late or twice by mistake.
Which people logged expenses in Harvest in September but have no expense report in NetSuite?
Billing coordinators
Check client expenses are covered by a report
You can confirm that the expenses you are about to bill to clients also exist as filed reports, and see the status of each one.
Compare Harvest expenses with NetSuite reports for Northwind Traders staff this quarter and show report status.
Finance managers
Catch reports with no matching expenses
Reports in NetSuite with no Harvest expenses behind them are listed, so you can ask the person what the claim was for.
Show me NetSuite expense reports from last month where the person has nothing in Harvest.
How it works
What PopdockAI does when you ask
You name the dates and your AI assistant reads Harvest and NetSuite for you. It only reads, so no expense or report is touched.
Ask
You give a date range and, if you like, part of a person name.
Read
It pulls expense totals by person from Harvest and expense reports from NetSuite.
Match
It pairs people by name and confirms borderline cases by email.
Report
You get the gaps on each side and the people in both, with report status.
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-expense-reports-team
netsuite-get-expensereport
harvest-get-users
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
Know who is missing an expense report
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)
