Straight Line Depreciation not calculating correctly

Question Status

Verified
zachs asked a question on 4 May 2015 4:36 PM

Ok so I'm currently entering in assets into the fixed asset module and I can't seem to figure out how GP is calculating the depreciation. Here is the relevant information

 

Cost Basis: 80,809.50

Place in service date: 12/29/14

Dep to date: 12/28/14

0 LTD and YTD

Life: 5 years 0 days

Dep method: Straight line Orig

No Averaging Convention

No Switchover

So based on all of this I am expecting the period depreciation to be $1,346.83 (80,809.50 / 5 / 12 ) since there isn't any depreciation taken on it yet. That would roughly $44.89 per day. However, it is calculating out periodic depreciation to be $1,571.30 and daily depreciation to be $50.82.

For the most part changing the averaging convention does very little but I set it to none because I want the assets to depreciate exactly based on their placed in service date. However, when I change the depreciation method to SL remaining life, it calculates periodic depreciation to be $1,368.22. This is better but still off from what I would expect.

 

Does anyone have an idea?

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 4 May 2015 5:41 PM

Hello,

Your assumptions for the calculations are totally correct, I have just simulated a similar case on a test environment and here is my perspective on how Dynamics GP calculates according to the configuration you've provided above

Depreciation Percentage is 20, which is associated with 5 years and 0 days. >> This means, the asset will be depreciated through 1825 days (5 years * 365 + 0 Days)

Calculating the daily depreciation rate:

( Acquisition Cost - Salvage values ) /  number of days for the asset to be depreciated

(80,809.50 - 0 ) / 1825 = 44.279

This means a periodic depreciation would be around 1372.

Here is the result as entered on Dynamics GP :

The calculation below reflects the exact numbers in the proposed scenario, which are totally correct.

Your feedback is highly appreciated,

Reply
Suggested Answer
Harry Lee responded on 4 May 2015 9:13 PM

Zachs,

Mahmoud's math checks out. The problem with your calculations is decimal place precision. Using $89,809.50 / 5 / 12 gives you a rough approximate periodic depreciation rate, not an exact one, because some months have 30 days, others 31 and February has 28. Using an approximate periodic depreciation to calculate a daily depreciation rate yields yet another approximation; this is why your calculations produce inaccurate results.

Using $89,809.50 / 5 / 365 yields an exact daily depreciation rate of $44.2792 (to the ten thousandth decimal place precision). Multiplying the daily depreciation rate by the days in a period then yields an exact periodic depreciation rate.

This is fairly typical during implementations, when new depreciation figures challenge those in spreadsheets, long considered accurate. In every situation I've been asked to explain, Dynamics GP was calculating depreciation correctly, but each time we're asked we do the math nonetheless.

Reply
zachs responded on 4 May 2015 10:29 PM

His math is fine and I would be happy if I could get GP to calculate out to anywhere near those numbers, as I mentioned though, the numbers Great plains is actually calculating is the $1,571.30 per period. I double checked my service dates and numbers and everything is showing up the same.

I feel that a $224 difference per month has to be something other than a decimal place error.

Reply
Harry Lee responded on 4 May 2015 10:51 PM

Zachs,

You are right, you have a distinctly different problem than decimal place accuracy. Please post an image of your Asset Book record for this asset.  If you cannot get that small enough to fit, include current values for all of the fields, especially Averaging Convention. With the settings you described, I get the exact same figures as Mahmoud.

Reply
Suggested Answer
Harry Lee responded on 4 May 2015 11:16 PM

Zachs,

One other thing, please capture and image and upload your fiscal period setup and Fixed Asset Calendar Setup. I believe your 12-2014 period may not be 31 days. Are you perchance using a 4-4-5 week setup? 35 days (7 days X 5 weeks) @ $44.89 = $1571.15 (pretty close to $1571.30).

Reply
Verified Answer
Harry Lee responded on 5 May 2015 12:10 AM

If you are running a 4-4-5 fiscal period setup, here is a post on resolving issues associated with this setup:

community.dynamics.com/.../overstated-depreciation-on-a-4-4-5-manufacturing-retail-calendar

Reply
zachs responded on 5 May 2015 9:52 AM

The 53 week issue was the problem. I'm surprised it doesn't automatically realize the issue considering it has the calendar set up.

Thank you both for your help.

Reply
Joe.M. responded on 25 Aug 2015 11:55 AM

Have you ever experienced a problem where several assets are Straight Line Depreciation but GP changes the depreciation to a larger amount in the last year of the assets life?  On one asset it changes from $2k a month to $225k for the several months of it's life.

Any help is appreciated as this Fixed Asset system is new to us. 

Thanks,

Joe

Reply
Brenda Willey responded on 13 Sep 2017 3:26 PM

Ok so i have the same issue.  Not sure how to explain this to the client how the Periodic Depr Rate is calculated.  

I get the 60.6745 Daily rate = 110,731/5/365  AND if I multiply the daily rate by 365 i get $22,146.19 which is the number the client is looking for the Yearly Depr but the Yearly Depr Rate is 18,505.7288  Why??

Also i can not get to the 1,856.57 Cur Run Depr.  This should have been for July which has 31 days.  31*60.6745 = 1,880.9095.   Even if i use 30 days ... 30 * 60.6745 = 1,820.235

Reply
Verified Answer
Harry Lee responded on 5 May 2015 12:10 AM

If you are running a 4-4-5 fiscal period setup, here is a post on resolving issues associated with this setup:

community.dynamics.com/.../overstated-depreciation-on-a-4-4-5-manufacturing-retail-calendar

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 4 May 2015 5:41 PM

Hello,

Your assumptions for the calculations are totally correct, I have just simulated a similar case on a test environment and here is my perspective on how Dynamics GP calculates according to the configuration you've provided above

Depreciation Percentage is 20, which is associated with 5 years and 0 days. >> This means, the asset will be depreciated through 1825 days (5 years * 365 + 0 Days)

Calculating the daily depreciation rate:

( Acquisition Cost - Salvage values ) /  number of days for the asset to be depreciated

(80,809.50 - 0 ) / 1825 = 44.279

This means a periodic depreciation would be around 1372.

Here is the result as entered on Dynamics GP :

The calculation below reflects the exact numbers in the proposed scenario, which are totally correct.

Your feedback is highly appreciated,

Reply
Suggested Answer
Harry Lee responded on 4 May 2015 9:13 PM

Zachs,

Mahmoud's math checks out. The problem with your calculations is decimal place precision. Using $89,809.50 / 5 / 12 gives you a rough approximate periodic depreciation rate, not an exact one, because some months have 30 days, others 31 and February has 28. Using an approximate periodic depreciation to calculate a daily depreciation rate yields yet another approximation; this is why your calculations produce inaccurate results.

Using $89,809.50 / 5 / 365 yields an exact daily depreciation rate of $44.2792 (to the ten thousandth decimal place precision). Multiplying the daily depreciation rate by the days in a period then yields an exact periodic depreciation rate.

This is fairly typical during implementations, when new depreciation figures challenge those in spreadsheets, long considered accurate. In every situation I've been asked to explain, Dynamics GP was calculating depreciation correctly, but each time we're asked we do the math nonetheless.

Reply
Suggested Answer
Harry Lee responded on 4 May 2015 11:16 PM

Zachs,

One other thing, please capture and image and upload your fiscal period setup and Fixed Asset Calendar Setup. I believe your 12-2014 period may not be 31 days. Are you perchance using a 4-4-5 week setup? 35 days (7 days X 5 weeks) @ $44.89 = $1571.15 (pretty close to $1571.30).

Reply