depreciation schedule ii of companies act 2013 format in excel

Depreciation Schedule II Format in Excel: Companies Act 2013 Compliance

By Nicole Rodriguez
AD

Grasping the intricacies of the Company's Act 2013 and its associated depreciation schedules can be a task in itself, especially when it comes to creating these schedules in an organized, easy-to-understand format like Excel. But with the right insights and some practice, you'll find that navigating the depreciation schedule II of the Companies Act 2013 format in Excel is not as daunting as it might initially seem.

To get started, let's briefly understand what depreciation schedule II of the Companies Act 2013 is all about. This schedule is a means of recording the depreciation of fixed assets, a crucial part of any company's financial reporting. It's a way of recognizing the cost of an asset over its useful life, which is important for an accurate representation of a company's net worth and cash flow.

The Basics of Depreciation Schedule II in Excel

The depreciation schedule II is typically created using tables in Microsoft Excel. It should capture all the necessary details about the depreciation of a company's assets, including the type of asset, its initial cost, the estimated useful life, and the method of depreciation used.

AD
Depreciation Schedule Template Excel, Download Free Depreciation Schedule
Depreciation Schedule Template Excel, Download Free Depreciation Schedule
Depreciation Excel Template
Depreciation Excel Template
Free Depreciation Schedule Template - Printable Formats
Free Depreciation Schedule Template - Printable Formats

Creating such a table requires carefully structuring the Excel sheet for optimal output. However, with the right structure and a bit of knowledge about the Companies Act 2013, you can create a clear and comprehensive depreciation schedule.

Setting Up the Excel Sheet

First, you'll need to format your Excel sheet. Start with the column headers: 'Asset Type', 'Asset ID' or 'Asset Description', 'Purchase Date', 'Initial Cost', 'Estimated Life', 'Method of Depreciation', 'Residual Value', 'Depciation Every Month/Year', and 'Cumulative Depreciation'.

Printable Depreciation Schedule Template
Printable Depreciation Schedule Template
How To Calculate Depreciation As Per Companies ACT 2013 | Depreciation Chart As Per Companies Act
How To Calculate Depreciation As Per Companies ACT 2013 | Depreciation Chart As Per Companies Act
13+ Depreciation Schedule Templates Free - Word Excel Templates
13+ Depreciation Schedule Templates Free - Word Excel Templates

These columns will allow you to record all the necessary details about the assets, the method of depreciation, and the amount of depreciation each year or month.

Filling in the Values

Next, you will input the details of each asset. For example, in the 'Asset Type' column, you might input 'Building', 'Vehicle', or 'Equipment', depending on the asset in question. You'd then fill in the 'Asset ID' or 'Asset Description', 'Purchase Date', and 'Initial Cost' in their respective columns.

AD

Following this, specify the 'Estimated Life' of the asset and the 'Method of Depreciation'. The method of depreciation could be Straight Line, reducing balance, units of production, or some other method as per the company's policy.

Depreciation Schedule Template Excel & Google Sheets
Depreciation Schedule Template Excel & Google Sheets
Free Depreciation Schedule Templates | MS Excel & MS Word
Free Depreciation Schedule Templates | MS Excel & MS Word
Straight Line Depreciation Schedule Calculator | Double Entry Bookkeeping
Straight Line Depreciation Schedule Calculator | Double Entry Bookkeeping
How to Create Monthly Depreciation Schedule in Excel - ExcelDemy
How to Create Monthly Depreciation Schedule in Excel - ExcelDemy
Depreciation Calculator | Excel Template | Straight Line, Double Declining, Sum of Years, Units of Production
Depreciation Calculator | Excel Template | Straight Line, Double Declining, Sum of Years, Units of Production
How to Use Depreciation (DB) Formula in Excel
How to Use Depreciation (DB) Formula in Excel

Calculations in the Depreciation Schedule

With the basic details of the assets recorded, the final step is to calculate the depreciation. In the 'Depreciation Every Month/Year' column, you would input the amount to be depreciated each year or month. The 'Cumulative Depreciation' column would automatically calculate the total depreciation so far.

Keep in mind that the Company's Act 2013 recommends tracking depreciation in either Rupees (₹) or as a percentage, so adapt your calculations accordingly.

AD

Straight Line Method

The straight line method is the most frequently used method. Here, the cost of the asset is spread over its entire lifespan. If you choose this method, the annual depreciation would be calculated as (Initialcost - ResidualValue) / Estimated Life. For example, if the initial cost of a building is ₹50 lac, the residual value is ₹5 lac, and the estimated life is 10 years, the annual depreciation would be (5000000 - 500000) / 10 = ₹450,000.

Download Free Accounting Templates in Excel
Download Free Accounting Templates in Excel

Similarly, you can calculate for other methods like reducing balance, units of production, etc.

Reviewing and Updating the Schedule

Remember to regularly review and update your depreciation schedule. This will ensure that your accounts reflect the true value of your assets and that you're complying with the Companies Act 2013. Further, maintaining an accurate depreciation schedule can significantly improve your potential loan applications, as banks and other financial institutions will often review these schedules during the approval process.

AD

By following these steps and maintaining a well-structured Excel sheet, you'll be able to accurately record and track the depreciation of your company's assets in line with the Companies Act 2013. As you move forward with this process, you'll find that staying organized and up-to-date with your depreciation schedule will provide indispensable insights into your company's financial health.

AD