Processing depreciation

Glossary

Basics of using a typical web page

This page allows you to process depreciation for a single asset or assets in batches. Tell me more.

The “Process Depreciation” page appears.

The system displays the following fields:

Process Run No.

A unique number identifying the depreciation process run. This number is automatically generated by the system at the time of processing.

Status

The status of the asset and tag combination. The various status available are:

  • Unprocessed – Indicates the status of the asset/tag for which the depreciation are yet to be processed.

  •  Partially Processed – Indicates that the assets/tag are picked up processing for partial financial period in the selected financial period.

  •  Processed – Indicates that the depreciation processing is complete.

  •  Partially Confirmed

  • Confirmed

Depreciation Book Code

Use the drop-down list box to select the code identifying the depreciation book. The system lists all the depreciation books defined in the “Set Depreciation Book” activity of “Asset Depreciation Setup” business component. The system displays “Corporate” by default on launch of the page.

Process Date

The date on which the depreciation process has run.

Note: If the process date is specified and the depreciation book selected is “Corporate” or “Tax”, then the date must lie in the open or provisionally closed financial period.

Finance Book

Use the drop-down list box to select the code identifying the finance book in which the accounting entries are to be posted. The system lists all the finance book mapped to the login organization unit for selection. The finance book must have been defined in the “Create Finance Book” activity of the “Organization Set Up” business component. The system displays the first finance book by default on launch of the page.

Note: If the depreciation book selected is other than “Corporate” or “Tax”, then the finance book must be left blank.

Numbering Type

Use the drop-down list box to select the numbering type for the login organization unit. The numbering types must have already been defined in the “Create Numbering Class” activity of the “Document Numbering Class” business component and must be in “Active” status as on the Transaction date. The system displays the numbering type set as default for the transaction in the “Document Numbering Class” business component.

Note: The system retrieves the revalued assets whose statuses are “Unprocessed” and “Partially Confirmed”.

Posting Cost Center

The code identifying the cost center in which the accounting entries must be posted (Alphanumeric, 10).

The system displays the following field:

Currency

The base currency of the login organization unit.

Financial Period Upto

Use the drop-down list box to select the financial period till which the depreciation must be processed. The system lists all the open or the provisionally closed financial period mapped to the login organization unit including the current period in descending order. The system displays the earliest open financial period by default on launch of the page.

The system displays the following fields:

Start Date

The start date of the first financial period available in the “Financial Period Upto” field.

End Date

The end date of the selected financial period. The system displays the end date of the period, which is defaulted in the financial period field.

Process Upto Date

The date till which you want the depreciation to be processed for the assets (Date Format).

Note:

  • Data entry in this field is required only if you want to process depreciation for the current open financial period.

  • Depreciation will be processed up till the date specified in this field.

  • The system updates the status to “Partially Processed” if this field is specified.

Ensure that the date specified in this field must be on or before the system date falling within  the current open financial year.

Note: Partial processing of depreciation can be done for current financial period only if the “Allow depreciation before period or year end” parameter has been set to “Yes” in the “Set Function Defaults” activity of the “Asset Depreciation Setup” business component.

If Process Upto Date is specified, then processing will be done upto this date.

Selection Basis

Use the drop-down list box to select the basis on which you want to retrieve the assets for processing the depreciation. The various options available are:

  • Asset Class – Select this option to process depreciation for all the assets belonging to the asset class selected

  • Balance of Assets – Select this option to select the assets for which depreciation are yet to be processed.

  • Cost Center – Select this option to process depreciation for all the assets belonging to the cost center.

  • Asset No. – Select this option to process depreciation for a single asset.

  • Analysis No. - Select this option to process depreciation for all the assets belonging to the analysis code.

The system displays “Asset Class” by default on launch of the page.

Asset Class Code

Use the drop-down list box to select the code identifying the asset class. The system lists the asset class code defined in the “Create Asset Class” activity of the “Asset Type Definition” business component. The system displays “All” by default on launch of the page.

Ensure that “All” is specified in this field if the “Balance of Assets” is selected as the “Selection Basis”.

The system retrieves the assets mapped to the asset class on the process end date specified for processing.

Depreciation Category

Use the drop-down list box to select the code identifying the depreciation category. The system lists all the depreciation category assigned for the asset class code. The system leaves the field blank by default on launch of the page.

Ensure the following:

  • This field is left blank if “Asset No”  or “Cost Center” is specified as the “Selection basis”

  • The value selected in this field must be a valid category mapped to the asset class specified.

Note: The assets must be assigned to the depreciation category before processing.

The system retrieves all the assets, which are in “Unprocessed” or in “Partially Confirmed” status, mapped to the category for processing.

Asset No.

The number identifying the asset (Alphanumeric, 18). The asset number must have been defined in the “Create Simple Asset” activity of the “Asset Capitalization” business component and a valid asset number for the specified “Finance Book”. This field is mandatory if the “Asset No.” is selected in the “Basis” field.

Ensure the following:

  • A value is entered in this field if “Asset No” is specified as the “Selection Basis”.

  • The value entered in this field is defined for the finance book selected in the “Process Information” group box.

  • This field is left blank if “Cost Center”  or “Asset Class” is specified as the “Selection basis”

Help facility available.

Note: The asset number must not be entered, if the “Basis” selected is “Depreciation Category”, “Asset Class” or  “Balance of Assets”.

Note: The system does not consider values specified in the “Asset Class Code”, “Asset No” and “Cost Center” fields if they are in contradiction to the value selected in the “Selection Basis” drop-down list box.

Cost Center

The code identifying the cost center (Alphanumeric, 10). The cost center must have been defined in the “Create Cost Center/Unit” activity of the “Cost Setup” business component. This field is mandatory if “Cost Center” is selected in the “Basis” field. The system retrieves all the assets that are mapped to the cost center specified for depreciation processing.

Ensure the following:

  • A value is entered in this field if “cost Center” is specified as the “Selection Basis”.

  • This field is left blank for any other values specified as the “Selection basis”

  • The cost center must be mapped to the relevant depreciation account code.

Analysis #

The code identifying the Analysis # (Alphanumeric, 5). The Analysis # must have been defined in the “Create Analysis Code” activity of the “Account Based Budget” business component. This field is mandatory if “Analysis Code” is selected in the “Basis” field. The system retrieves all the assets that are mapped to the Analysis Code specified for depreciation processing.

Ensure the following:

  • A value is entered in this field if “Analysis Code” is specified as the “Selection Basis”.

  • This field is left blank for any other values specified as the “Selection basis”

The Analysis Code must be mapped to the relevant depreciation account code.

Sub Analysis #

The sub analysis code that is mapped to the Asset specified for depreciation processing from the asset record. The System retrieves all the assets that are mapped to the Sub Analysis Code specified for Depreciation Processing.

Note: All the asset tags under the asset specified must be in “Unprocessed” or in “Partially Confirmed” status. Only those tags will be picked for processing depreciation.

Click the “View Statistics” pushbutton to view the total number assets and tags selected for processing.

Note: When any of the “Asset Selection” criteria is modified, ensure that you select the “View Statistics” pushbutton before selecting the “Process” pushbutton.

The system displays the following fields in the “View Statistics” group box:

Asset Selection

The number of assets selected for depreciation processing.

Records Selected

The total number of capitalization documents that would undergo depreciation processing.

Tags Selected

The number of asset tags selected for depreciation processing.

The system ensures that the flying hour of the asset is recorded before processing the depreciation, if the usage “Capitalized Maintenance Expenses” is mapped to the asset in the “Account Rule Definition” business component.

The system retrieves the depreciation rule set for an asset in the “Asset Depreciation Setup” business component and process the depreciation based on the rule.

The system updates the depreciation processing status for asset/tag/in-service combination to “Processed” on successful processing.

The system updates the period start date and the end date as the depreciation start date and the end date.

The system updates the depreciation processing status as “Processed” if the process end date is a depreciation period end date, else the system updates the processing status as “Partially Processed”.

If the depreciation convention is “Prorate”, “Mid Year”, “Mid Period”, or “User Defined”, the system considers the depreciation processing start date as

The system calculates the processing period as (processing end date – processing start date + 1).

Note: The value in the “View Statistics” group box must be available.

The number of records must not exceed the batch size defined in the “OU Process Parameter” activity.

If the “Include Revaluation” has been checked, then the revaluation depreciation processing must be in “Unprocessed” or in “Partially Processed” status. The assets must be in “Unprocessed” or in “Partially Processed” status before processing.

If the “Allows Depreciation below Book Value” parameter is set “Yes”, then the asset tag cost must not exceed the cumulative depreciation.

If multiple financial periods are selected, then processing will be done for each financial period sequentially.

If the in-service date or the revaluation run date is greater than the period end date, then those assets are not taken up for processing.

If the depreciation is processed for the first time, and if the asset tag associated to depreciation rule has a minimum asset value specified in the “Depreciation Charged Off Upto” field as defined in the “Create Depreciation Setup” activity of the “Asset Depreciation Setup” business component, the system performs the following:

The effective and the expiry date of yearly rates

The system determines the effective and the expiry date of the yearly rates.

Note: The system considers the expiry date of the previous year as the effective date for the subsequent years.

Rate for diminishing balance method

If the method selected is diminishing balance method and the useful life is retrieved from the rule. The system calculates the rate for the asset/tag/In service date as 1 – (salvage/cost)^(1/useful life).

Partially confirmed start date

If the depreciation asset status is “Partially Confirmed”, then the depreciation processing start date for the asset/tag/in-service would be a day added to the process upto date.

Mid period convention

 If the convention is mid period and the in-service date falls within the start and end date of the period, then the mid period date is calculated as (Period End date - Period Start date + 1)/2 + Period Start Date). The system updates the depreciation start date as the mid period date. In case of revaluation depreciation processing, in service date will be replaced by Revaluation run date.

Mid month convention

If the convention is mid month and the in-service date of the asset falls on or before the 15th of the depreciation processing period, then the depreciation will be charged on the asset for a full period. The system does not calculate any depreciation if the in-service date of the asset falls after the 15th of the depreciation processing period.

User-defined convention

If the convention is user-defined, then the effective date is calculated based on the following formula = (Year End date - Year Start date + 1)* First Year convention %age + Year Start Date.

Calculation of depreciation

The system calculates the depreciation for each asset/tag and in service date as (Rate * Period * Cost * Business use %age) / 360. The system retrieves the rates if defined under the rate ID with the effective and the expiry date.

The system calculates the depreciation for assets of usage “Capitalized Maintenance Expenses” based on the following formula:

The system calculates the suspension depreciation if the suspension period has been set for an asset.

The system calculates the maximum and minimum depreciation for the period, if the maximum and minimum depreciation has been defined in the rule. If the processed depreciation is greater than the maximum depreciation for the specified period then the assets depreciated reaches till the maximum depreciation. If the processed depreciation is lesser than the minimum depreciation for period, minimum depreciation is charged for the asset.

The system calculates the maximum depreciation for the period based on the following formula:

Note: If the “Allows Depreciation below Book Value” parameter set is not “Yes”, and the asset tag cost exceeds the cumulative depreciation, then that asset /tag cost and in service date combination must be ignored for processing

The system calculated the depreciation for assets for which rate is not provided based on the following formula:

The system generates the process run number based on the numbering type.

The system posts all the accounting entries in the books of accounts on processing. The system retrieves the earliest open financial period and posts the depreciation charges for both “Corporate” and “Tax” depreciation book.

100% depreciation write-off – Cap. Document Level

The system charges the entire tag cost as depreciation against cap. documents if:

 Note: The system does not take into account the salvage value

100% depreciation write off – Asset Tag – Period Level

The system charges the entire tag cost as depreciation against cap. documents if:   

Note: The system does not take into account the salvage value

This is the depreciation for the period in which the respective in-service dates of the cap. documents.

To proceed, carry out the following

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Processing depreciation – An overview

You can select the code identifying the depreciation book in which the entries have to be posted, the date on which the depreciation has to be processed, the numbering pattern based on which the process run number is generated, the code identifying the finance book and the code identifying the cost center. You can also process depreciation for the revalued cost of an asset. This page allows you to process depreciation for a certain period.

If depreciation is to be processed partially then a process upto date has to be specified. You can process depreciation for all the assets belonging to the asset class, depreciation category, the cost center and remaining assets that are not processed. This page also allows you to process depreciation for a single asset. The system displays the total assets selected and the total asset tags selected for processing. The system updates the status of asset/tags as “Processing”.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Prerequisites

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this page

Retrieve assets for processing

View statistics

 

 

 

 

 

 

 

 

 

 

 

 

 

Include revaluation for processing

You can also include cost of the asset after revaluation for depreciation processing.

Retrieve assets for processing

The assets can be retrieved based on the following options.

View statistics

You can view the assets selected for processing after specifying information in the “Assets Selected” group box.