Developer : International Company Services
Excel Templates for accountingOur Asset Register for Excel will help you record asset costs, establish current depreciation and book value by class at each month end incorporate tracking codes for locations and managers responsible.
Using Excel time and date functions you can quickly see all your monthly and cumulative depreciation values as totals, by departments and by individual assets, plus book values.
You can switch the current month end backwards or forwards to calculate depreciation at a year-end or alternative period end.
Users can change class standard lives with different depreciation periods and can look up the current balance and age of any asset using bar codes or codes.
Registers include Office Equipment, Computers, Machinery, Buildings, Leasehold, Autos, Investments, Intangibles and Goodwill. Investments, Intangibles and Goodwill include impairment adjustments
Depreciation and month end book value for each asset and for all assets, combines category balances and reports all these in the Summary table
Built-in Excel Lookup functions
Gain/loss at the date of disposal
Accumulated depreciation and book value balances at any selected month end
Balances at the end of Year
MACRS version for USA
Asset costs, useful lives, current monthly depreciation, cumulative depreciation
Disposal gains & losses records, audit verification
Annual and monthly declining balance tables
Platform : Windows XP/Me/9x/NT/2000/2003or later or Mac OS
Web Data Requires:
Excel 2000 or later and MS Windows XP/2000/2003 or later.
Please note that you also may want to purchase our 'Financial Excel Collection' - large collection of financial programs - as it contains this product.
30-day Money Back Guarantee!
Asset Depreciation / Excel & Office365
More International Company Services
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates
Copyright © International Company Services All Rights Reserved