Stock Management (Desktop App)

Step 10 - Variance Report

Variance investigation

The system will calculate the difference between the counted quantity and system quantity as per the snapshot. If you take your counted quantity and compare it to your system quantity you will have your variance.

Important pointers you have to look at on your variance:

• High-value items
• Items with a variance more than a 20 quantity, depending on your number of items in the practice
• Items with a variance more than R 300 currency value, depending on the value of the items in the practice
• Typing errors
• Items that were not counted

Step 10 - Variance Report

If you pick up anything on your variance that was incorrect you need to correct the mistake:

• If you Counted incorrectly or have made a typing mistake, you can still change your counted units and reprint the Variance report
• If you have not Billed all your Patient files you must ADD the quantity to the stock count of that item on the counted units of the stock take
• If you did not Capture a Credit Note on the Patient you must DEDUCT the quantity from your counted items on your stock take
• If you did not capture all your Creditors or Supplier invoices you must DEDUCT the quantity from your counted items on your stock take
• If you have not captured a Credit Note from your Supplier you must ADD the quantity to the stock count of that item on the counted units of the stock take

In Best practice, a Variance of 5% - 10% or less is acceptable on the value of your stock items. Anything more than 10% is a warning to start getting concerned and you must investigate immediately.

You must be able to explain to the auditors any and all variances on your Stock. 

There is an option on the variance to only show the modified items, to assist in shortening the list and concentrating on the items with a variance.

Step 11 - Editing quantities

When you have investigated all the variances you can still correct incorrect quantities.  People make mistakes and a finger fault is really easy, or if you have counted incorrectly.

Remember that the quantities of your stock items on the report are all the counting locations in that warehouse added together.

 

Step 12 - Post Stock Take

When you have investigated all the variances on the items you need to post your stock take for the system to adjust the items to the counted units.

Best practice is to post the stocktake within 24 hours after the stocktake.

The system will make a minus adjustment if the counted units were less than the quantity on the system and an added adjustment if the counted units were more than the quantity on the system. This will be on the time and date stamp as of your snapshot.

You can also set up your stocktake to automatically do a re-evaluation of your stock value. This is best practice because the purchase price increases and decreases a lot over time and varies from supplier to supplier. If you evaluate your stock with every stock take it will be at the best value.

The Final report will show the value and quantity that the system will have as the Stock on hand. Please remember that the quantity and value will differ if the practice started treating the patient again before the reports are printed.