This report is useful to understand the monthly depreciation related to the assets.
This report can be accessed by going to:
Reports > Depreciation Reports > Monthly Depreciation Report
After reaching here, the following screen will be visible:
The coloured boxes shown here in the Red Rectangle. These give us the option of saving as Report or Widget, Exporting the data as PDF or Excel File, Refreshing the data to reflect any new additions and Grid Settings to tailor the information grid according to our requirements by making changes to it.
Here, we will also see a drop down, shown above where “Default View” is written. This means that the monthly Depreciation Report which will be shown below will be in the default view which has been provided. We can also create our own custom view by clicking on the “+” Button on the right of “Default View”.
Here, we can see different fields associated with the monthly depreciation report. We have the fields related to Depreciation Method, Date, Category Name, Asset Location, Capitalization Date, Department.
Depreciation Method field helps us to choose the desired depreciation method for our fixed assets. When we click on it, we get to see these options:
Straight-Line Method we can calculate the depreciation.
In the Date column, we need to mention the date till which we want to see the Depreciation Report. Here 18th May has been mentioned.
In the category name we can add the category of the asset for which we want to see the depreciation information.
In the Asset Location we can add the Location of the Asset for which we want to view the monthly depreciation information.
Capitalization Date can also be mentioned.
Department field helps us in selecting the Department for whose assets we will see the depreciation information.
We can click on Clear Button shown in the green rectangle to clear all the information added in the fields till now.
After clicking on the run report button, the monthly depreciation report will look like this:
We can increase the per page records that will be shown, by clicking on Showing Records Dropdown which can be seen within the Purple Rectangle in the above image.
Here, different fields are shown such as Category Code, Asset Name, Asset Code, Invoice Date, Vendor Name, JAN, FEB, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Category Code shows the code of the category to which the asset belongs to.
Asset Name is the name of the asset for which the depreciation is being calculated.
Asset Code is the unique code of the asset.
Invoice Date is the date of raising the invoice of the asset with the vendor.
Vendor Name is the name of the vendor from whom the asset has been purchased.
Then the monthly depreciation up to the Date chosen is calculated and shown in the respective month column.
We can set Filters in the various fields above by typing in the Text Box in the Grid which is just below the respective Column Headings. We can set Multiple Filters. After adding the Filters, we will see the following screen:
We can see that the filter in the category code has been added and is shown by the yellow rectangle. After adding that, we can see the filtered records here in the image.
We can remove the filters through the “Clear Filter” Option.
This is how we can see the Monthly Depreciation Report.