Suggested Linked Inventory Accounts for New inventory

When I enter a new inventory item under the Linked tab I am able to assign the item to various accounts based on four categories: Asset, Revenue, COGS, and Variance. 

My question is how "granular" should I be in regards to the assignment of these inventory accounts? Right now, I expect that we will have about 20 products to sell from four main suppliers. I see there are standard entries for Inventory A, Inventory B, etc. Should I create and link 'Inventory Cost' and 'Inventory Revenue' accounts for each product? For example, "5020 Inventory Model AB-1 Cost" or "Sales Inventory Model BC-3". Or maybe create inventory accounts based on each supplier, like 5020 Inventory Supplier B?

Any suggestions you can provide this accounting newbie would be appreciated. Thanks

  • 0

    Hi Rick:

    The choice is up to you on how you would like to set up your inventory. Usually the asset chosen for inventory A or B etc. will be determined possibly by the value of the items going into inventory. Some companies want to track their high cost items separately. Others may want to separate their inventory depending upon their manufacturing concern (raw materials/finished goods) as opposed to wholesale/retail operations. The same scenario goes for the cost of goods and sales/revenue accounts. If you want to track costs against sales for certain categories for margins or gross profits it would be wise to create separate cost of sales accounts and revenue accounts to correspond to your needs. Breaking it down by supplier can be helpful if your supplier has demands/contractual obligations with your company or vice-versa.

    You can be as creative as you want, however, remember simple is better than overly complex. The software is limited to it's capability.

    Good luck!