How do you track sales and profits? - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > Platform Discussions > eBay Discussion!

eBay Discussion! EBay Forum. News, Updates, or Anything eBay is Welcome. A kind of lounge if you will.

Reply
 
Thread Tools
  #1  
Old 03-23-2013
Junior Member
 
Join Date: Jan 2013
Posts: 94
Thanks: 102
Thanked 11 Times in 11 Posts
Activity: 0%
Longevity: 65%
iTrader: (0)
Default How do you track sales and profits?

I was wondering if their is any good software to use to track sales and profits on ebay? I'm a small fish right now, so I was thinking a well designed Excel spreadsheet might be best? Does anyone have a good template?

I was thinking it would need sortable fields with:
Item, purchase location, purchase price, purchase date, category, sale date, sale price, shipping charged, ebay fee, paypal fees, shipping paid, net profit.

Am I missing anything here?
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 03-23-2013
rsot's Avatar
Executive [VIP]
 
Join Date: Dec 2009
Posts: 75,855
Thanks: 5,926
Thanked 8,909 Times in 8,202 Posts
Activity: 99%
Longevity: 83%
iTrader: (7)
Default

Sounds like you are looking for some bookkeeping and accounting advice... I might add a field for any complaints or chargebacks
Reply With Quote
The Following User Says Thank You to rsot For This Useful Post:
km018 (03-23-2013)
  #3  
Old 03-23-2013
slim jim's Avatar
Executive [VIP]
 
Join Date: May 2011
Posts: 1,788
Thanks: 376
Thanked 440 Times in 349 Posts
Activity: 0%
Longevity: 74%
iTrader: (0)
Default Re: How do you track sales and profits?

Use quicken or quickbooks. Its very user friendly and there is a ton of info out there on it
Reply With Quote
The Following User Says Thank You to slim jim For This Useful Post:
km018 (03-23-2013)
  #4  
Old 03-23-2013
Junior Member
Threadstarter  
 
Join Date: Jan 2013
Posts: 94
Thanks: 102
Thanked 11 Times in 11 Posts
Activity: 0%
Longevity: 65%
iTrader: (0)
Default

Quote:
Originally Posted by rsot View Post
Sounds like you are looking for some bookkeeping and accounting advice... I might add a field for any complaints or chargebacks
Yes I didn't think about that one.

Maybe I can find an excel expert on Fiverr.
Reply With Quote
  #5  
Old 03-23-2013
Futuremogul888's Avatar
Executive [VIP]
 
Join Date: Jul 2012
Posts: 558
Thanks: 141
Thanked 424 Times in 228 Posts
Activity: 2%
Longevity: 68%
iTrader: (0)
Default

Couple of good business accounting and bookkeeping websites like:

https://www.waveapps.com/accounting/ (free)

Accounting Software | Online Small Business Bookkeeping Services - Outright (semi-free)
Reply With Quote
The Following 2 Users Say Thank You to Futuremogul888 For This Useful Post:
km018 (03-23-2013), Packattack12 (04-12-2013)
  #6  
Old 03-23-2013
slim jim's Avatar
Executive [VIP]
 
Join Date: May 2011
Posts: 1,788
Thanks: 376
Thanked 440 Times in 349 Posts
Activity: 0%
Longevity: 74%
iTrader: (0)
Default Re: How do you track sales and profits?

Quote:
Originally Posted by km018 View Post
Yes I didn't think about that one.

Maybe I can find an excel expert on Fiverr.
Thats a good idea also. Try odesk.com
Reply With Quote
  #7  
Old 03-25-2013
Speeder33
 
Posts: n/a
Activity: 0%
Longevity: 0%
Default

2nd on the odesk, used them before, youd be amazed at what a few bucks an hour can do
Reply With Quote
  #8  
Old 03-25-2013
Executive [VIP]
 
Join Date: Nov 2012
Posts: 3,097
Thanks: 408
Thanked 668 Times in 494 Posts
Activity: 0%
Longevity: 66%
iTrader: (0)
Default

Most people who have at-least taken the two lower division college Accounting courses required by most schools nation wide should have enough of a foundation they can figure out how to do cash basis accounting themselves. If you haven't I would consider getting some simple guides, maybe watching youtube videos etc. It isn't that complicated. The more research you do the better off you are. Even with quick books or another program if you don't understand basic accounting and the tax laws you might be lost. Maybe even read up on IRS.gov about small business write offs keeping records etc.
Reply With Quote
  #9  
Old 03-25-2013
slim jim's Avatar
Executive [VIP]
 
Join Date: May 2011
Posts: 1,788
Thanks: 376
Thanked 440 Times in 349 Posts
Activity: 0%
Longevity: 74%
iTrader: (0)
Default Re: How do you track sales and profits?

This is true however cash basis accounting is not an generally accepted method , you should be looking up accural.
Reply With Quote
  #10  
Old 03-25-2013
Executive [VIP]
 
Join Date: Nov 2012
Posts: 3,097
Thanks: 408
Thanked 668 Times in 494 Posts
Activity: 0%
Longevity: 66%
iTrader: (0)
Default

Quote:
Originally Posted by slim jim View Post
This is true however cash basis accounting is not an generally accepted method , you should be looking up accural.
He said he was a small fish. You have to start with the basics. I agree with your point though.
Reply With Quote
The Following User Says Thank You to vogeltron For This Useful Post:
slim jim (03-25-2013)
  #11  
Old 03-27-2013
Junior Member
Threadstarter  
 
Join Date: Jan 2013
Posts: 94
Thanks: 102
Thanked 11 Times in 11 Posts
Activity: 0%
Longevity: 65%
iTrader: (0)
Default

I got a nice spreadsheet made for me on fiverr. It should do the trick for a while, and is actually pretty nice. It cost me 2 gigs ($10), but is far more complicated then anything my basic excel skills could have created.

Last edited by km018; 03-27-2013 at 08:04 PM.
Reply With Quote
  #12  
Old 03-28-2013
moneyhustler88's Avatar
Senior Member
 
Join Date: Apr 2012
Posts: 1,679
Thanks: 615
Thanked 94 Times in 84 Posts
Activity: 0%
Longevity: 69%
iTrader: (0)
Default

Thats good you could outsource to Fiverr, I myself would rather use a excel chart so yeah maybe I could do with a visit to Fiverr
Reply With Quote
  #13  
Old 03-28-2013
Banned
 
Join Date: Apr 2009
Posts: 8,605
Thanks: 1,580
Thanked 2,029 Times in 1,356 Posts
Activity: 0%
Longevity: 87%
iTrader: (47)
Default

I use Excel for mine.

Works perfectly for me so I know what account and types of items are doing well etc.
Reply With Quote
  #14  
Old 03-29-2013
Junior Member
Threadstarter  
 
Join Date: Jan 2013
Posts: 94
Thanks: 102
Thanked 11 Times in 11 Posts
Activity: 0%
Longevity: 65%
iTrader: (0)
Default

Quote:
Originally Posted by moneyhustler88 View Post
Thats good you could outsource to Fiverr, I myself would rather use a excel chart so yeah maybe I could do with a visit to Fiverr
I just found the top rated excel person on Fiverr. He actually charged me for 2 "gigs", or $10.

Mine has an inventory tab which purchase, date, price, location etc. Then when I sell an item, I enter sale price, shipping, fees, etc. I then hit an "update" button which carries all the sold items to the 2nd tab "sales". All the headers on the first 2 tabs are also sortable. The 3rd tab is "stats" where I can see total net profit per month, year, item, etc. I can also track how I do per item or per catagory that I am selling in.

I am very satisfied for $10
Reply With Quote
The Following User Says Thank You to km018 For This Useful Post:
Sandy D (04-12-2013)
  #15  
Old 04-12-2013
a.v.limited's Avatar
Senior Member
 
Join Date: May 2012
Posts: 656
Thanks: 12
Thanked 37 Times in 33 Posts
Activity: 6%
Longevity: 69%
iTrader: (-1)
Default

you can use ebay selling pro
Reply With Quote
  #16  
Old 04-12-2013
Banned
 
Join Date: Apr 2009
Posts: 8,605
Thanks: 1,580
Thanked 2,029 Times in 1,356 Posts
Activity: 0%
Longevity: 87%
iTrader: (47)
Default

Quote:
Originally Posted by km018 View Post
I just found the top rated excel person on Fiverr. He actually charged me for 2 "gigs", or $10.

Mine has an inventory tab which purchase, date, price, location etc. Then when I sell an item, I enter sale price, shipping, fees, etc. I then hit an "update" button which carries all the sold items to the 2nd tab "sales". All the headers on the first 2 tabs are also sortable. The 3rd tab is "stats" where I can see total net profit per month, year, item, etc. I can also track how I do per item or per catagory that I am selling in.

I am very satisfied for $10


Awesome.

You can find almost anything doing things like these in fiverr and for cheap like this.

Do you want to refer the person you used for other here?
Reply With Quote
  #17  
Old 04-12-2013
Junior Member
Threadstarter  
 
Join Date: Jan 2013
Posts: 94
Thanks: 102
Thanked 11 Times in 11 Posts
Activity: 0%
Longevity: 65%
iTrader: (0)
Default

Quote:
Originally Posted by Sandy D View Post
Awesome.

You can find almost anything doing things like these in fiverr and for cheap like this.

Do you want to refer the person you used for other here?
My pleasure. His name is Lavina2000. Great to work with. I had many questions, edits, etc and he was very helpful and responded to all of my questions.

Here is a link to his "gig", I hope it works. Lavina2000 will do any job in microsoft excel with 15+ years of experience for $5, only on fiverr.com

I'm sure he still has my spreadsheet to use as a template. Let him know the ebay spreadsheet template that Kurt used.
Reply With Quote
  #18  
Old 04-12-2013
Packattack12's Avatar
Senior Member
 
Join Date: Dec 2011
Posts: 405
Thanks: 363
Thanked 128 Times in 79 Posts
Activity: 0%
Longevity: 71%
iTrader: (11)
Default

Quote:
Originally Posted by Futuremogul888 View Post
Couple of good business accounting and bookkeeping websites like:

https://www.waveapps.com/accounting/ (free)

Accounting Software | Online Small Business Bookkeeping Services - Outright (semi-free)
I've never heard of either of those. But I am checking out Wave and we speak and I might have found my new software to keep books.

Def recommend. Thanks for the info!
Reply With Quote
  #19  
Old 10-03-2014
Banned
 
Join Date: Nov 2012
Posts: 1,707
Thanks: 441
Thanked 283 Times in 194 Posts
Activity: 0%
Longevity: 66%
iTrader: (2)
Default Re: How do you track sales and profits?

Where it says SIZES It's suppose to be colors!
Reply With Quote
  #20  
Old 10-04-2014
rsot's Avatar
Executive [VIP]
 
Join Date: Dec 2009
Posts: 75,855
Thanks: 5,926
Thanked 8,909 Times in 8,202 Posts
Activity: 99%
Longevity: 83%
iTrader: (7)
Default Re: How do you track sales and profits?

Good use of Excel Continental boss
Reply With Quote
  #21  
Old 10-04-2014
Banned
 
Join Date: Nov 2012
Posts: 1,707
Thanks: 441
Thanked 283 Times in 194 Posts
Activity: 0%
Longevity: 66%
iTrader: (2)
Default Re: How do you track sales and profits?

This is one of 6 or 7 different ones I use.
Reply With Quote
  #22  
Old 10-04-2014
GreenBean's Avatar
Executive [VIP]
 
Join Date: Sep 2007
Posts: 42,343
Thanks: 5,612
Thanked 9,142 Times in 7,106 Posts
Activity: 0%
Longevity: 96%
iTrader: (6)
Default Re: How do you track sales and profits?

Nice to bump an old thread too.

BTW, resize your image, Hun. It's too big.

Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
keeping a track of profits - software arshavin eBay Discussion! 33 06-12-2013 02:42 PM
What are your montly average sales/profits Packattack12 eBay Discussion! 11 08-16-2012 04:07 PM
Yard Sales, Estate Sales, Garage Sales... TGMT² Everything Else 22 08-09-2012 05:23 PM
How to track products' monthly sales on AMAZON incniu Subscriber Discussions 4 01-03-2011 10:00 AM
Strategies For Locating Hot Items, Hot Sellers, Fast Profits and Monthly Sales Volume HairyOldEbayer Subscriber Discussions 20 02-16-2009 08:54 AM


Aspkin Group

All times are GMT -5. The time now is 12:21 AM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58