Connectors

/

Wave

/

Audit Wave customer and vendor records
Report

Fix Wave contact gaps before invoices go astray

For operations and finance teams who want duplicate and incomplete Wave customers and vendors found by asking their AI assistant.

Try PopdockAI free
Get a live demo
Audit Wave customer and vendor records
Audit the customers and vendors in Wave for Northwind Traders and show me duplicates and anyone missing an email.
I checked 142 customers and 61 vendors and found 11 issues. - Missing email: 6 customers, 2 of them with an outstanding balance - Likely duplicate: Contoso Ltd and Contoso Limited, Contoso Ltd looks like the keeper (more complete) - Missing country: 3 vendors - Shared email: 1 pair of customers Nothing has been changed or deleted. Want the full list by record type?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
wave-get-vendor

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

Connect Wave, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Duplicate and incomplete contacts cause misdirected invoices

Duplicate customers and vendors in Wave, and records with no email or country, lead to misdirected invoices and customers who cannot be chased. They are found by paging through the lists by eye.

Without PopdockAI

  • Page through customer and vendor lists
  • Compare near-duplicate names by eye
  • Hunt for records with no email or country
  • Learn a balance cannot be chased only when chasing fails

With PopdockAI

  • Customers and vendors are read and checked together
  • Missing emails and near-duplicates are grouped
  • Duplicate pairs shown side by side with a suggested keeper
  • Read-only, and customers with balances are never suggested for deletion

The prompt

Use this prompt

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

Prompt
**Objective:** Audit contact data quality for `{record-type}` (customers, vendors or both; default both). Company: `{company}`.

**Step 1: Read**

If the user has access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. Call `wave-get-customer` with `is-archived` false and/or `wave-get-vendor` with `is-archived` false, `max-records` 1000.

**Step 2: Check**

* No email, or the same email on more than one record.
* Names that are near duplicates.
* Missing country, city or currency.
* For customers, accounts with `outstanding-amount` above zero and no email (cannot be chased).

**Step 3: Report**

Grouped findings with name and the issue. For duplicates, show the pair side by side and say which looks like the keeper (more activity or more complete). Give totals.

**Rules & Guidelines:**

* Do not call any write tool (every `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-archive-*`, `wave-send-*`, `wave-approve-*`, `wave-mark-*`, `wave-clone-*`, `wave-convert-*`, `wave-reset-*` and `wave-generate-*` tool). This prompt only reads.
* Do not suggest deleting a customer with an outstanding amount.
* Show the minimum personal data needed (name plus the failing field).

**Validation:**

* If nothing is wrong, say so with the record counts.

Who it's for

One answer, three teams that use it

Operations managers

Keep contact data reliable

Run a regular check so duplicates and gaps are fixed before they cause a misdirected invoice or a missed reminder.

Audit customers in Wave for Fabrikam and tell me which have no email or look like duplicates.

Accounts receivable

See who cannot be chased

Find customers who owe money but have no email on file, so you can fix the record before sending reminders.

Which Wave customers with an outstanding balance have no email address?

Accounts payable

Tidy the vendor list

Spot duplicate vendors and missing country or currency details before a payment run.

Check the vendors in Wave for Contoso for near-duplicate names and missing countries.

How it works

What PopdockAI does when you ask

You ask for a contact audit in plain words. Your AI assistant reads the records in Wave and reports the problems, showing only the minimum personal data needed.

Ask

You choose customers, vendors or both, and the company if needed.

Your AI tool

Read

It reads the active customers and vendors in Wave.

wave-get-customer
wave-get-vendor

Check

It looks for missing or shared emails, near-duplicate names and missing country, city or currency.

No items found.

Report

You get grouped findings, duplicate pairs with a suggested keeper, and totals.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.

get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-vendor

Returns vendors from Wave. Wave connector tool; filter by the parameters it offers.
Read only.Nothing in Wave 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

Contact records you can trust

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