So Many Item Numbers

Question: When I create orders in SAGE and bring them over into QuickBooks, I like to create generic items, such as apparel, and change the description each time. It seems like I would have too many items otherwise. What do you think?

Answer: In QuickBooks Premier, you can have up to 14,500 list items. In QB Enterprise, the limit is 100,000. I don’t think I have ever seen a distributor run up against the 14,500. We do tend to have reorders and really don’t order too many different items over time … certainly not 14,500.

I like having items created with their item number or SAGE Product Code (SPC) if you use that and the item description. That way, when you reorder an item, the information is already in QB. You can also run reports of sales by item number in QB, which can provide helpful information.

Please email accounting questions you would like considered for the column to HGatter@AccountingSupportLLC.com with the subject line of "Ask the Accountant."