Key takeaways
- The eBay bank deposit is a net payout, not a replacement for the underlying sales activity.
- Use transaction and payout reports to identify gross sales, refunds, final value fees, payment-related charges, holds, releases, and other adjustments.
- Post the activity to an eBay clearing account, then record the payout as a transfer from clearing to checking.
- Illustrative journal entries should balance exactly, but account names and mappings should follow your established bookkeeping policy.
- A remaining clearing balance needs an explanation, such as timing, a hold, an omitted line, or duplicate activity.
If you are learning how to record ebay sales in quickbooks, start with the eBay activity rather than the amount that arrived in the bank. eBay Managed Payments deposits are commonly net of fees, refunds, holds, and other adjustments. Recording only the payout total makes the bank appear correct while leaving the sales detail and marketplace charges unexplained.
The reliable manual workflow is eBay transaction and payout reports → eBay clearing → bank deposit match. Gross sales remain visible, refunds and fee expenses are posted separately, and the clearing account connects the detailed activity to the amount eBay actually sends.
Why the bank deposit alone is not enough
A payout deposited into checking is the final result of several eBay events. The marketplace may collect money from buyers, withhold fees, issue or process refunds, retain funds temporarily, and release a hold in a later payout. The bank sees one net amount. Your books need enough detail to explain how that amount was formed.
For example, this illustrative example shows a payout built from several lines:
| eBay activity | Amount | Effect on payout |
|---|---|---|
| Gross order sales | $4,800.00 | Increase |
| Customer refunds | $240.00 | Reduce |
| Final value fee expense | $576.00 | Reduce |
| Payment processing and other fee expense | $144.00 | Reduce |
| Reserve held by eBay | $300.00 | Reduce current payout |
| Net payout to bank | $3,540.00 | Deposit |
In this example, recording only the $3,540.00 deposit as sales hides refunds and fees. Recording it as income after posting the orders counts income twice. Recording only gross sales leaves the $1,260.00 difference unexplained.
The goal is not to force the gross sales figure to equal the bank deposit. The goal is to post each supported component and let the clearing account carry the net amount due from eBay.
How to record ebay sales in quickbooks with eBay clearing
Create or use an eBay clearing account in QuickBooks Online. It represents funds collected or held by eBay that have not yet arrived in your bank account. The account is a bridge, not a place to permanently hide unexplained differences.
Start with the report period and payout reference. Depending on the report, you may see order sales, refunds, fee lines, shipping or other adjustments, holds, releases, and transfers. Preserve the original descriptions and reference numbers while preparing the entry. A report can include activity that does not share the same date as the bank deposit, so avoid using the bank date as the only filter.
Map gross sales to the appropriate sales account. Map customer refunds to a returns or contra-sales account according to your existing structure. Map final value fees and other marketplace charges to consistent expense accounts. If eBay holds part of the proceeds, represent that movement separately when the report supports it. A hold is different from a fee: it changes when cash is available, while a fee changes the amount ultimately retained by the marketplace.
Report labels vary. Compare transaction detail with the payout summary. For background, see the eBay transaction report guide and the eBay payouts guide.
Gross sales, refunds, fees, and holds
Gross sales are the starting point for the settlement calculation. They show the order proceeds before marketplace charges and before the buyer-related reductions represented in the report. Keeping them visible makes sales activity easier to compare with order records.
Refunds reduce the proceeds associated with customer returns or other buyer adjustments. They should not be silently combined with marketplace fees. A refund may also be accompanied by a fee reversal or another adjustment, so review related lines instead of assuming every negative amount has the same meaning.
Final value fees are charges associated with qualifying eBay activity. The rate, description, and applicable programs can change, so do not build a process around a remembered fee schedule. Use the amount and label in the report, then map it consistently to an expense account. Other charges may need separate accounts if your reporting policy requires that detail.
Holds and releases need special attention. A hold reduces the current payout but may not be an expense. A later release increases a future payout. If the hold is posted as though it were a fee, expenses can be overstated and the future release may look like unexplained income. Keep the timing and reference visible in the reconciliation notes.
Illustrative journal example: post an eBay payout
This is an illustrative example only. It uses the amounts above and shows the detailed activity entering the clearing account. Debits and credits each total $4,800.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| eBay clearing | 3540.00 | |
| Sales returns and allowances | 240.00 | |
| Final value fee expense | 576.00 | |
| Payment processing and other fee expense | 144.00 | |
| Funds held by eBay | 300.00 | |
| Product sales | 4800.00 | |
| Total | 4,800.00 | 4,800.00 |
These account names are illustrative. Gross sales are credited, refunds and expenses are separate, and clearing holds the net payout. Here, the separate asset account tracks the hold. Use your actual report lines rather than copying the example.
When the $3,540.00 payout reaches checking, record the transfer:
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Business checking | 3540.00 | |
| eBay clearing | 3540.00 | |
| Total | 3,540.00 | 3,540.00 |
Match the bank-feed transaction to this transfer. Do not categorize the same deposit as new sales or miscellaneous income. The detailed activity was already recorded in the first entry.
Steps to record eBay sales in QuickBooks Online
- 1
Identify the payout
Note the eBay payout reference, covered period, currency, amount, and bank deposit date. Confirm that the deposit belongs to this payout and not a nearby transfer.
Download the reports: Obtain the eBay transaction report and payout details for the same activity. Keep the source files unchanged, including descriptions, identifiers, and negative lines.
Build the activity summary: List gross sales, refunds, final value fees, other charges, holds, releases, and any additional adjustments. Group only lines that have the same accounting meaning.
Check timing: Compare transaction dates, payout dates, and bank dates. A hold, release, refund, or correction may appear in a different payout than the original order.
Review existing entries: Search QuickBooks for imported orders, prior manual journals, fee entries, and deposits. Remove or correct duplicates before posting a new complete entry.
Post to eBay clearing: Record gross sales and the supported reductions in one balanced journal or controlled import. Confirm that the resulting clearing amount agrees with the payout report.
Record the bank transfer: Enter the net payout as a transfer from eBay clearing to business checking, then match the downloaded bank transaction to that transfer.
Document the result: Save the report reference, date range, entry number, and any open item. A note makes the next review faster and prevents a later duplicate entry.
For a more repeatable workflow, review the eBay QuickBooks integration. If you also reconcile other marketplaces, the Amazon settlement reconciliation guide shows the same clearing-account principle in a different report environment.
Troubleshooting an eBay clearing balance
A positive or negative clearing balance is a prompt to investigate, not an automatic reason to create a plug entry. First compare the payout reference and report scope. A monthly transaction export may not align with one payout, and a bank deposit may be combined with another transfer.
Next, look for holds and releases. A held amount can remain outstanding while the rest of the payout clears. When eBay releases it, the later report may carry the activity forward. Tie both lines to their references so the balance has a documented explanation.
Then search for refunds and fee reversals. A refund can be posted after the original order, and an associated charge or reversal may be reported separately. Compare transaction IDs and descriptions before changing the account mapping.
Duplicate activity is another common cause. If an integration imported order lines and a manual journal also captured the same payout, the clearing account may show an amount that cannot clear. Identify the duplicate source, correct it in a controlled way, and keep the audit note.
For small differences, check rounding, currency, and report filters rather than hiding the balance. The eBay accounting guide can provide additional context for organizing marketplace activity.
Keep the eBay-to-bank trail clear
A clean process has three visible stages: eBay activity is posted in detail, the net payout moves through eBay clearing, and the bank deposit is matched to that transfer. This makes gross sales, refunds, fees, and holds easier to review without treating a net deposit as the whole story.
If you want to reduce manual report preparation, explore ClearPayout's eBay integration and compare the workflow with your current process. You can also review ClearPayout pricing when deciding whether a more repeatable reconciliation process is useful for your team.
Aim for an explainable deposit, no unexplained clearing balance, and visible eBay activity in QuickBooks Online.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.