Asset Register PRO for Excel supplies nine asset registers plus YTD depreciation reports for fixed, intangible and investment assets, updating and reporting depreciation calculations and book values at each month end. Each asset entered into the register can contain the asset sequence number, date of purchase, description of asset, serial number, supplier's name, purchase order number, G/L reference code, accounting cost, useful life (depreciation period), physical location, plus if/when disposed/sold and gain/loss calculations and impairment ledgers for investments, intangibles and goodwill. Asset Register PRO can be used by the smallest to the largest enterprise to keep track of their assets and monthly depreciation calculations. Asset Register PRO applies the straight-line depreciation method, and the declining balance method adjusted annually and monthly. Depreciation tables supply monthly depreciation and cumulative depreciation from the acquired date to any period up to 240 months.
Quick and easy entry of assets into the registers using Excel's Data (Entry) > Form with the Name box.
Asset Register PRO provides continuous month end sequencing so that the asset class registers update each asset depreciation and book value every month automatically and combines all month end values into a Year To Date and Totals report. Different depreciation periods can be applied to individual assets and within each class of assets.
Asset Register PRO calculates book values at disposal dates and gain/losses on disposal.
All month end depreciation calculations and book balances can be recalculated backwards and forwards to any month end date by making a simple one step adjustment to the month end date held in the adate field. You can recalculate and forecast depreciation totals and written down balances for any month end past or future. Such calculations can be very useful for preparing financial business forecasts and for checking depreciation calculations.
Tell us your experience with TFP Asset Tracker for Excel2011.1105
RELATED PROGRAMS Our Recommendations
Portfolio Asset Tracker FREE Portfolio Asset Tracker allows you to group and track US investments by asset classes that you define. Prices are periodically pulled down and the performance of each asset class is instantly updated. With Asset Tracker you can: * View the day's performance summary in one glance * See... Download
Lodge Tracker TRIAL Lodge Tracker is a great application for masonic lodges to:Track and Manage Members that are: In good standing, Demitted, Suspended, Expelled, Masons that are currently in work by: EA Degree, FC Degree, Enter/Edit member information, Get current real time statistical information regarding:... Download
Fixed Asset Management TRIAL ExcelSoft® Fixed Asset 2.0 is designed to manage and to tract all company’s asset, from Acquiring, Service/maintenance, Custodian, to Warranty issue. Easy to navigate TreeView, user can group/sort and access the status with single click – minimum learning process. It supports various... Download