Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:gptip42day - MACRS Depreciation in GP

A question I run into rather regularly from users is 'Where do I enter the MACRS tables?'.  Well, the short answer is, you don't.  GP doesn't utilize MACRS tables for calculating MACRS depreciation.  Instead, it uses a combination of the many different depreciation methods and averaging conventions available in GP to simulate MACRS.

Now, for those of you asking, 'What the heck is MACRS?, the short answer is, can you spell IRS?  MACRS stands for Modified Accelerated Cost Recovery System, allows for accelerated writeoff of capital (Fixed Asset) costs, was passed into law in 1986 as part of the Tax Reform Act of 1986, and is still in force today.

Now, with that as a little background, let's keep this extremely simple.  Suffice it to say that by using the 200% Declining Balance depreciaiton method, Half-Year Convention, and a switch to Straight Line depreciation when advantageous, GP simulates MACRS depreciation.  Please see the chart below -

* click image to enlarge

As you can see, in this example, this combination of depreciation settings results in the same depreciation as the MACRS percentages.  There are some cases (assets with longer lives) where the GP depreciation may be off by a few dollars at the end of the asset life but it's close enough for government work.

Here's what the depreciation settings look like in the Asset Book window -

* click image to enlarge

To prove this method, you can run your own tests by setting up a few assets with different lives, run Depreciation Projections (Tools>Routines>Fixed Assets>Projection), and compare the results to the numbers you would get using the MACRS percentage tables, below.

* click image to enlarge

Happy depreciating!

Category:TIPS AND TRICKS BY MODULES: Fixed Asset Management
Link Owner:
Date Added:June 17, 2010 05:09:05 AM
Number Hits:82
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.