/
/
See which customer balances sit outside your tax nexus
For owners and finance leads who want Wave customers compared with Avalara AvaTax nexus by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Nobody can see where open balances meet nexus
Customer addresses live in Wave and registered nexus lives in Avalara AvaTax. Comparing them means exporting both and matching region names to codes by hand.
Without PopdockAI
- Export customers with balances from Wave
- Pull the nexus list from Avalara AvaTax
- Match region names to codes by hand
- Total balances per region in a spreadsheet
With PopdockAI
- Customers and current nexus are read from both systems
- Names and codes are matched, with guesses noted
- Gaps are grouped by place with total balances
- Customers with no region are listed as unknown
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 with an outstanding balance of at least `{min-outstanding}` (default 0.01) who are located in a country or region where the business has no nexus in Avalara AvaTax.
**Step 1: Read customers from Wave**
Call `wave-get-customer` (Wave server) with `is-active` true and `outstanding-amount.min` set to `{min-outstanding}`. Keep name, address-country-name, address-province-name and outstanding-amount.
**Step 2: Read nexus from AvaTax**
Call `avalara-avatax-get-nexus` (Avalara AvaTax server) with no filters except `max-records` 500. Build the set of country and region pairs. Ignore nexus records whose end-date is in the past.
**Step 3: Compare**
Match each customer's country and province to a nexus country and region. Wave gives names (for example "Ontario") and AvaTax gives codes (for example "ON"); match on name or code and note any you had to guess. Customers with no matching nexus are "no nexus".
**Step 4: Report**
Customers in no-nexus places, grouped by country and region, with total outstanding-amount per place. Then a short list of regions that do have nexus and how many customers sit in each. End with the biggest no-nexus balances.
**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-nexus-add`, `avalara-avatax-nexus-delete`, or any Wave write tool.
* Say plainly that this is a data comparison, not tax advice.
**Validation:**
* If AvaTax returns no nexus, say so and stop; every customer would look like a gap.
* Customers with no province on file are listed as "unknown region", not as gaps.Who it's for
One answer, three teams that use it
Business owners
Know where your customers are
See in one answer which customers who owe money are in places where you are not registered.
Which Wave customers who owe us money are in places where we have no nexus in Avalara AvaTax?
Tax managers
Prepare questions for your adviser
Get regions with no nexus and their balances so you can decide where to look closer.
Group Wave customers with at least 500 outstanding by region and show which have no AvaTax nexus for Contoso.
Finance directors
Size the exposure
See the biggest no-nexus balances first and how many customers sit in each nexus region.
List the largest balances from Wave customers outside our Avalara AvaTax nexus, with unknown regions shown separately.
How it works
What PopdockAI does when you ask
You ask with a minimum balance. Your AI assistant reads Wave and Avalara AvaTax, compares them and reports, and it states plainly that this is a data comparison, not tax advice.
Ask
You give a minimum outstanding balance.
Read
It reads customers with balances from Wave and the current nexus from Avalara AvaTax.
Match
It matches each customer's country and region to a nexus place, noting any guesses.
Report
You get no-nexus places with balances, regions with nexus and the biggest gaps.
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-nexus
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
A clear view of balances outside your nexus
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)
