Skip to main content

Depreciation

caution

This documentation is incomplete.

Depreciation is the process of expensing the total cost of a fixed asset over the asset's life. Depreciation represents how much of an asset's value has been utilized in a given period. It allows organizations to earn revenue from the fixed assets they own by paying for the asset over a certain period of time. The number of years over which an asset is depreciated is maintained in asset books. Similarly, the rule against an asset being depreciated is specified in the depreciation rule. Depreciation rules are assigned to asset books.

info

In InoERP, assets are created and maintained at a legal organization level.

Methods

InoERP provides below four depreciation methods. However, you can also create your own methods using JavaScript APIs.

  • Straight-line
  • Double declining balance
  • Sum of years digits
  • Table Rate

Straight-line

In the Straight-line method, the depreciation of an asset is spread evenly across its life. The value of an asset is reduced uniformly over each period until it reaches its salvage value. The straight line is the simplest form of depreciation, and the below simple formula calculates the depreciation amount.

if the calculation basis is cost, then

 Depreciation Amount = Current Cost / Life In Months;

if the calculation basis is cost, then

    Depreciation Amount =
(Recoverable Amount - Accumulated Depreciation) /
(Life In Months - No Of Completed Deprecated Periods);

Recoverable amount = Current Cost - Salvage Amount
Accumulated Depreciation = Sum of all the past depreciation for the asset in the asset book

Double declining balance

A double-declining balance method is a form of an accelerated depreciation method in which the asset value is depreciated at a higher rate than it is done in the straight-line method. It is frequently used to depreciate fixed assets more heavily in the early years, which allows the company to defer income taxes to later years. The rate is determined by the factor specified in the depreciation method.

if the calculation basis is cost, then

 Depreciation Amount = (Current Cost / Life In Months)*(Depreciation Factor Percentage / 100);

if the calculation basis is cost, then

    Depreciation Amount =
((Recoverable Amount - Accumulated Depreciation) /
(Life In Months - No Of Completed Deprecated Periods))*(Depreciation Factor Percentage / 100);

Recoverable amount = Current Cost - Salvage Amount
Accumulated Depreciation = Sum of all the past depreciation for the asset in the asset book

Sum of years digits

Sum of years digits is another accelerated depreciation method in which the total life determines the acceleration factor against the current period. For example, if an asset has a life of 3 years, the sum of years is 1+2+3 = 6. Fractional parts are built with the year as the numerator and the sum of years as the denominator but in reverse order. Year 1 is 3/6 depreciable cost; Year 2 is 2/6 depreciable cost, Year 3 is 1/6 * depreciable cost, etc.

if the calculation basis is cost, then

 Depreciation Amount = (Current Cost / Life In Months)*(factor);

factor = (Life Years - Current Year) / Sum Of Years;

if the calculation basis is cost, then

    Depreciation Amount =
((Recoverable Amount - Accumulated Depreciation) /
(Life In Months - No Of Completed Deprecated Periods))*(factor);

factor = (Life Years - Current Year) / Sum Of Years;
Recoverable amount = Current Cost - Salvage Amount
Accumulated Depreciation = Sum of all the past depreciation for the asset in the asset book

Table Rate

The table rate is the most flexible depreciation rule. In this method, you can specify what should be the depreciation rate for a specific period. The sum of all the rate must be 100, and the table must contain periods that is the maximum life of an asset.

if the calculation basis is cost, then

 Depreciation Amount = Current Cost * Rate for the period in the table;

if the calculation basis is cost, then

    Depreciation Amount =
(Recoverable Amount - Accumulated Depreciation) * Rate for the period in the table;

Recoverable amount = Current Cost - Salvage Amount
Accumulated Depreciation = Sum of all the past depreciation for the asset in the asset book

Depreciation Method

To create/view/update the depreciation rule, navigate to the "depreciation rule" screen from your dashboard/favorite.

Enter the organization/depreciation rule details or any other criteria in the search form and click on the search button to view an existing depreciation rule.

If you don't enter organization details, the system will show you all the depreciation rules. If your organization has configured to make any field mandatory for search, then you have to enter those fields to search depreciation rules.
The application will fetch all the server data and take you to the search result screen. The search result screen looks a bit different on desktop and mobile devices.

If you click on the create new button, the system will open a simple step form to create a new depreciation rule. You can click on the detail right bottom to view all the fields available for the object.

To view the search result in a table format, click on the table icon in the bottom left corner.

To view specific depreciation rule details, click on the menu of that record, and click on view/fetch & view.

You can also click on the expand icon against any item on the search result screen to view the depreciation rule header details, such as price list name, module, status, currency, etc.

The system will fetch all the selected document detail line data. The document details are shown either right on the search result screen or on a separate screen, depending on the device size.

Depreciation Method: Enter a unique name for the depreciation rule. The field is available in other forms (such as Asset Book) to select.
Calculation Basis: Calculation basis specifies the system's amount to calculate the depreciation amount. The two possible values are

  • Cost
  • Net Book Value

Method Type: Select one of the four methods available in the system

  • Straight-line
  • Double declining balance
  • Sum of years digits
  • Table Rate

Scroll left, right, up, and down to view all the details. The document line and details are shown in a separate tab.. The default configuration shows fields in various functional groups, such as

  • Finance
  • Entity
  • Reference
  • Data
  • Control
  • Etc

You can configure the application to show which fields should be shown under which group. You can also create new groups as per your business requirements.

All Fields
SequenceNameLabelInputTypeField Group
10faDepreciationMethodIdFa Depreciation Method IddefferedSelectREFERENCE
10srcEntityNameSrc Entity NamedefferedSelectDEFAULT
20srcEntityIdSrc Entity IdInputType.textREFERENCE
30depreciationMethodDepreciation MethodInputType.textFieldDEFAULT
40methodTypeMethod TypeInputType.selectCONTROL
50calculationBasisCalculation BasisInputType.selectDEFAULT
60lifeMonthLife MonthInputType.numberDEFAULT
70factorPercentageFactor PercentageInputType.numberDEFAULT
80reducingBalanceRateReducing Balance RateInputType.textFieldFINANCE
90statusStatusInputType.selectCONTROL
100descriptionDescriptionInputType.textFieldDEFAULT
5110createdByCreated ByInputType.textREFERENCE
5120creationDateCreation DateInputType.textREFERENCE
5130lastUpdatedByLast Updated ByInputType.textREFERENCE
5140lastUpdateDateLast Update DateInputType.textREFERENCE

Rates

Rule lines are applicable only for the "Table Rate" type of depreciation method. If you select the method type as "Table Rate," then you must enter the rate for each period in the rule lines,

You can add multiple rule lines to each rule header. Each line specifies the period and the depreciation rate for that period.

Navigate to the "rule lines" tab to view/add/update books.
Click on the add new entity to add a new line. If a line already exists, click on copy entity to copy all the details. You can enable/disable fields allowed to be copied in the menu configuration.

year: Enter a year number. It's a mandatory field.

period: Enter a value between 1 and 12. It's also a mandatory field.

Monthly Period: A read-only field. The system calculates the monthly period by the below formula.

 Monthly Period = ((Year - 1) * 12) + Period;

Scroll left, right, up, and down view all other fields.

Enter all the other fields and click on the save button to save the asset. The app will post all the data to the server and will show the messages returned from the server.

All Fields
SequenceNameLabelInputTypeField Group
10vvMonthlyPeriodNoMonthly Period NoInputType.textFINANCE
10faDepreciationMethodRateIdFa Depreciation Method Rate IdInputType.textREFERENCE
20srcEntityNameSrc Entity NamedefferedSelectDEFAULT
30srcEntityIdSrc Entity IdInputType.textREFERENCE
40faDepreciationMethodIdFa Depreciation Method IddefferedSelectREFERENCE
50yearYearInputType.numberDEFAULT
60periodPeriodInputType.numberFINANCE
70rateRateInputType.textFieldFINANCE
80descriptionDescriptionInputType.textFieldDEFAULT
5090createdByCreated ByInputType.textREFERENCE
5100creationDateCreation DateInputType.textREFERENCE
5110lastUpdatedByLast Updated ByInputType.textREFERENCE
5120lastUpdateDateLast Update DateInputType.textREFERENCE

Run Depreciation

You can run depreciation for an asset in the asset action screen. The application also allows you to run depreciation for all the assets in an asset category and all the assets in a legal organization.

Run Asset Depreciation: Run the depreciation for the current asset in all the books. The system creates depreciation transactions for all the books, but it does not generate any accounting entries.

Run Category Depreciation: System runs the depreciation for all the assets with the same asset category as the current asset.

Run Legal Org Depreciation: System runs the depreciation for all the assets with the same legal organization as the current asset.

You can also schedule/run the depreciation using the depreciation program.

View Transaction

The system creates depreciation transactions for each asset and each book combination. You can run depreciation only once in a period. If required, you can generate depreciation adjustments. However, the system does not allow you to update/delete any asset depreciation transaction.

Navigate to the "depreciation transaction" screen from your dashboard/favorite to view a depreciation transaction.

Enter the organization/depreciation transaction details or any other criteria in the search form and click on the search button to view an existing depreciation transaction.

The depreciation transaction is a customized view of Fa transaction screens. So, you can also use the FA transaction screen to view all the depreciation transactions. Enter the transaction type as depreciation.

Scroll left, right, up, and down to view all the details. The default configuration shows fields in various functional groups, such as

  • Reference
  • Control
  • Etc

You can configure the application to show which fields should be shown under which group. You can also create new groups as per your inventory requirements.

All Fields
SequenceNameLabelInputTypeField Group
10vvGlLedgerIdGl Ledger IddefferedSelectREFERENCE
10vvGlDocumentTypeGl Document TypeInputType.textCONTROL
20vvBookNameBook NamedefferedSelectDEFAULT
30vvBookTypeBook TypedefferedSelectCONTROL
40vvFaAssetCategoryIdFa Asset Category IddefferedSelectREFERENCE
50vvLegalOrgIdLegal Org IddefferedSelectREFERENCE
60vvAssetNumberAsset NumberdefferedSelectDATA
70vvAssetNameAsset NamedefferedSelectDEFAULT
80vvAssetStatusAsset StatusInputType.textCONTROL
90vvAssetTypeAsset TypeInputType.textCONTROL
100vvDepreciationCbDepreciation CbInputType.textDEFAULT
110faAssetTransactionIdFa Asset Transaction IdInputType.textREFERENCE
120srcEntityNameSrc Entity NamedefferedSelectDEFAULT
130srcEntityIdSrc Entity IdInputType.textREFERENCE
140faAssetIdFa Asset IddefferedSelectREFERENCE
150faAssetBookIdFa Asset Book IdInputType.textREFERENCE
160transactionTypeTransaction TypeInputType.selectCONTROL
170quantityQuantityInputType.textFieldDATA
180amountAmountInputType.textFieldFINANCE
190amount10Amount 10InputType.textFieldFINANCE
200amount20Amount 20InputType.textFieldFINANCE
210amount30Amount 30InputType.textFieldFINANCE
220amount40Amount 40InputType.textFieldFINANCE
230amount50Amount 50InputType.textFieldFINANCE
240amount60Amount 60InputType.textFieldFINANCE
250faBookIdFa Book IddefferedSelectREFERENCE
260glPeriodIdGl Period IddefferedSelectREFERENCE
270glAcProfileHeaderIdGl Ac Profile Header IddefferedSelectREFERENCE
280glJournalHeaderIdGl Journal Header IdInputType.textREFERENCE
290glJournalLineIdGl Journal Line IdInputType.textREFERENCE
300descriptionDescriptionInputType.textFieldDEFAULT
310depreciationPeriodNoDepreciation Period NoInputType.numberFINANCE
320referenceTypeReference TypeInputType.textFieldCONTROL
330referenceKeyNameReference Key NameInputType.textREFERENCE
340referenceKeyValueReference Key ValueInputType.textREFERENCE
5350createdByCreated ByInputType.textREFERENCE
5360creationDateCreation DateInputType.textREFERENCE
5370lastUpdatedByLast Updated ByInputType.textREFERENCE
5380lastUpdateDateLast Update DateInputType.textREFERENCE