/
/
Find Wave customers with no Avalara AvaTax record
For finance teams who want to catch Wave customers missing from AvaTax before they are taxed without a record, just by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
New Wave customers never reach AvaTax
Customers added in Wave are not copied to Avalara AvaTax by hand, so sales to them may be taxed without a customer record. Checking each one means searching AvaTax by email, name and code.
Without PopdockAI
- Export active customers from Wave
- Search AvaTax for each one by email
- Retry by name, then by customer code
- Judge by eye whether a near match is the same customer
With PopdockAI
- Each customer is looked up by email, name and code
- Missing customers are listed, largest balance first
- Name only matches are marked possible, not found
- No customer is created or changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Wave customers that have no customer record in Avalara AvaTax. Look at Wave customers matching `{name-contains}` (default: all active customers), up to `{max-customers}` (default 100).
**Step 1: Read customers from Wave**
Call `wave-get-customer` (Wave server) with `is-active` true, and `name.contains` when given, and `max-records`. Keep name, email, display-id, address-country-name, address-province-name, address-city and outstanding-amount.
**Step 2: Look each one up in AvaTax**
For each customer call `avalara-avatax-get-customer` (Avalara AvaTax server) with `email-address` equal to the Wave email. If the customer has no email, or nothing matches, retry with `name` equal to the Wave name. If still nothing, retry with `customer-code` equal to the Wave display-id. Count a customer as found if any attempt returns a record.
**Step 3: Report**
Two tables. First, customers found in both, with the AvaTax customer-code and a note when region or country differ. Second, customers missing from AvaTax, with name, email, region and outstanding-amount, largest outstanding-amount first. End with counts.
**Rules & Guidelines:**
* Wave tools start with wave-, Avalara AvaTax tools with avalara-avatax-. Both servers must be connected.
* Read-only. Do not call `avalara-avatax-customer-add`, `avalara-avatax-customer-update` or `avalara-avatax-customer-delete`, and do not call any Wave tool that adds, updates or deletes. Suggest the `sync-wave-customer-to-avatax` prompt for fixing a gap.
* Do not print email addresses beyond what the table needs.
**Validation:**
* If Wave returns no customers, say so and stop.
* A name match with a different email is a "possible match": list it separately and do not count it as found.Who it's for
One answer, three teams that use it
Accountants
Check tax setup for new customers
See which customers added in Wave have no AvaTax record, so the gap is closed before the next sale.
Which active Wave customers are missing from Avalara AvaTax?
Controllers
Fix the biggest gaps first
Get missing customers ordered by outstanding amount, so the most exposed accounts are handled first.
List the first 50 Wave customers with no AvaTax record, largest outstanding balance first.
Tax analysts
Confirm customer records match
Check that the customers found in both systems agree on region and country, and see near matches kept separate.
Check Wave customers with Northwind in the name against AvaTax and flag any where the region differs.
How it works
What PopdockAI does when you ask
You ask which Wave customers are missing, and your AI assistant checks each one in Avalara AvaTax. It only reads, and keeps name only matches out of the found count.
Ask
You optionally give part of a name and a limit.
Match
It reads active Wave customers and looks each up in Avalara AvaTax by email, then name, then code.
Report
You get customers found in both, those missing with the largest balance first, and counts.
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.
wave-get-customer
avalara-avatax-get-customer
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
Missing AvaTax customers found, biggest balance first
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)
