Welcome to the Rpoints Forums.
+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 19
  1. #1
    Enthusiast BobbyDrake
    Join Date
    Jan 2006
    Posts
    1,616
    Rep Power
    0

    Ebay profit and loss spreadsheet

    Does anyone use one? I'd like to start recording my transactions working out p+l in excel. Or is this not advisable because of the taxman lol. I'm trying to make one but it looks a bit pants at the moment. Has anyone got one I could adapt and make it useful.
    Thanks

  2. #2
    Enthusiast The_member
    Join Date
    Aug 2005
    Posts
    2,360
    Rep Power
    0

    Re: Ebay profit and loss spreadsheet

    Quote Originally Posted by Eskiboy
    Does anyone use one? I'd like to start recording my transactions working out p+l in excel. Or is this not advisable because of the taxman lol. I'm trying to make one but it looks a bit pants at the moment. Has anyone ot one I could adapt and make it useful.
    Thanks

    You could probably try to BUY one on shitbay!
    Dismembered....

  3. #3
    Contributor rmckee69
    Join Date
    Nov 2005
    Location
    Ipswich,
    Posts
    118
    Rep Power
    0

    Re: Ebay profit and loss spreadsheet

    You could probably try to BUY one on shitbay!
    [/quote]

    at the very least an ebook how to create one!

  4. #4
    Rpoints Elite qwerty321
    Join Date
    Sep 2005
    Posts
    7,690
    Rep Power
    0
    THIS what you looking for?

  5. #5
    Enthusiast BobbyDrake
    Join Date
    Jan 2006
    Posts
    1,616
    Rep Power
    0
    Yeah something like that, cheers i'll have a play around with it

  6. #6
    Enthusiast ComCrazy
    Join Date
    Feb 2004
    Posts
    1,440
    Rep Power
    0
    If you want to "roll your own", both ebay and paypal make CSV spreadsheet data available :

    Ebay: click the download link on http://cgi3.ebay.co.uk/ws/eBayISAPI.dll?ViewAccount

    Paypal: https://history.paypal.com/uk/cgi-bi...story-download

    both links will ask for a login if you aren't already logged in,
    so make sure you are already logged to ebay & paypal in if you are paranoid about links on forums !

  7. #7
    Expert guyuk
    Join Date
    Jan 2005
    Location
    out there
    Posts
    2,556
    Rep Power
    0

    Re: Ebay profit and loss spreadsheet

    Quote Originally Posted by Eskiboy
    I'd like to start recording my transactions working out p+l in excel. Or is this not advisable because of the taxman lol.
    Its always best to know what your P&L is

    The tax man will make an assessment and it will be up to you to prove otherwise - its doubtful he will under estimate your tax

    My advice is (and Ive done this)

    Set up a seperate current account.
    Get ALL you ebay / Amazon / Paypal / whatever monies paid into it
    Use the debit card to pay for ALL your postal costs
    Use a specific credit card to pay all your ebay fees
    Use the debit card to withdraw cash for your purchases of stock or credit card if you buy wholesale.

    This means that your profit is actually any plus you have in that account.

    Now finally (and this is important) keep a log.

    Log time spent browsing shops, stores, car boots
    Log time each week spent on listing, answering questions, posting etc.
    Keep idea of mileage to get around to assist your collection of stock etc.

    This means, if the HMRC do come after you, you can also 'charge' your 'business' for the time you have spent doing this.

    Of course the tax man will then want some of your 'earnings' for this but it will reduce your overall estimate of liability.

    If you can hand him one account it gives him little to go on.

    Good luck

    So Long and THANKS for all the fish !

  8. #8
    Contributor daniela9uk
    Join Date
    May 2005
    Location
    London
    Posts
    567
    Rep Power
    0
    You really ARE perfectly organized guyuk... (not done Tesco yet, sorry)

  9. #9
    Expert guyuk
    Join Date
    Jan 2005
    Location
    out there
    Posts
    2,556
    Rep Power
    0
    Quote Originally Posted by daniela9uk
    You really ARE perfectly organized guyuk... (not done Tesco yet, sorry)
    no

    just sad and with too much time on my hands

    So Long and THANKS for all the fish !

  10. #10
    Contributor eggman
    Join Date
    May 2004
    Posts
    145
    Rep Power
    0
    That's pretty good advice!

    Do you think the taxman will start tracking down sellers that seem to be doing well?


 

Similar Threads

  1. Chesham BS - Annual loss
    By HB in forum Mutuals
    Replies: 15
    Last Post: 20th March 2009, 05:07 PM
  2. Newcastle loss
    By Ord in forum Mutuals
    Replies: 6
    Last Post: 20th December 2008, 01:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts