Difference between revisions of "How do I account for a unit written off?"

From Catalyst
Jump to: navigation, search
m
(Writing Off the Value of the Unit)
 
(6 intermediate revisions by 2 users not shown)
Line 3: Line 3:
  
 
== More Information ==
 
== More Information ==
 +
{{Units}}
 
As the summary states, there are two things to do in order to write off a unit from the system.
 
As the summary states, there are two things to do in order to write off a unit from the system.
 +
 +
=== Showing the unit as being Written Off ===
 +
You will need to show that the unit has been written off in the {{VS}} system.
 +
 +
* Go to {{Menu|{{VS}}|Add or Edit Units}}.
 +
* On the {{DataPrompt|Search on:}} enter the unit in question and press {{KeyPress |Enter}} to list the unit.
 +
* Press {{KeyPress|F5}} or click {{Button|Edit}} to edit the unit.
 +
* Set the {{DataPrompt|Status:}} to {{DataValue|WRO}} (you may need to create a new code. If so make sure it is a non-stock status - see [[How do I create a unit status?]]).
 +
* Click on the {{Tab|Details}} tab and in the {{DataPrompt|Notes}} section enter in that the unit has been written off, when, how and if possible by whom.
 +
* Go to the {{Tab|Purchase}} tab and set the {{DataPrompt|Valuation Excluded?}} flag to {{DataValue|Yes}}.
 +
* Click {{Button|Done}} and {{Button|Accept}}.
 +
 +
{{Warning|text=The system will immediately reverse the journal holding the unit in stock i.e. Credit Unit Stock Value (usually 70001/71001) and Debit Unit Accruals (usually Z940). If there are any expenses against the unit these will also be reversed to Credit Stock of Expenses (usually 70101/71101) and Debit Expense Accruals (usually Z944).}}
 +
 +
* You should now deal with the postings made to take the unit out of your stock.
  
 
=== Writing Off the Value of the Unit ===
 
=== Writing Off the Value of the Unit ===
In order to reduce the value of stock, you will need to know the Nominal Centres for your {{DataValue|Stock Value}} and {{DataValue|Unit Write-Off}}.
+
Make sure you know the postings made so you understand which centres you need to Credit in order to Debit your Profit & Loss with the Write Off.
 +
* Use [[What does nominal review show me?|Nominal Review]] to view any postings made on today's date. You can enter the unit stock number into the {{DataPrompt|Filter on}} field to help you to find the postings made.
 +
* Make sure you have a {{DataValue|Unit Write-Off}} Nominal Centre.
  
{{Tip|text=If you do not have a {{DataValue|Unit Write-Off}} centre, you will need to [[How do I create a nominal code?|create one]] making sure that you set the {{DataPrompt|P/L indicator}} to {{DataValue|Cost of Sales}}. ''See : [[How do I create a nominal code?|here]] for instructions to do this.''}}
+
{{Tip|text=If you do not have a {{DataValue|Unit Write-Off}} centre, you will need to [[How do I create a nominal code?|create one]] making sure that you set the {{DataPrompt|P/L indicator}} to {{DataValue|Cost of Sales}}. See [[How do I create a nominal code?]].}}
  
You will need to do a journal between these centres.
+
Post a Multiple Entry journal to account for the write-off.
* Go to {{Menu|{{NL}}|Journal Entries|Double Entry}}.
+
* Go to {{Menu|{{NL}}|Journal Entries|Multiple Entry}}.
* On {{DataPrompt|1st Centre:}}, enter the centre for "Unit Write-Off".
+
* Enter the {{DataPrompt|Date}} of the write-off.
* On {{DataPrompt|Date:}}, enter the date that you wrote off the unit.
+
* Enter your Unit Accruals centre e.g. Z940.
* On {{DataPrompt|Amount:}}, enter the value of the unit as it appears on the {{VS}} system as a positive amount, because you will be debiting the "Unit Write-Off" code and crediting the "Stock Value".
+
* Under the {{DataPrompt|Credit}} column enter the amount to write off i.e. the value posted to the accruals centre by changing the status of the unit.
* On {{DataPrompt|Cheque No./Comment:}}, type {{DataValue|<Unit Stock number>}} and {{DataValue|W/Off}}.
+
* Enter a {{DataPrompt|Comment}} e.g. Unit 1234 Write-Off
* On {{DataPrompt|2nd Centre:}} enter the centre for your "Stock Value".
+
* On the next line of the journal enter your Write-Off nominal centre.
* The {{DataPrompt|Amount:}} will automatically be entered in as a negative of the amount entered previously.
+
* Under the {{DataPrompt|Debit}} column enter the amount to write off i.e. the value posted to the accruals centre by changing the status of the unit.
* Accept the posting.
+
* At {{DataPrompt|Comment}} press {{KeyPress|C-F6}} to repeat the comment from the line above.
 +
* If the unit had expenses associated to it, repeat the above but using the Unit Expenses Accrual and the Write-Off nominal centre. Make sure you Credit the Expense Accrual code unless the unit only had positive expenses associated to it e.g. bonuses, in which case you would Debit the Unit Expense code and Credit the Write-Off code.
 +
* Click {{Button|Done}} and {{Button|Accept}}.
  
 
This posting should have the effect of reducing the value of your stock on the accounts by the cost of the unit concerned, and increasing the cost of sales in the month in question by the same amount hence reducing your profit in that period.
 
This posting should have the effect of reducing the value of your stock on the accounts by the cost of the unit concerned, and increasing the cost of sales in the month in question by the same amount hence reducing your profit in that period.
Line 25: Line 45:
 
In order to account for any insurance money received for the unit written off, you will need to know the Nominal Centres for your {{DataValue|Unit Write-Off}} and {{DataValue|Bank Account}}.
 
In order to account for any insurance money received for the unit written off, you will need to know the Nominal Centres for your {{DataValue|Unit Write-Off}} and {{DataValue|Bank Account}}.
  
As before you will need to do a journal between these centres.
+
* Go to {{Menu|{{NL}}|Journal Entries|Cashbook Entry}}.
* Go to {{Menu|{{NL}}|Journal Entries|Double Entry}}.
+
* Select {{DataPrompt|Money in}}
* On {{DataPrompt|1st Centre:}}, enter the centre for "Bank Account".
+
* Enter the {{DataPrompt|Centre}} for your bank account.
* On {{DataPrompt|Date:}}, enter the date that you received the payment from the insurance company.
+
* On the next line enter the centre for the Unit Write-Off.
* On {{DataPrompt|Amount:}}, enter the value of the insurance payout as a positive amount, because you will be debiting the "Bank Account" code and crediting the "Unit Write-Off".
+
* Enter the {{DataPrompt|Date}} that you received the payment from the insurance company.
* On {{DataPrompt|Cheque No./Comment:}} enter the {{DataValue|<Unit Stock number>}} and {{DataValue|In/Pay}}.
+
* At {{DataPrompt|Credit}} enter the value of the insurance payout.
* On {{DataPrompt|2nd Centre:}} enter the centre for your "Unit Write-Off".
+
* At {{DataPrompt|Comment}} enter a suitable comment e.g. Unit 1234 Ins Payout.
* The {{DataPrompt|Amount:}} will automatically be entered in as a negative of the amount entered previously.
+
* Click {{Button|Done}} and {{Button|Accept}}.
* Accept the posting.
 
  
 
This posting should have the effect of reducing the value of Unit Write-Off on the accounts by the insurance pay out of the unit concerned, and decreasing the cost of sales in the month in question by the same amount hence restoring your profit in that period.
 
This posting should have the effect of reducing the value of Unit Write-Off on the accounts by the insurance pay out of the unit concerned, and decreasing the cost of sales in the month in question by the same amount hence restoring your profit in that period.
 
=== Showing the unit as being Written Off ===
 
You will need to show that the unit has been written off in the {VS}} and account for the value of the unit when doing a stock valuation.
 
You will need to:
 
* Go to {{Menu|{{VS}}|Add or Edit Units}}.
 
* On the {{DataPrompt|Search on:}} enter the unit in question and press {{KeyPress |Enter}} to list the unit.
 
* Press {{KeyPress|F5}} or click {{Button|Edit}} to edit the unit.
 
* Set the {{DataPrompt|Location:}} to {{DataValue|WRO}}.
 
 
{{Tip|text=If this location does not exist, press {{KeyPress|S-F10}} on the {{DataValue|Location}} and enter in an appropriate {{DataPrompt|Description:}}, press {{KeyPress|ESC}} and click {{Button|Accept}} to create the Location.}}
 
 
* Set the {{DataPrompt|Status:}} to {{DataValue|WRO}}.
 
 
{{Tip|text=If this status does not exist, press {{KeyPress|S-F10}} on the {{DataValue|Status}} and enter in a {{DataPrompt|Description:}}, set the {{DataPrompt|Text:}} and {{DataPrompt|Background:}} to colours that stand out, press {{KeyPress|ESC}} and click {{Button|Accept}} to create the status.}}
 
 
* Click on the {{Tab|Details}} tab and in the {{DataPrompt|Notes}} section enter in that the unit has been written off, when, how and if possible by whom.
 
* Click on the {{Tab|Sale}}.
 
** On the {{DataPrompt|Sale date:}} enter the date when the unit was written off.
 
** Set the {{DataPrompt|Target price:}} to {{DataValue|£0.00}}.
 
** Set the {{DataPrompt|Actual price:}} to {{DataValue|£0.00}}.
 
 
''See [[How do I exclude units from my stock valuation?|here]] on how to exclude this unit from your stock valuation.''
 
  
 
== See also ==
 
== See also ==
Line 67: Line 64:
 
* [[Creating a new unit by copying an existing unit]]
 
* [[Creating a new unit by copying an existing unit]]
  
{{KB_Tags|unit, written, write, off, write-off, insurance, value, bike, car, van, motorhome, motor, home, caravan, motorcycle}}
+
{{KB_Tags|unit, vehicle, wholegood, caravan, agricultural machine, tractor, trailer, car, suv, motorcycle, motorbike, scooter, truck, van, lorry, motorhome, quad, atv, boat, tricycle, quadricycle, bicycle, bike, plant, written, write, off, write-off, insurance, value, motor, home}}
{{KB_VS}}{{ZN_Admin}}
+
{{How}}{{KB_VS}}{{ZN_Admin}}
  
 
{{KB_Ref|VS01}}
 
{{KB_Ref|VS01}}

Latest revision as of 13:28, 10 May 2021

Summary

This article will explain how to account for writing off a unit from Unit Sales and altering the values in the accounts.

More Information

Units: Unit is a general term used to cover all types of vehicle and machinery, including items such as motorcycles, scooters, cars, trucks, vans, caravans, motorhomes, boats, tractors, ATVs, agricultural equipment, wholegoods and construction equipment.

As the summary states, there are two things to do in order to write off a unit from the system.

Showing the unit as being Written Off

You will need to show that the unit has been written off in the Unit Sales system.

  • Go to " Unit Sales Add or Edit Units".
  • On the "Search on:" enter the unit in question and press <Enter> to list the unit.
  • Press <F5> or click [Edit] to edit the unit.
  • Set the "Status:" to 'WRO' (you may need to create a new code. If so make sure it is a non-stock status - see How do I create a unit status?).
  • Click on the [Details] tab and in the "Notes" section enter in that the unit has been written off, when, how and if possible by whom.
  • Go to the [Purchase] tab and set the "Valuation Excluded?" flag to 'Yes'.
  • Click [Done] and [Accept].
The system will immediately reverse the journal holding the unit in stock i.e. Credit Unit Stock Value (usually 70001/71001) and Debit Unit Accruals (usually Z940). If there are any expenses against the unit these will also be reversed to Credit Stock of Expenses (usually 70101/71101) and Debit Expense Accruals (usually Z944).
  • You should now deal with the postings made to take the unit out of your stock.

Writing Off the Value of the Unit

Make sure you know the postings made so you understand which centres you need to Credit in order to Debit your Profit & Loss with the Write Off.

  • Use Nominal Review to view any postings made on today's date. You can enter the unit stock number into the "Filter on" field to help you to find the postings made.
  • Make sure you have a 'Unit Write-Off' Nominal Centre.
If you do not have a 'Unit Write-Off' centre, you will need to create one making sure that you set the "P/L indicator" to 'Cost of Sales'. See How do I create a nominal code?.

Post a Multiple Entry journal to account for the write-off.

  • Go to " Nominal Ledger Journal Entries Multiple Entry".
  • Enter the "Date" of the write-off.
  • Enter your Unit Accruals centre e.g. Z940.
  • Under the "Credit" column enter the amount to write off i.e. the value posted to the accruals centre by changing the status of the unit.
  • Enter a "Comment" e.g. Unit 1234 Write-Off
  • On the next line of the journal enter your Write-Off nominal centre.
  • Under the "Debit" column enter the amount to write off i.e. the value posted to the accruals centre by changing the status of the unit.
  • At "Comment" press <Ctrl+F6> to repeat the comment from the line above.
  • If the unit had expenses associated to it, repeat the above but using the Unit Expenses Accrual and the Write-Off nominal centre. Make sure you Credit the Expense Accrual code unless the unit only had positive expenses associated to it e.g. bonuses, in which case you would Debit the Unit Expense code and Credit the Write-Off code.
  • Click [Done] and [Accept].

This posting should have the effect of reducing the value of your stock on the accounts by the cost of the unit concerned, and increasing the cost of sales in the month in question by the same amount hence reducing your profit in that period.

Accounting for Insurance Money received

In order to account for any insurance money received for the unit written off, you will need to know the Nominal Centres for your 'Unit Write-Off' and 'Bank Account'.

  • Go to " Nominal Ledger Journal Entries Cashbook Entry".
  • Select "Money in"
  • Enter the "Centre" for your bank account.
  • On the next line enter the centre for the Unit Write-Off.
  • Enter the "Date" that you received the payment from the insurance company.
  • At "Credit" enter the value of the insurance payout.
  • At "Comment" enter a suitable comment e.g. Unit 1234 Ins Payout.
  • Click [Done] and [Accept].

This posting should have the effect of reducing the value of Unit Write-Off on the accounts by the insurance pay out of the unit concerned, and decreasing the cost of sales in the month in question by the same amount hence restoring your profit in that period.

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
unit, vehicle, wholegood, caravan, agricultural machine, tractor, trailer, car, suv, motorcycle, motorbike, scooter, truck, van, lorry, motorhome, quad, atv, boat, tricycle, quadricycle, bicycle, bike, plant, written, write, off, write-off, insurance, value, motor, home
Tags

VS01