Connectors

/

Wave

/

Check Wave customer regions against Avalara AvaTax nexus
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Wave customer regions against Avalara AvaTax nexus
Which Wave customers owing us more than 100 are in places where we have no nexus in Avalara AvaTax?
9 of 38 customers with balances sit in places with no nexus on file. - Texas, US: 3 customers, 12,400 outstanding - Ontario, CA: 2 customers, 5,150 outstanding - Unknown region: 4 customers have no province on file - Regions with nexus: California (11 customers) and New York (7) This is a data comparison, not tax advice. Want the biggest individual balances listed?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
avalara-avatax-get-nexus

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

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.

Prompt
**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.

Your AI tool

Read

It reads customers with balances from Wave and the current nexus from Avalara AvaTax.

wave-get-customer
avalara-avatax-get-nexus

Match

It matches each customer's country and region to a nexus place, noting any guesses.

No items found.

Report

You get no-nexus places with balances, regions with nexus and the biggest gaps.

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

avalara-avatax-get-nexus

Returns Avalara AvaTax nexus declarations with the filters the tool offers, for the selected AvaTax company. Read-only.
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

A clear view of balances outside your nexus

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