Net Book Value Report vs. Fixed Asset Summary Report

SOLVED

We imported asset infomation into SAGE FAS using the Net Book Value Report to balance to our original records.  Life was good.  Then, we printed a Fixed Asset Summary Report and the Total Accumulated Depreciation amount is different than the Current Accumulated Depreciation amount on the NBV report.

How could would there be a difference, and, how can it be remedied?   Thnx!

  • 0

    Hello Tony K,

    The NBV report is date insensitive, so tends to pull everything after running the depreciation

    The Fixed Asset Summary can be date sensitive or insensitive and is the only report designed to pull assets even if depreciation has not been ran yet.

    Try unchecking the box for Include only assets calculated through the Run Date and then re-run the Fixed Asset Summary report and see if the reports tie then.

    ~Delray

  • 0

    Unfortunately, this did not fix the situation.  After unchecking the "include only assets calculated through the run date" box, I reprinted the Fixed Asset Summary and received the same data.

    I simply do not understand how the two reports can be different.

  • 0

    Hello Tony K,

    Have you calculated depreciation since the import? If not, try that. Most reporting issue usually resolve after running depreciation.

    The Fixed asset Summary report is an annual report which is forward looking, so prior year disposals will not appear on it, where the NBV report is backwards looking including prior year activity but after an import I would not expect any disposal to be in the new company at all.

    Another difference between those reports is that the NBV is based on the Placed in Service date, and the Fixed Asset Summary report is based on Acquisition Date. Did you Import an Acquisition Date for each asset?

    Tying reports always comes down to the details, which assets are appearing on one report and not on the other or are they appearing differently between the reports. Then looking at the details of those assets and figuring out why they are behaving the way they are.

    If you can find assets which are throwing you off, and after looking at the details, things do not become clear, I would recommend call Customer Support at 800-331-8514 to sort it out.

    ~Delray

  • 0

    I notice that we imported a Beginning Date and Beginning Accumulated Depreciation.  The NBV report assimilates the Beginning Accumulated Depreciation into its Cuurent Accum Depreciation value, but the Fixed Asset Summary seems to only recognize the actual depreciation calculated since the import in its Total Accum Depr value.   Does this make sense?  

  • 0

    And thank you for your assistance, Delray!

  • 0

    Hello Tony K,

    The Beginning information is a manual override of depreciation. In effect, the Beginning Accum is the Current Accum as of the Beginning date.

    As you run depreciation going forward, the Beginning Accum is always a part of the total Accum, so, no that does not make any sense. Unless you are looking at the YTD amounts, I could see how it would appear that way based on YTD, but not on Accum.

    ~Delray

  • 0
    verified answer

    Ok.  I called Support and finally was able to speak to someone.  It was much easier to go into the history of how this problem arose.

    In a nutshell, there are two fields in the main asset screen.  A "Beginning YTD" field and a "Beginning Accum" field.  Apparently, these two fields must have the same value.  We had only imported a "Beginning Accum" value.  Once we input the "Beginning YTD" value, our NBV and Fixed Asset Summary reports matched!