How do I speed up month-end close for a Shopify Plus brand with a 3PL and Amazon?

Work the queues every day. Leave judgement for the last two days. That is the close.

Order of operations for close

Order of operations is a dependency chain, not a preference. Cut off shipments, receipts, returns, and 3PL internal moves first. An open 3PL shipment or an unreceived return will move valuation and COGS after you think you are done. Freeze inventory. Run valuation against the balance sheet and localize the variance by day and SKU before you post anything. One ugly cycle-count day can be millions. Then cash: Shopify payouts and Amazon settlements. Then COGS and landed-cost true-ups. Then the failed GL-sync queue. Then AR aging vs the balance sheet. Then lock. Skip a step and you will reopen the next one.

Reconciling cash and settlements

Cash is a close step, not the close. Shopify payments, refunds, and fees belong in a clearing account. The payout is a bank transfer off that account, not a pile of orders. A deposits-in-transit account lets withdrawal and deposit match. Amazon reconciles at the settlement, not the order. A drifting Amazon gateway balance is the health metric: unmatched fees, reserved funds, or a posting-model change you have not remapped. Payout-summary journals into QuickBooks or Xero (A2X-class) can match the bank and still book that deposit as sales. That is a revenue error, not a cash win. Isolate each recon (Shopify, Amazon, Stripe or PayPal fees) on its own track so one broken settlement does not stall the whole close.

3PL and FBA valuation

3PL valuation is only as good as shipments marked done. Open internal moves show as tied-up or negative stock. Returns sit in a not-received holding account until the 3PL receipts them, so COGS looks wrong in between. FBA Reserved and inbound are still inventory. They are not sold and they are not a Shopify export. Unmapped GL accounts (duty, freight, received-not-invoiced) will silently fail hundreds of supplier invoices. Fix the map once. Do not remap it every month.

Stock period locks and financial period locks are different. Know which one is biting you. Do not reopen a locked period to fix a stock move unless there is no other fix. Pre-cutover dummy costs will keep distorting COGS until someone cleans the cutover, even if support says ignore it. Comfort is not an audit. A leftover $1 kit cost or a negative on-hand is a valuation poison. Find it in the daily queue, not in the lock meeting.

Daily queues vs month-end judgement

Daily: clearing balances (Shopify, Amazon, deposits in transit), failed exports, unmatched bank lines, open 3PL shipments, cycle-count exceptions, negative inventory. If you sell gift cards, pre-orders, or prepaid boxes, the contract-liability rollforward is a queue too. Those balances are not a payout recon. Month-end only: accruals, landed-cost actuals, final tie-outs, the lock. Work queues while the period is open. Judgement is what you do after the queues are empty.