Asset Register PRO 5.2 Excel Templates

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.

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.

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

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

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

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

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.

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.

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