/
/
Find invoice balance errors without checking each one
For finance teams who want a period of Harvest invoices cross-checked against payments and line items, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Balance errors hide in a month of invoices
Each invoice has to be matched to its payments and its line items before you can trust the balance. Done one at a time, a paid invoice with money owing or an invoice with no lines is easy to overlook.
Without PopdockAI
- Open each invoice and add up its payments
- Compare the result with the balance due
- Total line items against the invoice amount
- Guess whether a gap is tax, discount or error
With PopdockAI
- Payments are matched by invoice number
- Balances and line item totals are checked for you
- Tax and discount gaps are labeled, not called errors
- Only exceptions are listed and nothing is corrected
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile invoices issued between `{period-start}` (default: first of last month) and `{period-end}` (default: today).
**Step 1: Invoices**
Call `harvest-get-invoices` with `issue-date.from` and `issue-date.to`. Keep `amount`, `due-amount`, `state` and `paid-date`.
**Step 2: Payments**
Call `harvest-get-invoice-payments` for the same clients and match by `invoice-number`. For each invoice check: `amount` minus the sum of payments equals `due-amount`.
**Step 3: Line items**
Call `harvest-get-invoice-line-items` with `invoice-issue-date.from` and `invoice-issue-date.to`. Sum `amount` per `invoice-number` and compare with the invoice `amount` (differences can be tax or discount, so say so rather than call it an error).
**Step 4: Report**
Exceptions only: paid-state invoices with a balance, open invoices with `due-amount` of zero, payment totals that do not match, invoices with no line items, line item totals far off. For each, say what you compared and the difference.
**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 record, change or delete payments or invoices.
**Validation:**
* If everything reconciles, say so with the count of invoices checked.Who it's for
One answer, three teams that use it
Accounts receivable
Trust the balance on every invoice
Find invoices where payments and the balance due disagree, without opening each one to add things up yourself.
Check last month's Harvest invoices for any where payments do not match the balance.
Finance controllers
Clear billing questions before close
Run the check for a whole period ahead of month end, so corrections can be made before reports go out.
Reconcile Harvest invoices from 1 to 31 October and give me the exceptions only.
Billing administrators
Find invoices with missing or odd lines
Spot invoices that have no line items, or whose line items are far from the invoice amount, and see the difference.
Are there any Harvest invoices this month with no line items?
How it works
What PopdockAI does when you ask
You give a period and your AI assistant reads invoices, payments and line items in Harvest. It compares and reports differences. It does not record, change or delete anything.
Ask
You give a period, or accept last month to today.
Match
It matches payments to invoices and checks the amount less payments equals the balance.
Total
It sums line items per invoice and compares them with the invoice amount.
Report
You get only the exceptions, with what was compared and the difference.
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-line-items
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
Only the invoices that need attention
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)
