Understanding the Columns in the Report
When you open the CSV, you will see more columns than you need. Most of them are for eBay's operational purposes rather than for tax. The columns that matter for tax purposes are these.
Transaction creation date. The date the sale completed. This is what you use to confirm which tax year a transaction falls in.
Item title. What sold. Useful for cross-referencing with your stock records and for identifying the expense category if you need to go back and check.
Buyer username. Not needed for tax but useful if you need to trace a specific transaction.
Total transaction amount. This is the gross figure. The full amount the buyer paid, including the item price and any postage they paid. This is the number that goes into your income records and the number HMRC received from eBay. Not the column next to it. Not the payout amount. This one.
eBay collected tax. Any VAT or sales tax eBay collected on the transaction. For UK domestic sales this is generally not relevant unless you are VAT-registered. For international sales it may show amounts eBay collected under marketplace facilitator rules on behalf of foreign tax authorities. These amounts do not form part of your trading income.
Final value fee. The fee eBay charged as a percentage of the gross transaction. This is a deductible business expense.
Net amount. What eBay paid you after deducting its fees. This is what appears in your bank account or eBay wallet. This is not your gross income for tax purposes.
Marcus's rule for the transaction report is simple. The Total transaction amount column is income. The Final value fee column is expenses. Everything else in the report is either irrelevant or already captured by those two columns.
The Gross vs Net Distinction in Practice
This is the point where most eBay sellers' records diverge from HMRC's data, and it is almost always because they looked at the wrong column or used their bank statements instead of the transaction report.
Bank statements show net amounts. When eBay pays out, it transfers the net figure after fees. A Levi's jacket that sold for £45 with £6.99 in total fees produces a bank entry of £38.01. If you record £38.01 as your income, your gross income figure is £38.01 lower than the £45 eBay reported to HMRC. Across hundreds of transactions a year, this discrepancy accumulates to a significant gap between your declared income and HMRC's data.
Marcus sells approximately 800 items per year on eBay at an average of around £20 per item. If he used net payouts rather than gross transaction amounts, his income would be understated by approximately the total fees charged, which runs to roughly £2,460 per year. That is a £2,460 discrepancy between his records and HMRC's.
The fees are still deductible as an expense. The total tax bill would not necessarily be higher if the expenses are claimed correctly. But the gross income figure would not match, which creates an unnecessary discrepancy that is difficult to explain if HMRC asks. Our post on why your bank balance is not your profit covers this distinction in full including how it affects the trading allowance threshold calculation and your final profit figure.
What to Do With the Data Once You Have It
Once Marcus has his quarterly transaction report downloaded and filtered to the right date range, his process has three steps.
First, he sums the Total transaction amount column for the period. This is his gross income for those three months from eBay. He enters this as a single income line in his records rather than entering each transaction individually, noting the date range and the report it came from.
Second, he sums the Final value fee column for the same period. This is his eBay fee expense for those three months. He enters this as a single expense line under platform fees.
Third, he notes any transactions where the buyer paid postage on top of the item price. These are already captured in the Total transaction amount column, which includes buyer-paid postage. The postage Marcus actually pays to send the item is a separate expense he records from his Royal Mail Click and Drop account or courier receipts.
This three-step process takes approximately twenty minutes per quarter. It produces accurate gross income and fee expense figures that match eBay's DAC7 data exactly.
Finding Gross Sales for Prior Years
If you need to find your gross eBay sales for a prior tax year, for example because you have been selling for two years without declaring and want to understand your back-year position, the transaction report is available in eBay Seller Hub for up to two years of history.
Download the reports covering the tax years in question, filter by the relevant dates, and sum the Total transaction amount column for each year. This gives you the gross income figure for each year you need to account for.
If your sales go back further than two years and you cannot retrieve the full transaction history from eBay, HMRC may still have the data from its own platform reporting arrangements or from earlier data-sharing agreements. Our post on what happens if you register for Self Assessment late covers the practical steps for bringing your position up to date, and our penalties guide explains the penalty structure for late registration and the difference voluntary disclosure makes to the outcome.
Recording Your Gross Sales Correctly All Year
The quarterly download rhythm Marcus uses prevents the January reconstruction problem. But any system that gets you to the right gross figure before you file your return is a valid approach. Monthly downloads work well for high-volume sellers. Annual downloads work for lower-volume sellers who are disciplined about doing it in April rather than January.
Whatever the frequency, the principle is the same. Use the Total transaction amount column from the eBay transaction report. Record it as your gross income. Record the fees separately as expenses. The two figures together give you an accurate and defensible starting point for your tax calculation.
The £1,000 trading allowance threshold is based on your gross income, not your net payout. If you have been checking your bank receipts to see whether you are above or below £1,000, you may have been measuring the wrong number. Our post on the gross income trap covers this specific mistake and what it means for your tax position if you have been catching it late.
Once you have your gross income figure and your fee expense figure from the transaction report, the UK Online Seller Tax Template takes both inputs and calculates your complete tax position, compares the trading allowance against actual expenses for your specific numbers, and produces the Self Assessment figures you need.
Get the UK Online Seller Tax Template, £14.99 per year →
