/
/
Bill unbilled work with open deals and cases in view
For finance teams who want the biggest unbilled Harvest clients shown with their Salesforce deals and cases, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Invoices that go out at the wrong moment
Harvest shows what is unbilled, but not that the customer has an escalated case or a deal in negotiation in Salesforce. Invoicing blind creates friction nobody planned for.
Without PopdockAI
- Run the uninvoiced report in Harvest
- Total unbilled work per client by hand
- Search Salesforce for each account
- Send an invoice the day a case escalates
With PopdockAI
- Unbilled work is totalled per client for you
- Open deals and cases are read from Salesforce
- Accounts needing care are called out
- Top 10 only, ambiguous accounts listed, nothing created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List clients whose unbilled Harvest work is at least `{min-unbilled-amount}` (default 1000) and add the Salesforce context for each, so billing is chased with the account situation in mind.
**Step 1: Find unbilled work (Harvest server)**
Call `harvest-get-uninvoiced-report` with `uninvoiced-amount.min` = `{min-unbilled-amount}`. Group the rows by `client-name` and total `uninvoiced-amount` per client. Keep the top 10 clients.
**Step 2: Add Salesforce context (Salesforce server)**
For each client call `salesforce-get-account` with `name` = the client name (fall back to `name.contains`). With the `account-id`, call `salesforce-get-opportunity` (`closed` = false) and `salesforce-get-case` (`closed` = false).
**Step 3: Report**
* Table: client, unbilled amount, projects involved, Salesforce account found (yes or no), open opportunities (count and value), open cases (count and highest priority).
* A call-out on clients where billing should be handled carefully: open high-priority cases or an opportunity in negotiation.
* Clients with no Salesforce account.
**Rules & Guidelines:**
* `harvest-get-uninvoiced-report` is on the Harvest server. `salesforce-get-account`, `salesforce-get-opportunity` and `salesforce-get-case` are on the Salesforce server.
* Never call any Harvest tool whose name contains `-create`, `-update`, `-delete`, `-stop` or `-restart`, and never call `salesforce-add-*` or `salesforce-update-*` tools. This prompt is read-only.
**Validation:**
* If the unbilled report is empty, say so and stop.
* If a client name matches several Salesforce accounts, list them for that client and move on.Who it's for
One answer, three teams that use it
Billing managers
Prioritise unbilled work by risk
See which large unbilled balances belong to accounts with open cases or deals in negotiation.
List clients with at least 1,000 unbilled in Harvest and show their open Salesforce cases.
Account managers
Know what billing is about to send
Check whether your accounts have unbilled work before your next conversation.
Does Fabrikam have unbilled Harvest work, and is there an open opportunity in Salesforce?
Finance controllers
Review the biggest unbilled balances
Get the top clients by unbilled amount with project counts and the Salesforce context in one table.
Show the top 10 clients by unbilled Harvest work with open opportunities and cases from Salesforce.
How it works
What PopdockAI does when you ask
You set a minimum and your AI assistant ranks unbilled Harvest work, then looks up each client in Salesforce. It reports what it finds and creates no invoices or tasks.
Ask
You set a minimum unbilled amount, or use the default.
Rank
It totals unbilled Harvest work per client and keeps the top 10.
Context
It finds each Salesforce account and reads open opportunities and cases.
Report
You get a table and a call-out of accounts to handle carefully.
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-uninvoiced-report
salesforce-get-account
salesforce-get-opportunity
salesforce-get-case
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
Billing timed with the account in mind
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)
