Difference between revisions of "How do I deal with a stock write down?"

From Catalyst
Jump to: navigation, search
Line 1: Line 1:
{{Review}}
 
 
== Summary ==
 
== Summary ==
The following article explains how to deal with stock write down.
+
The following article explains how to deal with parts, accessory and clothing stock write downs.
  
 
== More Information ==
 
== More Information ==
There may be times when you need to de-value your stock on the balance sheet. This may be due to a number of reasons, e.g. stock that has been in the system unsold for a number of years. To do this, you need to perform the following steps.
+
It is good business practice to assess the stock value on your balance sheet regularly, and consider whether the value should be written down. This could be due to a number of reasons, e.g. obsolete stock, or items that have not sold for a period of time. Generally you or your accountant will have decided on a stock write down policy which you will find in your year end accounts for HMRC.
  
 
=== Setup ===
 
=== Setup ===
* Decide on the figure you wish to reduce your stock value by.
+
* Decide on the figure by which you wish to write down your stock. Ideally, you would run an Aged Stock Report to help you decide what this figure should be and which items it will affect based on your write down policy.
* [[How do I Create a Nominal Code?|Create a new nominal code]] to sit along side the one for stock value (typically Z922) and call it "Stock Provision". Z9221 would be suitable. The centre would need to be set as a Balance Sheet centre and flagged as an Asset/Liability.
+
 
* Reduce Z922 (The centre for stock value) by the figure decided above and [[Posting Journals|journal]] to Z9221 (the new centre for stock provision).
+
{{Note|title=Note|text=In a perfect world, you would go through the individual items that you want to write down, and adjust them out of stock at their existing value, and then adjust them back into stock at their new written down value. This will reduce your Stock Value and post the other side to the Stock Adjustments code on the profit and loss automatically, however this can be very time consuming if there are a lot of items. It will give you the correct profit margins.}}
 +
 
 +
If adjusting every item is not practical, then the following method is a reasonable compromise.
 +
 
 +
* [[How do I Create a Nominal Code?|Create a new nominal code]] to sit alongside the one for Stock Value (typically {{DataValue|Z922}}) and call it {{DataValue|Stock Provision}}. {{DataValue|Z9221}} would be suitable. The centre will be a Balance Sheet centre and should be flagged as a Current Asset.
 +
* Reduce the new code, {{DataValue|Z9221}}, by the figure decided above and [[Posting Journals|journal]] the other side to {{DataValue|Z923}}, Stock Adjustments.
  
 
=== Monthly Routine ===
 
=== Monthly Routine ===
* Run a [[What Stock Reports should I run?|stock profit report]] for the month and make a note of the total cost of sales for that month.
+
* Run a [[What Stock Reports should I run?|stock profit report]] for the month and check if any of the items that you wanted to write down have been sold.
* [[Posting Journals|Journal]] that cost of sale from stock provision to stock value.  This has the effect over time of bringing back into line your stock value.
+
* [[Posting Journals|Journal]] the cost of sale of these items as a positive figure to Z9221, Stock Provision with the other side to Z923, Stock Adjustments.  This has the effect over time of reducing your stock provision if the items do actually sell.
  
 
== See Also ==
 
== See Also ==
 
*[[How do I Create a Nominal Code?]]
 
*[[How do I Create a Nominal Code?]]
 
*[[Posting Journals]]
 
*[[Posting Journals]]
 +
 +
{{KB_Tags|Write, down, value, stock}}{{KB_ST}}{{KB_NL}}{{ZN_Admin}}

Revision as of 13:33, 26 March 2013

Summary

The following article explains how to deal with parts, accessory and clothing stock write downs.

More Information

It is good business practice to assess the stock value on your balance sheet regularly, and consider whether the value should be written down. This could be due to a number of reasons, e.g. obsolete stock, or items that have not sold for a period of time. Generally you or your accountant will have decided on a stock write down policy which you will find in your year end accounts for HMRC.

Setup

  • Decide on the figure by which you wish to write down your stock. Ideally, you would run an Aged Stock Report to help you decide what this figure should be and which items it will affect based on your write down policy.
Note: In a perfect world, you would go through the individual items that you want to write down, and adjust them out of stock at their existing value, and then adjust them back into stock at their new written down value. This will reduce your Stock Value and post the other side to the Stock Adjustments code on the profit and loss automatically, however this can be very time consuming if there are a lot of items. It will give you the correct profit margins.

If adjusting every item is not practical, then the following method is a reasonable compromise.

  • Create a new nominal code to sit alongside the one for Stock Value (typically 'Z922') and call it 'Stock Provision'. 'Z9221' would be suitable. The centre will be a Balance Sheet centre and should be flagged as a Current Asset.
  • Reduce the new code, 'Z9221', by the figure decided above and journal the other side to 'Z923', Stock Adjustments.

Monthly Routine

  • Run a stock profit report for the month and check if any of the items that you wanted to write down have been sold.
  • Journal the cost of sale of these items as a positive figure to Z9221, Stock Provision with the other side to Z923, Stock Adjustments. This has the effect over time of reducing your stock provision if the items do actually sell.

See Also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Write, down, value, stock