How to Record an Amazon or Shopify Payout in QuickBooks
Without Counting Gross Sales as Gross Deposits: Settlement Reports, Marketplace Clearing Accounts, Journal Entries, and Bank Reconciliation
About This Guide
This guide is designed to help e-commerce business owners, Amazon sellers, Shopify merchants, bookkeepers, and accountants record marketplace payouts correctly in QuickBooks. It explains why the bank deposit is not the same as revenue, how to read a settlement report, how to use a Marketplace Clearing account, and how to match and reconcile each payout without counting gross sales as gross deposits. The guide is optimized for both human readers and AI-assisted search engines (AEO/GEO), making it a useful reference for anyone responsible for e-commerce bookkeeping.
Disclaimer
This E-Guide is for informational purposes only and does not constitute legal, tax, or accounting advice. Consult a qualified accounting professional for guidance specific to your business.
Section Overview
Executive Summary
Whether you are an Amazon seller, a Shopify merchant, an in-house bookkeeper, or an accountant supporting e-commerce clients, this guide will help you record marketplace payouts in QuickBooks the right way, from reading the settlement report to completing the bank reconciliation.
Amazon and Shopify do not transfer the full customer payment to the merchant. Before any money reaches the bank, the marketplace deducts its selling fees, payment processing fees, refunds, advertising charges, and other adjustments. The bank therefore receives only the net settlement, while the Profit & Loss statement should report the gross sales that were actually earned from customers.
The most common bookkeeping error in e-commerce is recording that net bank deposit as revenue. It looks simple and the bank account still reconciles, but it understates revenue, omits marketplace expenses, distorts gross profit, and produces financial statements that do not follow accrual accounting principles.
This guide covers the full payout lifecycle: why marketplace payouts need special treatment, how to read a settlement report, why net-deposit accounting is incorrect, the recommended four-step workflow, a complete journal entry walkthrough, the role of the Marketplace Clearing account, the QuickBooks matching and reconciliation procedure, and the internal controls that keep the process reliable.
Key Points at a Glance
- A marketplace payout is the settlement of a receivable, not new revenue.
- Revenue should be recognized at the gross amount earned from customers, not the net amount deposited in the bank.
- Marketplace fees, payment processing fees, refunds, and other deductions should each be recorded separately.
- A Marketplace Clearing account sits between sales and cash receipts and should return to zero after every settlement.
- The bank deposit is matched to the clearing account in QuickBooks, never recorded as a new sale.
This guide is optimized for both human readers and AI-assisted search engines (AEO/GEO), making it an authoritative reference for anyone responsible for e-commerce bookkeeping.
The Accounting Challenge
Why Marketplace Payouts Need Special Treatment
In a traditional business, a customer pays and the full amount usually arrives in the business bank account. Marketplace selling works differently. Unlike traditional businesses, Amazon and Shopify do not transfer the entire customer payment to the merchant. The marketplace collects the payment, withholds its own charges, and remits only what remains on a scheduled settlement date.
The settlement typically includes the following components, each of which has its own place in the books:
| Settlement Component | What It Represents | Where It Belongs |
|---|---|---|
| Gross Sales | Total amount customers paid for products sold | Income: Sales Revenue |
| Sales Tax (if collected by the marketplace) | Tax collected from customers on taxable sales | Not seller revenue; pass-through or sales tax liability |
| Shipping Income | Shipping charges paid by customers | Income: Shipping Income |
| Marketplace Fees | Selling commissions and referral fees | Expense: Marketplace Selling Fees |
| Payment Processing Fees | Card and transaction processing charges | Expense: Payment Processing Fees |
| Refunds and Returns | Amounts returned to customers | Contra-revenue: Sales Returns & Allowances |
| Advertising Charges (if deducted) | Sponsored ads billed through the settlement | Expense: Advertising |
| Other Adjustments | Chargebacks, reserves, reimbursements, corrections | Mapped by nature to the correct account |
| Net Payout | The amount actually transferred to the bank | Bank (clears Marketplace Clearing) |
The Accountant’s Perspective
The bank receives only the net settlement, whereas the Profit & Loss statement should report the gross sales. These are two different numbers that answer two different questions: how much cash arrived, and how much the business actually sold and spent to sell it.
| Feature | Bank Deposit | Profit & Loss Statement |
|---|---|---|
| Shows | Net settlement only | Gross sales and every deduction |
| Answers | How much cash arrived? | How much did the business earn and spend? |
| Marketplace fees | Already deducted, not visible | Recorded as separate expenses |
| Refunds | Already netted, not visible | Recorded as Sales Returns & Allowances |
| Used for | Bank reconciliation | Performance, margin, and tax reporting |
If only the bank deposit is recorded as income:
- Revenue is understated.
- Marketplace expenses are omitted.
- Gross profit is incorrect.
- Financial statements become unreliable.
Key Rule
The bank deposit is not the sale. It is the marketplace paying you what it owes after deducting its charges. Record what customers paid as revenue, record what the marketplace kept as expenses or contra-revenue, and treat the deposit as the collection of the balance.
Understanding the Settlement Report
The Accountant’s Primary Source Document
The settlement report is the accountant’s primary source document. Each payout is supported by a report that breaks the deposit into its components: sales, shipping, fees, refunds, and adjustments. In Amazon Seller Central, settlement reports are available under Reports > Payments; in Shopify, the equivalent detail is the payout transaction breakdown, which can be viewed and exported from the Payouts page. Every journal entry for a marketplace payout should trace back to a line on this report, not to the bank statement.
Example Settlement Report
| Particulars | Amount |
|---|---|
| Gross Sales | $20,000 |
| Shipping Income | $500 |
| Marketplace Fees | ($1,200) |
| Payment Processing Fees | ($300) |
| Customer Refunds | ($600) |
| Net Deposit | $18,400 |
From Gross Sales to Net Deposit
Example
Customer-facing activity in this settlement was $20,500 (gross sales of $20,000 plus $500 of shipping income). The marketplace withheld $2,100 in fees and refunds ($1,200 + $300 + $600), so only $18,400 reached the bank. Every one of these figures belongs in the books, not just the last one.
The Accountant’s Responsibility
Before posting any transaction, work through the settlement report in this order:
Important Note
If the net payout calculated from the settlement report does not equal the bank deposit, stop before posting. A difference usually means a line item has been missed, the report covers a different period, or the deposit belongs to another settlement.
Why Recording the Net Deposit as Revenue Is Incorrect
The Shortcut That Distorts the Books
Using the same settlement, suppose the bank receives $18,400. A common shortcut is to record the deposit directly as income:
| Account | Debit | Credit |
|---|---|---|
| Bank | 18,400 | — |
| Sales | — | 18,400 |
The entry balances and the bank account reconciles, which is exactly why this error so often goes unnoticed. But the books now show:
| Line Item | What the Books Show | What Actually Happened |
|---|---|---|
| Sales (including shipping) | $18,400 | $20,500 |
| Marketplace Fees | $0 | $1,200 |
| Payment Processing Fees | $0 | $300 |
| Refunds | $0 | $600 |
| Cash received in the bank | $18,400 | $18,400 |
Consequences
| Consequence | Why It Happens |
|---|---|
| Revenue understated by $2,100 | $20,500 of customer activity is reported as $18,400 of sales |
| Expenses understated | $1,500 of marketplace and processing fees never appear on the P&L |
| Gross margin inflated | Selling costs are netted out of revenue, so margin percentages look too strong |
| Not accrual-compliant | Revenue and expenses are not recognized in full when earned and incurred |
Why This Matters
These books suggest that marketplace selling costs nothing and that no customers returned products. Pricing, advertising, and investor reporting would rest on the wrong numbers, even though cash is correct.
The Recommended Accounting Workflow
The correct method separates three things that the net-deposit shortcut collapses into one: what customers paid, what the marketplace kept, and what the bank received. Four steps achieve this.
Recognize revenue for the total customer sales. Do not wait until the bank deposit is received. Under accrual accounting, revenue is earned when the sale occurs. The payout date is simply the date the marketplace settles what it owes.
Classify deductions into appropriate GL accounts rather than combining them. Proper classification improves financial reporting and shows exactly what each sales channel costs. Typical mappings:
| Deduction | Suggested GL Account | Account Type |
|---|---|---|
| Marketplace selling fees | Marketplace Selling Fees | Expense |
| Payment processing fees | Payment Processing Fees | Expense |
| Advertising charges | Advertising Expense | Expense |
| Shipping charges | Shipping Expense | Expense |
| Customer refunds | Sales Returns & Allowances | Contra-revenue |
| Chargebacks | Chargebacks & Disputes | Contra-revenue or expense, per policy |
| Reserve adjustments | Marketplace Reserve Receivable | Asset (funds held, not an expense) |
Rather than posting directly to the bank, use a temporary asset account. This account represents the amount expected from the marketplace. Common account names include:
Definition
A Marketplace Clearing account is a temporary current-asset account that holds the amount a marketplace owes the seller between the date sales and deductions are recorded and the date the payout reaches the bank.
When the payout reaches the bank, record the receipt against the clearing account rather than as new income:
| Account | Debit | Credit |
|---|---|---|
| Bank | Net payout | — |
| Marketplace Clearing | — | Net payout |
Key Rule
The clearing account should return to zero after each settlement.
Journal Entry Walkthrough
The following walkthrough applies the four-step workflow to a single settlement. Assume:
| Account | Debit | Credit |
|---|---|---|
| Marketplace Clearing | 25,000 | — |
| Sales Revenue | — | 25,000 |
Explanation: Revenue is recognized when the sale occurs. The clearing account represents the amount receivable from Amazon or Shopify.
| Account | Debit | Credit |
|---|---|---|
| Marketplace Fees Expense | 1,000 | — |
| Marketplace Clearing | — | 1,000 |
Explanation: The marketplace has deducted its commission before remitting funds, so the amount receivable is reduced and the cost is recorded as an expense.
| Account | Debit | Credit |
|---|---|---|
| Sales Returns & Allowances | 500 | — |
| Marketplace Clearing | — | 500 |
Explanation: Refunds reduce revenue and should be recorded separately for reporting purposes, so returns remain visible rather than hidden inside sales.
| Account | Debit | Credit |
|---|---|---|
| Bank | 23,500 | — |
| Marketplace Clearing | — | 23,500 |
Explanation: The clearing account is cleared once the actual payout is received.
How the Clearing Account Closes to Zero
Viewed as a T-account, the four entries show why the Marketplace Clearing account is such a reliable control. Every dollar recorded as receivable is either withheld by the marketplace or received in the bank:
The Result on the Profit & Loss Statement
Because each component was recorded separately, the income statement now tells the full story of the settlement, and the final figure still equals the $23,500 that reached the bank. Accurate reporting and accurate cash are achieved together:
| Profit & Loss Line | Amount |
|---|---|
| Sales Revenue | $25,000 |
| Less: Sales Returns & Allowances | ($500) |
| Net Sales | $24,500 |
| Less: Marketplace Fees Expense | ($1,000) |
| Settlement amount after marketplace deductions | $23,500 |
Why Use a Marketplace Clearing Account?
A Control Account Between Sales and Cash
The Marketplace Clearing account serves as a control account. It sits between the sale and the cash, holding the amount the marketplace owes until the payout arrives. Because every settlement should bring it back to zero, its balance becomes an instant health check on the e-commerce books.
Benefits
| Benefit | What It Means in Practice |
|---|---|
| Separates revenue recognition from cash receipts | Sales are recorded when earned; cash is recorded when received |
| Prevents duplicate income | The deposit clears a receivable instead of being booked as a second sale |
| Makes bank reconciliation straightforward | Each deposit has a matching entry already waiting in QuickBooks |
| Identifies outstanding settlements | A balance shows payouts that are still due from the marketplace |
| Detects missing or delayed payouts | Settlements that never arrive remain visible instead of disappearing |
| Provides an audit trail for each settlement | Each payout traces from settlement report to bank deposit |
Accountant’s Best Practice
Each settlement should clear the balance in the Marketplace Clearing account. A remaining balance indicates one of the following:
| A Remaining Balance May Indicate | What to Check |
|---|---|
| Pending payouts | The settlement has closed but funds have not yet been transferred; confirm the expected deposit date |
| Missing entries | A fee, refund, or adjustment on the settlement report has not been posted |
| Posting errors | An amount was entered incorrectly or posted to the wrong account |
| Timing differences | The settlement period and the bank deposit date fall in different months |
Important Note
Never post a plug entry to force the clearing account to zero. A remaining balance is information: trace it back to the settlement report until the cause is identified and corrected.
QuickBooks Workflow and Reconciliation
The QuickBooks Workflow, Step by Step
The same sequence applies to every Amazon or Shopify payout, whether entries are posted manually or through a connected integration:
Reconciliation Example
The settlement report and the bank feed describe the same payout from two directions. The match is made on the net deposit:
Reconciliation Procedure
Key Rule
Do not create a new Sales Receipt. The sales have already been recorded through the Marketplace Clearing account. A Sales Receipt for the payout would record the same income a second time.
Instead, in QuickBooks Online, open the downloaded deposit from the bank transactions For review list and:
Result:
- No duplicate revenue.
- Clearing account becomes zero.
- Bank reconciliation is completed.
Internal Controls, Best Practices & Common Errors
Best Practices
The following controls keep marketplace bookkeeping accurate from one settlement to the next:
- Reconcile every settlement report.
- Review Marketplace Clearing monthly.
- Separate each expense category.
- Retain settlement reports as audit evidence.
- Investigate uncleared balances immediately.
- Compare settlement reports with bank deposits.
Common Errors
Six errors account for most marketplace payout problems in QuickBooks. Each is avoidable with the workflow in this guide.
Why It Is Wrong: Revenue is understated and every fee, refund, and adjustment disappears from the Profit & Loss statement.
Correct Approach: Record gross sales and each deduction through the Marketplace Clearing account, then match the deposit.
Why It Is Wrong: An expense is netted against revenue, so both revenue and selling costs are understated.
Correct Approach: Post fees to a dedicated Marketplace Selling Fees expense account.
Why It Is Wrong: The business cannot see what fees, advertising, or processing actually cost per channel.
Correct Approach: Map each deduction type to its own GL account using the settlement report.
Why It Is Wrong: Recording the payout as a new deposit or Sales Receipt when the sales already exist doubles income.
Correct Approach: Match the downloaded deposit to the existing Marketplace Clearing transaction.
Why It Is Wrong: Returns are hidden, revenue quality is overstated, and the clearing account will not return to zero.
Correct Approach: Record refunds separately to Sales Returns & Allowances.
Why It Is Wrong: Unexplained balances can hide missing payouts, posting errors, or unrecorded deductions, and they grow harder to trace over time.
Correct Approach: Review the clearing account monthly and investigate uncleared balances immediately.
Reference
Frequently Asked Questions
No. The payout is the net amount left after the marketplace deducts fees, refunds, and other charges. Record gross sales as revenue, record each deduction separately, and treat the payout as the settlement of the amount the marketplace owes you by matching it to a Marketplace Clearing account.
It is a temporary current-asset account that holds the amount a marketplace owes you between the date sales and deductions are recorded and the date the payout reaches the bank. Common names include Amazon Clearing, Shopify Clearing, and Marketplace Receivable. It should return to zero after every settlement.
Because the marketplace withholds its fees, processing charges, refunds, and adjustments before paying you. The settlement report bridges the two figures. For example, $20,000 of sales plus $500 of shipping, less $2,100 of deductions, produces an $18,400 deposit.
Record each fee type, such as marketplace selling fees, payment processing fees, and advertising, to its own expense account, with the offsetting credit to the Marketplace Clearing account. Avoid posting fees to Sales or combining them into Miscellaneous Expense.
No. The sales were already recorded through the clearing account. Open the downloaded deposit, select Match, and match it to the Marketplace Clearing transaction. Creating a Sales Receipt would duplicate revenue.
Record refunds to Sales Returns & Allowances, a contra-revenue account, with the credit to the Marketplace Clearing account. Keeping refunds separate from sales makes return rates visible and keeps the clearing account in balance.
A remaining balance usually points to a pending payout, a missing entry, a posting error, or a timing difference between the settlement period and the deposit date. Trace it back to the settlement report; do not post a plug entry to force the balance to zero.
Separate clearing accounts, such as Amazon Clearing and Shopify Clearing, are recommended. Each marketplace settles on its own schedule with its own report, so separate accounts make it easier to match deposits and to see which channel has an outstanding balance.
Reconcile it against every settlement report as payouts arrive, and review the full account balance at least monthly. Any balance that remains after a settlement has been matched should be investigated immediately.
Retain each settlement report as audit evidence, along with the bank statement showing the deposit and the QuickBooks entries that record it. Together they provide a complete trail from customer sale to cash received.
No. Sales tax collected from customers is not revenue. Where a marketplace collects and remits the tax on your behalf, it should not be recorded as sales; where you are responsible for remitting it, it belongs in a sales tax liability account until paid. Confirm the treatment with your tax advisor.
Recording gross sales, recognizing marketplace deductions separately, and treating the payout as the settlement of a receivable follows accrual accounting and supports compliance with generally accepted accounting principles (GAAP) and other accrual-based reporting frameworks.
Summary
Key Takeaways
A marketplace payout is the settlement of a receivable, not new revenue. The bank deposit is not the sale.
Recognize revenue at the gross amount customers paid when the sale occurs, not at the net amount deposited in the bank.
The settlement report is the primary source document; every journal entry should trace back to a line on it.
Record marketplace fees, processing fees, refunds, and other deductions separately, each mapped to its own GL account.
Post sales and deductions through a Marketplace Clearing account that returns to zero after every settlement.
Match the downloaded bank deposit to the clearing account in QuickBooks; never create a new Sales Receipt for the payout.
A remaining clearing balance signals a pending payout, missing entry, posting error, or timing difference; never post a plug entry.
Reconcile every settlement, review the clearing account monthly, and retain settlement reports as audit evidence.
Final Thoughts
Conclusion
From an accountant’s perspective, Amazon and Shopify payouts represent the settlement of receivables rather than new revenue. Recording gross sales, separately recognizing marketplace deductions, and using a Marketplace Clearing account ensures accurate revenue recognition, proper expense classification, seamless bank reconciliation, and reliable financial statements.
This method also provides a clear audit trail and supports compliance with generally accepted accounting principles (GAAP) and other accrual-based reporting frameworks. It turns every payout into a short, repeatable routine: read the settlement report, post each component, match the deposit, and confirm that the clearing account is back to zero.
If your e-commerce books currently record payouts as income, if marketplace fees are buried in miscellaneous expense, or if the clearing account carries balances no one can explain, this is the moment to address it. The longer the errors continue, the more settlements need to be reconstructed.
Resources
Further Reading & Official Resources
Marketplace Resources
QuickBooks Resources
Related MASPARTNER Resources
Need Help Getting Your Books Reconciled?
MASPARTNER helps small businesses streamline bookkeeping, accounting, payroll, tax compliance, and financial reporting. Our team of CPAs and accounting professionals can take reconciliation, and every other bookkeeping function, entirely off your plate.
Book a Free Consultation Today