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.

General Notices