More information

Summary Asset Ledger

Access this report using Reports>Fixed Assets>Summary Asset Ledger.

Use this report to print summary information for all assets which can include depreciation and disposal activities on any given date range. This report allows you to view information by asset for a specified period.

This report contains:

Some information is derived from the calculations and adjustments made using the Activities>Fixed Assets>Calculate Depreciation, Review/Adjust Depreciation, and Enter Disposals forms. Asset types were created using the Maintain>Fixed Assets>Asset Types form, while assets were set up using the Maintain>Fixed Assets>Assets form.
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 when the organization was created by the Administrator (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.

Current Transaction Dates are also required to specify the date range for the data included in 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
Asset ID	The ID assigned to the asset on the Maintain>Fixed Assets>Asset tab.
Status	The status assigned to the asset on the Asset tab-Active, Inactive, or Discontinued/Disposed.
Description	The description assigned to the asset on the Asset tab.
Category	The category associated with the Asset ID. Categories were created on the Asset tab.
Tag Number	The inventory number for the asset (Maintain>Fixed Assets>Asset).
Original Asset ID	The ID assigned to an asset on the Asset tab.
Taxable	A designation of Yes or No, depending on whether or not the Taxable check box was selected using the Maintain>Fixed Assets>Assets form.
Acquisition Code	Represents a group of assets acquired at the same time. It was selected on the Maintain>Fixed Assets>Assets>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.
Responsibility Code	Represents the group or person responsible for the asset. It was selected on the Asset tab.
Location Code	Represents the location of an asset. It was selected on the Asset tab.
Distribution Code	The distribution code for the asset type selected on the Maintain>Fixed Assets>Asset Types form.
Asset Type ID	The ID assigned to the asset type.
Asset Account	The general ledger asset account (FAO account type) for the asset. It was selected on the Asset Types form.
Accumulated Depreciation Account	The general ledger asset account (FAO account type) for accumulated depreciation. This code was selected on the Asset Types form.
Cost	The cost or basis of the asset. It is calculated as Cost plus disposal amount given that the disposal happened on or after the report From date on the Setup tab.
Life	The current life (in months) of the asset. This information was entered either on the Maintain>Fixed Assets>Assets form or on the Activities>Fixed Assets>Enter Disposals>Disposal tab.
Last Depreciated Date	The date when the asset was last depreciated.
Beginning Depreciation	The depreciation for the asset prior to the report From date entered on the report Setup tab. This amount uses calculations from: Adjusted Depreciations (A), Calculated Depreciations (C), and Disposed Depreciations (D). If the disposal happened before the report From date, this amount includes the disposal depreciation.
Current Depreciation	The depreciation for the asset between the report From and Through dates entered on the report Setup tab. This amount uses calculations from: Adjusted Depreciations (A), Calculated Depreciations (C), and Disposed Depreciations (D).
Accumulated Depreciation	The depreciation for the asset up to, and including, the report Through date entered on the report Setup tab. This amount uses calculations from: Adjusted Depreciations (A), Calculated Depreciations (C), and Disposed Depreciations (D). It also includes any accumulated depreciations (greater than zero) generated outside the system. The calculation also takes into consideration the subtraction of the Disposal Accumulated Depreciation if the asset has a status of Active or Inactive.
Acquisition Date	The date the asset was acquired. It was assigned to the asset using the Maintain>Fixed Assets>Asset tab.
Fully Depreciated	The system displays No if the asset is not fully depreciated and Yes if it is. The asset is fully depreciated (Yes) if the Amount to Depreciate and the Accumulated Depreciation Amount are equal. The asset is also fully depreciated if the Cost is zero, Salvage is zero, and Amount to Depreciate is zero.
Last Disposal ID	The most recent ID assigned to the disposal using the Activities>Fixed Assets>Enter Disposals>Asset tab.
Last Disposal Date	The date assigned to the disposal using the Enter Disposals>Asset tab.
Full/Partial Disposal	A designation of full or partial disposal. This information was selected using the Enter Disposals>Disposal tab.
Cost/Basis Disposed	The difference between the Before Disposal Cost/Basis and the After Disposal Cost/Basis. The system uses data between the From and Through dates chosen on the report Setup tab.
Disposal Depreciation	The difference between the Before Disposal Accumulated Depreciation and the After Disposal Accumulated Depreciation. This amount uses calculations from Disposed Depreciation (D). (This amount was originally entered using the Maintain>Fixed Assets>Assets>Depreciation tab. To view the current amount, use the Enter Disposals>Disposal tab.) It includes the additional months calculated. The system uses data between the From and Through dates chosen on the report Setup tab.
Gain/(Loss) Disposed Before Disposal Depreciation	The difference between the Cost/Basis Disposed and the Accumulated Depreciation Disposed. The system uses data between the From and Through dates chosen on the report Setup tab.
Net Book Value	The net value of the asset. It is calculated as Cost minus Accumulated Depreciation up to and including the report Through date entered on the Setup tab. This amount uses calculations from: Adjusted Depreciations (A), Calculated Depreciations (C), and Disposed Depreciations (D). It takes into account depreciation history and disposals, and accumulated depreciation generated outside the system.
Zero Book Value	A designation of Yes or No, depending on whether or not the Zero Book Value check box was selected on the Maintain>Fixed Assets>Asset tab.

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
Suppress Lines with All Zeros	Select this option, along with the Summarize Amounts option, so that documents with zero amounts do not print. If the debit and credit on the same line nets to zero then it is suppressed. For example, there is a GL code with a debit of $100 (USD) and a credit of $100 (USD) and it is on the same line with no other entries. The GL code will not appear on the report.

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 deselected by any user other than the user that locked the report.