Generating Asset Reports

The fixed asset reporting tool uses Advanced PDF format. This enables you to print, view, or download the report in CSV (for Depreciation Schedule Report), PDF, or XML format. To generate the fixed asset reports, you must enable the Advanced PDF/HTML Templates feature in Setup > Company > Enable Features > SuiteCloud.

You can also export generated asset reports to an Excel file. For more information, see Exporting Asset Reports to an Excel File.

Note:

Fixed Assets Management doesn't currently support Depreciation Schedule Reports for assets with negative costs. For more information, see Fixed Assets Report Preferences.

Important:

Update depreciation history records for asset transfers with a ‘Sale or Disposal’ transaction type and no asset disposal type. Set the transaction type to ‘Acquisition’ and the transaction amount to a negative value. Asset transfers are shown as an Acquisition with a negative value on fixed asset reports.

To generate fixed asset reports:

  1. Go to Fixed Assets > Reports > Generate Reports.

  2. Provide values for the following fields:

    • Report Type — Select the report type to generate.

      • Asset Register — This report lists cost, accumulated depreciation, and net book value for each asset with the selected periods.

        Note:

        In Fixed Assets Management version 4.01.2 and later, disposals generate two types of depreciation history records (DHR) — a ‘Sale’ DHR for assets sold and a ‘Disposal’ DHR for assets written off. The Asset Register saved search includes added columns for SALE and DISP.

      • Asset Summary — This report lists cost or valuation, depreciation, and net book value totals for selected asset types and periods.

      • Depreciation Schedule Net Book Value — This report shows each asset's current value for the period.

      • Depreciation Schedule Period Depreciation — This report shows each asset's total depreciation for the period.

        Note:

        Generate an asset depreciation schedule report for future periods to view forecast depreciation amounts.

      • Depreciation Monthly Report — Shows the depreciation expense for the period by asset, including asset records and journal entries.

      • Asset Listing Report — Shows the total acquisition or production costs, additions, disposals, transfers, and write-ups for the fiscal year. This report is designed for German accounts and subsidiaries, and is also available to users with Austria and Switzerland accounts.

      • Schedule 16 (1) - This report shows assets, leased assets, disposed and fully depreciated assets that use the Japan straight line depreciation method.

      • Schedule 16 (2) - This report shows assets, leased assets, disposed and fully depreciated assets that use the Japan 200% declining balance and Japan 250% declining balance depreciation method.

      • Schedule 16 (4) — This report includes all leased assets, disposed and fully depreciated assets that use the standard Straight Line depreciation method.

    • Show Components in Reports — Check this box to view only the components on the report. Otherwise, clear this box to view only the parent compound asset on the report.

      Note:

      This option is only available for the Asset Register and Asset Listing Report s.

    • Save Report as CSV — Check this box to save the generated report as a CSV file. Enabling this setting disables the XML or PDF output.

      Note:

      This option is only available for the Depreciation Schedule and Depreciation Monthly Report s.

    • Start Date — Enter the start date for the report period.

    • End Date — Enter the end date for the report period.

    • Assets to Include — Select the assets to include in the report: All Assets, All Assets Except Leased, or Leased Only.

      Note:

      For Depreciation Monthly reports, this field is set to All Assets.

    • Alternate Depreciation — Select the depreciation method.

      Note:

      Selecting Accounting Method sets the Accounting Book filter to Primary Accounting Book, and the Books to Include filter to GL Posting. This applies to all reports except the Depreciation Monthly report.

    • Asset Types — Select one or more asset types to categorize assets. Default values are assigned to most of the asset configuration based on the asset type.

      Note:

      If no asset type is selected, the report also includes inactive asset types.

    • Subsidiary — Select the subsidiaries for which you want to generate a report.

      This field is available only for OneWorld accounts.

    • Include Children — Check this box to include assets of the child subsidiaries in the report.

    • Accounting Books — Select the accounting books for which you want to generate a report.

      Note:

      This field is available only if the Multi-Book Accounting feature is enabled in your account.

      Selecting None generates a report with the following information:

      • All depreciation history records for accounting methods and tax methods created before the Multi-Book feature was enabled.

      • Tax methods not associated to an accounting book.

    • Books to Include — Select to include GL Posting, Non GL Posting, or Both books in the report.

      Note:

      If you select Depreciation Monthly Report, this option is set to GL Posting.

    • Departments — Select a department to include only its associated assets.

      This field is available only if the Departments feature is enabled in your account.

    • Class — Select a class to include only its associated assets associated.

      This field is available only if the Classes feature is enabled in your account.

    • Location — Select a location to only include its associated assets.

      This field is available only if the Locations feature is enabled in your account.

  3. Click Generate.

    You'll be redirected to the Process Status page to track the report's progress. On the My Reports page (Fixed Assets > Reports > My Reports), you can view the generated report as PDF or XML. When viewing XML reports, use an application that can properly display XML files.

    The My Reports page doesn't show failed reports.

    Important:

    The report excludes manually created assets without depreciation history records and assets disposed before or after the report period.

To view a list of reports generated in the last 30 days, see Viewing Fixed Asset Reports.

Exporting Asset Reports to an Excel File

To export asset reports:

  1. Go to Fixed Assets > Reports > My Reports.

  2. Right click the XML link for the report that you want to export to Excel, and save it to your computer.

  3. Find the downloaded XML report on your computer, and then open it with Excel.

    Note:

    You can set your web browser to use Excel as the default program to open XML files.

General Notices