Connectors

/

Shopify

/

Reconcile Shopify orders with Rillet invoices
Report
Cross-Connector

Prove every Shopify order landed in Rillet at the right amount

For finance teams who want Shopify orders matched to Rillet invoices at month end, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Shopify orders with Rillet invoices
Reconcile last month's Shopify orders with Rillet invoices.
986 orders checked, and 14 need attention. - Missing from Rillet: 5 orders - Amount mismatch: 4 orders, including #1042 - Canceled in Shopify, open in Rillet: 3 invoices - No Shopify order: 2 Rillet invoices Want the four tables?
Shopify
Sample figures. Your results come from your own account.
shopify-get-order
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

Month end means proving every order landed in Rillet

Month end means proving every Shopify order made it into Rillet at the right amount. Matching orders to invoices, comparing totals and tax and catching orders canceled in Shopify but still open in Rillet is tedious work across two exports.

Without PopdockAI

  • Export Shopify orders and Rillet invoices
  • Match invoices to orders by number
  • Compare totals and tax line by line
  • Miss canceled orders still open in Rillet

With PopdockAI

  • Orders match invoices only by order name, never by amount alone
  • Totals and tax are compared to within a cent
  • Canceled orders still open in Rillet get their own table
  • Invoices with no order are listed, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** Reconcile Shopify orders created from `{from-date}` to `{to-date}` (default: the previous calendar month) against Rillet invoices, and report every order that is missing from Rillet, booked at a different amount, or cancelled in Shopify but still open in Rillet.

**Step 1: Read the Shopify orders**

Call `shopify-get-order` with created-at.from and created-at.to set to the date range. For each order note order-id, name, order-number, created-at, currency, subtotal-price, total-tax, total-price, financial-status and cancelled-at.

**Step 2: Read the Rillet invoices**

Call `rillet-get-invoices`. It takes no filters, so keep only invoices whose invoice-date falls within the range plus 7 days either side (booking dates can lag). Note invoice-id, invoice-number, invoice-date, customer-id, currency, subtotal, tax-amount, total, amount-due and status.

**Step 3: Match**

Match each Shopify order to a Rillet invoice whose invoice-number equals the Shopify order name. Compare with and without the leading # ("#1001" and "1001" are the same order). Do not match on amount or date alone.

For each matched pair compare total-price with total, and total-tax with tax-amount, in the same currency. Treat a difference of 0.01 or less as a match.

**Step 4: Report**

A summary line: orders read, invoices in range, matched, missing from Rillet, amount mismatches, cancelled but still open.

Then four tables:

1. Missing from Rillet: order name, created-at, total-price, currency, financial-status.
2. Amount mismatches: order name, Shopify total, Rillet total, Shopify tax, Rillet tax, difference.
3. Cancelled in Shopify, still open in Rillet: order name, cancelled-at, invoice-number, amount-due.
4. Rillet invoices in range with no Shopify order: invoice-number, invoice-date, total. Say these may simply be non-Shopify invoices.

**Rules & Guidelines:**

* `shopify-get-order` is on the shopify server. `rillet-get-invoices` is on the rillet server.
* This prompt is read-only. Do not call `rillet-add-invoice-ar-only`, `rillet-add-invoice`, `rillet-update-invoice`, `rillet-add-invoice-payment`, `shopify-update-order` or any other write tool. To create the missing invoices, use the backfill-shopify-orders prompt.

**Validation:**

* If Shopify returns no orders in the range, say so and stop.
* If Rillet returns no invoices at all, report every order as missing and say the Rillet side may not be booking Shopify sales yet.
* If an order and its invoice are in different currencies, list the pair as a mismatch with both currencies and do not convert.

Who it's for

One answer, three teams that use it

Accountants

Tie out revenue at month end

Four tables show exactly what to fix in Rillet, instead of a total that does not agree.

Reconcile Shopify orders from September with Rillet invoices.

Accounts receivable

Close invoices for canceled orders

Orders canceled in Shopify but still open in Rillet are listed, so customers are not chased for nothing.

Which orders canceled in Shopify last month still have open invoices in Rillet?

Controllers

Confirm nothing is missing from receivables

Orders missing from Rillet and amount mismatches come first, so the close is built on complete figures.

Show Shopify orders from Q3 missing from Rillet or with a different total or tax.

How it works

What PopdockAI does when you ask

You pick a date range, and your AI assistant matches Shopify orders to Rillet invoices by order name. It only reads and shows mismatched currencies without converting them.

01

Ask

You pick a date range, last month by default.

Your AI tool

02

Read

It reads Shopify orders and Rillet invoices dated a week either side.

shopify-get-order
rillet-get-invoices

03

Match

It matches by order name only and compares totals and tax to a cent.

No items found.

04

Report

You get four tables, with currencies shown unconverted.

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

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

A clear list to fix instead of a total that will not tie

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