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.