Key takeaways
- Record Amazon activity from a settlement report, not from the bank deposit alone.
- Keep gross sales separate from refunds, fees, reserves, reimbursements, and other settlement lines.
- Use an Amazon clearing account to connect the complete settlement entry with the net payout.
- Match the bank transaction to the clearing transfer so the payout is not recorded as another sale.
- Treat the dollar amounts below as illustrative examples and confirm account mappings for your own books.
Month-end closes with Amazon sales booked at the bank-deposit amount, so settlement fees and refunds never land in QuickBooks and the clearing balance drifts. If you are learning how to record amazon sales in quickbooks, start with the settlement report rather than the bank-feed amount. The deposit is the net result of several marketplace events, not a substitute for the underlying sales detail.
A reliable workflow is Amazon settlement report → Amazon clearing account → bank deposit. Record gross order proceeds, refunds, marketplace charges, and other supported adjustments in QuickBooks Online. Then record the net settlement as a transfer from clearing to checking. This approach keeps the sales total visible and gives every difference a place in the reconciliation.
How to record amazon sales in quickbooks: the core method
Amazon may combine many transaction types into one payout. A settlement can contain product sales, customer refunds, referral or commission charges, fulfillment activity, storage charges, reimbursements, reserve movements, and corrections. The bank sees one net deposit, while your accounting records need to explain the components that produced it.
Begin by creating or confirming an Amazon clearing asset account in QuickBooks Online. Its purpose is to hold the amount Amazon owes you between settlement activity and the bank payout. Depending on your existing chart of accounts, you may use separate expense accounts for marketplace fees, fulfillment, storage, and other recurring categories. Keep the mapping consistent so reports can be compared with later Amazon settlements.
The settlement entry normally credits gross product sales. It debits the clearing account for the amount payable by Amazon and debits accounts representing refunds or charges that reduced the payout. When the entry balances, the clearing debit equals the net settlement. The bank deposit then clears that amount.
This is different from categorizing the deposit as income. A bank-feed rule that posts every Amazon deposit directly to sales can make the books appear simple, but it hides the settlement mechanics. It can also duplicate revenue if sales were already imported or entered manually. The Amazon accounting guide provides broader context for organizing marketplace activity.
Gross sales versus the net Amazon deposit
Gross sales are the product proceeds shown in the settlement activity before the lines that reduce or increase the payout. The net deposit is what Amazon sends after those lines are applied. They answer different questions:
- Gross sales: How much product revenue does the settlement report show?
- Settlement adjustments: Which refunds, fees, reserves, reimbursements, and corrections changed the amount owed?
- Net payout: What amount should arrive in the bank for this settlement?
For this illustrative example, suppose a settlement report shows $6,000.00 of product sales, $900.00 of marketplace charges, $200.00 of fulfillment charges, and $300.00 of customer refunds. The resulting payout is $4,600.00. The exact categories and amounts in a real report will vary; use the report lines and your established account policy.
If you post $4,600.00 as sales, the financial statements do not show the $6,000.00 gross activity or the reasons the payout was lower. If you post $6,000.00 as sales and ignore the other lines, the clearing account cannot reconcile to the deposit. If you post the complete settlement, the gross sales and reductions remain visible while clearing explains the cash movement.
The Amazon settlement report guide can help you identify the settlement ID, covered dates, payout amount, and line categories before you prepare the QuickBooks entry.
Illustrative journal example: record a settlement
The following is an illustrative example only. It uses simple round numbers to show the mechanics. Debits and credits each total $6,000.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Amazon clearing | 4600.00 | |
| Marketplace fee expense | 900.00 | |
| Fulfillment expense | 200.00 | |
| Sales returns and allowances | 300.00 | |
| Amazon product sales | 6000.00 | |
| Total | 6,000.00 | 6,000.00 |
The account labels are examples, not required names. If your report includes storage, reserve activity, reimbursements, or fee reversals, add the corresponding lines rather than forcing them into an unrelated account. A positive reimbursement may increase the clearing amount; a refund of a prior charge may reduce the related expense. Preserve the source description and settlement reference in the memo or supporting schedule.
Illustrative journal example: clear the payout to the bank
After the settlement is posted, record the bank movement as a separate illustrative example. Debits and credits each total $4,600.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Business checking | 4600.00 | |
| Amazon clearing | 4600.00 | |
| Total | 4,600.00 | 4,600.00 |
When the bank-feed transaction appears, match it to this transfer. Do not categorize the same deposit as sales, miscellaneous income, or another fee entry. The settlement journal already captured the activity that produced the payout. If the bank amount differs, pause and investigate the settlement reference, timing, or omitted lines before forcing the difference into a generic account.
Steps to record Amazon sales in QuickBooks Online
- 1
Choose the settlement
Locate the Amazon settlement ID and payout that correspond to the bank transaction. Confirm the marketplace and covered dates. A nearby deposit may belong to a different settlement.
Download the report: Save the settlement report and any transaction detail needed to support the totals. Keep the original file and note the period you are reconciling.
Build a settlement summary: List gross product sales, refunds, marketplace fees, fulfillment charges, storage, reserves, reimbursements, and corrections in separate rows. Add a source reference for unusual lines.
Review existing entries: Search QuickBooks for imported orders, prior settlement journals, bank-feed rules, or manual entries covering the same activity. Remove or reverse duplicates through your normal review process.
Map each category: Assign each supported settlement line to the appropriate QuickBooks account. Keep fee categories distinct when the report distinguishes them, and document any intentional grouping.
Post the settlement: Debit Amazon clearing for the net amount payable, debit the accounts for refunds and charges, and credit the gross sales account. Confirm that total debits equal total credits.
Match the deposit: Record the transfer from Amazon clearing to checking, then match the downloaded bank transaction to that transfer. The deposit should not create a fresh sales entry.
Reconcile clearing: Compare the remaining clearing balance with unsettled payouts, reserves, timing items, or missing reports. Attach the settlement ID and a brief explanation to the reconciliation workpaper.
For a recurring month-end process, see the guide to reconciling Amazon settlements in QuickBooks. It covers the surrounding review while this guide focuses on recording the settlement through clearing.
Troubleshooting common Amazon settlement mismatches
The deposit is lower than the sales entry. Check whether fees, refunds, reserves, or other adjustments were omitted. Do not replace gross sales with the bank amount. Rebuild the settlement summary from the report and post the missing lines.
The clearing account has a credit balance. Look for a settlement posted without its matching sales, a duplicated payout transfer, or a bank deposit categorized directly to an income account. Also check whether the report includes a prior-period adjustment.
The clearing account has a debit balance. The payout may not have arrived yet, or the bank transfer may be missing. A reserve or timing difference can also leave an amount in clearing. Tie the balance to a settlement ID and expected follow-up rather than erasing it.
The settlement total does not match the report. Confirm the report period, marketplace, currency, and settlement status. Review negative lines, fee reversals, reimbursements, and rounding. Compare the report total with your summary before editing the QuickBooks journal.
The bank feed creates duplicate sales. Review automation rules and imported transactions. Keep the bank-feed action limited to matching the clearing transfer when the settlement has already been recorded. A single source should own the settlement detail.
A fee category is unclear. Retain the Amazon description and reference, place it in a review queue, and use a consistent temporary mapping only if your bookkeeping process permits it. Update the mapping once the line is identified, with an audit note explaining the change.
Keep Amazon sales reconcilable
The goal is not to make sales equal the deposit. The goal is to make the deposit explainable: gross sales remain visible, settlement reductions are represented, and the clearing account connects Amazon activity to cash without recording the payout twice.
If manual settlement summaries take too much time, review the Amazon–QuickBooks integration to see how a settlement-based workflow can support recurring imports and account mappings. You can also review ClearPayout pricing when deciding whether automation fits your month-end process. ClearPayout can help organize Amazon settlement activity for QuickBooks Online, while your team retains responsibility for reviewing mappings and resolving exceptions.
Use the same sequence each period: source the settlement, classify its lines, post through Amazon clearing, match the net payout, and explain anything left behind. That discipline prevents bank deposits from becoming a misleading shortcut for marketplace sales.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.