Connectors

/

Harvest

/

Reconcile Harvest and Dynamics 365 Sales invoices
Report
Cross-Connector

Compare Harvest and Dynamics 365 Sales invoices without a spreadsheet

For finance teams who want a client's invoices matched across Harvest and the CRM by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Harvest and Dynamics 365 Sales invoices
Compare Northwind Traders invoices in Harvest with the invoices in Dynamics 365 Sales since 1 January and show me where they disagree.
7 of 9 Northwind Traders invoices match; 2 need a look. - Paid in one only: INV-1042 is paid in Harvest, 6,200.00 still due in the CRM - Amount differs: INV-1047, 4,250.00 against 4,520.00 - In Harvest, not in the CRM: none - In the CRM, not in Harvest: one draft-style invoice, 900.00 Want the totals billed and outstanding in each system?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
microsoft-dynamics-365-sales-get-invoices

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

Invoice totals copied between systems drift apart

Finance pastes invoice totals from Harvest and the CRM into a sheet to compare. Paid-versus-unpaid differences and invoices on one side only are easy to overlook in a long list.

Without PopdockAI

  • Export invoices from Harvest
  • Export invoices from the CRM
  • Line them up in a sheet by hand
  • Miss paid versus unpaid differences

With PopdockAI

  • Both sets of invoices are read for the client
  • Pairs are matched by number, or by amount and date
  • Currency mismatches are listed, not compared
  • It reports differences only, and nothing is edited

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For `{client-name}`, compare invoices in Harvest with invoices in Dynamics 365 Sales, issued on or after `{issued-from}` (YYYY-MM-DD, default the first day of this year), and list amounts, status or existence that disagree.

**Step 1: Harvest invoices (Harvest server)**

Call `harvest-get-invoices` with `client-name.contains` set to `{client-name}` and `issue-date.from` set to `{issued-from}`. Keep `number`, `amount`, `due-amount`, `state`, `issue-date`, `purchase-order` and `currency`. If more than one distinct client name appears, list them and stop.

**Step 2: CRM invoices (Dynamics 365 Sales server)**

Call `dynamics-365-sales-get-invoices` with `customer.contains` set to `{client-name}` and `created-on.from` set to `{issued-from}`. Keep `name`, `invoice-id`, `total-amount`, `amount-due`, `status` and `created-on`.

**Step 3: Match**

Match on the invoice number appearing in the CRM invoice `name`, else on the same amount with an issue date within 7 days. Mark each pair as exact, amount differs, or paid in one and unpaid in the other (Harvest `due-amount` of zero against CRM `amount-due` above zero, or the reverse).

**Step 4: Report**

Table of matched pairs with the difference, then Harvest invoices not in the CRM, then CRM invoices not in Harvest, then totals billed and outstanding in each system.

**Rules & Guidelines:**

* `harvest-*` tools belong to the Harvest server and `dynamics-365-sales-*` tools belong to the Dynamics 365 Sales server. Both servers must be connected.
* This is read-only. Never call any Harvest tool that creates, updates, deletes, stops or restarts anything, and never call `dynamics-365-sales-create-account`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-phone-call` or any `dynamics-365-sales-update-*` tool.
* Harvest rates, cost rates and Dynamics 365 credit limits are sensitive: do not show them unless asked.

**Validation:**

* If the currencies differ, do not compare amounts; list the pair as currency mismatch.
* If one side returns nothing, say so; do not list the other side as all unmatched without that note.
* Do not state which system is right; report the difference only.

Who it's for

One answer, three teams that use it

Accounts receivable

Spot paid versus unpaid differences

See invoices that Harvest shows as paid but the CRM still shows as due, or the reverse, before you chase the wrong client.

Which Contoso invoices are paid in Harvest but still show an amount due in Dynamics 365 Sales?

Finance analysts

Replace the comparison spreadsheet

Get matched pairs, amount differences and unmatched invoices for a client in one answer, with totals for each system.

Compare Fabrikam invoices in Harvest and Dynamics 365 Sales since the start of the year and total billed and outstanding in each.

Sales operations

Keep CRM invoice records trustworthy

Find Harvest invoices that never made it into the CRM, and CRM invoices with no Harvest match, for a given client.

Are there Northwind Traders invoices in Harvest that do not appear in Dynamics 365 Sales?

How it works

What PopdockAI does when you ask

You name the client and your AI assistant matches the two sets of invoices. It does not say which system is correct, it only reports where they disagree.

Ask

You name the client and a start date.

Your AI tool

Read

It reads the client's invoices in Harvest and in Dynamics 365 Sales.

harvest-get-invoices
microsoft-dynamics-365-sales-get-invoices

Match

It pairs them by invoice number or by amount and date and marks each pair.

No items found.

Report

You get the differences, the unmatched invoices on each side and totals for billed and outstanding.

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

microsoft-dynamics-365-sales-get-invoices

Returns Dynamics 365 Sales invoices. Filter by name, customer, invoice ID, created date, total amount, status reason and due date, and cap how many records come back.
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 invoice difference in one list

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