Connectors

/

Shopify

/

Reconcile Shopify sales tax with Rillet
Report
Cross-Connector

Check Shopify sales tax against your Rillet tax account

For finance teams preparing a filing who want Shopify tax collected compared with what was posted in Rillet, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Shopify sales tax with Rillet
Reconcile Shopify sales tax for Q3 with Rillet account 2200.
Shopify net tax is 18,420.30, and Rillet shows 18,102.10, a 318.20 gap. - Collected: 19,014.80 on uncancelled orders - Refunded: 594.50 - Likely cause: refunds booked in October - Likely cause: 3 orders not yet invoiced in Rillet Want the detail behind each figure?
Shopify
Sample figures. Your results come from your own account.
shopify-get-order
shopify-get-order-tax-line
shopify-get-refund
shopify-get-refund-line
rillet-get-accounts
rillet-get-journal-entry-lines
rillet-get-invoices

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

Connect Shopify, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Sales tax collected rarely matches the liability account

The sales tax Shopify collected should match what was posted to your tax liability account in Rillet, but refunds, timing and filings muddy the comparison. Working it out by hand before a filing means adding order tax, subtracting refunded tax and netting journal lines.

Without PopdockAI

  • Add up tax on every Shopify order
  • Subtract tax on refunds
  • Net the credits and debits on the Rillet tax account
  • Guess why the two figures differ

With PopdockAI

  • The Rillet tax account is confirmed before anything else
  • Order tax is totalled and refunded tax subtracted
  • Credits and debits on the account are netted and compared
  • Likely causes of any difference are listed, and nothing is posted

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Compare the sales tax Shopify collected on orders from `{from-date}` to `{to-date}` (default: the previous calendar month), net of refunded tax, with the net credits posted to Rillet account `{tax-account-code}` in the same period.

**Step 1: Tax collected in Shopify**

Call `shopify-get-order` with created-at.from and created-at.to set to the period. Leave out orders with cancelled-at set. Sum total-tax by currency.

If the period has 50 orders or fewer, also call `shopify-get-order-tax-line` for each order-id and total shop-price-amount by title, so the report can show the tax by jurisdiction. Above 50 orders, skip the breakdown and say why.

**Step 2: Tax refunded in Shopify**

Call `shopify-get-refund` with created-at.from and created-at.to set to the period. For each refund-id, call `shopify-get-refund-line` filtered by order-refund-id and sum total-tax.

**Step 3: Tax posted in Rillet**

Call `rillet-get-accounts` filtered by account-code `{tax-account-code}` and confirm it exists. Then call `rillet-get-journal-entry-lines` (no filters) and keep lines whose account-code is `{tax-account-code}` and whose date falls in the period. Net them as credits minus debits, by currency.

**Step 4: Report**

A table by currency:

| | Amount |
|---|---|
| Shopify tax collected | |
| Shopify tax refunded | |
| Shopify net tax | |
| Rillet net credits to the tax account | |
| Difference | |

Then the jurisdiction breakdown if you have it.

If there is a difference, look for its likely causes and list them: refunds booked in a different period, orders not yet invoiced in Rillet (check `rillet-get-invoices` for invoice-numbers equal to the order names, with or without #), or tax filings posted to the same account.

**Rules & Guidelines:**

* `shopify-get-order`, `shopify-get-order-tax-line`, `shopify-get-refund` and `shopify-get-refund-line` are on the shopify server. `rillet-get-accounts`, `rillet-get-journal-entry-lines` and `rillet-get-invoices` are on the rillet server.
* This prompt is read-only. Do not call `rillet-add-journal-entry`, `rillet-update-journal-entry` or any other write tool.

**Validation:**

* If `{tax-account-code}` is not a Rillet account, stop and say so.
* If there are no Shopify orders in the period, report Shopify tax as zero and still show the Rillet side.
* Show every currency separately. Do not convert.

Who it's for

One answer, three teams that use it

Tax accountants

Prepare a filing with confidence

See whether Shopify tax and the ledger agree, and why if they do not, before you file.

Reconcile Shopify sales tax for October with Rillet account 2210.

Controllers

Explain the tax account at close

Likely causes such as refunds in another period or orders not yet invoiced point you to the fix.

Why does Shopify tax collected for Q2 differ from the Rillet tax liability account?

Finance managers

See tax by jurisdiction

For smaller periods tax is broken down by jurisdiction, so you can see where the money is owed.

Break down Shopify sales tax by jurisdiction for last week and compare it with Rillet.

How it works

What PopdockAI does when you ask

You pick a period and the tax account, and your AI assistant compares Shopify tax collected with your Rillet tax account. It keeps every currency separate and posts nothing.

01

Ask

You pick a period and the Rillet tax account.

Your AI tool

02

Total

It totals tax on Shopify orders and subtracts tax on refunds.

shopify-get-order
shopify-get-order-tax-line
shopify-get-refund
shopify-get-refund-line

03

Compare

It nets the credits and debits posted to that Rillet account.

rillet-get-accounts
rillet-get-journal-entry-lines

04

Report

You get the difference, a jurisdiction breakdown where possible and likely causes.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.

get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
get-data

shopify-get-order-tax-line

Returns the taxes charged on Shopify orders. Filter by order, tax title, source and amount.
get-data

shopify-get-refund

Returns Shopify refunds with their order and total adjustments. Filter by order, customer, customer email, refund and created date.
get-data

shopify-get-refund-line

Returns the line items on Shopify refunds, with the subtotal and how each was restocked. Filter by refund, order, SKU, name and restock type.
get-data

rillet-get-accounts

Returns chart of accounts entries (code, name, type, status) from Rillet.
get-data

rillet-get-journal-entry-lines

Returns journal entry lines (account code, debit/credit side, amount) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
Read only.Nothing in Shopify 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

File knowing whether store and ledger agree

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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