Key takeaways
- A sales or order export supports revenue detail, but it does not necessarily explain the net payout.
- Use payout records to identify bank transfers and transaction detail to explain their components.
- Keep available financial statements as period-level checks, not automatic replacements for transaction exports.
- Route eBay payment activity through a clearing account before matching deposits in QuickBooks Online.
- Save reports with their date basis, filters, and payout references so your bookkeeper can reproduce the reconciliation.
Your bookkeeper asks for the documents behind last month’s eBay deposits. You send the sales CSV, then discover it does not explain why the bank received a different amount. That is where eBay seller reports need to work together: orders explain what sold, payment transactions explain what changed your balance, and payout records explain what eBay sent to your bank.
For sellers using eBay Managed Payments, the useful bookkeeping trail is not simply “sales equal deposits.” It is settlement activity → clearing account → bank match. Once you separate those stages, month-end becomes much easier to follow—and much easier to hand off.
Which eBay seller reports matter for bookkeeping?
Think of your report pack as a set of documents answering different questions. Names, available downloads, and navigation can vary by account, country, and interface version, so focus on the information each report contains rather than expecting one exact menu label.
Sales and order reports: What did customers buy?
Sales or order exports help you identify orders, items, quantities, selling prices, shipping charged to buyers, and other order-level information available in your account.
These are useful for checking revenue detail, investigating a specific order, or connecting accounting totals to operational records. They may also help you separate different product lines.
Their limitation is important: an order record is not necessarily a complete record of payment processing. Fees can appear elsewhere, refunds can happen later, and an order placed near month-end may not contribute to a bank deposit until the following month.
Keep the sales CSV, but do not ask it to do the payout report’s job.
Payment transaction detail: What changed the payment balance?
In Seller Hub’s Payments area, look for downloadable transaction activity or a transaction report. Depending on the export, this can show sales-related payment activity, refunds, fees, adjustments, and references connecting entries to orders or payouts.
This is usually the most useful starting point for rebuilding the accounting behind a payout. You need the components, not just the final transfer amount.
Review the actual columns before importing anything. A report can contain gross amounts, fee amounts, and net amounts on the same row. Adding all three together would double-count the same activity.
Likewise, do not assume every transaction has already been paid out. Check statuses and payout references where available.
Payout records: What did eBay send to the bank?
Payout history and downloadable payout detail identify transfers initiated through eBay Managed Payments. Look for the payout amount, date, status, destination, and reference or identifier available in your account.
This is the record to start with when matching a bank deposit. The transaction report then explains how the payout amount was built.
The payout initiation date and the bank’s posting date can differ. A transfer initiated at the end of one month may appear on the next month’s bank statement. That timing difference is not, by itself, a bookkeeping error.
Financial statements: Does the period make sense overall?
Where available, download the financial statement covering the reporting period. It provides another view of payment activity and balances that can help you check your transaction-level work.
Read the statement’s definitions and date coverage. Do not assume its totals use the same date basis as your sales export or bank statement.
A financial statement is a useful control document, but it may not contain enough detail to investigate an individual fee or rebuild every payout. Save it alongside the underlying exports.
How to download a useful month-end report pack
Begin in Seller Hub and open the relevant Orders, Payments, or reporting area. For payment documents, look for transaction activity, reports, statements, and payout history. Use the available download or report-generation controls.
Before exporting, decide what question you are answering:
- Monthly accounting activity: Which transactions belong in the accounting period under your established bookkeeping method?
- Payout reconstruction: Which transactions or balance movements explain a particular payout?
- Bank reconciliation: Which completed payouts reached the bank during the statement period?
Those questions may require different filters.
For monthly activity, export the full reporting period using the appropriate transaction date basis. For payout reconstruction, use the payout identifier or linked payout detail where available. If you only have a date-range export, include enough surrounding activity to investigate transactions crossing the month boundary.
Save the original CSVs without changing their contents. Make a separate working copy for sorting, formulas, and account mapping. Keep statement PDFs too, where offered.
A helpful filename might be ebay-payment-transactions-2026-09.csv. Add the account identifier if you operate more than one store, and keep a short note of the selected filters and report date basis.
Steps to rebuild an eBay payout and match the bank
- 1
Choose one payout
Start with a completed payout that has a corresponding bank deposit. Record its amount, identifier, initiation date, and bank posting date.
Collect its supporting activity: Open the payout detail and gather the associated transactions where eBay provides those links. Use transaction exports to investigate individual sales, refunds, fees, and adjustments.
Separate the components: Group the activity into accounting categories. Keep sales, customer refunds, selling fees, and other adjustments distinct rather than treating the entire deposit as revenue.
Check the arithmetic: Confirm that the included activity explains the payout. Account for opening available balances, funds still pending or held, and other balance movements when relevant. Do not force unrelated transactions into the payout just to make it balance.
Post through clearing: Record the summarized payment activity against an eBay clearing account in QuickBooks Online, using your agreed account mapping and reporting dates.
Record and match the transfer: Record the payout from clearing to the bank account. When the deposit appears in the bank feed, match it to that existing entry instead of adding another sale.
Review the remainder: Explain the clearing balance after posting. It may represent legitimate unsettled activity, but it should be supported by reports rather than left as an unexplained difference.
For a new process, complete this exercise for one payout before attempting a whole month. It is easier to catch a misunderstood fee column or duplicated refund in a small, traceable example.
Example: A summarized payout journal
The following numbers are illustrative examples, not a description of every eBay payout.
Assume a payout’s supporting detail shows:
| Component | Example amount |
|---|---|
| Sales proceeds before the listed fee and refund lines | $1,200 |
| Customer refunds | ($100) |
| Selling and payment fees | ($150) |
| Net payout | $950 |
For simplicity, the example assumes all listed activity belongs to one payout, there are no opening balances or holds, and there are no other adjustments. The sales amount excludes marketplace-collected tax; any shipping charged to buyers is already included rather than added again.
Your actual account mapping may need more categories. Use the report’s definitions and your bookkeeper’s established treatment.
First, summarize the underlying activity into clearing:
Example journal: summarized payment activity
| Account | Debit | Credit |
|---|---|---|
| eBay Clearing | 950.00 | |
| Sales Returns and Allowances | 100.00 | |
| eBay Selling and Payment Fees | 150.00 | |
| Sales Revenue | 1200.00 | |
| Total | 1200.00 | 1200.00 |
| Total | 2,400.00 | 2,400.00 |
This records $1,200 of revenue, $100 of returns, and $150 of fees. The remaining $950 sits in clearing until the payout is recorded.
Next, record the transfer:
Example journal: payout received in the bank
| Account | Debit | Credit |
|---|---|---|
| Business Checking | 950.00 | |
| eBay Clearing | 950.00 | |
| Total | 950.00 | 950.00 |
| Total | 1,900.00 | 1,900.00 |
The bank deposit now has a matching accounting entry, and this example’s clearing balance returns to zero.
Do not post these entries on top of sales, refunds, or fees that another integration has already recorded. Decide which system owns each entry first. Otherwise, a well-intended reconciliation can duplicate revenue or expenses.
The same clearing-account logic applies across marketplaces. Our guide to reconciling Amazon settlements in QuickBooks explains the broader settlement-to-bank workflow, although eBay’s report labels and payment details differ.
Why the reports may not agree immediately
A difference between reports is a reason to investigate, not proof that something is missing.
Different dates describe different events
An order date, payment transaction date, payout date, and bank posting date can all be different. Compare reports on a consistent basis before concluding that totals are wrong.
For example, a late-month payout received early the next month belongs in the reconciliation bridge between the two periods. It should not be reclassified as a new sale simply because that is when the bank received it.
Refunds and fees do not always follow the original sale
A refund may reduce a later payout than the one containing the original sale. Related fee adjustments may also appear separately.
Follow the transaction references rather than assuming each month’s refunds relate only to that month’s orders. Keep the refund and any fee credit visible as separate components.
Pending funds, holds, and adjustments affect availability
Not every payment balance is immediately available for payout. Review the balances and statuses shown in your account, and retain supporting information for held or pending amounts.
Some charges or adjustments may also be collected outside the payout you are reviewing. If a separate bank or card charge appears, trace its supporting record rather than automatically subtracting it from a payout again.
Report columns can overlap
An export may show both an order’s gross amount and its net proceeds. It may also display tax collected and remitted by the marketplace.
Do not treat every positive column as seller revenue or every displayed amount as cash owed to you. Document how each field is used in the reconciliation. This guide explains the bookkeeping trail, not how to determine tax obligations.
Your month-end handoff checklist
Give your bookkeeper a small, organized folder rather than one unexplained spreadsheet.
Include:
- Sales or order export: The period’s order-level support, with the selected date basis noted.
- Payment transaction export: The activity needed to identify sales, refunds, fees, and adjustments.
- Payout records: Amounts, identifiers, statuses, and dates supporting transfers to the bank.
- Available financial statements: Period-level documents for checking totals and balances.
- Bank statement: The statement covering the deposits, including relevant transfers crossing month-end.
- Reconciliation worksheet: A schedule showing each payout, its supporting total, its bank match, and any remaining difference.
- Exception notes: Explanations and references for holds, disputes, unusual charges, or unresolved items.
- Posting summary: Which entries have already been imported or recorded, and by which system.
Also include the prior month’s closing clearing balance. Without that starting point, your bookkeeper may be unable to distinguish an old unsettled amount from a new discrepancy.
If you sell in multiple currencies, keep the currency visible throughout the handoff. Reconcile each currency’s activity before combining amounts, and identify any conversion-related entries separately.
A useful final question is: Could someone trace this bank deposit back to its payout and supporting transactions without asking me to log in? If the answer is yes, your report pack is doing its job.
Make the next month easier
Once you have a reliable report pack, repeat the same export routine each month. Consistent filenames, saved filters, and a documented account map reduce the amount of detective work required later.
ClearPayout is designed to reconcile Amazon, Walmart, and eBay sales into QuickBooks Online. If manually rebuilding payout summaries is becoming a recurring chore, you can review ClearPayout’s pricing and consider whether an automated workflow fits your bookkeeping process.
Whether you use software or spreadsheets, keep the same foundation: explain the settlement activity, move the net amount through clearing, and match the payout to the bank. The sales CSV remains useful—but now it has the supporting documents needed to tell the whole story.
Treat the payout summary the way Amazon sellers treat a settlement: summarize, journal, match. For the Amazon parallel, read reconcile Amazon settlements in QuickBooks and review the Amazon QuickBooks integration. Plan options are on pricing.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.