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 (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 summarize 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
Fixed Asset Accounting With MACRS For Excell
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
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