In this article

1. Straight-Line depreciation
2. Declining-Balance 1 depreciation
3. Declining-Balance 2 depreciation
4. DB1/SL depreciation

There are eight methods of depreciation available in Business Central:

• Straight-Line

• Declining-Balance 1

• Declining-Balance 2

• DB1/SL

• DB2/SL

• User-defined

  Define your own depreciation method by using depreciation tables. To learn more about applying a user-defined depreciation method, go to Set Up User-Defined Depreciation Method.

• Manual

  Use the manual method for assets that aren't subject to depreciation, for example, land. You must enter depreciation in the fixed asset G/L journal. The Calculate Depreciation batch job omits fixed assets that use the manual depreciation method.

• Half-Year Convention

  This method depreciates a fixed asset by the same amount each year.

When you use the straight-line method, you must specify one of the following options in the fixed asset depreciation book:

• The depreciation period (years or months) or a depreciation ending date
• A fixed yearly percentage
• A fixed yearly amount
• Depreciation period

If you enter the depreciation period (the number of depreciation years, the number of depreciation months, or the depreciation ending date), the following formula calculates the depreciation amount:

Depreciation Amount = ((Book value - Salvage Value) x Number of Depreciation Days) / Remaining Depreciation Days

Remaining depreciation days are calculated as the number of depreciation days minus the number of days between the depreciation starting date and the last fixed asset entry date.

Book value may be reduced by posted appreciation, write-down, custom 1 or custom 2 amounts, depending on whether the Include in Depr. Calculation field is deactivated and whether the Part of Book Value field is activated on the FA Posting Type Setup page. This calculation ensures that the fixed asset is fully depreciated at the depreciation ending date.

If you enter a fixed yearly percentage, Business Central uses the following formula to calculate the depreciation amount:

Depreciation Amount = (Straight-Line % x Depreciable Basis x Number of Depr. Days) / (100 x 360)

If you enter a fixed yearly amount, Business Central uses the following formula to calculate the depreciation amount:

• Depreciation Amount = (Fixed Depreciation Amount x Number of Depreciation Days) / 360

A fixed asset has an acquisition cost of LCY 100,000. The estimated life is eight years. The Calculate Depreciation batch job is run biannually.

For this example, the fixed asset ledger entry looks like this:

This depreciation method allocates the largest part of an asset's cost to the early years of its useful lifetime. If you use this method, you must enter a fixed yearly percentage.

The following formula calculates depreciation amounts:

• Depreciation Amount = (Declining-Bal. % x Number of Depreciation Days x Depr. Basis) / (100 x 360)

The depreciable basis is calculated as the book value at the beginning of the year. The number of depreciation days are the number of days between the posting date and the last depreciation date. Business Central calculates depreciation assuming that any depreciation done in the fiscal year is done with this formula.

The posted depreciation amount can contain entries with various posting types (write-down, custom1, and custom2) posted since the starting date of the current fiscal year. These posting types are included in the posted depreciation amount if there are check marks in the Depreciation Type and the Part of Book Value fields on the FA Posting Type Setup page.

A fixed asset has an acquisition cost of LCY 100,000. The Declining-Balance % field is 25. The Calculate Depreciation batch job is run biannually.

The following table shows how the fixed asset ledger entries look.

Calculation method:

• Year 1: 25% of 100,000 = 25,000 = 12,500 + 12,500

• Year 2: 25% of 75,000 = 18,750 = 9,375 + 9,375

• Year 3: 25% of 56,250 = 14,062.50 = 7,031.25 + 7,031.25

The calculation continues until the book value equals the final rounding amount or the salvage value that you entered.

An asset's book value is 100,000 on 12/31/2022. You post a depreciation of 1,778 on 2/2/23, which is the expected (proportional) amount of the year's depreciation at 32 days. If you run depreciation on 6/30/2023 Business Central will suggest 8,222, because there are 148 days from 2/2/2023 until 6/30/2023. The expected remaining depreciation for 6/30/2023 is calculated using the following formula:

• 148/360 x 0.20 x 100,000 = 8,222

If you post an amount that doesn't align with the Declining Balance 1 depreciation method, for example, 5,000, Business Central will suggest the remainder of the expected amount.

An asset's book value is 100,000 on 12/31/2022. You post a depreciation of 5,000 on 2/2/2023, which is more than the expected (proportional) amount on 2/2/2023 at 32 days. If you run depreciation on 6/30/2023, Business Central will suggest 8,222, because there are 148 days from 2/2/2023 until 6/30/2023. The expected remaining depreciation for 6/30/2023 is calculated using the following formula:

• 148/360 x 0.20 x 100,000 = 8,222

An asset's book value is 100,000 on 12/31/2023. You post a depreciation of 95,000 on 2/2/2023, which exceeds the allowed depreciation amount for the year. If you run depreciation on 6/30/2023, Business Central will suggest 5000, because there are 148 days from 2/2/2023 until 6/30/2023. The expected remaining depreciation for 6/30/2023 is calculated using the following formula:

• 148/360 x 0.20 x 100,000 = 8,222

However, the remaining book value is only 5,000, so Business Central will suggest 5,000 because a book value can't be negative.

The Declining-Balance 1 and Declining-Balance 2 methods calculate the same total depreciation amount for each year. However, if you run the Calculate Depreciation batch job more than once a year, the Declining-Balance 1 method will result in equal depreciation amounts for each depreciation period. The Declining-Balance 2 method, on the other hand, will result in depreciation amounts that decline for each period.

A fixed asset has an acquisition cost of LCY 100,000. The Declining-Balance % field is 25. The Calculate Depreciation batch job is run biannually. The fixed asset ledger entries look like this:

Calculation Method:

• BV = Book value
• ND = Number of depreciation days
• DBP = Declining-balance percent
• P = DBP/100
• D = ND/360

The formula for calculating the depreciation amounts is:

DA = BV x (1 – (1 –P)D)

The depreciation values are:

DB1/SL is an abbreviated combination of Declining-Balance 1 and Straight-Line. The calculation continues until the book value equals the final rounding amount, or the salvage value that you entered.

The Calculate Depreciation batch job calculates a straight-line amount and a declining balance amount, but only the greater of the two amounts are transferred to the journal.

You can use various percentages to calculate declining-balance.

If you use this method, you must enter the estimated useful lifetime and a declining balance percentage on the FA Depreciation Books page.

 Note

If you use any of the declining balance depreciation methods, and you want to run depreciation for multiple years, you must run each year's depreciation separately. If you run depreciation for the whole period from acquisition date to the end of the last fiscal year or last accounting period, it's likely that the results will be incorrect. For example, you might want to run it for multiple years if you have imported legacy data and you use the actual acquisition dates for your assets and want to catch up on accumulated depreciation. For declining balance methods, Business Central calculates the allowed depreciation per year, starting with the registered book value for each year. It can't do a multi-year depreciation in one step.

The Fixed asset - Projected Value report can project depreciations for multi-year periods, which might be confusing compared to the results you get if you run depreciations for multiple years using one of the declining balance methods

A fixed asset has an acquisition cost of LCY 100,000. On the FA Depreciation Books page, the Declining-Balance % field contains 25 and the No. of Depreciation Years field contains 8. The Calculate Depreciation batch job is run biannually.

The fixed asset ledger entries look like this:

SL after the book value means that the straight-line method has been used.

Calculation method:

• Year 1 (2020):

  Declining-balance amount: 25% of 100,000 = 25,000 = 12,500 + 12,500

  Straight-line amount = 100,000 / 8 = 12,500 = 6,250 + 6,250

  The declining-balance amount is used because it is the greater amount.

• Year 5 (2025):

  Declining-balance amount: 25% of 23,730.46 = 4,943.85= 2,471.92 + 2,471.92

  Straight-line amount = 23,730.46/3 = 7,910.15 = 3,995.07 + 3,995.08

  The straight-line amount is used because it is the greater amount.

The Half-Year Convention method will only be applied if you have placed a check mark in the Use Half-Year Convention field in the fixed FA Depreciation Book page.

This depreciation method can be used with the following depreciation methods:

• Straight-Line
• Declining-Balance 1
• DB1/SL

When you apply the Half-Year Convention, a fixed asset has six months of depreciation in the first fiscal year, regardless of the contents of the Depreciation Starting Date field.

Note

The estimated life of the fixed asset that is remaining after the first fiscal year will always contain a half-year using the Half-Year Convention Method. Thus, for the Half-Year Convention method to be applied correctly, the Depreciation Ending Date field on the FA Depreciation Book page must always contain a date which is exactly six months before the final date of the fiscal year in which the fixed asset will fully depreciate.

A fixed asset has an acquisition cost of LCY 100,000. The Depreciation Starting Date is 03/01/20. The estimated life is five years, so the Depreciation Ending Date must be 06/30/25. The Calculate Depreciation batch job is run annually. This example is based on a calendar fiscal year.

The fixed asset ledger entries look like this:

A fixed asset has an acquisition cost of LCY 100,000. The Depreciation Starting Date is 11/01/20. The estimated life is five years, so the Depreciation Ending Date must be 06/30/25. On the FA Depreciation Books page, the Declining-Balance % field contains 40. The Calculate Depreciation batch job is run annually. This example is based on a calendar fiscal year.

The fixed asset ledger entries look like this:

SL after the book value means that the straight-line method has been used.

Calculation method:

• Year 1:

  Declining-balance amount = Full year amount = 40% of 100,000 = 40,000. Thus, for half a year 40,000 / 2 = 20,000

  Straight-line amount = Full year amount = 100,000 / 5 = 20,000. Thus, for half a year = 20,000 / 2 = 10,000

  The declining-balance amount is used because it is the greater amount.

• Year 5 (2024):

  Declining-balance amount = 40% of 17,280.00 = 6,912.00

  Straight-line amount = 28,800 / 1.5 = 11,520.00

  The straight-line amount is used because it is the greater amount.

If you have three depreciation books, B1, B2 and B3, and you want to duplicate entries from B1 to B2 and B3, you can select the Part of Duplication List checkbox on the depreciation book cards for B2 and B3. For example, this setting can be useful in the following situations:

• Depreciation book B1 integrates with the general ledger and uses the fixed asset G/L journal.
• Depreciation books B2 and B3 don't integrate with the general ledger and use the fixed asset journal.

When you make an entry in B1 in the fixed asset G/L journal, and select the Use Duplication List checkbox, Business Central will duplicate the entry in book B2 and B3 in the fixed asset journal when the entry is posted.

 Note

You can't duplicate in the same journal and journal batch as you're duplicating from. If you post entries in the fixed asset G/L journal, you can duplicate them in the fixed asset journal or in the fixed asset G/L journal using another batch.

Note

You can't use the same number series in the fixed asset G/L journal and the fixed asset journal. When you post entries in the fixed asset G/L journal, you must leave the Document No. field empty. If you enter a number in the field, the number is duplicated in the fixed asset journal. You'll have to manually change the document number before you can post the journal.

Fixed Assets
Setting Up Fixed Assets