Mr. Ancentus Okwengo is the sole proprietor of a small business. The following trial balance
was extracted from his books at 31 March 2000.

Additional information:

1. Closing stock on 3 1 March
2000 was Sh.2, 008,000.
Loose tools at valuation
Sh.384, 000.
2 .Provision is to be made for the following amount
owing on 3 1 March 2000: Electricity and power
Sh.192,000.
3. Payments in advance on 31 March
2000 were as follows: Van licenses
Sh.2,520 and rates Sh.13,800.
4. Depreciation on plant and machinery and delivery vans is to be provided at the rate of
20% and 25% respectively on cost at the end of the year.
5. Bad debts amounting to Sh.26,000 are to be written off and the provision for
doubtful debts is to be 10% of trade debtors.
Required:
A ten-column worksheet for the year ended 31 March 2000.
 

Capital Freehold land and buildings (at cost) Plant and machinery at cost Provision for depreciation - plant and machinery Delivery vans Provision for depreciation - delivery vans Loose tools at valuation on 1 April 1999 Stocks 1 April 1999 Purchases Loose tools Sales Wages and Salaries Rates and Insurance Repairs and maintenance of buildings Sales expenses including vehicle running costs Electricity and power Industrial training levy Administration expenses Provision for doubtfuldebts Debtors and Creditors Drawings Bank Cash in hand Sh. ,,000 Sh. ,,000 4,896 3,600 3,480 960 288 2,232 4,440 192 5,288 384 240 344 1,440 72 672 1,984 480 24 26,120 1,680 672 15,840 240 1,928 864 26,120