Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Monthly Depreciation & Book Value Calculations Plus Tables

 

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Fixed Asset Accounting With MACRS For Excel Start

Fixed Asset Accounting With Excel Screen Shots

Fixed Asset Accounting With Excel 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.

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

You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.

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 (125).

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

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

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

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

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

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

MACRS version for USA

In a separate and additional version, customers in the USA can calculate and summarize 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

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

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

Back to: Fixed Asset Accounting With MACRS For Excel Start

Fixed Asset Accounting With MACRS For Excell $169.95 $99.95 Secure Payment Options
Buy as part of All Excel Templates Gold Edition - HUGE Value - 80% Discount!

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS