Excel Spreadsheets: Asset Register PRO 5.2

Straight line depreciation registers with MACRS version for USA

Start by entering up to 25 separate asset categories (computers, office equipment, autos, etc) that are really specific to your organization. Each Category has an assigned number (1–25).

Category numbers are a really easy way to combine and track records within each asset class. You enter Category numbers into the register each time you create a new record and this classes the asset within the register.

You enter Category numbers into the register each time you create a new record and this classes the asset within the register
Click to enlarge

The register is really easy to use, and there is capacity for 10,000 records.

The asset register calculates depreciation and month end book value for each asset and for all assets, combines category balances and reports all these in the Summary table.

You can copy existing asset records held in Excel into Asset Register 5.2 if you wish using the regular Copy > Paste.

The asset register calculates depreciation and month end book value for each asset and for all assets, combines category balances and reports all these in the Summary table
Click to enlarge

You can retrieve records and balances from the register using built-in Excel Lookup functions.

You can retrieve records and balances from the register using built-in Excel Lookup functions
Click to enlarge

Asset disposal removes the asset from the depreciation records, and calculates gain/loss at the date of disposal.

Asset disposal removes the asset from the depreciation records, and calculates gain/loss at the date of disposal
Click to enlarge

You can change the month end date backwards (or forwards) to recalculate accumulated depreciation and book value balances at any selected month end.

You can change the month end date backwards (or forwards) to recalculate accumulated depreciation and book value balances at any selected month end
Click to enlarge

For example turning the June 30, 2005 register back 6 months recalculates balances at the end of 2004.

For example turning the June 30, 2005 register back 6 months recalculates balances at the end of 2004
Click to enlarge

MACRS version for USA

In a separate and additional version, customers in the USA can calculate and summarise annual MACRS balances.

The Macrs version asset register contains four additional columns that bring MACRS current year depreciation calculations into the register.

The Macrs version asset register contains four additional columns that bring MACRS current year depreciation calculations into the register
Click to enlarge

MACRS annual depreciation totals for each Category are provided in the Summary table together with the current year difference between total straight line and Macrs depreciations, for deferred tax calculations.

MACRS annual depreciation totals for each Category are provided in the Summary table together with the current year difference between total straight line and Macrs depreciations, for deferred tax calculations
Click to enlarge

The MACRS depreciation tables provided work with 3/5/7/10/15 & 20 year MACRS write down periods. Separate 27.5 years and 39 year real estate depreciation tables are provided, however 27.5 years and 39 year are not included in the Macrs depreciation calculations.

Order

Additional Information: Asset Register Pro 5.2

30 day money-back guarantee!

Buy Online

buy.gif (540 bytes)

$169.95

Please see also:

All Programs Gold Edition - contains Asset Register Pro and many other programs (just $169.95)

30 day money-back guarantee!

 
Additional Information: All Programs Gold Edition
30 day money-back guarantee!

Buy Online  $169.95

buy.gif (540 bytes)

Regular Price : 169.95


Copyright © Millennium Software All Rights Reserved