Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand

...

serverJIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdecdb5e56-0e2c-3e03-a39a-d088ee783b83
keyFA-197
titleFull Month Convention Sample Computation

Given Data:

Depreciation Type : Mid-Month

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120



Monthly Depreciation Formula

Basis * Year Percentage / Number of Months in a year 


Year #Month #DateTransactionComputation
Depreciation To Date
1112/31/2020Place in service

0.00
1112/31/2020Depreciation120 * .5 /125.005.00 
1201/31/2021Depreciation120 * .5 /125.0010.00 
1302/28/2021

Jira
serverJIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdecdb5e56-0e2c-3e03-a39a-d088ee783b83
keyFA-155

Jira
serverJIRA
serverIdecdb5e56-0e2c-3e03-a39a-d088ee783b83
keyFA-205

Expand
titleFull Month Convention Sample Computation

Given Data:

Depreciation Type : Mid-Month

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

Monthly Depreciation Formula

Basis * Year Percentage / Number of Months in a year 

Year #Month #DateTransactionComputationDepreciation To Date1112/31/2020Place in service0.001112/31/2020Depreciation120 * .5 /125.00515.00 
1240103/31/2021Depreciation120 * .5 /125.001020.00 
1302/28/2021Depreciation120 * .5 /125.0015.00 
1403/31/2021Depreciation120 * .5 /125.0020.00 
51504/30/2021Depreciation120 * .5 /125.0025.00 
1605/31/2021Depreciation120 * .5 /125.0030.00 
1706/30/2021Depreciation120 * .5 /125.0035.00 
1807/31/2021Depreciation120 * .5 /125.0040.00 
1908/31/2021Depreciation120 * .5 /125.0045.00 
11009/30/2021Depreciation120 * .5 /125.0050.00 
11110/31/2021Depreciation120 * .5 /125.0055.00 
11211/30/2021Depreciation120 * .5 /125.0060.00 
2112/31/2021Depreciation120 * .5 /125.0065.00 
2201/31/2022Depreciation120 * .5 /125.0070.00 
2302/28/2022Depreciation120 * .5 /125.0075.00
2403/31/2022Depreciation120 * .5 /125.0080.00
2504/30/2022Depreciation120 * .5 /125.0085.00
2605/31/2022Depreciation120 * .5 /125.0090.00
2706/30/2022Depreciation120 * .5 /125.0095.00
2807/31/2022Depreciation120 * .5 /125.00100.00
2908/31/2022Depreciation120 * .5 /125.00105.00
21009/30/2022Depreciation120 * .5 /125.00110.00
21110/31/2022Depreciation120 * .5 /120115.00
21211/30/2022Depreciation120 * .5 /121120.00


This is marked as Fully Depreciated when Total Months = Depreciated Months

...

Expand
titleImported Assets

Given Data:

Depreciation Type : Mid-Month

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120

Imported : Yes

Placed in Service: 12/31/2020

Imported Depreciation thru:12/31/2021

Depreciation to date GAAP:  75


Entry on "Create asset" being clicked

AccountDRCR
Asset360
Accumulated Depr
75
Offset Account285

Monthly Depreciation Formula

Basis * Year Percentage / Number of Months in a year 


285


Monthly Depreciation Formula

Basis * Year Percentage / Number of Months in a year 


Year #Month #DateTransactionComputation
Depreciation To Date
1112/31/2020Place in service

0.00
1112/31/2020Depreciation000
1201/31/2021Depreciation000
1302/28/2021Depreciation000
1403/31/2021Depreciation000
1504/30/2021Depreciation000
1605/31/2021Depreciation000
1706/30/2021Depreciation000
1807/31/2021Depreciation000
1908/31/2021Depreciation000
11009/30/2021Depreciation000
11110/31/2021Depreciation000
11211/30/2021Depreciation000
2112/31/2021Depreciation000
2112/31/2021Imported0075
2201/31/2022Depreciation120 * .5 /125.0080.00 (75.00+5.00)
2302/28/2022Depreciation120 * .5 /125.0085.00
2403/31/2022Depreciation120 * .5 /125.0090.00
2504/30/2022Depreciation120 * .5 /125.0095.00
2605/31/2022Depreciation120 * .5 /125.00100.00
2706/30/2022Depreciation120 * .5 /125.00105.00
2807/31/2022Depreciation120 * .5 /125.00110.00
2908/31/2022Depreciation120 * .5 /125.00115.00
21009/30/2022Depreciation120 * .5 /125.00120.00
21110/31/2022Depreciation120 * .5 /120120.0.00 (Reached Max dep due to imported value
21211/30/2022Depreciation120 * .5 /120120.00


This is marked as Fully Depreciated when Depreciate To Date Amount >= Basis Amount





Expand
titleMid Year Convention Sample Computation

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Mid Year Depreciation: Yearly Depreciation / 2 = 120 / 2 = 30

The total depreciation on the year where the asset was placed in service should be 30. 

Remaining Months = No. of Months starting from Date In Service up to the last of month of the year.

Date In Service Jan 1, 2022: Remaining Months: 12

Depreciation: Mid Year Depreciation / Remaining Months of the year = 30 / 12 = 2.5

Next Year Depreciations: should use regular Monthly Depreciation: 5

YearApply Mid Year
1Yes
2No
3No
Year #Month #DateTransactionComputation
Depreciation To Date
1101/31/2022Depreciation30 / 122.502.50
1202/28/2022Depreciation30 / 122.505.00
1303/31/2022Depreciation30 / 122.507.50 
1404/30/2022Depreciation30 / 122.5010.00 
1505/31/2022Depreciation30 / 122.5012.50 
1606/30/2022Depreciation30 / 122.5015.00 
1707/31/2022Depreciation30 / 122.5017.50 
1808/31/2022Depreciation30 / 122.5020.00 
1909/30/2022Depreciation30 / 122.5022.5 
11010/31/2022Depreciation30 / 122.5025.00 
11111/30/2022Depreciation30 / 122.5027.50 
11212/31/2022Depreciation30 / 122.5030.00
2101/31/2023Depreciation120 * .5 /125.0035.00 
2202/31/2023Depreciation120 * .5 /125.0040.00 
2303/28/2023Depreciation120 * .5 /125.0045.00
2404/31/2023Depreciation120 * .5 /125.0050.00
2505/30/2023Depreciation120 * .5 /125.0055.00
2606/31/2023Depreciation120 * .5 /125.0060.00
2707/30/2023Depreciation120 * .5 /125.0065.00
2808/31/2023Depreciation120 * .5 /125.0070.00
2909/31/2023Depreciation120 * .5 /125.0075.00
21010/30/2023Depreciation120 * .5 /125.0080.00
21111/31/2023Depreciation120 * .5 /125.0085.00
21212/30/2023Depreciation120 * .5 /125.0090.00
3101/31/2024Depreciation120 * .5 /125.0095.00
3202/29/2024Depreciation120 * .5 /125.00100.00
3303/31/2024Depreciation120 * .5 /125.00105.00
3404/30/2024Depreciation120 * .5 /125.00110.00
3505/31/2024Depreciation120 * .5 /125.00115.00
3606/30/2024Depreciation120 * .5 /125.00120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Mid Year Depreciation: Yearly Depreciation / 2 = 120 / 2 = 30

The total annual depreciation on the year where the asset was placed in service should be 30. 

Remaining Months = No. of Months starting from Date In Service up to the last of month of the year.

Date In Service May 1, 2022: Remaining Months: 8

Depreciation: Mid Year Depreciation / Remaining Months of the year = 30 / 8 = 3.75

Next Year Depreciations: should use regular Monthly Depreciation: 5

YearApply Mid Year
1Yes
2No
3No
Year #Month #DateTransactionComputation
Depreciation To Date
1105/31/2022Depreciation30 / 83.753.75
1206/30/2022Depreciation30 / 83.757.50
1307/31/2022Depreciation30 / 83.7511.25 
1408/31/2022Depreciation30 / 83.7515.00
1509/30/2022Depreciation30 / 83.7518.75
1610/31/2022Depreciation30 / 83.7522.50
1711/30/2022Depreciation30 / 83.7526.25
1812/31/2022Depreciation30 / 83.7530.00 
2101/31/2023Depreciation120 * .5 /125.0035.00 
2202/31/2023Depreciation120 * .5 /125.0040.00 
2303/28/2023Depreciation120 * .5 /125.0045.00
2404/31/2023Depreciation120 * .5 /125.0050.00
2505/30/2023Depreciation120 * .5 /125.0055.00
2606/31/2023Depreciation120 * .5 /125.0060.00
2707/30/2023Depreciation120 * .5 /125.0065.00
2808/31/2023Depreciation120 * .5 /125.0070.00
2909/31/2023Depreciation120 * .5 /125.0075.00
21010/30/2023Depreciation120 * .5 /125.0080.00
21111/31/2023Depreciation120 * .5 /125.0085.00
21212/30/2023Depreciation120 * .5 /125.0090.00
3101/31/2024Depreciation120 * .5 /125.0095.00
3202/29/2024Depreciation120 * .5 /125.00100.00
3303/31/2024Depreciation120 * .5 /125.00105.00
3404/30/2024Depreciation120 * .5 /125.00110.00
3505/31/2024Depreciation120 * .5 /125.00115.00
3606/30/2024Depreciation120 * .5 /125.00120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Mid Year Depreciation: Yearly Depreciation / 2 = 120 / 2 = 30

The total annual depreciation on the year where the asset was placed in service should be 30. 

Remaining Months = No. of Months starting from Date In Service up to the last of month of the year.

Date In Service December 1, 2022: Remaining Months: 1

Depreciation: Mid Year Depreciation / Remaining Months of the year = 30 / 1 = 30

Next Year Depreciations: should use regular Monthly Depreciation: 5

YearApply Mid Year
1Yes
2No
3No
Year #Month #DateTransactionComputation
Depreciation To Date
1112/31/2022Depreciation30 / 13030.00 
2101/31/2023Depreciation120 * .5 /125.0035.00 
2202/31/2023Depreciation120 * .5 /125.0040.00 
2303/28/2023Depreciation120 * .5 /125.0045.00
2404/31/2023Depreciation120 * .5 /125.0050.00
2505/30/2023Depreciation120 * .5 /125.0055.00
2606/31/2023Depreciation120 * .5 /125.0060.00
2707/30/2023Depreciation120 * .5 /125.0065.00
2808/31/2023Depreciation120 * .5 /125.0070.00
2909/31/2023Depreciation120 * .5 /125.0075.00
21010/30/2023Depreciation120 * .5 /125.0080.00
21111/31/2023Depreciation120 * .5 /125.0085.00
21212/30/2023Depreciation120 * .5 /125.0090.00
3101/31/2024Depreciation120 * .5 /125.0095.00
3202/29/2024Depreciation120 * .5 /125.00100.00
3303/31/2024Depreciation120 * .5 /125.00105.00
3404/30/2024Depreciation120 * .5 /125.00110.00
3505/31/2024Depreciation120 * .5 /125.00115.00
3606/30/2024Depreciation120 * .5 /125.00120.00
Expand
titleMid Quarter Convention Sample Computation

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service Jan 1, 2022: Remaining Months in Quarter: 3 (Jan, Feb, March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 3 = 2.5

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5


Year #Quarter #Month #DateTransactionComputation
Depreciation To Date
11101/31/2022Depreciation7.5 / 32.502.50
11202/28/2022Depreciation7.5 / 32.505.00
11303/31/2022Depreciation7.5 / 32.507.50 
12404/30/2022Depreciation120 * .5 /125.0012.50 
12505/31/2022Depreciation120 * .5 /125.0017.50 
12606/30/2022Depreciation120 * .5 /125.0022.50
13707/31/2022Depreciation120 * .5 /125.0027.50
13808/31/2022Depreciation120 * .5 /125.0032.5 
13909/30/2022Depreciation120 * .5 /125.0037.50
141010/31/2022Depreciation120 * .5 /125.0042.50 
141111/30/2022Depreciation120 * .5 /125.0047.50 
141212/31/2022Depreciation120 * .5 /125.0052.50
21101/31/2023Depreciation120 * .5 /125.0057.50 
21202/31/2023Depreciation120 * .5 /125.0062.50 
21303/28/2023Depreciation120 * .5 /125.0067.50
22404/31/2023Depreciation120 * .5 /125.0072.50
22505/30/2023Depreciation120 * .5 /125.0077.50
22606/31/2023Depreciation120 * .5 /125.0082.50
23707/30/2023Depreciation120 * .5 /125.0087.50
23808/31/2023Depreciation120 * .5 /125.0092.50
23909/31/2023Depreciation120 * .5 /125.0097.50
241010/30/2023Depreciation120 * .5 /125.00102.50
241111/31/2023Depreciation120 * .5 /125.00107.50
241212/30/2023Depreciation120 * .5 /125.00112.50
31101/31/2024Depreciation120 * .5 /125.00117.50
31202/29/2024Depreciation120 * .5 /122.50120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service Feb 1, 2022: Remaining Months in Quarter: 2 (Feb, March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 2 = 3.75

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5

Year #Quarter #Month #DateTransactionComputation
Depreciation To Date
11202/28/2022Depreciation7.5 / 23.753.75
11303/31/2022Depreciation7.5 / 23.757.50 
12404/30/2022Depreciation120 * .5 /125.0012.50 
12505/31/2022Depreciation120 * .5 /125.0017.50 
12606/30/2022Depreciation120 * .5 /125.0022.50
13707/31/2022Depreciation120 * .5 /125.0027.50
13808/31/2022Depreciation120 * .5 /125.0032.5 
13909/30/2022Depreciation120 * .5 /125.0037.50
141010/31/2022Depreciation120 * .5 /125.0042.50 
141111/30/2022Depreciation120 * .5 /125.0047.50 
141212/31/2022Depreciation120 * .5 /125.0052.50
21101/31/2023Depreciation120 * .5 /125.0057.50 
21202/31/2023Depreciation120 * .5 /125.0062.50 
21303/28/2023Depreciation120 * .5 /125.0067.50
22404/31/2023Depreciation120 * .5 /125.0072.50
22505/30/2023Depreciation120 * .5 /125.0077.50
22606/31/2023Depreciation120 * .5 /125.0082.50
23707/30/2023Depreciation120 * .5 /125.0087.50
23808/31/2023Depreciation120 * .5 /125.0092.50
23909/31/2023Depreciation120 * .5 /125.0097.50
241010/30/2023Depreciation120 * .5 /125.00102.50
241111/31/2023Depreciation120 * .5 /125.00107.50
241212/30/2023Depreciation120 * .5 /125.00112.50
31101/31/2024Depreciation120 * .5 /125.00117.50
31202/29/2024Depreciation120 * .5 /122.50120.00

Given Data:

Depreciation Type : Mid Year

Duration : 2 years

Year 1 : 50%

Year 2 : 50%

Asset Cost : 360

Salvage Value : 240

Basis : 360 - 240 = 120


Depreciation Formulas

Monthly Depreciation: (Basis * Depreciation Percentage / ( Years * 12)) = ((120 * 0.5)/ 12) = 60 / 12 = 5

Yearly Depreciation: Monthly Depreciation * 12 = 5 * 12 = 60

Quarterly Depreciation: Yearly Depreciation / 4 = 60 / 4 = 15

Mid Quarter Depreciation: Quarterly Depreciation / 2 = 15 / 2 = 7.5

The total depreciation on the quarter where the asset was placed in service should be 7.5

Remaining Months In Quarter = No. of Months starting from Date In Service up to the last of month of the Quarter where the asset was placed in service.

Date In Service March 1, 2022: Remaining Months in Quarter: 1 (March)

Depreciation: Mid Quarter Depreciation / Remaining Months of the Quarter = 7.5 / 1 = 7.5

Next Month Depreciations after quarter depreciation: should use regular Monthly Depreciation: 5

Year #Quarter
Year
#Month #DateTransactionComputation
Depreciation To Date
11
12
303/31/
2020
2022
Place in service
Depreciation
0
7.
00
5 / 1
112/31/2020Depreciation000
1201/31/2021Depreciation000
1302/28/2021Depreciation000
1403/31/2021Depreciation000
1504/30/2021Depreciation000
1605/31/2021Depreciation000
1706/30/2021Depreciation000
1807/31/2021Depreciation000
1908/31/2021Depreciation000
11009/30/2021Depreciation000
11110/31/2021Depreciation000
11211/30/2021Depreciation000
2112/31/2021Depreciation000
2112/31/2021Imported0075
22
7.507.50 
12404/30/2022Depreciation120 * .5 /125.0012.50 
12505/31/2022Depreciation120 * .5 /125.0017.50 
12606/30/2022Depreciation120 * .5 /125.0022.50
13707/31/2022Depreciation120 * .5 /125.0027.50
13808/31/2022Depreciation120 * .5 /125.0032.5 
13909/30/2022Depreciation120 * .5 /125.0037.50
141010/31/2022Depreciation120 * .5 /125.0042.50 
141111/30/2022Depreciation120 * .5 /125.0047.50 
141212/31/2022Depreciation120 * .5 /125.0052.50
21101/31/2023Depreciation120 * .5 /125.0057.50 
21202/31/2023Depreciation120 * .5 /125.0062.50 
21303/28/2023Depreciation120 * .5 /125.0067.50
22404/31/2023
01/31/2022
Depreciation120 * .5 /125.00
80.00 (75.00+5.00)
72.50
22
3
5
02
05/
28
30/
2022
2023Depreciation120 * .5 /125.00
85
77.
00
50
22
4
6
03
06/31/
2022
2023Depreciation120 * .5 /125.00
90
82.
00
50
2
5
37
04
07/30/
2022
2023Depreciation120 * .5 /125.00
95
87.
00
50
2
6
38
05
08/31/
2022
2023Depreciation120 * .5 /125.00
100
92.
00
50
23
7
9
06
09/
30
31/
2022
2023Depreciation120 * .5 /125.00
105
97.
00
50
2
8
410
07
10/
31
30/
2022
2023Depreciation120 * .5 /125.00
110
102.
00
50
2
9
411
08
11/31/
2022
2023Depreciation120 * .5 /125.00
115
107.
00
50
2
10
412
09
12/30/
2022
2023Depreciation120 * .5 /125.00
120
112.
00
50
3
2
1
11
1
10
01/31/
2022
2024Depreciation120 * .5 /12
0
5.00
120.0.00 (Reached Max dep due to imported value11
117.50
312
12
02/
30
29/
2022
2024Depreciation120 * .5 /12
0
2.50120.00
This is marked as Fully Depreciated when Depreciate To Date Amount >= Basis Amount