Fixed Assets and Databases

An enterprise, especially a huge 1, may well possess a big quantity of fixed assets. Prior to computerization these would have been kept in a manual fixed asset register. A database enables this fixed asset register to be stored in an electronic form. A database file for fixed assets may possibly contain most or all of the following categories of particulars.

• Code number to give the asset a one of a kind identification in the database
• Type of asset. For example motor car, leasehold premises, for published accounts purposes
• Even additional detailed description of the asset. For example serial number, car registration number, create
• Physical location of the asset. For example address
• Firm location of the asset. For example accounts department
• Person responsible for the asset. For example in the case of a enterprise owned vehicle, the Person who use it
• Firm expense of the asset
• Date of acquire
• Depreciation rate and method created use of to the asset
• Accumulated depreciation to date
• Net book price of the asset
• Estimated residual cost
• Date when the physical existence of the asset was final verified
• Supplier

Unquestionably, the information and facts kept about the asset would depend on the Sort of asset it is.

Any Sort of computerized fixed asset register record will strengthen efficiency in accounting for fixed assets taking into consideration of the ease and speed with which any necessary calculations can be created. Most apparent is the calculation of the depreciation provision which can be an especially onerous approach if it is completed monthly and there are frequent acquisitions and disposals and lots of one of a kind depreciation rates in use.

The particular benefit of employing a database for the fixed asset function is its flexibility in creating reports for many purposes. Aside from regular cost and net book cost info a database with fields such as those listed above in the record of each single asset could possibly possibly compile reports analyzing assets according to location say, or by manufacturer. This data could possibly possibly be produced use of to support compare the performance of many divisions, possibly, or to assess the useful life of assets supplied by diverse manufactures. There may possibly be as a huge quantity of Significantly way more possibilities as there are permutations of Individual pieces of data.

Operating with spread sheets

A spreadsheet is generally an electronic piece of paper divided into rows and columns with a built in pencil, eraser and calculator. It offers an swift way of performing numerical calculations.

The intersection of every single single column and row of a spreadsheet is referred to as a cell. A cell can include things like text, numbers of formulate. Use of a formula implies that the cell which consists of the formula will display the outcomes of a calculation based on data in other cells. If the numbers in those other cells adjust, the result displayed in formula cell will also adjust accordingly. With this facility, a spreadsheet is produced use of to make economic models.

http://accounting-help.blogspot.com/2010/07/198-fixed-assets-and-databases.html