Connectors

/

Harvest

/

Review overdue Harvest invoices
Report

See which overdue Harvest invoices still need chasing

For finance teams who want overdue invoices with payment history, past reminders and contacts, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review overdue Harvest invoices
Which Harvest invoices are overdue as of today for Northwind Traders and Contoso, and have we already reminded them?
Northwind Traders has 2 overdue invoices totalling 4,800.00, and Contoso has 1 totalling 1,250.00. - INV-1042, Northwind Traders: 12 days overdue, reminded and silent - INV-1047, Northwind Traders: 5 days overdue, not yet reminded - INV-1039, Contoso: 21 days overdue, partially paid on 14 October - Contacts: Dana Whitfield at Northwind Traders, Tom Reyes at Contoso Shall I include the date of each earlier reminder?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
harvest-get-invoice-payments
harvest-get-invoice-messages
harvest-get-contacts

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

Chasing invoices means digging through three screens

To chase an overdue invoice you check the list, then the payments, then the messages to see who was already reminded. A partial payment or a recent reminder is easy to overlook, and the client gets chased twice.

Without PopdockAI

  • Scan the invoice list for due dates
  • Open payments for each client
  • Dig through messages to see who was reminded
  • Look up the contact to write to

With PopdockAI

  • Open invoices past due are found with days overdue
  • Payments and earlier reminders are added per client
  • Each invoice is tagged by what it needs
  • Nothing is sent and no payment is recorded

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 open invoices past their due date as of `{as-of-date}` (default: today) for `{client-name}` (default: all clients), with enough context to chase them.

**Step 1: Find overdue invoices**

Call `harvest-get-invoices` with `state` open, `due-date.to` set to the day before `{as-of-date}`, and `client-name` if given. Keep rows with `due-amount` above zero. Compute days overdue from `due-date`.

**Step 2: History**

For each client with overdue invoices, call `harvest-get-invoice-payments` with `invoice-client-name` to see partial and recent payments, and `harvest-get-invoice-messages` with `invoice-client-name` and `event-type` to see reminders already sent and when.

**Step 3: Contacts**

Call `harvest-get-contacts` with `client-name` to find who to write to.

**Step 4: Report**

Group by client, oldest first: invoice number, subject, `due-amount`, days overdue, last payment date, last reminder date, contact. Tag each: not yet reminded, reminded and silent, partially paid. Totals per client and overall.

**Rules & Guidelines:**

* This is a read-only job. Never call any Action tool (any tool whose name ends in create, update, delete, restart, stop or create-from-tracked-time).
* Do not send reminders or record payments. Point to the send-overdue-reminder prompt for that.

**Validation:**

* If the `state` value open returns nothing, call without `state` and filter on `due-amount` instead.
* If no invoices are overdue, say so.

Who it's for

One answer, three teams that use it

Accounts receivable

Chase with the facts in hand

See what has been paid, what was already reminded and who to write to before you send anything to a client.

Which Harvest invoices for Fabrikam are overdue, and who should I write to?

Finance managers

Plan this week's collections

Get overdue invoices grouped by client with totals, oldest first, so you can decide where to focus the team.

Show all Harvest invoices overdue as of today with totals per client.

Account managers

Know where your client stands

Check whether a client has been reminded or has part paid before you pick up the phone, so the call is not a surprise.

Has Contoso been sent any reminders for their overdue Harvest invoices?

How it works

What PopdockAI does when you ask

You give a date and optionally a client. Your AI assistant reads invoices, payments, messages and contacts in Harvest, then reports. Sending reminders stays with you.

Ask

You give an as-of date and, optionally, a client.

Your AI tool

Find

It lists open invoices past due with a balance still owing and the days overdue.

harvest-get-invoices
harvest-get-invoice-payments
harvest-get-invoice-messages
harvest-get-contacts

Add history

It looks up payments, earlier reminders and the contact for each client.

No items found.

Report

You get invoices grouped by client, tagged by what each needs, with totals.

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-invoices

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

harvest-get-invoice-payments

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

harvest-get-invoice-messages

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

harvest-get-contacts

Returns contacts from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
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

Every overdue invoice with its next step

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