# Scenario: Multichannel duplicate detection

Source: https://developer.avalara.com/transaction-reconciliation/fnz4162036608580/

# Scenario: Multichannel duplicate detection

Learn how AI-assisted reconciliation analyzes transactions present in AvaTax but not found in ERP.

This scenario illustrates how the AI assistant reviews unmatched AvaTax transactions and identifies likely causes.

**User:**

```
 "There are 5 transactions in AvaTax that aren't in the ERP"
```

**AI Response:**

I analyzed the 5 AvaTax transactions without ERP matches:

**Webstore Transactions (3)**:

These have document codes starting with "SHOP-" indicating they came from your Shopify integration.

AvaTax Code

Date

Amount

Match Confidence

SHOP-78234 → SO-2025-891

2025-11-10

$127.50

98% (amount+date+customer)

SHOP-78291 → SO-2025-903

2025-11-11

$89.00

95% (amount+customer)

SHOP-78445 → SO-2025-917

2025-11-14

$234.75

99% (amount+date+customer)

Warning

Be careful not to report tax twice on the same sale! These appear to be legitimate—your webstore sends orders directly to AvaTax, then they're also created in your ERP from Shopify.