MS Excel Templates: Accounting : register for recording assets, asset classes

Software : Finance : Asset Register PRO

Accounting Excel Templates

Product Rank:

Excel Templates for accounting

Now includes asset location location summaries, sorting records by any criteria. Straight line, double declining balance and declining balance options.

Asset Register PRO provides a complete ready-made register for recording assets, asset classes, dates of purchase, accounting expenses, depreciation periods, locations, General Ledger codes, and for calculating month end cumulative depreciations and written down values. The depreciation methods are straight line and declining balances.

Asset Register PRO supplies calculation of month end depreciation charges by item and by class, plus month book value, YTD and complete Register reports.

Registers include:

Office Equipment
Computers
Machinery
Buildings
Leasehold
Autos
Investments
Intangibles and Goodwill

Investments, Intangibles and Goodwill include impairment adjustments.

Select any register from Excel's Name box for quick and easy entry of assets into the register.

Scrolling right each register displays asset costs, useful lives, current monthly depreciation, cumulative depreciation and written down values at the month end date.

You can use Asset Register PRO to calculate depreciation and written down balances before or after the current month end with a simple change month entry. In this example Asset Register PRO forecasts depreciation and book values at the year end, 3 months ahead of the current month end date.

Scroll right again to review disposal gains & losses records. An audit verification checklist is provided.

The templates for intangibles and goodwill adjust written down balances for impairment.

The summary report supplies a complete overview of all asset classes, costs, cumulative depreciation and written down balances at the month end selected.

Asset register names can be changed by the user.

Depreciation tables are supplied for calculating the complete schedules for straight line, annual declining balances, and monthly adjusted declining balances.

More Info

Asset Register Excel Spreadsheets

Attitional Information

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

New

We have released upgrades to this product by adding in our new Business Budgets PRO spreadsheets. Business Budgeting PRO helps you prepare a 12 month business budget in double quick time. Includes actual monthly reporting and variance analysis for the current month and cumulative total and variances year to date.

Over 30 product rows and 100 expense categories plus cost of sales for each product/service line.

We called this new product Assset Register Pro Bonus Pack for Excel. It contains two financial applications for Excel, rather than one.

System Requirements

Platform : Windows XP/Me/9x/NT/2000/2003 or Mac OS

Web Data Requires:

Excel 2000 or later and MS Windows XP/2000/2003 or later.

Order

30-day Money Back Guarantee!