Querri ties Shopify, Amazon and retail to NetSuite or QuickBooks, matches payouts to deposits, catches retailer deductions, and gives the leadership pack one margin by channel that every team uses. No warehouse or data hire first, and every number opens to its source.
One minute: settlements tied to the books, the Channel close blueprint, and what else your finance data answers.
One view of the month
Four sources. One margin by channel, tied to the books.
Orders and payouts live in Shopify, settlements in Amazon, invoices, cost and deposits in the ledger, and retailer deductions in remittances and promo sheets. Querri joins them by order, payout and invoice, and checks for gaps and duplicates before it queries, so the close and the leadership pack start from the same numbers.
Store orders and payoutsShopify
Amazon orders and settlementsAmazon
Ledger, cost and depositsNetSuiteQuickBooks
Remittances and promo calendarExcelGoogle Sheets
Defined once
Margin by channel, April to September
Channel
Net sales
Fees and deductions
CM2
Online store
$48,136
$1,751
55%
Amazon
$12,477
$5,022
36%
Wholesale
$27,174
$2,681
18%
Sample data: Marigold Supply Co., a fictional multichannel brand. CM2 is net sales less product cost, channel fees and fulfillment, plus shipping charged.
Where ecommerce finance teams start
Three questions that cross the ledger's edge
These are good first jobs, not the whole list. Once Shopify, Amazon and the books are in, the same definitions answer whatever you ask next.
One margin by channel, tied to the books.
“What did the store, Amazon and retail each earn this month, on the numbers ecommerce and the board use?”
How it's done today
Shopify and Seller Central exports, a NetSuite report pulled into Excel, and a margin tab that differs from the one ecommerce built.
In Querri
Querri joins Shopify orders and refunds, Amazon orders, fees and settlements, and invoices, item cost and channel class from NetSuite or QuickBooks. Each channel runs from gross sales to contribution on one definition, and the leadership pack reads it.
Sample data. Amazon keeps 76% as gross margin and 36% once its fees land. The same ladder runs for the store and wholesale.
Payouts that match what you booked.
“Do Shopify and Amazon payouts match what we booked, and which line made the gap?”
How it's done today
Each settlement report opened by hand, matched to bank deposits in a spreadsheet, and the gap carried as a plug.
In Querri
Querri reads Shopify payouts and every Amazon settlement line beside the deposits in your ledger, and matches them by payout. Each gap shows the fee, refund or reserve behind it, and a monitor flags new fees before close.
Amazon settlements closed July to September, against the books
Line
Amazon
Booked
Gap
Sales
$7,025
$7,025
$0
Referral fees
-$1,065
-$1,065
$0
FBA fees
-$1,216
-$1,216
$0
Storage and subscription
-$630
$0
-$630
Sample data. Each settlement is dated by the day it closes, as the books post it. Storage and subscription fees were never booked, and rose from $90 in April to $190 in September.
Retailer deductions, checked against what you agreed.
“Which retailer deductions tie to a promo we agreed, and which are leakage?”
How it's done today
Remittances from each retailer portal, credit memos in the ledger, and the promo calendar in someone's workbook.
In Querri
Querri lines up A/R and credit memos from the books with retailer remittances and your promo calendar, so each deduction shows whether it ties to a promo you agreed. The rest is a dispute list, by retailer and reason.
Sample data. $1,331 of $2,681 in deductions ties to nothing you agreed, enough to take wholesale's CM2 from 23% down to 18%.
Margin by channel is one question. Ask next about inventory in the books against the 3PL, refunds by channel or the month's variance to plan. See how asking works →
More than a close checklist
One set of channel numbers, for every report and every AI agent
The three jobs run on the same foundation as everything else in Querri. Define a number once, and every dashboard, spreadsheet export, board pack and AI answer uses it.
The Library
Teach it once. It stays right.
Say what counts as net sales, landed cost and contribution, and which class each channel books to, and every answer after that uses it. Finance, ecommerce and the board pack finally show one margin.
Click a channel's margin to see the orders, settlement lines and ledger entries behind it, and when each refreshed. Before it queries, Querri checks the data for gaps and duplicates, and when it can't answer, it says what's missing.
Ask in plain language, with no SQL and no queue. Send the leadership pack to Excel or slides, build a dashboard by asking, or ask from your AI assistant, under each person's own access.
Monitors judge each channel's fees, each payout and each retailer's deductions against its own history, and say which one moved, not just that the total did. Every night Querri works through your data and leaves what it found in your Inbox. Nothing changes without your OK.
Four steps from sign-up to your own channel close desk. No warehouse, BI build or data hire first.
1
Sign up free
No credit card. Your own workspace is ready in about a minute.
2
Install Channel close
Open Blueprints, pick the card and install it. Sample data comes with it, so every page has numbers right away.
Channel close21 pieces
3
Keep the sample, or connect your data
Connect Shopify, Amazon and NetSuite or QuickBooks for payouts and deposits, then add remittances, the promo calendar and your channel close map. An agent sets up each connection with you.
4
Open your channel close desk
Margin by channel, payouts against deposits and retailer deductions, on one site.
Open your channel close desk
Margin by channel and the payout tie-out, on the Channel close desk (Marigold Supply Co. sample data).
Everything that installs
5 Site pages
Channel close desk
Month-end tie-out
Channel P&L
Payouts and settlements
Retailer deductions
Definitions and data readiness
3 Dashboards
Channel P&L
Payout tie-out
Deductions
4 Views
Channel P&L
Settlement lines
Payouts and deposits
Deductions
3 KPIs
Net sales
CM2 %
Unmatched payouts
4 Skill and monitors
Month-end close
Payout gap watch
Amazon fee watch
Deduction watch
A payout matches when the deposit booked for it carries its reference, or the same amount within five days. Monitors compare each fee, payout and retailer with its own history.
How Querri compares with the other ways ecommerce finance gets these numbers
Most ecommerce finance teams already have ERP reports, a settlement summary tool, Excel, or all three. Here is where each fits, where it stops, and how Querri works alongside it.
Querri
ERP reports
A settlement summary tool
Exports and Excel
Time to the first answer
Minutes on sample data from the blueprint, then on your own
Already there for what's booked
Days to set up, then each payout posts on its own
Every month, by hand
Shopify, Amazon, retail and the ledger together
One Library, from 125+ connectors and file uploads
Summaries only, unless middleware brings order detail in
Store and marketplace payouts; retail sits outside
Whatever someone pastes in
Margin by channel to the SKU
Gross sales to contribution, by channel and SKU
By class, at summary level
Not its job: it books summaries
A tab per channel, rebuilt each month
What net sales and margin mean
Defined once; every answer, dashboard and AI agent uses it
In each saved search
In the tool's mapping to your accounts
In each workbook's formulas
Where a number came from
Click any number to see its source tables and refresh time
Drill into the journal
The payout it came from
In the formulas, for whoever built them
Retailer deductions against promos
Matched to the promo calendar, rest flagged for dispute
Credit memos, without the reason
Not covered
A lookup someone maintains
Posting journal entries
Not Querri's job. Querri reads, never writes
Its core strength
Its core strength
Pasted in by hand
How it works with Querri
Reads from all three, plus order and ad detail
Keep it as the book of record. Querri adds the channel detail
Keep it to post summaries. Querri checks them against orders and margin
Answers export to Excel, so the workbook stays
The right call on its own when
The close crosses the store, Amazon, retail and the books
You sell through one channel
You only need payouts posted
It's a one-off question
Approaches, not products: what each typically looks like in late 2026.
Ecommerce finance across Shopify, Amazon and retail: common questions
How do ecommerce controllers close the month across Shopify, Amazon and retail on one set of numbers?
Querri joins Shopify orders and payouts, Amazon orders and settlements, and invoices, cost and deposits from NetSuite or QuickBooks into one Library. Net sales and margin are defined once, so the close, the leadership pack and ecommerce's dashboards agree. Every number opens to the orders and ledger lines behind it. See every connector →
How can I reconcile Amazon settlements and Shopify payouts to bank deposits?
Connect Shopify and Amazon next to your ledger. Querri matches each payout and settlement to the deposit booked for it and breaks any gap into its lines: fees, refunds, reserves, or charges posted outside the settlement. A monitor flags a new or rising fee before close, not after. Nightly insights and Monitors →
Can Querri show margin by channel, from gross sales to contribution?
Yes. Querri runs each channel from gross sales through discounts, returns, product cost, channel fees and fulfillment to contribution, with item cost and channel class from NetSuite or QuickBooks. The same ladder works by SKU, so you see which products earn their place on Amazon. KPIs →
How do I check retailer deductions and chargebacks against our promo calendar?
Bring A/R and credit memos from the books, retailer remittances as files, and your promo calendar from Excel or Google Sheets. Querri matches each deduction to the promo it belongs to and lists the rest by retailer and reason, ready to dispute. Excel workbooks →
Can an ecommerce finance team of one or two keep working in Excel with Querri?
Yes. Ask in plain language, then send any answer to Excel as a workbook that refreshes from the same definitions. There's no SQL to learn and no analyst queue, and the leadership pack can go out as slides from the same numbers. Excel workbooks →
Is it safe to connect NetSuite, QuickBooks, Shopify and Amazon to Querri?
Yes. Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified. Each organization has its own database and storage, encrypted with AES-256 at rest, and your data, prompts and results never train any model. Connectors are read-only, so Querri never changes a record in your ledger or your store, and an agent sets up each connection without ever seeing your passwords. Visit the Trust Center →
What does an ecommerce finance team connect first to get started with Querri?
To get started with Querri, connect NetSuite or QuickBooks, then Shopify and Amazon. Add retailer remittances and the promo calendar as files when you're ready. An agent sets up each connection with you. The Channel close blueprint opens on sample data first, with margin by channel and the payout tie-out, then runs on your own data. Sign up and open the blueprint →
Do I need a credit card to try Querri for ecommerce finance?
No. Querri is free to start, and no credit card is required, so a finance team can try it on sample data before any budget conversation. There's no warehouse, BI tool or data hire to set up first. Current plans and prices are on the Querri pricing page. See pricing →
Playbooks
Three month-end questions across channels
Step by step, with sample data, for the person who builds the report.
Playbook coming
Margin by channel for the leadership pack
What did the store, Amazon and retail each earn this month, tied to the books?
Playbook coming
Amazon settlements and Shopify payouts against deposits
Which payouts don't match what we booked, and which line made the gap?
Playbook coming
Retailer deductions against the promo calendar
Which deductions tie to a promo we agreed, and which should we dispute?
From the blog
For the CFO and the founder
What to do once you have the answer.
Article coming
Why Shopify revenue never matches the bank
Where payouts and booked sales part ways, and how to close the gap every month.
Article coming
Contribution margin by channel, one definition for the whole company
How finance and ecommerce stop bringing two margins to the same meeting.
Article coming
Retailer deductions are a margin line, not a rounding error
What leakage costs a brand selling to retail, and how to win it back.
Close this month on one set of numbers.
The channel close blueprint opens when you sign up. Connect Shopify, Amazon and NetSuite or QuickBooks, and ask what each channel earned and which payout doesn't match.
Shopify
Amazon
NetSuite
QuickBooks
Excel
Google Sheets