Which Columns in the eBay Transaction Report Matter for Tax?
The columns that matter for tax are Transaction creation date, which tells you which tax year a sale falls in, Total transaction amount, which is your gross income for each sale including buyer-paid postage, Final value fee, which is your deductible expense for that transaction, and Net amount, which is what eBay paid you and which you should not use as your income figure.
When you open the CSV, you will see more columns than you need. Most are for eBay's operational purposes rather than for tax. Here is what each relevant column contains.
Transaction creation date. The date the sale completed. This is what you use to confirm which tax year a transaction falls in. Filter this column to isolate transactions between 6 April and 5 April for your relevant tax year.
Item title. What sold. Useful for cross-referencing with your stock records and for identifying an expense category if you need to trace a specific transaction later.
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 collected under marketplace facilitator rules. These amounts do not form part of your UK trading income.
Final value fee. The fee eBay charged as a percentage of the gross transaction. This is a deductible business expense. It does not include the VAT element eBay adds on top, so for income tax purposes you need to multiply this figure by 1.2 to get the full deductible amount including the irrecoverable VAT. The Final value fee column multiplied by 1.2 is expenses. eBay's transaction report shows fees before VAT. Multiplying by 1.2 adds the 20 percent VAT that eBay charged on top, giving you the full deductible amount
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. Do not use this column for income.
Marcus's rule for the transaction report is simple. The Total transaction amount column is income. The Final value fee column multiplied by 1.2 is expenses. Everything else in the report is either irrelevant or already captured by those two columns.
Why Is the Gross vs Net Distinction So Important?
Bank statements show net amounts. When eBay pays out, it transfers the net figure after fees. If you record the bank figure as your income, your gross income is understated by the total fees charged across the year. HMRC holds the gross figure from eBay. A discrepancy between your declared income and HMRC's platform data increases your risk of a compliance check.
This is the point where most eBay sellers' records diverge from HMRC's data. It is almost always because they looked at the wrong column or used their bank statements instead of the transaction report.
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 understated by £6.99 on that one transaction alone. Across hundreds of transactions a year, this discrepancy accumulates into 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 £2,460 per year, the total fees charged.
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 Is Marcus's Three-Step Process for Using the Report?
Once you have your quarterly transaction report downloaded and filtered to the right date range, the process has three steps. First, sum the Total transaction amount column to get your gross income for the period. Second, sum the Final value fee column and multiply by 1.2 to get your total eBay fee expense including VAT. Third, note any buyer-paid postage already captured in the gross figure so you record your own outgoing postage costs separately as a distinct expense line.
Marcus applies this process every quarter. It takes approximately twenty minutes and produces accurate gross income and fee expense figures that match eBay's DAC7 data exactly.
He enters his quarterly gross income as a single income line in his records, noting the date range and the report it came from, rather than entering each transaction individually. He enters his quarterly fee expense as a single expense line under platform fees.
The postage Marcus actually pays to send items is a separate expense he records from his Royal Mail Click and Drop account or courier receipts. This is a distinct cost from the buyer-paid postage already captured in the Total transaction amount column, and the two should never be conflated.
How Do You Find Gross Sales on eBay for Prior Tax Years?
To find your gross eBay sales for a prior tax year, download the transaction reports for the relevant periods from eBay Seller Hub, which holds up to two years of history. Filter the Transaction creation date column to isolate transactions within the tax year you need and sum the Total transaction amount column. This gives you the gross income figure to declare for that year.
If you are calculating your position for a prior year because you have been selling without declaring, this is the starting point.
If your sales go back further than two years and you cannot retrieve the full transaction history from eBay, HMRC may still hold the data from earlier data-sharing arrangements. 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 and the difference voluntary disclosure makes to the outcome.
How Often Should You Download Your eBay Transaction Report?
Download your eBay transaction report quarterly rather than annually. A quarterly download takes twenty minutes while the transactions are recent and reconcilable. An annual reconstruction in January takes significantly longer and produces less accurate figures because individual transactions are harder to verify months after the fact.
The quarterly download rhythm also means your records stay current throughout the year rather than existing only on paper in January. If your gross income is approaching the £1,000 trading allowance threshold or the Self Assessment registration requirement, a quarterly download gives you visibility of your position before you cross a threshold rather than after.
Whatever frequency you choose, 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. Together these two figures give you an accurate and defensible starting point for your tax calculation.
The gross income trap post covers the specific mistake of measuring income by bank receipts rather than platform gross amounts 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, 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 →
