/
/
Check gift certificate liability against the Rillet balance sheet
For finance teams who want BigCommerce gift certificate balances compared with the ledger, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Store gift balances and the ledger liability drift apart
Gift certificate liability is checked by exporting BigCommerce balances and comparing them with a Rillet balance sheet line by hand. The two drift apart unnoticed, and expired certificates with a balance are rarely spotted.
Without PopdockAI
- Export gift certificate balances from BigCommerce
- Find the right liability line in Rillet
- Compare totals in a spreadsheet
- Miss expired certificates that still hold value
With PopdockAI
- Active certificate balances are summed and the five largest listed
- The Rillet balance sheet is searched for gift, deferred, then unearned lines
- Store balance, ledger liability and the difference are shown
- No zero is assumed when no line exists, 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 the outstanding value of active BigCommerce gift certificates with the matching liability on the Rillet balance sheet as of `{as-of-date}` (default: today).
**Step 1: Outstanding certificates (bigcommerce server)**
Call `bigcommerce-get-gift-certificate` with `status` set to active and `max-records` 250. Sum `balance` and `amount`, count the certificates, and list the five with the largest `balance`. Note any whose `expiry-date` is on or before `{as-of-date}`.
**Step 2: Ledger liability (rillet server)**
Call `rillet-get-balance-sheet-lines` with `as-of-date` = `{as-of-date}` and `line-item.contains` = `{line-item-text}` (default "gift"). If the first search returns nothing, retry with "deferred" and then "unearned". Keep `line-item`, `section` and the amount.
**Step 3: Report**
Store outstanding balance, ledger liability, difference, and the expired certificates still carrying a balance. Say which balance sheet lines were used.
**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:**
* If no balance sheet line matches, report that the liability could not be found and stop; do not assume zero.
* If certificates are in more than one currency, do not total them; report per currency.Who it's for
One answer, three teams that use it
Accountants
Tie out gift liability at month end
Store balance and ledger liability side by side show whether a true up is needed.
Compare BigCommerce gift certificate balances with the Rillet balance sheet as of 31 October.
Finance controllers
Spot expired balances
Expired certificates still carrying a balance are listed for a decision on treatment.
Which active BigCommerce gift certificates are past expiry, and does Rillet liability cover them?
Auditors
See which ledger line was used
The matching balance sheet line is named, so the comparison can be checked.
Which Rillet balance sheet line holds our BigCommerce gift certificate liability today?
How it works
What PopdockAI does when you ask
You give an as-of date and your AI assistant compares BigCommerce gift certificate balances with the Rillet liability line. It names the line it used.
01
Ask
You give an as-of date, or use today.
02
Sum
It totals active BigCommerce gift certificate balances and lists the largest.
03
Find
It searches the Rillet balance sheet for the matching liability line.
04
Report
You get both balances, the difference and expired certificates still carrying a balance.
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-gift-certificate
rillet-get-balance-sheet-lines
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
Store gift balances checked against the ledger
Related use cases
More ways to put this data to work
Check BigCommerce products against Rillet products
Ask your AI which best-selling BigCommerce products are missing from Rillet or priced differently, with weak matches labelled as suggestions and no products created.
Learn More
Check BigCommerce refunds against Rillet credit memos
Ask your AI to match refunded BigCommerce orders to Rillet credit memos and report which refunds have none, with ambiguous matches flagged and nothing created.
Learn More
Compare BigCommerce sales with Rillet invoiced revenue
Ask your AI to total BigCommerce orders and refunds against Rillet invoices and credit memos for a period and get the gap per currency, with partial sums flagged.
Learn More
Find BigCommerce customers missing from Rillet
Ask your AI which recent BigCommerce customers are not customers in Rillet and it matches on email then name, never guesses and changes nothing.
Learn More
Reconcile a BigCommerce order with a Rillet invoice
Ask your AI to find the Rillet invoice for a BigCommerce order and it compares total, currency and date, labelling inferred matches and refusing to pick between ties.
Learn More
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.