info | details | screenshots | testimonials | FAQS
DepreciationWorks® uses a database to store asset data and perform calculations.
Depreciation Methods:
- Straight-line
- Straight-line over remaining life
- Declining balance: 200, 175, 150, 125 (or variable factor) and straight-line rate
- Declining balance options: convert to straight-line, leave residual at end of useful life, continue beyond useful life
- Sum of the years digits
- Fixed percentage on declining balance
- Part year conventions available: mid-month, half year, modified half year, full year, and more
Features include:
- Multiple companies; no limit on number of assets per company
- Data files movable to a network drive for concurrent multiple user access to shared data
- Rolling forward to next year accomplished by a simple annual closing
- Context sensitive help file and help information panel for each screen
- Defaults for salvage, depreciation method, life, property tax category, and general ledger accounts
- Quick grid feature for spreadsheet style asset entry
- Grids allow editing assets
- Voluminous assets entry with spreadsheet import
- Multiple asset retirement
- Gain/loss on asset disposals
- Unlimited short years
- Expensed property (below capitalization threshold period costs) tracked separately from assets
- Backup and restore included
- Database table optimize, verify, and repair included
- Transport data between computers running DepreciationWorks
- Shared calendar for scheduling events for fixed assets and personnel
Input Fields:
- Division: top level grouping for assets
- General ledger cost account number: 2nd level grouping for assets
- General ledger accumulated depreciation account number: for journal entries
- General ledger expense account number: for journal entries and departments
- Asset code: your identifier
- System number: automatic sequential identifier
- Description
- Description 2
- Memo: unlimited notes field
- Date acquired
- Date in service
- Date retired: multiple asset retirement supported
- Depreciation method: see depreciation methods below
- Useful life: in years with months entered as a decimal
- Intangible: Boolean
- Cost
- Salvage: optional
- Accumulated depreciation: calculates from any date placed in service to the beginning of the current fiscal year
- Override accumulated depreciation: Boolean
- Current year depreciation: calculated for the current fiscal year
- Override current year depreciation: Boolean
- Monthly depreciation: calculated based on the current fiscal year depreciation amount
- Sales Price
- Selling Expense
- Gain/loss on sale of asset: calculated
- Property type: assign defaults to property type for method, life, salvage, property tax category, and gl accounts
- Property tax category: for business property tax reporting by location
- Location: business property tax location
- Group code: user assigned groups linked to group table
- Vendor
- Manufacturer
- Serial number
- Manufacturer web address
- Custodian: user of asset
- User 1: user defined field
- Store multiple documents and pictures for each asset
- Expensed asset tracking
- Prior year retired asset archive
- Link asset records to calendar to schedule events for assets
Output:
- Reports grouped by division and general ledger cost account with grand totals for all divisions
- Monthly journal entries for accumulated depreciation and depreciation expense accounts
- Book depreciation schedules by month, quarter, and year for the current and next fiscal year
- General ledger reconciliation reports for additions and retirements
- Gain or loss on asset dispositions
- Other reports include net book value, depreciation expense by month, rolling year to date, quarterly expense and four year quarterly expense forecast, ten year depreciation expense forecast, and grouping reports
- Summary and detail reports for additions and retirements by property type for income tax preparers
- Retired assets for prior fiscal years saved to an archive in the database
- Business property tax statement summary as both a report and a grid
- Print reports to disk in various file formats including PDF, Excel®, Word®, and Text
- Grids are similar to reports and can be grouped and sorted by any field, printed or exported
- Grids are visual custom report writers
- On-screen pivot grids, like pivot tables, data mine
- Record of expensed property (period costs, not depreciated)
Download the free 30 day trial and explore DepreciationWorks' database integrity and spreadsheet-like ease of use.