Accountancy Forum

Full Version: fixed assist register in excel form with formulas
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi
does someone have fixed assist register in excel form with formulas?

Thanks
Dear,


Following is the information required under TR of ICAP that a company should keep for its fixed assets. You can make columns in MS Excel accordingly.

Fixed Assets records

Adequate itemized record of fixed assets should be maintained which at minimum must indicate following particulars
(a) detailed description of each item
(b) original cost of the item
© date of its acquisition
(d) classification of the item
(e) the location and/or the custodian of the item
(f) the rate of depreciation
(g) accumulated depreciation
(h) depreciation charge for the period
(i) the department / cost center / product to which the depreciation is charged
(j) date of revaluation (if any)
(k) revalued amount (if any) of the items
(l) depreciation on revalued amount
(m) accumulated depreciation on the revalued amount

In case of any query about depreciation, kindly post your brief questions.

Regards,