Sage North America|Sage WorldWide
Sage FAS Online Community
Search in

Troubleshooting Depreciation This Run

The value that appears in the DEPRECIATION THIS RUN column on the Depreciation Expense Report is a common cause for concern among FAS Asset Accounting users. Troubleshooting this report field is a simple matter. All it requires is a basic understanding of what the data in this field truly represents.

The first thing to keep in mind is that this column is, by nature, a volatile one. There is no set interval of time that represents a depreciation run. A company that commonly does their depreciation yearly is going to show a different Depreciation This Run than a company that does depreciation quarterly or monthly, but this still does not guarantee that a run is always going to be that period of time. Fortunately, the Depreciation Expense Report gives you all the data necessary to find out what period of time the Depreciation This Run column is representing.

Depreciation Expense Report:

sample report

Above, you can see a sample Depreciation Expense Report. The reported asset has a DEPRECIATION THIS RUN of $25.49. For the purposes of this article, let's assume that Westfields Bakery depreciates their assets on a monthly basis. Looking at this report, we know that FAS Asset Accounting is reporting a monthly depreciation calculation. Why?

There are two dates that are circled on this report. One is the date under the Prior Thru column, and one is the "as of" date at the top of the report. The date displayed in the Prior Thru-column represents the previous time that depreciation was run on the asset. The "as of" date is the date that was entered during your current depreciation calculation. The depreciation calculated in the time between these two dates is your DEPRECIATION THIS RUN.

So, Westfields Bakery is satisfied with their depreciation for January 2008 and decides to book it to their ledger. Some time passes, and after booking their May 2008 depreciation, they realize that they need to reprint that January 2008 report. They depreciate their asset back to January 2008 and draw up their report and see the result below:

sample report

Where did that Depreciation This Run of $4519.69 come from? That definitely doesn't match the value of $25.49 on the previous report. Looking at the top of the report, we can see that the "as of" date is correct, but what about the Prior Thru? It no longer says 12/31/2007 like it did in the previous report. In fact, it's blank. What happened?

Westfields Bakery had already depreciated their assets to May when they decided they needed to reprint the January report. They depreciated directly to January. The problem is DEPRECIATION THIS RUN is not a stored field, and they didn't give FAS Asset Accounting a starting point for that depreciation. When you're depreciating forward, the program is always going to have a starting point for the calculation: the previous month's depreciation date.

When you depreciate to a past period, FAS Asset Accounting doesn't have a prior date to pull from. Therefore, it's going to start its calculation from one of the three firm points of data that the program has, each of which is circled on the screenshot below:

screenshot

Most commonly, this is going to be the Service Date of the asset, which is shown in the second report screenshot. When the program calculates forward from the Service Date, the Prior Thru date is going to be blank. The other two possible starting points are the Beginning Date or the Period Close date. FAS Asset Accounting will start from the most recent of these dates that is available.

So how do we fix this problem? The solution is quite simple. We need to give FAS Asset Accounting an actual starting point for its calculation. Since Westfields Bakery does their depreciation monthly, the starting point we need is going to be December 2007.

screenshot

Once this depreciation calculation completes, you will be given a report that looks somewhat similar to the problem report we had in January:

screenshot

Don't worry about this report looking wrong. The data in it is irrelevant to what we're doing. After completing this calculation, FAS Asset Accounting now has a starting point for our January calculation. Let's depreciate to January and see what happens:

screenshot

As you can see, we once again have a proper interval for our Depreciation This Run. With the Prior Thru reading 12/31/2007, the report shows the value we would expect: $25.49. Problem solved.

Any time you see a value under Depreciation This Run, be it under an active asset or a disposal, the very first thing you should look at is the date in the Prior Thru column. If you depreciate yearly, it should display the end of the previous year. If you depreciate quarterly, it should display the end of the previous quarter. If this date is ever wrong, you know immediately that the program isn't giving you the interval you would expect. Depreciate your assets to the end of the previous period, and then the current period, and the issue will nearly always resolve itself.

Comments

No Comments

About jwest

Product Specialist with Sage Software