Hello Anne,

With Depreciation ran through a current period, I am unsure what you are trying to compare. The NBV report is non-date sensitive which is only pulling data based on the Current Through date in each asset, whereas the Projection reports are calculating reports based on the critical depreciation fields and ignoring the current calculated depreciation.

Of course, if you ran depreciation to that point 33 years in the future and then run the NBV report, then you would have a point of comparison, but without running depreciation to various date I would not expect any of the Standard reports to tie to a projection.

Again, I do not see those reports as comparable. The NBV report is non-date sensitive which is only pulling data based on the Current Through date in each asset which would also include prior disposals and transfers which would could very easily account for the $312,824.68 you are looking for since those prior year Disposal and Transfers would not appear as a part of the projection.

In our financials, we disclose the NBV of intangibles, and the amount of amortization that will be expensed over the remaining intangible assets.

Currently, the NBV of intangibles is $174,712,381.44

I ran the annual projection report for the intangible assets for 33 years so I can see when everything will fully depreciate.
Results of that report are below, and total $175,025,206.12.

The total remaining amounts to be expensed should equal the current NBV, but I'm off by $312,824.68

Dec 2016 $ 11,727,548.21
Dec 2017 11,702,714.13
Dec 2018 11,568,797.46
Dec 2019 11,447,608.94
Dec 2020 11,286,152.36
Dec 2021 11,145,491.49
Dec 2022 11,111,073.22
Dec 2023 11,110,893.04
Dec 2024 11,110,532.68
Dec 2025 11,106,330.36
Dec 2026 11,082,641.18
Dec 2027 10,881,515.62
Dec 2028 10,206,872.87
Dec 2029 8,852,623.99
Dec 2030 5,711,347.61
Dec 2031 4,747,314.12
Dec 2032 4,254,233.06
Dec 2033 2,598,816.39
Dec 2034 1,718,012.22
Dec 2035 1,113,898.13
Dec 2036 78,159.89
Dec 2037 78,159.89
Dec 2038 78,159.89
Dec 2039 78,159.89
Dec 2040 78,159.89
Dec 2041 24,639.89
Dec 2042 24,639.89
Dec 2043 24,639.89
Dec 2044 21,014.64
Dec 2045 13,763.86
Dec 2046 13,763.86
Dec 2047 13,763.86
Dec 2048 13,763.70
Dec 2049 0.00
Dec 2050 0.00
Dec 2051 0.00
Dec 2052 0.00
Dec 2053 0.00
Dec 2054 0.00
Dec 2055 0.00

I ran the monthly projection report for intangible assets, and confirmed that the report YTD ties to the FA Summary Current YTD Expense, and the monthly projection for the year 2016 is the same as the annual projection for 2016.

01/31/2016 $ 0.00 $ 0.00
02/29/2016 0.00 0.00
03/31/2016 2,941,262.68 2,941,262.68
04/30/2016 976,253.83 3,917,516.51
05/31/2016 976,254.01 4,893,770.52
06/30/2016 976,254.07 5,870,024.59
07/31/2016 976,253.85 6,846,278.44
08/31/2016 976,253.98 7,822,532.42
09/30/2016 976,253.91 8,798,786.33
10/31/2016 976,253.95 9,775,040.28
11/30/2016 976,253.90 10,751,294.18
12/31/2016 976,253.95 11,727,548.13

Grand Total $ 11,727,548.13

Yes, it does. Then you will be looking at the Depreciation Adjustment report – since your missing depreciation is most likely hidden on the under-depreciated assets.

I'm not using the NBV Report. I'm using the calculated NBV of all assets in the FA Summary Report (ending cost less total accumulated depreciation). I have not had any transfers or disposals in this class of assets since 2012. Does that help clarify what I'm trying to do?

To deal with under depreciated asset we normally recommend change the Depreciation Method to RV for those assets as being the safest way to deal with those.

 

As for the rest – I really would advise running depreciation to that future date to see if the actual calculation matches the Projection. After that, I would need detail asset information to be of any use.

The depreciation adjustment report shows $(183833.26) total, which is about half of my difference. What is the best way to make a correction?