An Inside Look at the UK Online Seller Tax Template: What It Does and How It Works

The UK Online Seller Tax Template calculates your complete tax position on your selling income automatically. Enter each sale with the amount you received, your platform fees and any buyer-paid delivery, and the template works out your correct gross income, your taxable profit, your tax and National Insurance bill, what to set aside from every payment, and whether the trading allowance or actual expenses produces the lower result for your specific numbers.

Marcus had been running his eBay and Depop reselling business for two years using a spreadsheet he built himself. It tracked what came in and roughly what went out. In January it produced a profit figure. He submitted his return. He paid what it said.

What it had never done was tell him whether the figure was right. Whether his gross income matched what eBay had already reported to HMRC. Whether he had claimed everything he was entitled to. Whether the trading allowance or actual expenses was the right route for his numbers.

He opened the template on a Tuesday morning. By the time he closed it he had answers to all four questions. And a tax bill that was £3,602 lower than his previous return.

What Does the UK Online Seller Tax Template Actually Do?

The template solves three specific problems that generic spreadsheets and basic calculators do not. It records your gross income correctly so your declared income matches what eBay, Etsy and Vinted already reported to HMRC. It compares the trading allowance against your actual expenses automatically and shows which route produces the lower tax bill for your numbers. And it accounts for the interaction between your selling income and any PAYE salary, student loan or payment on account obligation.

Most online sellers use one of three approaches before finding the template. They record bank receipts as income, which understates gross income by the total fees deducted. They guess at the trading allowance decision without running the comparison. Or they ignore the interaction between their day job salary and their trading profit, which understates the tax owed on the selling income.

The template removes all three errors from day one. It works in Google Sheets and Microsoft Excel. No software to install. No monthly subscription. No bank feed to connect.

How Does the Sales and Costs Tab Work?

The Sales and Costs tab records one row per sale. Each row has nine columns: date, item description, platform, personal item flag, amount received, platform fees, buyer-paid delivery, gross sale and delivery cost paid. The gross sale figure is calculated automatically from the other columns. You do not calculate it yourself.

The gross sale formula adds the amount you received plus the platform fees deducted plus any delivery the buyer paid. This is the correct gross income figure for tax purposes and the figure that matches what eBay, Etsy and Depop reported to HMRC under DAC7. If you enter only the amount received, the formula adds the fees back automatically, which is exactly what the gross income trap correction requires.

The Personal Item flag is a Y or N column that changes how the row is treated. Mark a sale Y and it is excluded from your trading income entirely. This matters for sellers who are also clearing genuine personal possessions alongside their trading stock. A jacket you bought three years ago and wore is a personal sale. A jacket you bought specifically to resell is trading stock. The template handles both correctly in the same tab without mixing the two figures.

Marcus enters his eBay sales in this tab. His gross sale on a £45 Levi's jacket with £6.99 in platform fees is automatically calculated as £51.99 not £45. His declared gross income matches what eBay reported. The discrepancy that was quietly building in his old spreadsheet disappears from day one.

How Do the Expenses and Tax Summary Tabs Work?

The Expenses tab records general business costs not tied to a single sale. Mileage at 55p per mile, home storage proportion, packaging materials, phone costs, subscriptions and professional fees all go here with a date, category, description and amount. The category list covers every allowable expense category for online sellers. Marcus enters his quarterly mileage total, his spare room proportion and his packaging costs as single lines rather than transaction by transaction.

The Tax Summary tab is where the template calculates everything. It pulls your gross sales and cost of items from the Sales and Costs tab and your running costs from the Expenses tab. It asks for three inputs from you: your gross PAYE salary if you have one, your student loan plan, and whether this is your first year of Self Assessment which triggers payment on account.

From those inputs it calculates income tax at your correct marginal rate accounting for personal allowance used by any employment income, Class 4 National Insurance, student loan repayment on all five UK plans, and the first payment on account if applicable. It also runs the trading allowance versus actual expenses comparison and shows which route produces the lower taxable profit for your specific numbers.

Marcus enters his PAYE income as zero because he is a full-time seller. He selects no student loan. He confirms it is not his first year. The Tax Summary shows his actual expenses of £14,853 against the trading allowance of £1,000. Actual expenses produces taxable profit of £7,947. The trading allowance would have produced £21,800. The comparison is automatic. The saving is visible immediately.

What Does the Dashboard Show?

The Dashboard shows your year at a glance. Gross sales, net trading profit, total tax and NI bill, the better method confirmed, and the exact percentage to set aside from every payment you receive. It updates every time you add a row to the Sales and Costs tab or an entry to the Expenses tab. You can open it after any sale and see your running tax position for the year.

Marcus opens the Dashboard on the first Saturday of every month. His gross eBay and Depop income year to date, his running profit after expenses, his estimated tax bill and the set-aside percentage. The number that changes his behaviour is the set-aside percentage. The template shows 15 percent. He transfers 15 percent of every payment to a dedicated savings account the same day it arrives. By January the money is already there.

The Dashboard is the answer to the question that caused him the most anxiety in his first two years of full-time selling. Not what did I earn. What do I owe. Those are different numbers and the Dashboard shows the right one all year round.

For a complete picture of the expenses that feed into the Tax Summary, our complete expenses guide for online sellers covers every allowable category including the spare room claim and the 55p mileage rate that Marcus had been missing entirely before using the template. The eBay tax guide covers how gross income is calculated for eBay specifically and how the platform fee deductibility works alongside the template's Sales and Costs tab.

The template costs £14.99 per year. It is updated every April when new tax year rates are confirmed. It works in Google Sheets for free and in Microsoft Excel. For a full-time seller at Marcus's level it produced a corrected tax bill that was £3,602 lower than his previous return in the first year of using it. That is not a saving from clever tax planning. It is the difference between guessing and knowing.

Get the UK Online Seller Tax Template, £14.99 per year →