Key takeaways
- Reconcile each Managed Payments payout by its payout reference, covered activity, and net amount.
- Treat the bank deposit as a transfer from eBay clearing, not as a new sale.
- Keep gross sales separate from transaction fees, refunds, reserves, holds, and other report lines.
- A funds-on-hold balance may explain why activity and cash arrive in different payouts.
- Use illustrative journal entries to test the flow, then apply your own account mappings consistently.
Bank shows an eBay Managed Payments deposit, but QuickBooks sales and fees were entered from order exports, so the deposit never matches and eBay clearing never clears to zero. If you are searching for how to reconcile ebay payouts, start with the payout report rather than the bank feed. The bank shows only the net amount that arrived. Managed Payments contains the detail needed to explain that amount.
The reliable sequence is eBay transaction and payout report → eBay clearing → bank deposit. Gross sales, refunds, fees, holds, and other supported adjustments remain visible in the settlement entry. The net amount then moves from clearing to checking and matches the bank transaction. This prevents a payout from being recorded as a second sales entry.
How to reconcile ebay payouts: understand the clearing flow
An eBay Managed Payments payout is the cash movement that follows marketplace activity. The payout can include proceeds from multiple orders and may be reduced by fees, refunds, shipping-related adjustments, disputes, holds, or other lines shown in the report. The exact labels and available fields can change, so use the current eBay report as the source of detail.
QuickBooks needs a bridge account because the order date, transaction date, payout date, and bank date do not always represent the same event. An eBay clearing account holds the amount generated by the marketplace activity until the related cash reaches the bank. A completed payout should normally leave the matching portion of clearing at zero, while a remaining balance should have a clear explanation.
This approach also keeps the bank feed simple. When the deposit downloads, match it to the transfer from eBay clearing. Do not categorize the deposit directly to sales if sales were already recorded from the transaction report or an order import. Otherwise, one sale can appear once in the order data and again through the bank deposit.
Start with the eBay transaction and payout reports
Before changing an entry, identify the payout reference, payout date, currency, marketplace, and net amount. Then obtain the report that supports the payout. A transaction report can explain order-level sales, refunds, fees, and adjustments, while a payout report explains the cash amount released to the bank. They answer related but different questions.
For a broader view of the source data, see the eBay transaction report guide. If you need to review the cash movement itself, the eBay payouts guide can sit alongside this clearing workflow.
Make a working schedule with report descriptions, references, amounts, and QuickBooks mappings. Preserve original references when grouping lines so you can investigate later differences.
Separate gross sales, fees, holds, and releases
Gross sales represent the order proceeds before marketplace reductions. Fees are separate report lines that reduce the amount available for payout. Refunds and dispute-related activity can reverse or reduce proceeds. A hold or reserve can keep funds from being released in the same payout even though the underlying activity is present in the report.
Do not use the bank deposit as a substitute for this detail. For example, this illustrative example shows why a payout can be smaller than the sales total:
| Managed Payments component | Amount | Effect on eBay clearing |
|---|---|---|
| Gross order proceeds | $4,800.00 | Increase |
| Transaction and payment fees | $480.00 | Reduce |
| Customer refunds | $120.00 | Reduce |
| Funds held for later release | $300.00 | Reduce available payout |
| Net payout to bank | $3,900.00 | Transfer to checking |
The figures above are illustrative, not a current fee schedule. The important relationship is that $4,800.00 less the listed reductions produces the $3,900.00 payout. A real report may contain additional lines, including fee reversals, shipping adjustments, disputes, prior-period corrections, or releases from an earlier hold.
A hold deserves special attention. If the report shows activity that has not reached the bank, leave that amount connected to the relevant eBay clearing or funds-held mapping. When the release appears in a later payout, match the release to the later report. The eBay funds on hold guide provides a focused companion for that situation.
Illustrative journal example: record Managed Payments activity
The following is an illustrative example of recording the report detail before the bank deposit arrives. The debits and credits balance at $4,800.00. Account names can vary by chart of accounts.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| eBay clearing | 3900.00 | |
| Transaction and payment fee expense | 480.00 | |
| Sales refunds and allowances | 120.00 | |
| Funds held by eBay | 300.00 | |
| Gross eBay sales | 4800.00 | |
| Total | 4,800.00 | 4,800.00 |
This entry keeps the components visible while showing that only $3,900.00 is ready for the bank. The held amount is not silently removed from the reconciliation; it has its own identifiable line. If your workflow uses one clearing account for all eBay activity, map the held amount consistently and document how later releases are posted.
When the deposit arrives, record the transfer separately:
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Business checking | 3900.00 | |
| eBay clearing | 3900.00 | |
| Total | 3,900.00 | 3,900.00 |
The second entry does not create sales. It moves the previously recorded amount from eBay clearing to checking. Match the downloaded bank transaction to this transfer and retain the payout reference in the memo or reconciliation record.
Steps to reconcile an eBay Managed Payments payout
- 1
Identify the bank deposit
Locate the deposit amount, date, currency, and bank reference. Identify the related eBay payout before assigning an account.
Find the payout report: Search eBay for the corresponding payout reference and confirm the net amount. Compare the report date and release status with the bank information.
Pull transaction detail: Export the transaction activity covering the payout. Include sales, refunds, fees, disputes, holds, releases, and other adjustments that contribute to the payout total.
Build the payout bridge: Sum the report lines by category and compare the result with the net payout. Preserve negative lines and reversals instead of omitting them because they complicate the total.
Review existing QuickBooks entries: Search for order imports, manual journals, prior payout entries, and bank-feed categorizations. Remove or correct duplicates through your normal review process before adding another entry.
Post the activity to clearing: Record gross sales and each supported reduction or held amount using the eBay mappings in your chart of accounts. Confirm that the journal balances and that the release amount agrees with the report.
Match the bank transaction: Transfer the net payout from eBay clearing to checking, then match the bank-feed deposit to that transfer. The deposit should not be posted to sales a second time.
Clear and explain the balance: Review the remaining eBay clearing balance by payout reference. A zero balance may be appropriate for a completed payout, while an open hold, timing difference, or missing report line needs a note and follow-up.
Troubleshoot an eBay clearing balance
If clearing is higher than expected, look for a payout report line that was omitted from QuickBooks or a bank deposit that was categorized directly to an income account. Also check whether the payout contains activity from an earlier period. A report filtered by order date may not align with a payout filtered by release date.
If clearing is lower than expected, look for duplicate sales imports, a fee posted twice, or a bank deposit matched to the wrong payout. Compare payout references rather than relying only on equal dollar amounts; nearby payouts can have similar values.
A hold or reserve can create a valid open balance. Confirm whether eBay shows the amount as released, pending, or carried forward. When a later report releases the funds, connect that release to the original held activity. Do not force the original payout to equal the eventual cash total.
Refunds and reversals also deserve a line-by-line review. A refund may reduce proceeds in one report, while a related fee reversal or correction appears separately. Preserve the source references and explain the net effect in your reconciliation notes.
Use a repeatable eBay-to-QuickBooks workflow
Save the reports and reconciliation schedule so another reviewer can follow each payout from order activity through clearing to the bank.
The eBay QuickBooks integration can help make marketplace imports more repeatable. If you are comparing settlement workflows across channels, the Amazon settlement reconciliation guide shows the same clearing principle in another marketplace context. You can also review ClearPayout pricing if a more structured process fits your bookkeeping routine.
:::cta Want a cleaner way to connect eBay Managed Payments activity with QuickBooks? Explore the ClearPayout eBay integration and see whether a report-to-clearing workflow fits your process. :::
The goal is not to make the bank deposit equal gross sales. The goal is to make every deposit explainable: sales remain visible, fees and holds remain identifiable, and eBay clearing connects the Managed Payments report to the cash that reached the bank.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.