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 arranged per subsidiary and accounting book. Within a subsidiary and accounting book combination, the values are further organized per asset type.
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. Whenever possible, you should 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. Depreciation history records with blank Accounting Book fields are assumed to be DHRs for the Primary Book. In the asset register report, these DHRs will be displayed under the Primary Book.
The following information is available in the asset register report:
-
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 acquisition amount of the asset 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 was transferred to another class, department, or location, the Acquisition column will show the asset cost and the transferred amount.
-
Transfer — This shows the current cost of the asset that was transferred.
-
Sale — This shows the amount of assets disposed through sale during the report period.
-
Disposals — This shows the amount of assets written off during the report period.
-
Depreciation — This shows the amount of accumulated depreciation within the report period.
-
Revaluation — This shows the amount of adjustment done to the asset because of the 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 net book value of the asset at the end of the report period.
Asset Summary Report
This report lists cost or valuation, depreciation, and net book value totals for the selected asset types and the specified period. Depreciation history records with blank Accounting Book fields are assumed to be DHRs for the Primary Book. In the asset summary report, these DHRs will be displayed under the Primary Book.
The report is divided into the following three sections:
-
The Cost section will include 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 all new assets acquired during the report period.
-
Sale — This shows the amount of assets disposed through sale during the reporting period.
-
Disposal — This shows the amount of assets written off during the reporting 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 will include the following information:
-
Beginning Balance — This shows the balance of depreciation of the asset types at the start of the report period.
-
Additions — This shows the depreciation within the report period.
-
Sale — This shows the amount of assets disposed through sale during the reporting period.
-
Disposal — This shows the amount of assets written off during the reporting 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 will include 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. This can be computed as Asset Cost (ending balance) – Depreciation Ending Balance = NBV Ending Balance.
-
-
The Total NBV section will include 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 adjustments within the report period.
-
Revaluation — This shows the total revaluation adjustments within the report period. This is calculated as 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 current value of the asset for the specified period. The depreciation schedule period depreciation report shows the total depreciation of each asset for the specified period. Depreciation history records with blank Accounting Book fields are assumed to be DHRs for the Primary Book. In the depreciation schedule report, these DHRs will be displayed under the Primary Book.
The depreciation schedule report can also group and display the depreciation and net-book values in 4-4-5 Weeks period. Instead of calendar months, the accounting period is used as the column headers in the report. This change is visible 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 properly record the depreciation histories. For more information, see Fixed Assets General Preferences.
The following information is available in the PDF/XML and CSV version of the depreciation schedule report:
-
Asset Type — This shows the class or the asset type of the asset.
-
ID — This shows the asset ID.
-
Name — This shows the name of the asset.
-
Asset Life — This shows the life of the asset.
-
Depreciation Method — This shows the asset’s depreciation method.
-
Periods — This shows the depreciation period of the asset. Maximum period is 12 months. For report periods that exceeds 12 months, the succeeding months are presented in the following pages.
Note:The Calendar Months and 4-4-5 Weeks accounting period format are currently supported. The 4 Weeks accounting period format, which has 13 periods, is not supported.
The period names are indicative of 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 following additional information is available in the CSV version of the depreciation schedule report:
-
Subsidiary – Shows the subsidiary associated with the asset.
-
Posting – Shows whether the asset’s depreciation method is GL Posting or not.
-
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 will be the same as 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 will be 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 in the Generate Reports page.
-
The accounting period is incomplete.
-
The accounting period starts and ends on a month other than January and December.
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, there will be no forecast depreciation amounts for undefined accounting periods.
If the Subsidiary does not have an amount for the specified report period, it will be listed in the Subsidiary with zero value section of the report.
Depreciation Monthly Report
The depreciation monthly report shows the depreciation expense for the period by asset, the asset records, and journal entries. Depreciation history records with blank Accounting Book fields are assumed to be DHRs for the Primary Book. In the depreciation monthly report, these DHRs will be displayed under the Primary Book.
The following information is available in the depreciation monthly report:
-
Date — Shows the last depreciation date of the asset.
-
Asset ID — Shows the asset ID.
-
Asset Name — Shows the name of the asset.
-
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. It is an annual report, and by default, is set to the current year. Customers, however, may also run the report monthly or quarterly.
The Asset Listing report uses the format for Germany’s consolidated financial statements, in accordance with the German Commercial Code. This report is targeted for German accounts and subsidiaries, and available to users with Austria and Switzerland accounts.
The following information is available in the Asset Listing report:
-
Asset Record (Anlageposten) – Shows the asset name
-
Asset ID (Anlagen-ID) – Shows the asset ID
-
Asset Type (Anlagentyp ) – Shows the class or type where the asset belongs to
-
Opening Balance – Cost (Gesammtte AK/HK) – Show 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 of the current financial year
-
NBV Previous Years (Buchwert Vorjahre) – Shows the NBV of 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 to Japanese account and accounts with a Japanese subsidiary. The Schedule 16 reports will only include posting DHRs. Assets with an asset life of 1 or more than 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 that use the Japan Straight-Line depreciation method. This report does not include leased assets that use the straight line depreciation method, and assets where the Depreciation Active is false.
-
Schedule 16 (2) - This report includes assets, leased assets, disposed and fully depreciated assets that use the Japan 200% Declining Balance and Japan 250% Declining Balance depreciation methods. This report does not include leased assets that use the old declining balance method, and assets where the Depreciation Active is false.
-
Schedule 16 (4) — This report includes all leased assets, disposed and fully depreciated assets that use the standard Straight Line depreciation method. This report does not include leased assets that uses the Japan Straight Line and Japan Declining Balance depreciation methods, and assets where the Depreciation Active is false.