Asset Reports

The Fixed Assets Management SuiteApp provides several reports that offer comprehensive reporting across assets, valuation and depreciation. With these reports, you can report on assets across locations, subsidiaries, asset types, and more.

Report values are organized by subsidiary and accounting book. Within a subsidiary and accounting book combination, the values are further organized per asset type.

Important:

Scripts triggered through script deployment does not have a corresponding FAM process record. The FAM process record is a required parameter for FAM scripts, and without it, the script will fail. You're recommended to use the appropriate user interface for running or generating FAM transactions and reports. The FAM process record is automatically created when scripts are triggered through the appropriate user interface.

Asset Register Report

This report lists cost, accumulated depreciation, and net book value for each asset between the periods selected. The system assumes that depreciation history records with blank Accounting Book fields are for the Primary Book. In the asset register report, these DHRs are displayed under the Primary Book.

The asset register report includes the following information:

Asset Type — This shows the class or type where the asset belongs to.
ID — This shows the asset ID.
Name — This shows the name of the asset record.
Depreciation Start Date — This shows the date when the asset depreciation started.
Asset Life — This shows the life of the asset.
Beginning Balance — This shows the balance of all assets before the report date. This column contains the following information:
- Beginning Cost — This shows the asset's acquisition amount before the report start date
- Beginning Depreciation — This shows the asset’s accumulated depreciation before the report start date.
- Beginning Net Book Value — This shows the asset’s net book value before the report start date.
Acquisitions — This shows the cost of all assets acquired within the report period.

Note:
If the asset is transferred to another class, department, or location, the Acquisition column shows the asset cost and the transferred amount.
Transfer — This shows the current cost of the transferred asset.
Sale — This shows the amount of assets sold during the report period.
Disposals — This shows the amount of assets written off during the report period.
Depreciation — This shows the accumulated depreciation within the report period.
Revaluation — This shows the adjustment made to the asset due to revaluation.
Write Down — This shows the asset’s write down amount.
Lease — This shows the lease adjustment amount. The previous period lease adjustment is considered in the computation of the cost beginning balance.
Net Book Value — This shows the asset's net book value at the end of the report period.

Asset Summary Report

This report shows the total cost, depreciation, and net book value for the selected asset types over the specified period. The system assumes that depreciation history records with blank Accounting Book fields are for the Primary Book. In the asset summary report, these DHRs are displayed under the Primary Book.

The report has the following sections:

The Cost section includes the following information:
- Beginning Balance — This shows the balance of the asset types at the start of the report period.
- Additions — This shows the cost of new assets acquired during the report period.
- Sale — This shows the amount of assets sold during the report period.
- Disposal — This shows the amount of assets written off during the report period.
- Revaluation — This shows the write-off amount.
- Ending Balance — This shows the balance of the asset types at the end of the report period.
The Depreciation section includes the following information:
- Beginning Balance — This shows the depreciation balance of the asset types at the start of the report period.
- Additions — This shows the depreciation for the report period.
- Sale — This shows the amount of assets sold during the report period.
- Disposal — This shows the amount of assets written off during the report period.
- Revaluation — This shows the depreciation adjustment.
- Ending Balance — This shows the total depreciation of the asset types at the end of the report period.
The Net Book Value section includes the following information:
- Beginning Balance — This shows the net book value of the asset at the start of the report period.
- Ending Balance — This shows the net book value of the asset at the end of the report period. You can calculate this as Asset Cost (ending balance) – Depreciation Ending Balance = NBV Ending Balance.
The Total NBV section includes the following information:
- Additions — This shows the additional asset acquisition and depreciation within the report period.
- Sale — This shows the total sales adjustments within the report period.
- Disposals — This shows the total write-off adjustment within the report period.
- Revaluation — This shows the total revaluation adjustment within the report period. This is the sum of the write-down amount and depreciation adjustments.
- Lease — This shows the lease adjustment amount.

Depreciation Schedule Report (Net Book Value and Period Depreciation)

The depreciation schedule net book value report shows the asset's current value for the specified period. The depreciation schedule period depreciation report shows the total depreciation of each asset for the specified period. The system assumes that depreciation history records with blank Accounting Book fields are for the Primary Book. In the depreciation schedule report, these DHRs are displayed under the Primary Book.

The depreciation schedule report can also group and display the depreciation and net book values by 4-4-5 week periods. The report uses accounting periods as column headers instead of calendar months. You'll see this change in the report if the following conditions are met:

The account uses the 4-4-5 Weeks accounting period.
The Use Accounting Period Dates For Depreciation preference is enabled to record depreciation histories correctly. For more information, see Fixed Assets General Preferences.

The depreciation schedule report includes the following information in the PDF/XML and CSV versions:

Asset Type — This shows the asset's class or asset type.
ID — This shows the asset ID.
Name — This shows the asset's name.
Asset Life — This shows the asset's lifespan.
Depreciation Method — This shows the asset’s depreciation method.
Periods — This shows the asset's depreciation period. The maximum period is 12 months. For report periods over 12 months, the succeeding months are shown on the following pages.

Note:
The report supports the Calendar Months and 4-4-5 Weeks accounting period format. The 4 Weeks accounting period format, which has 13 periods, is not supported.

The period names match their column position in the report. For example, Period 1, Period 2, and so on. These are different from the names of the accounting periods. Period names are sourced from the Manage Accounting Periods page. For more information, see Manage Accounting Periods Page.

The CSV version of the depreciation schedule report includes the following additional information:

Subsidiary – Shows the asset's subsidiary.
Posting – Shows whether the asset’s depreciation method uses GL Posting.
Accounting Book – Shows the accounting book associated with the depreciation histories.
Calendar Year – Shows the year for the 12 periods that begin on January 1 and ends on December 31.
Financial Year – Shows the label of the parent financial year record for the 12 periods. The financial year matches the calendar year if Use Accounting Period Dates for Depreciation is not enabled.
Financial Year ID – Shows the internal ID of the parent financial year record. This column is blank if Use Accounting Period Dates for Depreciation is not enabled.

Data in the report will appear blank under the following conditions:

The dates are outside of the selected start and end dates on the Generate Reports page.
The accounting period is incomplete.
The accounting period starts and ends on a month other than January and December.

Note:

To view forecast amounts for depreciation, you can generate an asset depreciation schedule report for future periods.

When the Use Accounting Period Dates for Depreciation preference is enabled, you won't see forecast depreciation amounts for undefined accounting periods.

Important:

If the Subsidiary has no amount for the report period, it's listed in the Subsidiary with zero value section.

Depreciation Monthly Report

The depreciation monthly report shows the depreciation expense for the period by asset, the asset records, and journal entries. The system assumes that depreciation history records with blank Accounting Book fields are for the Primary Book. In the depreciation monthly report, these DHRs are be displayed under the Primary Book.

The depreciation monthly report includes the following information:

Date — Shows the asset's last depreciation date.
Asset ID — Shows the asset ID.
Asset Name — Shows the asset's name.
Posting Reference — Shows the journal entry information.
Transaction Amount — Shows the depreciation amount.

Asset Listing Report (Anlagenspiegel)

The Asset Listing report shows the total acquisition or production costs, additions, disposals, transfers, and write-ups for the fiscal year. By default, it's an annual report set to the current year. Customers can also run the report monthly or quarterly.

The Asset Listing report follows the format for Germany’s consolidated financial statements, as per the German Commercial Code. This report is designed for German accounts and subsidiaries, and available to users with Austria and Switzerland accounts.

The Asset Listing report includes the following information:

Asset Record (Anlageposten) – Shows the asset name
Asset ID (Anlagen-ID) – Shows the asset ID
Asset Type (Anlagentyp ) – Shows the asset's class or type.
Opening Balance – Cost (Gesammtte AK/HK) – Shows the beginning balance at the start of the report period
Acquisition (Zugaenge) – Shows new acquisitions for the selected period
Disposals (Abgaenge) – Shows disposals for the current year
Transfer (Umbuchungen) – Shows the adjustments, including WiP to activated assets and interdepartmental transactions
Revaluation (Zuschreibungen) – Shows the revaluation
Accumulated Depreciation (Abschreibungen Kumuliert) – Shows the accumulated depreciation or YTD depreciation
Net Book Value (Buchwert Abschlussjahre) – Shows the NBV for the current financial year
NBV Previous Years (Buchwert Vorjahre) – Shows the NBV for the previous financial year
Depreciation (Abschreibung Abschlussjahre) – Shows the current financial year depreciation

Schedule 16 Reports

Schedule 16 reports are supplemental documents used to calculate corporate tax and are available for Japanese accounts and accounts with a Japanese subsidiary. Schedule 16 reports only include posting DHRs. Assets with a lifespan of 1 or over 50 are excluded from these reports. The following Schedule 16 reports are available:

Schedule 16 (1) - This report includes assets, leased assets, disposed, and fully depreciated assets using the Japan Straight-Line depreciation method. This report excludes leased assets that use the straight line depreciation method, and assets with Depreciation Active set to false.
Schedule 16 (2) - This report includes assets, leased assets, disposed, and fully depreciated assets using the Japan 200% Declining Balance and Japan 250% Declining Balance depreciation methods. This report excludes leased assets that use the old declining balance method, and assets with Depreciation Active set to false.
Schedule 16 (4) — This report includes all leased assets, disposed, and fully depreciated assets using the standard Straight Line depreciation method. This report excludes leased assets that use the Japan Straight Line and Japan Declining Balance depreciation methods, and assets with Depreciation Active set to false.