Hello everyone,
I hope members of the forum can help me. I have been selling on ebay over the last 3 months as a VAT registered Limited company. I am preparing my quarterly VAT return and have uploaded a CSV file to quickfile containing transactions on ebay. (PS: I have subscribed to the feed membership last week, so hopefully things will be automatic in the future.)
I am unsure if this is the right CSV to use, please see below:
| Transaction creation date | Type | Order number | Legacy order ID | Buyer username | Buyer name | Post to city | Post to province/region/state | Post to postcode | Post to country | Net amount | Payout currency | Payout date | Payout ID | Payout method | Payout status | Reason for hold | Item ID | Transaction ID | Item title | Custom label | Quantity | Item subtotal | Postage and packaging | Seller collected tax | eBay collected tax | Seller specified VAT rate | Final value fee – fixed | Final value fee – variable | Regulatory operating fee | Very high ‘item not as described’ fee | Below standard performance fee | International fee | Gross transaction amount | Transaction currency |
|---|
Title of each column of ebay transaction CSV file
Screenshot of one transaction (with confidential details removed)
Please see the scenario below:
Seller list an item (Item 1) on ebay
Insertion Fee for Item 1: -£0.36
Item Listed at £8.05 with Free Delivery
Buyer
Buyer makes purchase and pays £8.05 to ebay
Seller incurs:
Ebay fees (final value fee and regulatory operating fee) for the sale is £1.46
Postage costs (via simple delivery): £3.65 (Royak Mail tracked 48)
File uploaded to Quickfile which is then interpreted as below:
Date Reference Money Out Money In Balance Status
17/02/26 Order – 6.59 2.68
17/02/26 Postage label 3.55 – –
16/02/26 Other Fee 0.36 – -0.36
Other fee (VAT claimable)
Postage label (VAT 0)
Order (VAT payable) but is it the right amount or is VAT payable on the listed price i.e £8.05
Missing:
Ebay final value and regulatory fees (which would be VAT Claimable) from interpreted CSV
Do I pay VAT on listed price i.e £8.05 or “order value” which is £6.59 as per CSV
What would be the best way to present the data to quickfile so that it is correctly and accurately interpreted (as I think a lot of the issues relate to Input data).
I know this is a long post but I have tried to provide as much details as possible.
I would appreciate any inputs which can help out.
Many Thanks
Far