Connectors

/

Harvest

/

Flag Harvest unbilled work for clients with open Salesforce deals
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Flag Harvest unbilled work for clients with open Salesforce deals
Which clients have more than 2,500 in unbilled Harvest work, and what is going on with them in Salesforce?
Four clients have more than 2,500 unbilled, and two need care before invoicing. - Contoso: USD 8,900 unbilled, 1 open high-priority case - Northwind Traders: USD 6,200 unbilled, opportunity in Negotiation (USD 40,000) - Fabrikam: USD 3,100 unbilled, no open items - No Salesforce account: Tailspin Toys Should I lower the minimum to 1,000?
Harvest
Sample figures. Your results come from your own account.
harvest-get-uninvoiced-report
salesforce-get-account
salesforce-get-opportunity
salesforce-get-case

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

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.

Prompt
**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.

Your AI tool

Rank

It totals unbilled Harvest work per client and keeps the top 10.

harvest-get-uninvoiced-report
salesforce-get-account
salesforce-get-opportunity
salesforce-get-case

Context

It finds each Salesforce account and reads open opportunities and cases.

No items found.

Report

You get a table and a call-out of accounts to handle carefully.

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-uninvoiced-report

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

salesforce-get-account

Returns Salesforce accounts with their type, industry, owner, billing address, phone and annual revenue. Filter by name, account number, type, industry, owner, billing city or state, annual revenue and created date.
get-data

salesforce-get-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
get-data

salesforce-get-case

Returns Salesforce support cases with their subject, status, priority, origin, owner, account, contact and whether they are escalated or closed. Filter by case number, subject, status, priority, owner, account, contact email, closed flag and created date.
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

Billing timed with the account in mind

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