Next Making Tax Digital quarterly update deadline: Start filing now

Why does my eBay payout differ from my sales?

An eBay payout can combine several orders and include deductions for fees, refunds and postage paid from eBay funds. It can arrive on a different day from the day eBay sent it. Record the underlying activity once and use the payout to check what reached the bank.

Inside the Excel workbook

  • eBay activity for the amounts behind each payout.
  • Payout check to compare those amounts with eBay and your bank.
  • Worked example with fictional figures. Both working tabs start blank.

Worked example of a £180.00 payout

The October sales and November refund all relate to the same payout. Use the activity dates in your records and the bank date for the deposit check.

eBay sent £180.00 on . The bank received the same amount on .

DateActivityEffect on payout
Order A+£150.00
Selling fee, order A−£15.00
Order B+£90.00
Selling fee, order B−£9.00
eBay postage label−£9.00
Partial refund, order A−£30.00
Fee credit, order A+£3.00
Expected payout£180.00

Where do I download my eBay transaction history?

In Seller Hub, open Payments → Reports. Download the Transaction report and Payout report, then have your bank statement to hand.

RecordHow to use it in your books
Transaction reportOn the eBay activity tab, copy Payout ID into the column of the same name. Use Activity date for the transaction date and Order / note for the order ID. A sale and its fee go on separate rows with the same Payout ID.
Payout reportOn Payout check, enter the Payout ID once. Put the date eBay sent the payout in eBay sent and the amount in eBay paid.
Bank statementFind the matching deposit and enter Bank date, Bank reference and Bank received on the same Payout check row.
Monthly Financial StatementReview the monthly summary. Use the Transaction report for individual lines.
Annual Digital Sales ReportCheck eBay’s separate calendar-year reporting figures under Payments → Taxes → Digital Sales Report, when available.

How to match your eBay payout to your bank

  1. Record the activity

    Enter the activity date, payout ID, type and amount. Split sales and fees when eBay shows them on one line. Include postage you charged the buyer in the sale. Deduct only the part of each postage label paid from eBay funds. Record any separately paid part in your main books.

  2. Check what eBay sent

    Enter each payout ID once in Payout check, with the date and amount from the Payout report. The workbook totals the related activity. If the figures differ, check for missing fees, refunds or activity from the previous month.

  3. Match the bank deposit

    Find the deposit using its amount and reference, then enter the bank date and amount. Both differences should be £0.00. Leave the bank details blank until the deposit arrives.

  4. Update your main bookkeeping spreadsheet

    Keep the dated sales, refunds and expenses in your main books, including business costs paid outside eBay. The payout settles money you have already recorded.

When eBay bookkeeping software makes sense

Keep checking payouts and recording sales and costs in your spreadsheet. When you need to send Making Tax Digital for Income Tax quarterly updates, use aligned.tax with your main Excel records.

See how aligned.tax works for sole traders

From your payout to your quarterly update

  • Use the eBay workbook to check payouts. Keep your original digital sales and expense records in your main books, such as the sole trader bookkeeping spreadsheet.
  • Prepare the quarterly update from your main records. If Transactions is available in your account, you can also review your entries and prepare the update there.

If you transfer digital records for Making Tax Digital, use a digital link such as linked spreadsheet cells or a file export and import. HMRC’s digital link guidance

Tax and Making Tax Digital for eBay sellers

Do I have to pay tax on my eBay sales?

Selling your own unwanted belongings is usually outside Income Tax. If you buy or make goods to sell at a profit, you may be trading. HMRC guidance on selling online

The trading allowance is up to £1,000 for the 2026/27 tax year. If your total gross trading income across all your trades is £1,000 or less before expenses, you usually do not need to tell HMRC about it. There are exceptions. Above £1,000, you may be able to claim the allowance in place of deducting your actual expenses. HMRC guidance on the trading allowance

The government has announced an increase to £3,000 from 6 April 2027. Government announcement on the trading allowance increase

If you sell a personal possession for £6,000 or more and make a gain, Capital Gains Tax may apply. Capital Gains Tax on personal possessions

Does eBay report my sales to HMRC?

eBay says it reports UK-resident sellers with at least 30 sales transactions in a calendar year, or at least £1,707 in sales after the deductions specified in its guidance. These are platform reporting thresholds. Your tax position depends on your activity and income. Read the reporting guidance

When do eBay sellers need Making Tax Digital?

For a sole trader, HMRC uses total qualifying income from self-employment and property before expenses to decide when Making Tax Digital for Income Tax starts. Your marketplace payout is only the cash transferred to your bank. See the qualifying income thresholds and start dates or check your own start date.

Can I deduct eBay selling fees?

If you trade on eBay and use actual expenses, you can generally deduct fees you pay for business sales. Record the sales and fees separately in your books. If you claim the trading allowance instead, you cannot deduct actual expenses for the same trade. HMRC guidance on allowable business expenses

HMRC sources checked on

Published by aligned.tax. Codex checked the tax guidance against HMRC’sguidance for online sellersand its Making Tax Digital eligibility rules.

Get the eBay bookkeeping spreadsheet

Start with the worked example, then enter your own activity and payouts.

Download Excel workbook