Free eBay bookkeeping spreadsheet
Already keep your books in a spreadsheet? Use this Excel workbook to record eBay sales, fees and refunds, then match each payout to your bank.
Excel (.xlsx) · UK sellers · No email required
| Activity | Effect on payout |
|---|---|
| Order sales | +£240.00 |
| Fees after credit | −£21.00 |
| Postage label | −£9.00 |
| Refund | −£30.00 |
| Bank deposit | £180.00 |
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 .
| Date | Activity | Effect 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.
| Record | How to use it in your books |
|---|---|
| Transaction report | On 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 report | On Payout check, enter the Payout ID once. Put the date eBay sent the payout in eBay sent and the amount in eBay paid. |
| Bank statement | Find the matching deposit and enter Bank date, Bank reference and Bank received on the same Payout check row. |
| Monthly Financial Statement | Review the monthly summary. Use the Transaction report for individual lines. |
| Annual Digital Sales Report | Check eBay’s separate calendar-year reporting figures under Payments → Taxes → Digital Sales Report, when available. |
How to match your eBay payout to your bank
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.
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.
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.
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 tradersFrom 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