Free asset register download

However, if you need a more advanced asset management system, there are numerous software solutions designed for just that purpose. But, give the Vertex42 template a whirl and let me know if there are things you'd like it to do that it currently does not. Optimize your IT asset management process and minimize security risks Netwrix Auditor complements IT asset inventory and management tools by enabling control over hardware, software and other critical assets in your IT environment, so that you can adhere to ITAM best practices.

Simplify regular Windows Server inventory, enable better control. Download this College Fixed Asset Register Template and prepare an asset tracking register that can help in the tracking process.

Maintenance of Fixed Asset Register Example. Depending on your intended use, you may not need all of the columns, or you may want to add more. For example, if you don't put ID tags on your equipment, you may not need the 'ID' column. Though, if you are really interested in tracking your equipment, you may want to consider ID tags. The asset tracking template also contains a Suppliers worksheet, so you can keep track of supplier contact information for repair, maintenance, and warranty purposes.

Our business model is simple. No need to pay hefty license free for software as like other software , we are giving software as a service SAS , subscribe to any plan with nominal charge for hassle-free usage.

Note: After reviewing the filtered data, you need to clear the filter in order to display all the asset records on the sheet. A filter can be cleared by simply clicking the selection arrow next to the appropriate column heading again and clicking the "Select All" option. All asset transactions must be recorded on the Transact sheet.

There are basically 2 types of transactions that can be recorded namely acquisitions and disposals. An asset transaction can be recorded by entering the required data into the user input columns - the column headings of all user input columns contain a yellow cell background while the column headings with a light blue cell background indicate that these columns contain formulas which are automatically copied for all new transactions that are added to the sheet.

Note: Recording an asset number on the Assets sheet will have no effect in terms of recording the cost of an asset in the fixed asset register.

An acquisition transaction needs to be recorded on the Transact sheet for each fixed asset that is acquired before the appropriate asset values will be included in the fixed asset register on the Assets sheet and the summaries on the Category and Class sheets. Note: All the columns on the Transact sheet have been included in an Excel table. You can therefore add a new transaction by simply entering a transaction date in column A - the table will then automatically be extended to include the new transaction.

The following user input is required in the user input columns on the Transact sheet the columns with yellow column headings : Transaction Date - enter the date of the transaction. Transaction Type - select the transaction type from the list box. The ACQ option should be selected for all asset acquisitions and the DIS option should be selected for all asset disposals. Asset Number - select the appropriate asset number of the asset to which the transaction relates from the list box in this column.

All the asset numbers that have been added to the Assets sheet will be available for selection. You therefore need to create an asset number for the appropriate fixed asset on the Assets sheet before you will be able to record any transactions for the particular fixed asset. Supplier - enter the name of the supplier from which the asset has been acquired.

If a disposal transaction is recorded, you can enter the name of the customer in this column. Document Number - enter the document number of a supporting document which will enable you to trace the transaction back to its supporting documentation. For acquisitions, this should be the supplier invoice number and for disposals, the customer invoice number.

Amount - enter the transaction amount in this column. For acquisitions, the supplier invoice amount should be entered exclusive of any sales tax. For disposals, a nil amount should be entered. Lifetime in Years - enter the estimated lifetime of the asset in years for all acquisition transactions in this column.

For disposals, enter a nil value in this column. Note that if an asset should not be depreciated, a nil lifetime needs to be specified in this column. Residual Value - if the asset that is being acquired has a residual value, this residual value should be entered in this column. The residual value affects the depreciation calculations in that the residual value is deducted from the cost of an asset in order to calculate the total amount that will be depreciated over the lifetime of the asset.

A nil value should be entered for all disposal transactions. Proceeds on Sale - if a disposal transaction is being recorded, enter the proceeds on the disposal of the asset in this column. The proceeds should equal the total amount that is received for the asset. If an asset is being scrapped, enter nil in this column. A nil value should also be entered for all acquisition transactions.

The Transact sheet also includes 7 calculated columns - the column headings of all the calculated columns contain a light blue cell background. All of these columns contain formulas which are automatically copied for all new transactions that are added to the sheet. Error Code - if there is a problem with the input in any of the user input columns, an error code will be displayed in this column.

Category - the asset category is looked up on the Assets sheet based on the asset number that is specified in column C. This column is included for information purposes only. Transaction Date ID - the formula in this column is based on the transaction date which is entered in column A.

Transaction Amount - the formula in this column is based on the amount which is entered in column F. Historical Cost -the formula in this column is based on the amount which is entered in column F for all acquisition type transactions. Current Lifetime - the formula in this column is based on the asset lifetime which is entered in column G.

Current Residual - the formula in this column is based on the residual value which is entered in column H. Note: Only one acquisition transaction can be recorded for each asset because an asset can only be acquired once. If an asset is scrapped which is recorded as a disposal and subsequently needs to be added back to the fixed asset register, a new asset number should be used for this purpose.

The recording of duplicate asset acquisitions will result in an input error in the Error Code column and may also result in inaccurate template calculations. Note: All the depreciation calculations that form part of the fixed asset register are automated and you therefore do not need to record any transactions in order to record any monthly or annual depreciation amounts.

Also note that all the automated calculations in this template are based on the review date that is specified on the Assets sheet. You can therefore roll the template forward for subsequent periods or back to previous periods by simply changing the review date on the Assets sheet.

All the column headings on the Transact sheet contain a filter selection arrow. The following error codes may result from inaccurate input on the Assets and Transact sheets and will be displayed in the Error Code columns on the appropriate sheet. The heading of the affected input column will also be highlighted in orange in order to indicate that an error is present in the appropriate column:.

Note: Input errors may result in inaccurate template calculations and it is therefore imperative that all errors are resolved before reviewing the fixed asset register balances and processing any general ledger journal entries. The Category sheet contains a fixed asset register summary for all the asset categories that are created on the Set-up sheet. Individual assets are linked to a fixed asset category by selecting a category in column E on the Assets sheet.

No user input is required on the Category sheet. Note: Only the first 30 asset categories are included on the Category sheet by default but you can add additional asset categories if required to the sheet by simply copying the formulas in the last row that contains data into the appropriate number of additional rows. Note: If you want to view the detailed fixed asset records that make up the totals on the Category sheet, you can apply a filter to the Category column on the Assets sheet by clicking the selection arrow next to the column heading and selecting the appropriate asset category.

The totals above the column headings will equal the amounts that are reflected on the Category sheet. Note: The Category sheet is compiled based on the review date that is specified in cell E2 on the Assets sheet.

If you therefore want to amend the reporting period for which the asset category summary is compiled, simply enter a new review date on the Assets sheet. The Class sheet contains a fixed asset register summary for all the asset classes that are created on the Set-up sheet.

Individual assets are linked to a fixed asset class by selecting an asset category in column E on the Assets sheet. Each asset category is linked to a separate asset class by selecting the appropriate asset class in the asset category set-up on the Set-up sheet.

No user input is required on the Class sheet. Note: The template accommodates a maximum of 30 asset classes on the Class sheet. This should be more than sufficient for any business because the asset classes are used for financial statement reporting purposes. Note: If you want to view the detailed fixed asset records that make up the totals on the Class sheet, you can apply a filter to the Class column on the Assets sheet by clicking the selection arrow next to the column heading and selecting the appropriate asset class.

The totals above the column headings will equal the amounts that are reflected on the Class sheet. Note: The Class sheet is compiled based on the review date that is specified in cell E2 on the Assets sheet. If you therefore want to amend the reporting period for which the asset class summary is compiled, simply enter a new review date on the Assets sheet.

The Journals sheet contains an automated report of the recommended journal entries that need to be processed in order to account for all fixed asset transactions in a general ledger. The general ledger journal entries on this sheet are compiled on an asset category basis because each asset category is linked to a general ledger account for each of the transaction types that are included in the template.

Note: Only the first 30 asset categories are included on the Journals sheet by default but you can add additional asset categories if required to the sheet by simply copying the formulas in the last row that contains data into the appropriate number of additional rows. Note: The Journals sheet is compiled based on the review date that is specified in cell E2 on the Assets sheet. If you therefore want to amend the reporting period for which the automated journal report is compiled, simply enter a new review date on the Assets sheet.

The general ledger journal entries on the Journal sheet can be compiled on a month-to-date MTD or a year-to-date YTD basis by simply selecting the appropriate period from the list box in cell E2.

All the journal entry amount calculations are automatically updated. Each general ledger journal entry consists of four columns which contains two sets of accounts and amounts. The account numbers that are included on the Journal sheet are determined based on the general ledger accounts that are linked to each asset category on the Set-up sheet. In terms of the journal entry amounts, a positive value refers to a debit entry and a negative value refers to a credit entry.

There are 5 general ledger journal entries on the Journals sheet - the purpose of each of these journal entries can be summarized as follows:. Note: If you want to analyse the values that have been included on the Journals sheet, we recommend that you refer to the Category sheet or that you apply the Filter feature to the asset records on the Assets sheet in order to analyse the journal amounts for a specific asset category. How to use the Basic Fixed Assets Register template Download the sample or trial version when reviewing these instructions.

Template Set-up The template can be customized for your business by editing the business details, asset categories and asset classes on the Set-up sheet. Asset Classes The template includes 6 default fixed asset classes which can be customized in the cell range from cell A17 to cell B Asset Categories The template includes 11 asset categories which can be customized in the cell range from cell A27 to cell G The accounts that need to be entered in each column are better described as follows: Cost - the general ledger accounts that are entered in this column reflect the cost of each asset category.

These accounts should therefore be balance sheet accounts. Accum Depr - the accounts in this column reflect the accumulated depreciation that has been written off against each asset category. Depr - the total depreciation charges for each asset category is allocated to the accounts in this column. These accounts should therefore be income statement accounts.

Profit - if assets are sold, the profits or losses on the disposal of assets are allocated to the accounts that are specified in this column. You can again use a single account for all asset categories or enter separate accounts for each asset category. These accounts should be income statement accounts. Input Error Codes The input error codes at the bottom of the Set-up sheet are included for information purposes only and provide users with a reason for the error codes that may be encountered when entering transactions on the Assets and Transact sheets.

Asset Set-up Each individual fixed asset must be added to the Assets sheet by assigning an asset number to the fixed asset. Maintenance of Fixed Asset Register Example hprural.

In this PDF format template, you can see the guideline that has been provided in case of managing the fixed asset by a public service organization for rural development. Similarly, you can create a schedule for managing your fixed asset tracking following those guidelines.

Fixed Assets Register Example comfsm. In this Fixed Assets Register Example template you are getting the example of the fixed asset managed by a college for a very long time. Using this as a base, edit the content and modify it to get your asset inventory. Fixed Assets Register Template padburyparishcouncil. Then go for this Fixed Assets Register Template and prepare the give your sample asset register this structure.

As you can see in this template you can provide the asset description, location, facilities, and the valuation. There are four columns that are provided in this template. You can change the labels of these columns if you want since the whole template is customizable.

In simple terms, the register acts as a manager of all the fixed assets of the company. Download this sample asset template that can help you to draft a complete and comprehensive register for your fixed assets. Sample Fixed Assets Register Template sanjayaditya.

Download this Fixed Assets Register in DOC and map out a simplified method of the proper administration of the fixed assets. This professional asset template comes in the DOC format, therefore you can customize the content of this template in the DOC editor 8.

Basic Fixed Assets Register Example winsford. With this template, you can get the basic idea of creating a register. Download this Basic Fixed Assets Register Example template and make the full utilization of this efficient asset template by modifying every bit of it with your own words and content. Hurry and download now. Fixed Asset Register in Excel networknorth.