An order management system should send QuickBooks four things for each channel and period: sales, cost of goods sold at the time of sale, marketplace fees, and refunds. It should keep the order-level detail, every line item, every address, every status, in its own database where an operator can look it up. The ledger is for financial facts that roll into statements. The OMS is for the transactions that produced them. Sellers who confuse the two end up with a QuickBooks file that has 200,000 invoices in it and a P&L that takes four minutes to load.
Sellercloud, branded on its site as Descartes Sellercloud, is inventory and order management software for marketplace sellers. Per sellercloud.com, it centralizes orders, product information, and fulfillment for sellers on Amazon, Walmart, and other channels. ConnectBooks connects Sellercloud data to QuickBooks or Xero. The question is what should cross that connection.
Sales by channel, by period. Revenue for the month on Amazon, on Walmart, on Shopify, each on its own income line or class. Gross of refunds, so refunds can be tracked separately.
COGS at sale. When 340 units of a SKU ship in October, the FIFO cost of those 340 units leaves inventory and lands in COGS in October. Not when the PO was paid, not when the settlement arrives. The ledger needs the cost relieved in the period of the sale.
Fees. Referral fees, fulfillment fees, storage, advertising, and the dozen smaller charges each marketplace levies. Each on its own expense account, because "Amazon fees" as one line tells you nothing when it moves.
Refunds and returns. Refunded revenue, the fee credits that come back with it, and the inventory restocked, if any.
That is the whole list. Notice what is missing: individual customers, individual orders, tracking numbers, SKU quantities in real time. None of those change the financial statements.
The mechanical decision is whether each order becomes its own QuickBooks transaction or whether the period's orders become one journal entry per channel.
Illustrative numbers. Take a seller doing 18,000 orders a month across four channels, 11,200 of them on Amazon.
Per-order posting. Each Amazon order becomes a sales receipt or an invoice plus a payment. That is 11,200 sales transactions, plus fee lines on each, plus a credit memo for every refund. Across four channels and twelve months, the file gains roughly 216,000 sales transactions a year before fees and refunds. Intuit publishes usage and list limits for each QuickBooks edition; the practical limit arrives sooner, when reports slow down and the accountant stops opening the file.
Summary journal. October's Amazon activity becomes one entry.
Check the first block: $9,370 plus $46,860 plus $58,200 plus $3,100 plus $194,870 equals $312,400, which matches the credit. The clearing debit is what Amazon owes the seller on those orders before storage fees, subscription charges, and reserves, which hit the clearing account on separate settlement entries. The point of the example is that a summary entry forces you to explain every dollar between gross sales and what Amazon owes, once a month, on one screen. Per-order posting spreads the same dollars across 11,200 transactions where nobody will ever add them up.
The argument for per-order posting is traceability. If the auditor asks for order 113-4456789, the accountant wants to find it in QuickBooks.
The answer is that the auditor wants to find it somewhere, and the OMS is a better somewhere. A summary journal that is backed by an order-level report, with the report's total tying to the journal's sales line to the penny, is a stronger audit trail than 11,200 sales receipts, because the report shows the population and the journal shows the posting. The auditor pulls a sample from the report, traces each one to a settlement line, and is done. What the auditor cannot accept is a summary journal with nothing behind it. The report is not optional.
This is the split ConnectBooks' pricing page describes between its tiers: the Gold tier sends summary data to QuickBooks or Xero, and the Diamond tier reconciles per SKU. Both keep transaction-level detail in ConnectBooks. The choice is how much of it you want mirrored in the ledger, and the pricing page is the place to see the capability list for each.
A summary posting is only as good as the tie-out that proves it. Three checks.
Sales to the OMS. The journal's Amazon sales line, $312,400, has to equal the OMS's October Amazon order report, filtered to the same date basis. If the OMS reports by order date and the journal was built from settlement dates, they will differ, and the difference is timing, not error. Pick one basis for both.
Deposits to settlements. October's bank deposits from Amazon will not equal October's sales. Illustrative: three settlements landed in October totaling $245,900. The settlement covering September 27 through October 10 includes September orders. The settlement covering October 25 through November 7 lands in November. The clearing account carries the gap, and at month end its balance should equal the unsettled portion of October sales less the unsettled fees. If the clearing balance is growing month after month, something is posting to it that never clears.
COGS to inventory. Units sold per the OMS, valued at FIFO, has to equal the COGS line. If the OMS says 8,400 units shipped and the ledger relieved 8,120 units' worth of cost, 280 units left the building without a cost. Free replacements, samples, and unfulfilled-but-marked-shipped orders are the usual suspects.
Do these three and the summary journal is defensible. Skip them and it is a guess with nice formatting.
The OMS knows what shipped. It does not know what Amazon paid, because the settlement arrives two weeks later with fees that differ from the estimate, reimbursements that were never orders, and reserves that hold money back. Settlement reconciliation is accounting work, not order management work. ConnectBooks reconciles each settlement into QuickBooks Online, Desktop, or Enterprise at the transaction level, and Sellercloud data connects alongside so the OMS's view of orders and the books' view of money meet in one place. The difference between those two views, and who wins when they disagree, is spelled out in the order management system vs accounting system glossary.
Send four things. Keep the rest. Tie it out on the last day of the month.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
