Child pages
  • Stock shrinkage and self consumption in RetailManager

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:9413

To cater for stock shrinkage/spoilage of your stock items in RetailManager, you have two options: selling

  • sell the items for $0.00, or
completing
  • complete a single item stocktake.
Which

The option you choose depends on what is 's right for your business.

 

UI Expand
titleOption 1: Sell the items for $0.00
  1. Set your own store up as a new customer by going to the Information menu and choosing Customers.
  2. Press F5 on the keyboard.
  3. Enter as little or as much of your stores details as you choose. See our example below.
  4. Click Commit.
  5. Go to the Transaction menu and choose Sales.
  6. Enter the applicable Staff number and the Customer number created above.
  7. Enter the barcode(s) of the item(s) you will be using for self consumption or writing off as damaged stock (shrinkage).
  8. Change the selling price to $0.00.
  9. Press the Tab key on your keyboard to move to the Quantity field. A message may appear warning that you are selling the item below cost. Click Yes. Another warning will appear, click OK.
  10. Enter the quantity of the item(s) being written off.
  11. Go to the Payment Details section click to highlight the Cash payment type.
  12. Enter the number zero ( 0 ) into the paying field and click Add. See our example below.
    Image
  13. Click Commit
UI Expand
titleOption 2: Complete a single item stocktake
  1. Go to the Stock Management menu and choose Stocktake.
  2. Enter the applicable Staff number.
  3. Select Single Item Stocktake.
  4. Enter the barcode of the item that has been damaged or written off for self consumption. See our example below.
  5. The expected quantity on hand will be displayed in the Expected column as In Stock. In the above example, the expected quantity is 58. If one of these items had been damaged or used for internal consumption, you would enter the number 57 into the Qty field and click Add (58 in stock minus 1 damaged item equals 57 in stock ).
  6. Repeat steps 4 - 5 for all other items that may have been damaged or used internally. 

Reporting on spoilage

By entering a $0 sale to a specific customer card that you have set up to account for spoilage, you are then able to report on the sales on that customer card. The "Who's Buying" report will show the Gross Profit figure next to that customer card. As you have "sold" the goods at $0 to account for spoilage, you can use the Gross Profit figure. For example, the gross profit of -$722.73 in the screenshot below indicates that $722.73 worth of stock was written off.

Image

 

Here is the resulting report:

HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;FAQs</h2><br>
UI Expand
titleWhat is the effect on the transaction journals exported to my MYOB accounting software?

In both instances (shrinkage/self consumption), the following transaction will occur:

 Income

 No change 

 Bank Account 

 No change 

 Inventory

 Decreases (Credit) 

 Cost Of Goods Sold 

 Increases (Debit)

 

 

 

 

 

If you would like the shrinkage/self consumption to be recorded as an expense, you can Record a Journal Entry in your Accounting software. The Journal Entry could be recorded as follows: 

 Cost Of Goods Sold

Decreases (Credit)

  Spoilage Expense

Increases (Debit)

 

 

 

You may need to create a new Expense account or use one that is already used for spoilage/shrinkage. If you are unsure which account you should use, please consult your Accountant. 

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Retail user guides

Stocktaking in RetailManager

End of financial year in RetailManager

Advanced Inventory in RetailManager (packages and components)

...