The correct way to get an Amazon settlement into QuickBooks Desktop Enterprise is one summarized entry per settlement period that nets exactly to the deposit that hit your bank, with each fee type in its own expense account, plus a separate cost of goods entry driven by units shipped. Order-by-order imports are the wrong shape for a seller moving thousands of units a month. They swell the company file, they rarely tie to the bank, and they turn every month-end into an archaeology dig through 40,000 transactions looking for the $1,200 you cannot explain.
This is a workflow problem before it is a software problem. Get the shape right and the tooling question answers itself.
Amazon settles most seller accounts on a rolling schedule that Seller Central describes as a standard period of roughly 14 days, though it varies by seller agreement. At the close of each period, Amazon generates a settlement report covering every order, refund, fee, adjustment, and reserve movement inside that window, then disburses the net.
Amazon's own developer documentation for Settlement Reports notes that the settlement flat file carries a transaction type on each row, either Order or Refund, with fee and adjustment detail attached. That structure matters. It means the report is not a sales report and it is not a bank statement. It is a ledger of everything that moved money in both directions, and the sum of it equals your deposit.
Two consequences follow. First, settlement periods almost never align with calendar months, so a period that opens July 28 and closes August 10 straddles your close. Second, the deposit amount is a net figure that already has fees, refunds, and reserve changes baked in. If you book the deposit as revenue, your revenue is wrong and your fee expense is zero.
Before you post anything, Enterprise needs somewhere to put it. A workable chart of accounts for an Amazon seller separates at minimum:
The clearing account is the piece most sellers skip and then regret. It gives you a place to hold the timing difference between when a sale is earned and when Amazon pays it. If the balance in that clearing account does not match Amazon's reported reserve plus unsettled activity, something is wrong, and you found out in five minutes instead of five weeks.
Enterprise also gives you Class tracking, which is the cleanest way to carry channel down to the profit and loss without duplicating the entire chart of accounts. One class per marketplace. That single decision makes channel-level margin reporting possible later.
Take a settlement period running July 1 through July 14, 2026 for a seller who does most of their volume in FBA.
| Line | Amount |
|---|---|
| Product sales | 402,118.40 |
| Shipping credits collected | 8,442.15 |
| Promotional rebates | (6,310.88) |
| Referral fees | (60,317.76) |
| FBA fulfillment fees | (48,905.30) |
| Storage fees | (3,112.44) |
| Refunds, product amount | (18,440.60) |
| Refund fee credits returned | 2,766.09 |
| Cost of advertising | (11,204.00) |
| Reserve movement | (22,000.00) |
| Net disbursement | 243,035.66 |
The bank shows a single ACH of $243,035.66. The journal entry credits product sales for $402,118.40 and shipping revenue for $8,442.15, debits each fee account for its own amount, debits refunds for $18,440.60, credits the refund fee recovery for $2,766.09, moves $22,000 into the reserve holding account, and debits the bank for $243,035.66. The entry balances because Amazon's math balances.
Note what the referral fee line tells you without any outside data. $60,317.76 divided by $402,118.40 is 15.0 percent of product sales for this seller's category mix. Fulfillment fees run another 12.2 percent. Before a single dollar of product cost, Amazon has taken 27.2 percent of gross product sales.
Nothing in the settlement report tells you what the goods cost. That number comes from your inventory records, and it should be posted as its own entry against units shipped in the period, not units ordered and not units invoiced.
Say this seller shipped 9,412 units in the period at a FIFO cost of $148,320.55. Revenue net of refunds and all Amazon fees was $265,035.66. Subtract product cost and the contribution is $116,715.11, or 29.0 percent of gross product sales. That is the number the seller actually runs the business on, and it is invisible until both entries exist.
FIFO matters here more than sellers expect. If you bought the same SKU at three different landed costs across two container loads, a weighted average smears the margin difference across the whole year and hides the moment your unit economics changed. Enterprise supports FIFO costing through Advanced Inventory, which Intuit's product page states is included in the Platinum and Diamond subscriptions only. If you are on QuickBooks Enterprise Silver or Gold, FIFO inside QuickBooks is not available to you and the costing has to happen upstream. Our glossary entry on Advanced Inventory covers what each tier includes.
Three failure points account for most of the mismatches we see.
Reserve movement treated as revenue or ignored. Amazon holds funds. When the reserve grows, the deposit shrinks even though sales were fine. Sellers who do not carry a reserve account interpret the smaller deposit as a bad month.
Straddling periods closed as if they were clean. A settlement that closes on August 10 contains sales from late July. Recognizing all of it in August overstates August and understates July. The fix is to accrue the open period at month end using the unsettled activity, then reverse it.
Sales tax handled as revenue. Under marketplace facilitator rules, Amazon collects and remits sales tax in the states where those rules apply. That money is never yours. It should pass through a liability or be excluded, never sit in a revenue account. How this works varies by state and by year, so confirm your specific situation with your CPA or the state's department of revenue rather than assuming last year's treatment still holds.
The manual version of this is roughly two to four hours per settlement once you have templates built, and it goes wrong the first time Amazon adds a new fee category. The alternative is a connector that reads the settlement, maps every line to your accounts, and writes a balanced entry directly into Enterprise. ConnectBooks does this for Amazon into QuickBooks Desktop and Enterprise, carrying FIFO cost of goods at the SKU level and reconciling the entry against the actual disbursement so a mismatch surfaces immediately instead of at year end.
The same pattern extends to Shopify, Walmart, eBay, and TikTok Shop through the QuickBooks integrations set, which matters once a second channel starts producing its own payout schedule with its own fee vocabulary. What you want at the end is an accounting layer where one entry per payout explains one deposit, and every SKU carries its real cost. If you want to see it against your own settlement file, book a walkthrough.
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
