/
/
Compare BigCommerce sales with Rillet invoiced revenue
For finance teams who want store sales tied out to Rillet invoices and credit memos for a period by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Store sales tie-out takes two exports and a pivot table
Month-end tie-out of BigCommerce sales to Rillet revenue is done with two exports and a pivot table, and gaps are found days after close. Mixed currencies and refunds make the sums easy to get wrong.
Without PopdockAI
- Export orders and refunds from BigCommerce
- Export invoices and credit memos from Rillet
- Build a pivot by currency
- Find the gap days after close
With PopdockAI
- Orders, tax and refunds are totalled per currency
- Rillet invoices and credit memos are totalled for the same range
- Store net, ledger net, difference and gap are shown per currency
- Currencies are never added together, 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.
**Objective:** Compare what the store sold with what the ledger invoiced between `{from-date}` and `{to-date}` (YYYY-MM-DD), optionally for one `{currency}` (default: all).
**Step 1: Store sales (bigcommerce server)**
Call `bigcommerce-get-order` with `date-created.from` = `{from-date}`, `date-created.to` = `{to-date}` and `max-records` 250. If `{currency}` is given pass it as `currency-code`. Sum `total-including-tax`, `total-tax` and `refunded-amount` per `currency-code`, and count the orders. Note the number of orders in each `payment-status`.
**Step 2: Ledger invoices (rillet server)**
Call `rillet-get-invoices` and keep rows whose `invoice-date` falls in the same range. Sum `total`, `tax-amount` and `amount-due` per `currency`, and count them. Call `rillet-get-credit-memos` with `credit-memo-date.from` and `credit-memo-date.to` set to the range and sum `total` per `currency`.
**Step 3: Report**
Per currency: store orders (count, total), refunds, store net; ledger invoices (count, total), credit memos, ledger net; the difference and the percentage gap. Add the five largest store orders by `total-including-tax` and ask the reader to check whether each has an invoice (do not check them all).
**Rules & Guidelines:**
* `bigcommerce-*` tools are on the bigcommerce server; `rillet-*` tools are on the rillet server. Both servers must be connected.
* This prompt is read-only. Never call any bigcommerce `-add`, `-update` or `-delete` tool or any rillet `-add`, `-update`, `-apply`, `-unapply`, `-record`, `-set` or `-setup` tool.
* Quote ids and amounts exactly as returned. Do not guess a match.
**Validation:**
* Do not add amounts in different currencies together.
* If more than 250 orders exist in the range, say the store figure is a partial sum and narrow the dates.
* Timing differences (orders not yet invoiced) are expected; report them as a possible reason, not as an error.Who it's for
One answer, three teams that use it
Accountants
Tie out store sales at month end
Store net and ledger net per currency are ready for the close checklist.
Tie out BigCommerce sales against Rillet invoices and credit memos for September.
Finance controllers
Size the gap before you sign off
The difference and percentage gap per currency show whether the period is ready to close.
What is the gap between BigCommerce net sales and Rillet invoiced revenue for Q3, in USD only?
Revenue accountants
Know where to look first
The five largest store orders are listed to check against invoices, and timing is offered as a possible reason.
Compare BigCommerce sales with Rillet revenue for August and list the largest orders to check.
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant ties BigCommerce sales to Rillet invoiced revenue. It flags partial sums when the order limit is hit.
01
Ask
You give a date range and optionally a currency.
02
Store
It totals BigCommerce orders, tax and refunds per currency.
03
Ledger
It totals Rillet invoices and credit memos for the same range.
04
Report
It shows each net, the difference and gap per currency, and the largest orders to check.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
rillet-get-invoices
rillet-get-credit-memos
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
The sales to revenue gap per currency, at tie-out
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)
