A fast and secure browser that's designed for Windows 10
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
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?
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,
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.
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.
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.
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).
If you are running a 4-4-5 fiscal period setup, here is a post on resolving issues associated with this setup:
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.
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.
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