Member Since: 29th Nov 2012
22nd Oct 2019
First format the date column to have full year as 00/00/2019.
after typing dates up to December 31st, select the column and FIND ,Replace 2019 with 2018. From January it will be 2019 only. It will be hardly a minute's work.
If you put '18" only for the year and replace with '19'then dates '18' appearing in each month also will be replaced with '19'.
18th Nov 2016
Already there is a Basic Excel tutorial that appeared in AccountingWEB sometime back. You can explore whether that will be help.ful
30th Jun 2013
Writing off WIP
The last year entry was the wrong thing.You should have credited the trading account and debited WIP. This year you should credit WIP and debit Trading account/Cost of sales and show a loss of £2000 as you have rightly concluded.