Inventory account

Inventory (products bought for resale, materials bought to manufacture products to be sold, etc.), can't be expensed until sold - and in the meantime are accounted in the stock/inventory asset account in the balance sheet. The inventory account table allows you to control the inventory/stock level. The ending inventory is what shows up in the balance sheet.

In the Product details worksheet, you enter the Minimum Stock Level for each product, and in the Inventory Account worksheet you can adjust the minimum stock level if necessary throughout the year. During the high season you may want to increase the stock level, as well as reduce it during the low season.

Losses & thefts

The losses and thefts of inventory entered in the Assumptions worksheet is evenly divided throughout the year. You can adjust the amounts if necessary.

Personal consumption (Sole Proprietor/Partnership only)

Many retail business owners use some of their inventory for personal purposes. This has to be properly accounted for and deducted from the purchases. The personal consumption of inventory entered in the Assumptions worksheet is evenly divided throughout the year. You can adjust the amounts if necessary.

In the Assumptions worksheet you also enter:

1. Cash purchases %: the percentage of raw material (incl. finished products) purchases that are paid in cash.
2. Number of days payable: the average number of days it takes to pay inventory suppliers (30, 60, 90, or 120 days).
3. Losses & thefts: an estimated percentage of purchases for each year.
4. Personal consumption (Sole Proprietor/Partnership only): an estimated annual amount for each year.