Fiscal Year 365 Days Field, Depreciation Book Table

When the Calculate Depreciation batch job calculates depreciations, the batch job normally uses a standardized year of 360 days where each of the 12 months has 30 days.

If you select this field, the Calculate Depreciation batch job uses the calendar year of 365 days instead, where each month is calculated with the same number of days as in the calendar. The only exception is February in leap years, which the batch job will treat as having 28 days and not 29. Because of that, all years, also leap years, are considered to have 365 days.

If you select the Fiscal Year 365 Days field, you cannot select the Use Use Custom 1 Depreciation field.

Note

The yearly depreciation amounts to 6000 in both methods. The two methods just distribute the monthly depreciation in different ways but the yearly depreciation is fixed.

A fixed asset has acquisition date = 01-01-07, acquisition cost = 24000, and is depreciated over 4 years, 6000 each year. If you do not select the Fiscal Year 365 Days field, then the fixed asset is depreciated like this:

Date Days Amount

31-01-07

30

500.00

28-02-07

30

500.00

31-03-07

30

500.00

30-04-07

30

500.00

31-05-07

30

500.00

30-06-07

30

500.00

31-07-07

30

500.00

31-08-07

30

500.00

30-09-07

30

500.00

31-10-07

30

500.00

30-11-07

30

500.00

31-12-07

30

500.00

Total

360

6000.00

The amount is calculated like this:

Acq. Cost * Yearly Percent / 100 * Days / 360 =

24000 * 25 / 100 * 30 / 360 = 500.

If you select the Fiscal Year 365 Days field, the fixed asset is depreciated like this:

Date Days Amount

31-01-07

31

509.59

28-02-07

28

460.27

31-03-07

31

509.59

30-04-07

30

493.15

31-05-07

31

509.59

30-06-07

30

493.15

31-07-07

31

509.59

31-08-07

31

509.59

30-09-07

30

493.15

31-10-07

31

509.59

30-11-07

30

493.15

31-12-07

31

509.59

Total

365

6000.00

The amount in January, March, May, July, August, October, and December is calculated like this:

Acq. Cost * Yearly Percent / 100 * Days / 365 =

24000 * 25 / 100 * 31 / 365 = 509.59

The February-amount is calculated like this:

Acq. Cost * Yearly Percent / 100 * Days / 365 =

24000 * 25 / 100 * 28 / 365 = 460.27

The amount in April, June, September, and November is calculated like this:

Acq. Cost * Yearly Percent / 100 * Days / 365 =

24000 * 25 / 100 * 30 / 365 = 493.15

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Depreciation Book Table Fixed Assets
Depreciation Book Table Fixed Assets

See Also

Reference

Depreciation Book Card
Depreciation Book List
Use Custom 1 Depreciation

Other Resources

Calculate Depreciation