/
/
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.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
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.
**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.
Find
It lists open invoices past due with a balance still owing and the days overdue.
Add history
It looks up payments, earlier reminders and the contact for each client.
Report
You get invoices grouped by client, tagged by what each needs, with totals.
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-invoices
harvest-get-invoice-payments
harvest-get-invoice-messages
harvest-get-contacts
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
Every overdue invoice with its next step
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)
