How to Use Sage Fixed Assets for Group Depreciation

We currently have all of our computers, monitors, etc. listed as individual assets in Sage Fixed Assets. However, we would like to start using group depreciation instead by consolidating all our computer hardware into one asset. Each month we would add to the asset value the amount of new computer hardware, partially dispose the value of computer hardware disposed, and depreciate the asset by 3% of the total asset value (SL 3yr life).

We know that this is allowed under GAAP, however, when talking to Sage Support they stated that there is no official/standard way to transition to or perform group depreciation in the system. 

Has anyone else done this at their company or know of a way to work with Sage to accomplish this?

  • Hello DMorimoto.

    First, By design, the SFA program wants individual assets, one physical object one asset entered into the system. The reasons for this are mostly for Tax purposes which is why there is nothing built into the program to allow the consolidation of asset.

    Second, as a general rule, we will discourage the actual running of depreciation on just a group of assets, mostly to avoid confusion on the reporting side, and always recommending the <All Complete Assets> group. The calculation can be summarized in various different ways on reports by the use of Groups and sorts on those reports. It is not that you cannot run depreciation on a group of assets - it is more that if there is some question about the results of those reports, we, as technicians, will first re-run depreciation on the <All Complete Assets> before even looking at some other Group or customization of a report. It is amazing how much time can be saved that way. See KB ID:16919 How to create a group which I add just in case you have not seen the Group Manager before.

    You can always setup your own "Lumpy" assets but that would be your own manual process which, as long as it makes sense to you, will be fine. There is just nothing we can advise you on or that is built into the program to help.

    That 3% above is supposed to be 33%, right?

    ~Delray

  • Hello,

    I'm replying to an old conversation where you mentioned running depreciation using the <All Complete Assets> group?  We've got our assets set up in groups by location.  With the number of groups we have it requires over an hour to run depreciation each month and I'm looking for a way to be more efficient with my time.  But we currently post using the depreciation report generated for each group.  If I use the <All Complete Assets> group to run depreciation what kind of report will I get?  Can I sort or filter the report to give me depreciation by my groups?

    Thanks for your help

    Mickey Daughtry

    Troy Bank & Trust

  • Hello Mickey,

    By default the report generated on running depreciation will be the Depreciation Expense report as the report was last saved on the Report Definition dialog under Reports, Standard Reports, Depreciation Expense.

    You could just run depreciation and not generate a report at all which makes sense if you are not really interested in getting a report including all the assets in the company. Then you are just running the Depreciation Expense report, or any other report, selecting your location groups as you go.

    ~Delray

  • Ok, thanks, I was running depreciation by each group by book to get the reports we need.  I pulled up the Depreciation Expense report for a few of our groups  - they are the same that's generated to the screen (if I choose run to Window) when I calculate depreciation by group, correct?  Another question - do I have to run depreciation by each book individually (currently we run tax and internal) or can I select both books and make one run?

    I appreciate your help!

    Mickey

  • Yes, you can run Tax and Internal at the same time but the normal procedure is running Tax at the year end while running Internal at the end of each month.

    As for running depreciation in Groups, there is no harm in it. I say to always run depreciation on the <All Completed Assets> more out of paranoia just to make sure nothing gets missed. That way there are fewer elements to troubleshoot if there is some question on the report.

    ~Delray