- Start working with lease or loan schedules for your business plans.
- Update lease and loan repayment records - one payment at a time.
- Integrate with purchasing power factors for forecasting inflation values.
- Drag and drop schedules and reports from the web into Excel.
- Combine lease/loan accounts into summaries with averaged interest rate.
Our asset and lease accounting Excel workbook provides all you need to manage and keep track of up to 3,000 asset and capital lease accounting records. You can select straight line depreciation or declining/double declining deprecation methods for the Asset Register. You can export asset records from your current accounting package into Excel and copy the asset descriptions, purchase costs and dates of purchase straight into the Asset Register.
Each asset is defined by location (100 possible), asset class (100 possible), depreciation months and salvage percentage.
Individual assets can have their own unique depreciation life independently of the class assigned.
Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.
Depreciation totals are reported for any month end. Users can wind the month end date backwards or forwards to recalculate asset purchases, depreciation and book values by department and asset class for any selected date. |
