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