Calculate Depreciation

Access this form using Activities>Fixed Assets>Calculate Depreciation.

Use this form to calculate depreciation for assets. The system determines the depreciation dates for these calculations, based on the Calculation Date and the organization's calculation Frequency. (With Administrative user rights, you selected a frequency for the organization using Organization>Set Up Modules>Fixed Assets.) If you want to include the entire month, quarter, or year in the calculation, you must enter the last day of the month, quarter, or year as the Calculation Date.

Note: If you make a change on this form or related forms (such as Maintain>Fixed Assets>Assets, Asset Types, or Custom Depreciation Codes) after the calculation process, you need to re-calculate. This ensures that any changes made are reflected in the calculation.

The system does not display assets if they exhibit one of the following criteria:

  • The asset type has a depreciation code of "No-No Depreciation Calculated."
  • A full disposal exists for the asset.
  • There is already a calculation for the current Depreciation Date.
  • The asset has the Zero Book Value check box selected.

Calculation Information

  • Calculation ID: Enter an ID for this calculation, or select one from the drop-down list. We recommend using all numeric IDs. Numeric IDs are generally easier and faster to enter during transaction entry. We also recommend limiting your entry to strictly alphabetic characters (A through Z) or numeric characters (0 through 9), and avoiding the use of symbols.
  • Calculation Date: Enter a valid date for this calculation.

Select Asset From

  • Category: If you select this option button, all the categories that you set up using the Maintain>Fixed Assets>Assets form display in the Calculate Items group box. (Remember, categories contain a group of assets. If you select a category, in essence, you are selecting all assets in the category.)
  • All Assets: If you select this option button, all the assets you created using the Assets form or the Asset Quick Entry form display in the Calculate Items group box. The asset's description and the date it was last depreciated also display in the group box.

Calculate Items Available Items, Selected Items: To select a category or asset for calculation, highlight it in the Available Items box, and then click the Mover ( > ) to move it to the Selected Items box.

  • When you close a fiscal year (Activities>Close Fiscal Year), you will not be able to depreciate assets that have a Last Depreciation Date within that fiscal year. Furthermore, if the asset has a Status of Discontinue/Disposed, it cannot be changed after the year is closed.
  • If you need to add Basis to an Active asset that is fully depreciated, you will need to create a new asset if the Last Depreciation Date for the asset is in a closed year. Depreciation cannot be transferred to a closed year (Activities>Fixed Assets>Transfer Depreciation/Disposals).
  • When setting up or importing assets, verify that the Last Depreciation Date, Accumulated Depreciation Amount, and Months Depreciated are correct before calculating and transferring to your general ledger (Activities>Fixed Assets>Transfer Depreciation/Disposals). If you have not already done so, you need to make a journal voucher entry (Transactions>Enter Journal Vouchers) to record the cost and accumulated depreciation amounts.
  • When you calculate depreciation you are crediting a contra account (accumulated depreciation) and debiting an expense account (depreciation expense).