/
/
Reconcile Rillet and AvaTax tax totals for a period
For accountants who want to know why Rillet and Avalara AvaTax disagree on a period's tax, just by asking.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Period tax gaps found late in a month end spreadsheet
At month end an accountant exports invoices from Rillet and transactions from Avalara AvaTax and compares totals in a spreadsheet. Gaps between the two are found late, and the invoices behind them take longer still.
Without PopdockAI
- Export invoices from Rillet for the period
- Export transactions from AvaTax
- Compare totals in a spreadsheet
- Hunt for the invoices behind any gap
With PopdockAI
- Tax and amounts totalled in both systems for your range
- Invoice numbers matched to transaction codes
- A warning when that matching is unreliable
- Unmatched and mismatched invoices listed, nothing written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For invoice dates from `{from-date}` to `{to-date}` (format YYYY-MM-DD), compare the tax Rillet recorded on invoices with the tax AvaTax calculated, and list the invoices that explain any gap. AvaTax company is `{company}` (default: the default company).
**Step 1: Read Rillet invoices**
Call `rillet-get-invoices`. It has no filters, so keep only rows whose invoice-date is in the range. Total the tax-amount and total across them and count them.
**Step 2: Read AvaTax transactions**
Call `avalara-avatax-get-transaction` with `date.from` set to `{from-date}`, `date.to` set to `{to-date}`, `company` if given and a high `max-records`. Keep sales invoices only (document-type SalesInvoice) and exclude those with status Cancelled. Total total-tax and total-amount and count them.
**Step 3: Match**
Match each Rillet invoice to an AvaTax transaction where the AvaTax code equals the Rillet invoice-number. Rows with no match on the other side go into an unmatched list for that side. Among matched pairs, list those where tax-amount and total-tax differ by 0.01 or more.
**Step 4: Report**
Show the two totals and their difference, the counts, then three lists: Rillet invoices with no AvaTax transaction, AvaTax transactions with no Rillet invoice, and matched pairs whose tax differs (invoice-number, Rillet tax, AvaTax tax, difference). Cap each list at 25 rows and say how many more there are.
**Rules & Guidelines:**
* Tools whose names start with avalara-avatax are on the avalara-avatax server; tools whose names start with rillet are on the rillet server. Both servers must be connected.
* This prompt is read-only. Never call any AvaTax action tool (for example `avalara-avatax-transaction-create`, `avalara-avatax-transaction-adjust`, `avalara-avatax-transaction-void`, `avalara-avatax-transaction-commit`) or any Rillet add, update, apply or set tool (for example `rillet-add-invoice`, `rillet-update-invoice`, `rillet-add-credit-memo`).
* Report what the two systems show. Do not present the result as a filed tax return or as tax advice.
**Validation:**
* If the range is empty on both sides, say so and stop.
* If a transaction code does not follow the invoice-number convention, say that matching is unreliable and show totals only.
* If `{from-date}` is after `{to-date}`, stop and ask for a corrected range.Who it's for
One answer, three teams that use it
Accountants
Reconcile tax without exports
Get both period totals and the invoices behind any difference in one answer.
Do Rillet and Avalara AvaTax agree on total tax for October 2026?
Tax managers
File with totals that match
See the unmatched and mismatched invoices before you file the return.
Reconcile Q3 tax between Rillet and AvaTax and list the invoices behind any gap.
Controllers
Close the month with tax tied out
Make the tax reconciliation a quick step in the close checklist.
Check last month's tax totals in Rillet against AvaTax before we close the books.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant totals tax in Rillet and Avalara AvaTax and explains any gap. It validates the range first and never writes to either system.
01
Ask
You give a date range, which it validates.
02
Total
It totals tax and amounts in Rillet and in AvaTax.
03
Match
It matches invoice numbers to transaction codes and warns if that is unreliable.
04
Report
You get the gap and the unmatched and mismatched invoices behind it.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-invoices
avalara-avatax-get-transaction
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
Period tax that ties out between Rillet and AvaTax
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)
