You sold $5,000 on Whatnot, eBay, Etsy, or another marketplace, but only $4,300 reached your bank account. Then QuickBooks pulled in the deposit and asked you to categorize it.
Should you record $4,300 as sales? What happened to the other $700? And how do you know whether your books show what your business actually earned?
Learning how to record marketplace sales in QuickBooks Online starts with understanding that your bank deposit is only one piece of the transaction. The marketplace may have already deducted fees, refunds, advertising charges, shipping adjustments, or other costs before sending your payout.
If you record only the deposit as sales, your revenue and expenses may both be understated.
Why Marketplace Sales and QuickBooks Deposits Don’t Match
Marketplace sales, payouts, and bank deposits represent different parts of the same activity.
Your sales report shows what customers purchased. Meanwhile, your payout report explains what the marketplace added or deducted before transferring your money. Finally, your bank feed shows the amount that reached your account.
For example:
- Gross marketplace sales: $5,000
- Refunds: $200
- Marketplace and processing fees: $500
- Net payout deposited: $4,300
If you categorize the $4,300 bank deposit as sales, QuickBooks won’t show the original $5,000 in revenue or the $500 you paid in marketplace fees.
Although the final net amount appears correct, your reports won’t clearly show how your business performed.
This is the same reason your Whatnot sales and payouts may not match.
What to Gather Before Recording Marketplace Sales
Before entering or reviewing marketplace activity, download the reports that explain your payouts.
Depending on the platform, you may need:
- A monthly sales or seller statement
- A payout or settlement report
- Transaction-level details
- Refund and adjustment reports
- Your business bank statement
For Whatnot, the Seller Statement and Ledger provide information about sales, fees, adjustments, and payouts. Whatnot recommends using its Seller Statements, Ledger, and applicable tax forms as sources for financial reporting.
Download these records regularly. It’s much easier to investigate a difference from last month than one from eleven months ago.
How to Record Marketplace Sales in QuickBooks Online
The exact QuickBooks setup will depend on your sales volume, accounting method, connected apps, and the level of detail you need. However, your bookkeeping should still account for the following pieces.
Record sales as sales
Start with the sales total supported by your marketplace report—not simply the payout deposited into your bank.
ELB records sales as sales so the revenue on the profit and loss statement reflects the business’s marketplace activity.
Be careful not to record the same sale twice. For example, an app may already import sales into QuickBooks while the bank feed separately imports the corresponding payout. Categorizing both as new income would overstate revenue.
Separate marketplace fees
Next, record marketplace commissions, payment-processing fees, advertising charges, and other selling costs in the appropriate expense categories.
Keeping these costs separate helps you see what each platform costs your business. It also makes your financial reports more useful when you compare marketplaces or calculate your real profit as a reseller.
QuickBooks provides general instructions for recording third-party sales and fees, but your marketplace reports should remain the source for the actual amounts.
Account for refunds and adjustments
Refunds shouldn’t automatically be combined with marketplace fees. Neither should shipping adjustments, promotions, failed payouts, or account corrections.
Review each deduction, so your bookkeeping reflects what actually happened. Otherwise, a month with several customer refunds might look like it simply had unusually high marketplace fees.
Match the payout with the bank deposit
Once the sales, fees, refunds, and adjustments have been accounted for, the remaining amount should connect to the marketplace payout deposited into your bank.
Many bookkeeping systems use a marketplace clearing account to help connect the activity shown in the marketplace reports with the money received. However, the best setup depends on how your business operates, so avoid creating new accounts or changing established bookkeeping without understanding the effect on your reports.
The ultimate goal is simple: the payout recorded from the marketplace should match the deposit in your bank.
Don’t Forget Inventory and Cost of Goods Sold
Recording a marketplace payout doesn’t account for what you originally paid for the inventory you sold.
ELB records inventory costs as cost of goods sold and records sales as sales. Those amounts remain separate from marketplace fees, shipping, supplies, and other operating expenses.
For example, if you sold an item for $80 that originally cost $20, your books need both pieces of information. Recording only the sale tells you how much came in, but not what it cost you to make that sale.
Accurate inventory and cost-of-goods-sold records make it easier to review gross profit and understand whether your selling activity is actually profitable.
Should You Enter Every Marketplace Order Individually?
Not every reseller needs thousands of individual orders entered into QuickBooks.
Some businesses use detailed integrations. Others record summarized marketplace activity using settlement or monthly reports. The right method depends on factors such as:
- Monthly transaction volume
- Number of marketplaces
- Inventory system
- Available integrations
- Reporting needs
- Bookkeeping method
More detail isn’t automatically better. If an integration creates duplicate sales or floods QuickBooks with entries you can’t reconcile, it may create more work instead of giving you clearer reports.
Whatever method you use, you should be able to trace the summarized amounts back to the marketplace reports that support them.
Common QuickBooks Mistakes Resellers Make
As you review your bookkeeping, watch for these common problems:
- Categorizing every net deposit as sales
- Recording both imported orders and bank deposits as income
- Combining every deduction into one marketplace-fee category
- Forgetting refunds or payout adjustments
- Mixing inventory costs with marketplace fees
- Leaving marketplace balances unreconciled
- Expecting a 1099-K to equal net payouts or profit
If you receive a marketplace tax form, our guide to Form 1099-K for online sellers explains why its gross amount may not match your deposits.
Keep Your Marketplace Books Useful
Knowing how to record marketplace sales in QuickBooks Online means looking beyond the amount in your bank feed. Your records should show your sales, fees, refunds, adjustments, inventory costs, and final payouts clearly.
That structure gives you a more useful picture of what you sold, what it cost, and what your business kept.
If you’re selling across multiple platforms or your QuickBooks activity no longer matches your marketplace reports, ELB provides monthly bookkeeping services for resellers and e-commerce businesses. You can tell me about your business or schedule a free 15-minute discovery call to discuss what’s happening in your books.
Ever Leslie Bookkeeping provides bookkeeping and financial-organization services. We don’t prepare tax returns or provide tax advice. Please confirm tax treatment and filing decisions with a CPA or qualified tax professional.

Be the first to comment