Inventory tracking software?

[Admiral]

I'm looking for software that would simply take in a spreadsheet of SKUs and quantity associated with it and we would update it every 1-2 days preferably giving us charts to show the sales rates.  Also I would want to be able to aggregate multiple SKUs at once since we have a different one for every size shirt.

Pretty basic stuff but I had trouble finding it through google so perhaps someone here knows.  We need to be able to track our inventory over different time lines to avoid stockouts. 

For example:

9/08
SKU: 0-HAPPYPLACE_XL    10

9/10
SKU: 0-HAPPYPLACE_XL    7

9/12
SKU: 0-HAPPYPLACE_XL   6

9/14
SKU: 0-HAPPYPLACE_XL    6

would be the quantities and dates and we would be able to see it would likely sell out in 2 weeks and need to be replenished. 

Preferably the software would be inexpensive.  We wouldn't want someone with a monthly payment...

Thanks

[Gilligan]

This is something that would be beyond a fancy excel sheet?  What about an access database?  Those aren't too hard to work yourself, depending on your needs.

[mimosatexas]

we use a multisheet excel file for this kind of tracking.  Excel can do basically whatever you want, but you will probably have to do some googling for specific formulas and formatting if you don't know it that well already.

[Admiral]

We currently use spreadsheets - google ones.  The problem is that the SKUs don't line up as more are added so the formatting is off and difficult to work with.  Plus tracking over different intervals isn't easy at all with how we have it right now.

I will look into using Excel and doing fancy things with it...

[mimosatexas]

we actually use google as well, but it is basically the same as excel.  Either way...

we have ours setup with basically two sections per style, one very basic section that is essentially just for quick reference, with current stock and "ideal" stock, then it uses those to generate what we need to order (and there is some info on pricing etc. to determine when it makes sense to order stuff).  We order when it gets low or we run out or the formula says we should (lol).  The second section is larger and related to sales over time and has a lot more complex formulation to show us different things.  I guess there is kind of a third section with a bunch of random weird calculations we have done on a whim, and when we find we reference one enough it gets put in section two and cleaned up and labeled clearly.

[Gilligan]

And if you are looking for trends, you will be dumping the info into excel anyway.

[papinc]

Do you use any accounting software?

[Admiral]

Do you use any accounting software?

Quickbooks

[papinc]

It's been long time since I've worked in Quickbooks, so I don't really know the functionality of it's inventory features. We use Peachtree which I prefer (more accounting friendly....and in another life I was an accountant).

Maybe download a trial of Peachtree Complete to see if the inventory features would suit what you're trying to accomplish without all of the spreadsheets...and yes I love spreadsheets.