Forum

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?

Sounds like you are looking for some bookkeeping and accounting advice... I might add a field for any complaints or chargebacks :)

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

Yes I didn't think about that one.

Maybe I can find an excel expert on Fiverr. :typing:

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)

Re: How do you track sales and profits?
 

Thats a good idea also. Try odesk.com

2nd on the odesk, used them before, youd be amazed at what a few bucks an hour can do

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.

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.

He said he was a small fish. You have to start with the basics. I agree with your point though.

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.

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 use Excel for mine.

Works perfectly for me so I know what account and types of items are doing well etc.

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

you can use ebay selling pro

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.

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!

Re: How do you track sales and profits?
 

Where it says SIZES It's suppose to be colors!
http://i59.tinypic.com/1zlxglx.jpg

Re: How do you track sales and profits?
 

Good use of Excel Continental boss :thumb:

Re: How do you track sales and profits?
 

This is one of 6 or 7 different ones I use.

Re: How do you track sales and profits?
 

Nice to bump an old thread too.

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

:peace: