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
Accumulated Depreciation Disposed	The amount of accumulated depreciation removed from the total accumulated depreciation by the disposal process within the report date range (the "From" and "Through" dates), following the formula: Beginning Accumulated Depreciation + Regular Depreciation Expense + Disposal Catch-Up Depreciation Expense – After Disposal Accumulated Depreciation Amount (as of the Disposal Date). If multiple disposal events occur within the report date range, this column shows the total of the accumulated depreciation disposed of during the reporting period.
Asset ID	The asset's assigned ID
Status	The status of the asset (Active, Inactive, or Discontinued)
Description	The description of the asset
Category	The category the asset belongs to
Tag Number	The asset's physical tag number, if applicable
Original Asset ID	The ID of the original asset. Original Asset ID fields can be used when you want to indicate an improvement to an existing asset, or to track assets that have been reclassified or moved to a different location. It is not a required field.
Taxable	Indicates whether the asset is taxable or not
Acquisition Code	An optional designation code, used to represent how an asset was acquired
Valuation Code	An optional designation code, used to represent the method used to determine the asset's value
Responsibility Code	An optional designation code, used to represent the group or person responsible for the asset
Location Code	An optional designation code, used to represent the physical location of the asset
Distribution Code	The distribution code, based on the asset's type
Asset Type ID	The asset's type
Asset Account	The general ledger asset account, based on the asset's type
Accumulated Depreciation Account	The general ledger asset account for accumulated depreciation, based on the asset's type
Cost	The cost or basis of the asset recorded in Maintain>Fixed Assets. The system does not track manual changes to this value that occur outside of the disposal process. If this value is updated directly without a corresponding manual General Ledger adjustment, the Net Book Value may become skewed.
Life	The life of the asset, displayed in months
Last Depreciation Date	The date when the asset was last depreciated
Beginning Accumulated Depreciation	The depreciation for the asset as of the beginning of the report date range (the "From" date). This amount includes calculations from: A - Adjusted Depreciations C - Calculated Depreciations D - Disposal Catch-Up Depreciations If a disposal happened before the "From" date, the disposal depreciation is included in this value. If applicable, the External System Accumulated Depreciation is used to derive this value if its accrual period occurs before the "From" date in the report.
Current Depreciation	The depreciation for the asset within the report date range (the "From" and "Through" dates). This amount includes calculations from: A - Adjusted Depreciations C - Calculated Depreciations If an asset was affected by disposals, you'll need to add the Disposal Depreciation (Accumulated) to this value to tie out the Ending Accumulated Depreciation. If applicable, the External System Accumulated Depreciation is used to derive this value if its accrual period falls within the "From" and "Through" dates of the report.
Ending Accumulated Depreciation	The total depreciation for the asset from the beginning of its depreciable life within the report date range (the "Through" date). This amount includes calculations from: A - Adjusted Depreciations Expense C - Calculated Depreciations Expense D - Disposal Catch-Up Depreciations Expense External System Accumulated Depreciation when the entirety of the external system accumulation period falls before or after the From date, but not after the Through dates of the report. The calculation accounts for the subtraction of the Accumulated Depreciation Disposed.
Acquisition Date	The date the asset was obtained
Begin Depreciation Date	The date the asset was placed into service, whether from MIP or an external system
Fully Depreciated	Whether the asset is fully depreciated, indicated by "Yes" or No"
Last Disposal ID	The most recent ID assigned to the disposal
Last Disposal Date	The date assigned to the disposal
Full/Partial Disposal	Indicates whether the disposal was a Full or Partial Disposal
Cost/Basis Disposed	The difference between the Before Disposal Cost/Basis and the After Disposal Cost/Basis, using the amounts within the report date range
Disposal Catch-Up Depreciation Expense	The "catch-up" depreciation accrued during the disposal process, accumulated within the report date range (the "From" and "Through" dates) If you're disposing of an asset between depreciation frequency periods, the system will first calculate and book the catch-up depreciation, then process the disposal. If multiple disposal events affect an asset within the report parameters, this column will show the accumulation of the disposal catch-up depreciation. Example: If your asset was last depreciated in March and you're disposing of the asset in June, if you have not processed regular depreciation between March and the disposal date, the system will create disposal catch-up depreciation records before it processes the actual disposal. If there are additional effects to the accumulated depreciation due to a disposal event, that value will be reflected in Accumulated Depreciation Disposed.
Gain/(Loss) on Disposal	The difference between the Cost/Basis Disposed and the Ending Accumulated Depreciation, using the amounts within the report date range
Net Book Value	The net value of the asset (Cost or basis minus Ending Accumulated Depreciation) The calculation uses the accumulated depreciation less the Accumulated Depreciation Disposed from the beginning of the asset's depreciable life through the "Through" date used in the report. The calculation accounts for depreciation history and disposals, and any accumulated depreciation generated outside the system. The Net Book Value includes calculations from: A - Adjusted Depreciations C - Calculated Depreciations D - Disposal Catch-Up Depreciations
Zero Book Value	Indicated with "Yes" or "No". Zero Book Value is a checkbox available on the asset's maintenance page through Maintain>Fixed Assets>Assets
External System Last Depreciated Date	The date the asset was last depreciated in a system outside of MIP Example: The asset was last depreciated on 12/31/2024 before moving to MIP in January 2025.
External System Months Depreciated	The total number of months the asset was depreciated in a system outside of MIP Example: The asset was depreciated for 12 months in 2024 before moving to MIP in 2025.
External System Accumulated Depreciation	The total accumulated depreciation for the asset recorded in a system outside of MIP, up to the External System Last Depreciated Date Example: The asset depreciated $1,000 per month for 12 months in 2024, for a total accumulated depreciation of $12,000. Note: An important reporting concept is the external system accumulation period, defined as the number of months between the Begin Depreciation Date and the External System Starting Point Last Depreciation Date. If the entirety of the external system accumulation period falls before the From date, the whole value of the External System Accumulated Depreciation will be rolled into the Beginning Accumulated Depreciation. If the entirety of the external system accumulation period falls between the From and Through dates of the report, then it must be added to Adjusted, Calculated, and Catch-up Depreciation to tie out the Ending Accumulated Depreciation for the report.

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.