Accountancy Forum
fixed assist register in excel form with formulas - Printable Version

+- Accountancy Forum (https://www.accountancy.com.pk/forum)
+-- Forum: The Profession (https://www.accountancy.com.pk/forum/forumdisplay.php?fid=4)
+--- Forum: Accounting and Audit (https://www.accountancy.com.pk/forum/forumdisplay.php?fid=7)
+--- Thread: fixed assist register in excel form with formulas (/showthread.php?tid=9092)



fixed assist register in excel form with formulas - Riftaj - 11-04-2010

hi
does someone have fixed assist register in excel form with formulas?

Thanks


- ciapk - 11-04-2010

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,