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.
Provides asset confirmation fields for audit purposes.
Buy individually or as part of the Analysis Collection for Microsoft Excel and save!
$35.00
ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models. Many studies reports that spreadsheet errors are the rule, and for many spreadsheet models, Microsoft Excel Audit tools are not enough.
MS Excel 2000 or later
More Info
TCO!stream Asset Manager $400.00 (not for Excel)
TCO!stream Asset Manager is an IT inventory management solution for small and medium size business. Provides full analysis of all hardware/software inventory and powerful reporting tools. You can use it for hardware/software auditing, license management, remote control and detail reporting on every PC in your network.
Cool Info 2001 (not for Excel)
Cool Info 2001 System Information, Analysis, Auditing and Inventory
Add/Remove
Plus! 2002 Mobile Kit $99.95 (not for Excel)
Perform easy uninstallations on any number of PCs and software audits
Add/Remove Plus! 2003 Mobile Kit helps IT personnel, consultants, technicians, VAR's, and MIS/IT managers to perform easy uninstallations on any number of PCs, keep only authorized and useful software, perform software audits to check for software license compliance, etc. The program is a better alternative to the Windows Control Panel uninstall feature and it also displays programs with a missing or bad uninstaller, helping you to locate programs that don't longer work.
Windows All Versions More Info