/
/
Check a Shopify order against its FreshBooks invoice
For bookkeepers who want an order and its invoice compared by asking their AI assistant for the order number.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Checking one order against FreshBooks takes three searches
A bookkeeper checking a Shopify order has to find the client in FreshBooks, search for the invoice and compare totals and payment status by eye. Missing invoices and wrong amounts slip through, especially when tax and shipping make totals differ.
Without PopdockAI
- Open the Shopify order and note the email and total
- Find the client in FreshBooks
- Search their invoices for the order number
- Compare totals and payment status by eye
With PopdockAI
- The order is read and the client found by its email
- The invoice is found by PO number or invoice number
- Total, currency, status and outstanding are marked Match or Differs
- Cancelled orders are flagged, 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:** Find the FreshBooks invoice for Shopify order `{order-name}` (for example #1001) and report whether the totals and payment state agree. FreshBooks company: `{company}`.
**Step 1: Read the order** (shopify server)
Call `shopify-get-order` with `name` set to `{order-name}`. If nothing returns, stop and say the order was not found. Keep order-id, order-number, email, customer-id, total-price, currency, financial-status, created-at and cancelled-at.
**Step 2: Find the invoice** (freshbooks server)
Call `freshbooks-get-client` with `email` set to the order email and `company` set to `{company}` to get the client id. If no client matches, report the order as having no FreshBooks client and stop.
Then call `freshbooks-get-invoice` with `customer-id` set to that client id, `company` set to `{company}` and `create-date.from` set to the order date minus 7 days. Match the invoice whose `po-number` or `invoice-number` equals the order name or order-number. If none matches, report the order as present in Shopify and not invoiced in FreshBooks.
**Step 3: Compare and report**
Show a table: order total vs invoice amount, currency vs currency-code, financial-status vs payment-status, and outstanding. Mark each Match or Differs and give the difference amount.
**Rules & Guidelines:**
* `shopify-get-order` is on the shopify server; `freshbooks-get-client` and `freshbooks-get-invoice` are on the freshbooks server.
* Read-only. Do not call any add-, update-, delete-, mark- or send- tool on either server.
**Validation:**
* If several invoices could match, list them and ask which one; do not guess.
* Shopify total-price includes tax and shipping; say so when the totals differ by exactly the tax or shipping amount.
* A cancelled Shopify order (cancelled-at set) should be flagged, not compared.Who it's for
One answer, three teams that use it
Bookkeepers
Check an order without three searches
Get the invoice comparison for a single order in one question, with the differences spelled out.
Does Shopify order #2307 match its FreshBooks invoice for Contoso Goods?
Store owners
Answer a customer's billing question
When a customer queries an invoice, see straight away whether it matches what they ordered and paid.
A customer says invoice for order #1876 is wrong. Compare it with the Shopify order.
Accounts receivable
See what is still outstanding
Payment status and outstanding are compared, so you know whether the order is actually paid in FreshBooks.
Is Shopify order #2140 marked paid in FreshBooks for Fabrikam Studio, and is anything outstanding?
How it works
What PopdockAI does when you ask
You give the order and the company, and your AI assistant finds the matching FreshBooks invoice and compares it. It asks you when several invoices could match.
01
Ask
You give the Shopify order name and the FreshBooks company.
02
Read
It reads the order and finds the FreshBooks client by email.
03
Find
It looks for the invoice that matches the order name or number.
04
Compare
You get total, currency and payment status marked Match or Differs.
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.
shopify-get-order
freshbooks-get-client
freshbooks-get-invoice
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
Each order checked against its invoice in one step
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)
