Key takeaways
- A payout moves money already represented by marketplace activity; it is not another sale.
- Tie each payout reference to its transaction detail before comparing it with checking.
- Review existing sales and fee entries so only missing activity is posted.
- Use clearing to separate marketplace activity from the later bank transfer.
- Explain the remaining clearing balance with unpaid activity, holds, or transfers in transit.
Managed Payments deposits reach checking, but order exports have already recorded sales and fees in QuickBooks Online. Now ebay managed payments reconciliation seems stuck: the bank amount is real, yet posting it as income would count sales twice, and leaving it unmatched gives you no connection to the payout report.
The missing connection is an eBay clearing account. Use payout and transaction detail → eBay clearing → bank match to explain the money without recreating activity already in the books. Start with what was imported, not with another sales journal.
What ebay managed payments reconciliation needs to prove
A complete reconciliation answers three questions. Does the report explain the payout? Does QuickBooks contain the underlying activity exactly once? Does the bank deposit match the movement out of clearing?
These are separate checks. A matching bank amount does not prove sales and fees were posted correctly. Likewise, accurate order imports do not prove the payout reached the right bank account. Keep the payout reference alongside the transaction references so you can trace both directions.
This guide focuses on that connection rather than classifying every seller charge. Use the eBay transaction report guide for supporting export detail. The goal here is a documented route from existing entries to clearing and then checking.
Establish report scope before posting
Collect the payout record and supporting transaction export from your seller account. Save the original files with the payout reference, currency, destination account, reported amount, and relevant dates. Report labels and available fields can change, so identify fields by their purpose rather than expecting one fixed layout.
Do not assume a calendar-month order export represents one payout. Order activity, funds availability, payout initiation, and bank posting can fall in different periods. Where references are available, use them to select the transactions assigned to the payout. Document any allocation that requires additional evidence.
If the export repeats order totals across multiple detail rows, separate summary values from posting lines before adding amounts. A repeated order value is not necessarily another sale. Likewise, a net transaction amount may already include a fee; adding both without checking their meaning can count the fee twice.
Inspect the entries already in QuickBooks
Run the eBay clearing account detail and inspect representative imported orders, refunds, and fees. Check the accounts, amounts, dates, and source references. An import can look complete on the profit and loss report while sending its other side to checking or another holding account.
If sales and fees already affect eBay clearing correctly, retain them. The payout process should verify their contribution and post only missing adjustments and the bank transfer. Do not import a second complete sales summary merely because it matches the payout report.
If order imports use accounts receivable, inspect whether a payment entry already moves the receivable into clearing. If they use checking directly, resolve that mapping before posting another bank movement. Corrections depend on the original transaction type and reconciliation status; agree the method with your bookkeeper rather than layering a journal over an unexplained balance.
Illustrative example: connect existing activity to a payout
All amounts in this example are illustrative, not a fee schedule. Assume the opening eBay clearing balance is zero. The payout's supporting activity shows gross sales of $4,800.00, customer refunds of $200.00, and seller charges of $600.00. That leaves $4,000.00 available for this payout, with no holds or other adjustments in this simplified example.
The following journal summarizes the effect of the entries already imported. It is a reconciliation reference, not an instruction to post the same activity again. Debits and credits both equal $4,800.00.
| Account | Debit | Credit | Memo |
|---|---|---|---|
| eBay clearing | 4000.00 | Existing net marketplace activity | |
| Sales returns and allowances | 200.00 | Existing customer refunds | |
| Marketplace fee expense | 600.00 | Existing seller charges | |
| Product sales | 4800.00 | Existing gross sales | |
| Total | 4,800.00 | 4,800.00 |
Actual imports may use separate entries for sales, refunds, and charges. Their combined effect should agree with the supported activity, even if no single journal resembles this summary. Preserve their original references in the reconciliation worksheet.
When the bank receives the payout, the separate movement is:
| Account | Debit | Credit | Memo |
|---|---|---|---|
| Business checking | 4000.00 | Payout received in bank | |
| eBay clearing | 4000.00 | Release the matched payout | |
| Total | 4,000.00 | 4,000.00 |
This second illustrative entry balances at $4,000.00. Record the movement once using the appropriate QuickBooks transaction for your clearing account setup, then match the downloaded deposit to it. Do not create both a transfer and a journal for the same payout. With no other activity, clearing now returns to zero.
Steps for reconciling Managed Payments in QBO
- 1
Identify the payout
Record its reference, currency, amount, destination bank account, and reported date. Find the corresponding bank deposit, allowing for a different bank posting date without assuming a fixed arrival schedule.
Gather its supporting activity: Select the transaction detail connected to that payout. Separate sales, refunds, charges, reversals, and balance movements. Keep source references so each component remains traceable.
Build the report bridge: Show how the supported activity produces the payout. If opening balances or funds on hold affect the result, show those separately rather than forcing current orders to equal the deposit.
Compare with existing entries: Match the supporting activity to QuickBooks imports by reference and amount. Mark each line as already recorded, missing, or requiring review. A spreadsheet with those statuses helps prevent duplicate posting.
Resolve missing or misplaced activity: Post only supported missing lines through clearing. Investigate incorrect mappings and overlapping imports before making corrections. Keep the original and correction references together.
Record and match the payout: Move the supported payout amount from eBay clearing to checking once. Match the bank-feed deposit to that entry instead of categorizing it as new income.
Reconcile the remaining balance: Compare clearing with unpaid activity, held funds, and payouts still in transit at the cutoff. Save the report bridge, account detail, and bank evidence together.
For the surrounding payout workflow, see how to reconcile eBay payouts. The Amazon settlement reconciliation guide also explains the clearing-to-bank approach, though marketplace reports and transaction types differ.
Troubleshooting differences without a balancing plug
The bank deposit was added as income
Search checking for both the imported payout movement and a bank-feed transaction categorized to sales. If both exist, the bank balance or revenue may be overstated. Review the duplicate with your bookkeeper and retain the valid entry. If the period is reconciled, assess that impact before changing historical transactions.
Clearing still shows the full payout
Check whether the bank match connected to a transaction that actually credits eBay clearing. A deposit categorized to income can satisfy a superficial bank review while leaving the marketplace receivable untouched. Also confirm that the payout movement did not use a second, similarly named clearing account.
The report and clearing differ by a refund or charge
Compare transaction identifiers and signs, not just totals. A refund may already exist in the order import while its related charge adjustment appears separately. Check whether the export shows gross and net columns describing the same activity. Post an adjustment only after identifying what is missing or misclassified.
Clearing has a supported month-end balance
A nonzero balance can be valid. Start with opening clearing, add recorded marketplace activity, and subtract recorded payouts. The result should agree with identifiable remaining funds and transfers in transit. Do not assume every month closes at zero or clear a difference to miscellaneous expense just to finish.
Maintain a short schedule listing each remaining component, source reference, amount, status, and next review action. Later payout evidence can support an amount in transit; unexplained older items need investigation rather than repeated carryforward without comment.
Keep the report-to-bank trail repeatable
A useful close package contains the payout record, supporting transaction export, existing-entry comparison, clearing rollforward, and bank match. That gives the next reviewer evidence rather than just a matching total.
If you want help organizing marketplace activity for QuickBooks, review the ClearPayout eBay integration and compare the workflow with your current imports. You can also review pricing when evaluating the fit. Keep the objective unchanged: record each sale and fee once, explain clearing, and match each payout without creating new revenue.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.