Asset transactions are limited to acquisitions & disposals. Transact - all asset transactions need to be recorded on this sheet. The period for which the fixed asset register is compiled is determined by the review date that is specified at the top of the sheet.

User input is limited to entering an asset identification number, asset description, asset type, asset category and depreciation basis. A complete list of user input error codes are also included on this sheet for information purposes.Īssets - this sheet enables users to create a unique asset code for all fixed assets and the columns with the light blue column headings contain all the comprehensive, automated calculations that form part of the fixed asset register. You can enter your business name, select a year end period, specify whether depreciation needs to be calculated on a monthly or daily basis, specify how to treat depreciation calculations on additions & disposals, maintain the default fixed asset classes and maintain the default fixed asset categories. Set-up - the input cells on this sheet enable you to customize the template for your business. The following sheets are included in this template: Note: This template only enables users to enter additions & disposals - if you require a solution which enables you to also enter revaluation & impairment transactions, we suggest that you refer to our IFRS Fixed Asset Register template which accommodates these transactions but only on a straight-line depreciation basis. The template accommodates depreciation calculations based on the straight-line, diminishing value and double diminishing value calculation methods on a monthly or daily basis. This basic asset register template enables users to compile a complete fixed assets register which incorporates an unlimited number of fixed asset classes and categories facilitates recording additions & disposals automatically calculates monthly and year-to-date depreciation charges and includes a comprehensive automated journal report.

Stock register format in excel