The Importance Of Inventory Control in Accounting

When you create products in your accounting software you should almost certainly be able to enter the cost, if so make the effort.

Without the cost your accounting software's financial statements will only show a fraction of the story.

The cost that you enter should, in most cases, be as close as possible to the average cost of that item that you have in stock. For example -

What is average stock? Let's assume that you have 1 bolt in stock and it cost you $1.00. You then go out and buy another bolt for stock and the cost has shot up to $2.00. You now have 2 items in stock that cost a total of $3.00. Therefore your average cost is $1.50 per item. When you sell one of these items the software will take into account that the cost of that sale was $1.50. Most accounting software systems will adopt this approach

There is a separate section towards the end that looks at the different types of product cost and what they mean.

Another important issue when setting up your products in your accounting software is closely related to whether there are re-order reports in your accounting software and a Purchase Order module that is linked to the re-order system, and you intend using either or both.

This issue basically deals with the ideal maximum and minimum stock that you wish to keep of a particular product. It can be done several ways but the most common would be -

Maximum and Minimum. Let's say you want a maximum number of the item in stock at any time of 20 and a minimum quantity of 10. When the stock level falls to 10 or below the system will tell you to order whatever quantity that takes it back to 20. The minimum level is also known as the re-order point.

In a similar situation your accounting software may only work to a maximum stock level in which case whenever your stock level falls below 20 it will show an order quantity to take it back to 20. "Your system may allow you to enter different levels based on seasons. For example if it gave you four separate seasons then you would need to give it four different levels. This method is more common in industries where there can be large fluctuations in sales depending on season as in summer and winter, as in Christmas and non Christmas periods etc.

If you operate in a country where you charge GST or similar and later claim this tax back then the cost of the product should be shown excluding the tax.

For example a bolt costs $5.00 plus $0.50 GST then show it as $5.00. This example applies to Australia If you are not sure about your own situation then check with your accountant.

Products Module - Additional Uses

You will have already set up your products in your accounting software before you started invoicing so that part should already be done except maybe for some fine tuning that you need along the way.

To reap the full benefits of a products module you will need to record into your accounting software your stock as you receive it.

One of the more important aspects of the products module though in any accounting software is that it keeps a track of your stock.

Many business people that I have met over the years have seen this as being of not much value to their overall day to day operation.

Before you arrive at this conclusion consider some of the possible benefits of keeping a stock control system from the following

Reflecting and recording the true value of stock and the cost of your sales can directly impact on your profit and, or, loss and, therefore, the amount of tax you pay at the end of the year.

You have various reports on hand in your accounting software to show what stock is running low, therefore you can re-order from your suppliers before you run out and possibly lose sales.

Stock control in your accounting software should show you which are your faster moving items and therefore where your money in stock should be more heavily invested.

Stock sales reports in your accounting software should tell you when you last sold a product therefore have you got stock (and maybe lots of that product) that is taking up valuable storage space which could be used for better selling items, or tying up valuable cash in slow moving items.

Is stock mysteriously disappearing? Is someone helping themselves without your knowledge.

Is product running passed its effective use by date or shelf life.

Are some of your products seasonal so are you stocking the right quantities for the peaks and reducing stock for the off seasons.

Is some of your stock shop soiled and not really in a condition to portray your business image.

Many accounting software packages will create re-order reports for you of what the system thinks you may need without you going out there and physically counting. By all means check the suggested order but let the accounting software take some of the grind out for you.

Some businesses can have an enormous amount of capital tied up in stock and it is important to make sure that this capital has been invested wisely. Could some of this value be liquidated to pay off some debt or to invest in new equipment and so on.

Look at what you have and, if necessary talk to your accountant.

I have been involved in all aspects of the accounting software industry for over 20 years. I run several websites that specialize in various subjects including http://www.diyaccounts.com.au that gives advice on all aspects of accounting software from choosing, setting up and using it. Amongst other sites that I run are http://www.sense-now.com that helps newbies understand what internet business will probably work for them and what won