A multichannel month-end close in QuickBooks Desktop works when it runs in dependency order: cash first, then channel clearing accounts, then accruals for open settlement periods, then inventory and cost of goods, then review. Skip ahead and you will produce a profit and loss, discover an inventory variance, and have to redo the revenue work you already signed off on.
The whole close for a seller running four channels should take a disciplined bookkeeper two to four hours once the structure exists. If it is taking two days, the problem is almost never the person.
Two structural facts break the standard close.
Settlement periods do not respect your calendar. Amazon settles most seller accounts on a rolling schedule that Seller Central describes as a standard period of roughly 14 days, varying by seller agreement. A period that opens July 29 does not close until mid-August. On July 31 you have three days of sales that are real, earned, and completely unpaid, sitting in a report that does not exist yet.
Money you can see is not money you have. Marketplace reserves, pending payouts, refunds in flight, and chargebacks under review all sit between earning revenue and holding cash. Every one of them needs a home on the balance sheet or it lands somewhere wrong.
Neither problem is solved by working harder. Both are solved by structure.
1. Reconcile every bank and credit card account. Not "review." Reconcile, to the statement, with a zero difference. Everything downstream assumes cash is right.
2. Confirm every marketplace payout matched to an entry. Pull the bank feed, filter to deposits from each platform, and check that each one has a corresponding entry that fully explains it. A deposit matched to a single revenue line is a failure, not a match.
3. Tie each channel clearing account. For every channel, the clearing balance should equal unsettled activity plus any platform-held reserve. Write the expected number down before you look at the actual one.
4. Accrue the open settlement period. Take sales from the last settlement close through month end, apply your channel's known fee rate, and book the net to revenue and clearing. Reverse it on day one of the next month.
5. Accrue known fees not yet billed. Advertising spend that runs on a separate cycle, 3PL invoices that arrive on the tenth, storage charged in arrears.
6. Book the sales tax position. Where a marketplace facilitator collects and remits, that money should never have touched a revenue account. Where you collect and remit yourself, the liability has to reflect what you actually owe. The rules differ by state and change, so this is a question for your CPA or the state department of revenue, not something to settle by pattern-matching from last quarter.
7. Reconcile inventory quantity by location. Warehouse, 3PL, marketplace fulfillment centers, in transit. Each one separately. A single blended number hides the location where the problem is.
8. Clear the received-not-billed balance. Anything sitting longer than your normal supplier billing cycle is a missing invoice or a receipt against the wrong purchase order.
9. Allocate landed cost on everything received. Freight, duty, brokerage, and drayage invoices that arrived this month get allocated to the receipts they belong to. If they sit in a freight expense account, inventory is understated and cost of goods is overstated in the wrong period. Intuit's product documentation limits the landed cost feature to QuickBooks Enterprise Platinum and Diamond subscriptions, so on Silver or Gold this allocation happens upstream.
10. Post cost of goods against units actually shipped. Not units ordered, not units invoiced, not a percentage of revenue.
11. Tie inventory asset to the valuation report. This is the check that catches everything the previous four steps missed.
12. Run the profit and loss by class. One column per channel. Compare margin percentages to the prior three months. A channel that moved more than two points needs an explanation before you close.
13. Review the balance sheet for accounts that should be near zero. Undeposited Funds, suspense, ask-my-accountant, opening balance equity. Each one is a place errors hide.
14. Compare gross revenue to platform dashboards. Not to the penny, since timing differs, but within a percent. A larger gap means something structural.
15. Lock the period. Set a closing date with a password. A close that can be edited is not a close.
A seller closes July 2026 across Amazon, Shopify, Walmart, and eBay.
Amazon clearing, expected balance:
| Component | Amount |
|---|---|
| Sales July 29 to 31, gross | 41,880.20 |
| Less estimated fees at 27.2 percent | (11,391.41) |
| Net unsettled | 30,488.79 |
| Platform-held reserve | 22,000.00 |
| Expected clearing balance | 52,488.79 |
Actual balance in QuickBooks Desktop at July 31: $53,912.44. Variance: $1,423.65.
Investigating the variance takes eleven minutes and finds an FBA inventory reimbursement of $1,423.65 on the July 14 settlement that posted to the clearing account instead of to other income. The clearing account never clears it because no deposit relates to it. Reclassify, and the account ties.
That variance would have been invisible in a close that checks only the bank. It surfaced because someone wrote down the expected balance before looking.
Inventory tie-out:
| Location | FIFO value |
|---|---|
| Own warehouse | 312,440.80 |
| Marketplace fulfillment centers | 158,610.55 |
| In transit | 19,168.80 |
| Total per inventory system | 490,220.15 |
Inventory asset per QuickBooks Desktop at July 31: $486,220.15. Variance: $4,000.00.
The cause is a $4,000 ocean freight invoice received on July 22 and coded to freight expense instead of allocated across the receipt it belonged to. Reallocating moves $4,000 out of expense and into inventory asset, which raises July gross profit by $4,000 and lowers it in the months those units actually sell.
Two variances, both real, both found in under half an hour, both invisible to a close that stops at the bank reconciliation.
Five statements should be true when you lock the period:
If all five hold, the profit and loss is defensible in front of a lender, a buyer, or an auditor. If any of them does not, the bottom line is an estimate presented with two decimal places, which is worse than an estimate presented as one.
In the manual version of this close, steps 2, 3, 4, 9, and 10 consume most of the hours. Every one of them is arithmetic against data the platforms already publish.
ConnectBooks handles that arithmetic: reading settlements from Amazon, Shopify, Walmart, eBay, and TikTok Shop, decomposing each payout into its components, posting entries into QuickBooks Desktop and Enterprise that reconcile to the actual deposit, and carrying FIFO landed cost by SKU and by warehouse through the inventory layer. The result stands behind an accuracy guarantee.
What that leaves for the human is steps 12 through 15, which is the part where judgment actually matters: does this channel's margin movement make sense, and do I believe these numbers. The accounting approach and the full QuickBooks integrations set cover how the pieces connect.
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
