More information

Depreciation Calculation

Access this report using Reports>Fixed Assets>Depreciation Calculation.

Use this report to print the untransferred calculated, adjusted, and disposed depreciation. The information contained in this report is derived from the calculations and adjustments made using Activities>Fixed Assets>Calculate Depreciation, Review/Adjust Depreciation, and Enter Disposals.

This report contains:

Additional items, columns, and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box and are listed as an available filter. User defined fields with a field type of Currency follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).
Currency fields which follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Calculation ID	The ID assigned for the calculation using Activities>Fixed Assets>Calculate Depreciation.
Calculation Date	The date assigned for the calculation using the Calculate Depreciation form.
Date	The date based on the depreciation type. The only date displayed is for Calculated Depreciation. This date is not available for Adjusted Depreciation (A) or Disposed Depreciation (D).
Acquisition Code	Represents a group of assets acquired at the same time. It was selected on the Maintain>Fixed Assets>Assets>Asset tab.
Location Code	Represents the location of an asset. It was selected on the Asset tab.
Responsibility Code	Represents the group or person responsible for the asset. It was selected on the Asset tab.
Valuation Code	Represents the method used to determine the value of the asset, such as cost, donated, and fair market value. It was selected on the Asset tab.
Category	The category associated with the Asset ID. Categories were created on the Asset tab.
Asset ID	The ID assigned to the asset on the Asset tab.
Description	The description assigned to the asset on the Asset tab.
Status	The status assigned to the asset on the Asset tab.
Acquisition Date	The date the asset was obtained. This date was entered on the Maintain>Fixed Assets>Assets>Asset tab.
Cost or Basis	The cost or basis of the asset. This amount was entered using the Maintain>Fixed Assets>Assets> Depreciation tab.
Salvage	The salvage value of the asset (the expected net recovery when the asset is sold at the end of its useful life). This value was entered on the Depreciation tab.
Amount to Depreciate	The amount to depreciate (the sum of the Cost minus the Salvage Value). This value was calculated on the Depreciation tab.
Life	The life of the asset. It displays in months, not years. This number was selected on the Depreciation tab.
Last Depreciation Date	The date when the asset was last depreciated. This date was entered on the Depreciation tab.
Asset Type	The ID assigned to the asset type. Asset types were created using the Maintain>Fixed Assets>Asset Types form.
Depreciation Code	The code selected on the Maintain>Fixed Assets>Asset Types form. The depreciation code could be a standard code or a custom code that was created using the Maintain>Fixed Assets>Custom Depreciation Codes form.
Switch Depreciation Code	The alternate depreciation code you selected on the Maintain>Fixed Assets>Asset Types form.
Method	The calculation method for the depreciation code-FA, PD, PN, TD, or TN. This method was selected using the Maintain>Fixed Assets>Fixed Assets>Custom Depreciation Codes>Calculation Method tab.
Depreciation Type	The depreciation type. The report displays a C for Calculated Depreciation, an A for Adjusted Depreciation, or a D for Disposed Depreciation. For more information on depreciation types, see the Activities>Fixed Assets>Review/Adjust Depreciation form.
Depreciation Description	The description based on the Depreciation Type. If it is an Adjusted Depreciation, the description was entered on the Review/Adjust Depreciation form. If it is a Calculated or Disposed Depreciation, the system assigns the appropriate description.
Depreciation Date	This date is system generated. The calculation date entered using the Activities>Fixed Assets>Calculate Depreciation form determines the depreciation date, along with the Fiscal Year-Ending date (File>New Organization). For example, if the ending date is 12/31/20xx, the depreciation date is set for the end of every month.
Distribution Code	The distribution code for the asset type selected on the Asset Type tab.
Expenditure Account	The expenditure code for the asset type ID selected on the Asset Type tab.
Accumulated Depreciation Account	The general ledger asset account (FAO account type) for accumulated depreciation. This code was selected on the Asset Types form.
Accumulated Depreciation Amount	The amount for the accumulated depreciation that was entered using the Maintain>Fixed Assets>Assets>Depreciation tab.
Taxable	A designation of Yes or No, depending on if the Taxable check box was selected using the Maintain>Fixed Assets>Assets>Asset tab.
Amount	The amount based on the depreciation type. For example, if the depreciation was adjusted on the Review/Adjust form, the amount displays here. Otherwise it is based on the Calculated or Disposed Depreciation amount.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to set up any Available Options for the report.

Options	Description
Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.