I run a small online retail business.
I am currently using Quickbooks Pro 2009 for my accounting.
I have no problems importing bank transactions, balancing bank ledgers and the like.
However, I sell on Amazon, and maintain an inventory that currently includes 1200 items (varieties, not individual pieces) and has included just under 7000 different items since I started.
I sell in excess of 1000 pieces per month. I have few repeat customers.
Here comes the problem:
I had been treating all individual sales on Amazon as a ‘black box’. Amazon makes a deposit into my checking account a few times a month, and I treat them as a single customer.
Sales had not been linked to individual customers, and I had not been incrementing or decrementing my inventory based on individual sales.
Rather, I had been accounting for inventory in a spreadsheet, and then importing the quantities from reports produced by warehouse staff as they do inventory and fill orders.
Due to a desire to conform to more normal accounting practices, and advice given in the below thread, I have wanted to begin accounting for sales on a ‘per sale’ basis and handle individual sales in my accounting.
I started the process of converting to proper inventory accounting. During the course of this research, I discovered a deal-breaker:
In Quickbooks, you can only have 14,500 names
Cite:
http://forums.quickbooksusers.com/archive/index.php/t-20973.html
This means that I can only have a combined count of less than 14,500 items (types, not pieces) and customers.
That pretty much guarantees that I’ll hit the limit in a few years, especially if I expand my business.
I’m fine for now, since I’m not entering most sales or most items into Quickbooks.
I need a grown-up accounting package. Quickbooks isn’t it.
I’ve looked at PostBooks, Xero, Salesforce, and others.
It’s become apparent that I can’t just switch over without substantial investment of time, and that even investigating a given option is time-consuming.
Can somebody suggest a good solution?
I’d like something where I can easily import my current SKU and items into the inventory database. I’d really rather not have to sit down and enter 1200 SKUs by hand.
I’d also like something that can import transactions from my banks.
Preferably not too expensive, but I’m not too cheap to cough up a few hundred dollars.