Depreciation

This query is : Resolved

SUMUKHGB (Querist)
Follow

29 March 2013 Respected experts ,

I am doing a company audit and iam finding difficulty in entering depreciation schedule when there is a deletion /sale. my excel formula is not matching with the manual calculation i have done... can anyone guide me with this regard ?

If u have any example for the same plzupload...

CA Prashant Gupta

CA Prashant Gupta (Expert)
Follow

29 March 2013 I am taking it as compnies act depreciation

if asset cost was 1,00,000
depreciation till date 50,000
sale of asset 20,000

profit & loss will be 30,000

in depreciation chart asset will be less by 1,00,000 and depreciation till date will be less by 50,000

no effect of profit and loss

Message likes : 1 times