Fixed Asset Accounting With MACRS For Excel supplies nine asset registers plus YTD depreciation reports for fixed, intangible and investment assets, updating and reporting depreciation calculations and book values at each month end. Calculates number of asset records by Asset Class and the average purchase cost by Asset Class. An Asset Class can be any description you choose which categorizes assets into families with the same depreciation period. There are 10 possible Asset Classes By on it's own or part of All Excel Templates HUGE Value - 80% Discount.
About Fixed Asset Accounting With Excel
Fixed Asset Accounting With Excel for Excel supplies nine asset registers plus YTD depreciation reports for fixed, intangible and investment assets, updating and reporting depreciation calculations and book values at each month end. Each asset entered into the register can contain the asset sequence number, date of purchase, description of asset, serial number, supplier's name, purchase order number, G/L reference code, accounting cost, useful life (depreciation period), physical location, plus if/when disposed/sold and gain/loss calculations and impairment ledgers for investments, intangibles and goodwill.
Fixed Asset Accounting With Excel can be used by the smallest to the largest enterprise to keep track of their assets and monthly depreciation calculations. Asset Register PRO applies the straight-line depreciation method, and the declining balance method adjusted annually and monthly. Depreciation tables supply monthly depreciation and cumulative depreciation from the acquired date to any period up to 240 months.
Quick and easy entry of assets into the registers using Excel's Data (Entry) > Form with the Name box.
Fixed Asset Accounting With Excel provides continuous month end sequencing so that the asset class registers update each asset depreciation and book value every month automatically and combines all month end values into a Year To Date and Totals report. Different depreciation periods can be applied to individual assets and within each class of assets.
Fixed Asset Accounting With Excel calculates book values at disposal dates and gain/losses on disposal.
All month end depreciation calculations and book balances can be recalculated backwards and forwards to any month end date by making a simple one step adjustment to the month end date held in the a date field. You can recalculate and forecast depreciation totals and written down balances for any month end past or future. Such calculations can be very useful for preparing financial business forecasts and for checking depreciation calculations.
Provides asset confirmation fields for audit purposes.
Fixed Asset Accounting With MACRS For Excel $189.95 Or, 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.
See Also: Excel Templates Index & Financial Software Index & Financial Calculators Index or, Super Amortization Loan Software | Amortization Schedules & Interest | Quick Calculation Amortization | Amortization Software | Appreciation Calculator | Financial Advisor | Quick Calc Mortgage & Loan Manager
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