1. We would like to know you better hence we made the introductions more interesting. Would love to see you answer the questions here!
  2. Hi Guest, tell us what change you'd like to see in the forums Click Here

eBay Accounting for Newbies - an example spreadsheet for you to download

Discussion in 'Money, Accounts & Finance' started by ladyvgw, Nov 24, 2010.

  1. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
    Hi all,

    As an accountant I have been meaning to do this for sometime :)

    There are lots of threads running on how you should record your Ebay transactions but I thought I would knock up a very simple Excel sheet that gives you an idea of how I do it. You will, obviously, need to tailor this to your own needs but hopefully it will give you an idea of how to start. It should be viewed as a guide and not taken as gospel.

    I have filled in some columns with dummy info just to give you an idea of how it works, simply replace with your own details.

    For every sale I make I print an Ebay invoice for myself and print a copy of the paypal transaction and staple these together. I then write the postage cost on top of the sheet when I post it. This makes it easier in case you ever get an inspection from HMRC as in my experience they like to have a paper trail to follow.

    Income – Using my system I would record each transaction in date order. I record the total sale including postage charged an on the spreadsheet I record my ebay invoice number and paypal reference so that I can cross reference to the hard copy if necessary. I then record the paypal fees on this transaction and the postage cost on to the income sheet. This may seem a bit peculiar but as all this information is now on one page in front of me it saves me switching between 2 pages in Excel to record them separately.

    Expenditure – The idea of this spreadsheet is to record every expense along with as much detail as you feel is necessary and to record each expense category in its own column so that at the end of the year you can easily see the total amount for each category to record on your tax return.

    Depending on how many transactions you have per month you may need to have a separate sheet for each month rather than one HUGE list covering the whole year!

    Please feel free to download the spreadsheet for your own use.

    Vicky :)

    Attached Files:

  2. UKbuyer1

    UKbuyer1

    Joined:
    Oct 30, 2009
    Messages:
    8,314
    Wow.

    This is sure to help some if the newer ebayers. And some if the older ones.

    Thanks vicky.
  3. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
    No probs, happy to help as always :)
  4. saigondropshipping

    saigondropshipping

    Joined:
    Jun 16, 2010
    Messages:
    310
    Thanks a great help.
  5. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
  6. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
    If anyone has any questions or problems with accounting please let me know and I will do my best to help :)
  7. tierno

    tierno

    Joined:
    Nov 26, 2010
    Messages:
    9
    Im just starting out on ebay and was having a lot of problem recording.
    Thanks for that, it will really help :)
  8. kiprogers

    kiprogers

    Joined:
    Aug 28, 2010
    Messages:
    40
    Thanks for that vicky!
  9. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
  10. Pipehype

    Pipehype

    Joined:
    Jan 5, 2009
    Messages:
    1,096
    Fair play to ya! Another great post.

    Seán
  11. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
  12. energyking

    energyking

    Joined:
    Nov 5, 2010
    Messages:
    712
    Thanks, thats very handy!
  13. Blue Swoop

    Blue Swoop

    Joined:
    Jul 18, 2010
    Messages:
    403
    Great post again Vicky :)

    I just edited it for my needs if I was going to use it; it now automatically calculates the the PayPal fees from the Gross Value, it also has drop down selection for the payment method and also shows me the profit I've made with some conditional formatting so it's green or red depending on profit/loss.

    Here's the download if anyone wants it:
  14. ladyvgw

    ladyvgw

    Joined:
    Aug 14, 2010
    Messages:
    4,953
    Nice one.

    I made it as simple as possible to begin with for this very purpose :)
  15. kiprogers

    kiprogers

    Joined:
    Aug 28, 2010
    Messages:
    40

    cheers blue!
    all i need to do now is get my copy of excel unlocked:thumbdown:
  16. Matilda28

    Matilda28

    Joined:
    Jan 3, 2011
    Messages:
    84
    Hi Blue Swoop

    This is probably a stupid question but hey ho!
    When you get the profit total on your version I presume it has also taken off the postage costs and Ebay listing fees is that right?
  17. buzzmartdotcom

    buzzmartdotcom Banned Member

    Joined:
    Jan 12, 2011
    Messages:
    9
    its an excellent little spreadsheet, but like me I prefer to turn a blind eye to ebay and PayPal fees, it hurts to see how my profits go down
  18. SoSupplies

    SoSupplies

    Joined:
    Jan 8, 2011
    Messages:
    47
    Hi there,

    I dont no if iam being stupid but why are paypal fees and postage columns on the income spread sheet??

    Please help

    :rolleyes:
  19. Aquila

    Aquila

    Joined:
    Jan 8, 2011
    Messages:
    28
    Wow!! thanks so much for this - really useful! :)
  20. mgroadster

    mgroadster Banned Member

    Joined:
    Oct 18, 2010
    Messages:
    1,770
    I do our household accts. using spreadsheets, they're easy to layout and ensure you get it right.
    It also allows you to see "how much month is left at the end of the money":D

You must be a member to reply…

Why should you join us?

  • Networking Opportunities
  • Find Genuine Wholesalers
  • Source Profitable Stock
  • 100,000 Members Strong
Back to top

Share This Page