depreciation schedule as per companies act 2013 in excel format

Depreciation Schedule per Companies Act 2013: Free Excel Templates

By Anthony Young
AD

Embracing the digital age, businesses are increasingly leveraging technology to streamline their operations, including asset management. The Companies Act, 2013, in India, mandates the creation of a depreciation schedule for fixed assets. Excel, with its robust features and widespread use, is a powerful tool for creating and maintaining such schedules. Here, we delve into the intricacies of creating a depreciation schedule as per the Companies Act, 2013, using Excel.

Firstly, understanding the Companies Act, 2013, is crucial. The act stipulates that fixed assets should be depreciated at a rate prescribed by the Income Tax Department. This is typically based on the useful life of the asset and is applicable to various asset classes, such as land and buildings, machinery, vehicles, furniture, and computers.

Setting Up the Excel Template

Begin by creating a new Excel sheet. In the first row, list down the columns you need: 'Asset ID/Name', 'Purchase Date', 'Cost', 'Useful Life', 'Depreciation Method', 'Annual Depreciation', and 'Accumulated Depreciation'.

AD
Depreciation Schedule Template Excel, Download Free Depreciation Schedule
Depreciation Schedule Template Excel, Download Free Depreciation Schedule
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
Printable Depreciation Schedule Template
Printable Depreciation Schedule Template

Using Excel's data validation features, ensure the 'Depreciation Method' column only accepts methods prescribed by the Income Tax Department, such as 'Straight Line', 'Written Down Value', or 'Units of Production'. This enhances data integrity and simplifies the depreciation calculation.

Calculating Depreciation

Excel's built-in functions can automate depreciation calculations. For 'Straight Line' depreciation, use the DDB (Double Declining Balance) function. For 'Written Down Value', use the SLN (Straight Line) function. The formula for 'Units of Production' is more complex and may require additional columns to track units produced and their value.

Free Depreciation Schedule Template - Printable Formats
Free Depreciation Schedule Template - Printable Formats
Depreciation Excel Template
Depreciation Excel Template
13+ Depreciation Schedule Templates Free - Word Excel Templates
13+ Depreciation Schedule Templates Free - Word Excel Templates

For instance, assuming the 'Useful Life' is 5 years and the 'Cost' is 5,000, the formula for 'Annual Depreciation' in the 'Straight Line' method would be: `=5000/5`. To calculate 'Accumulated Depreciation', use a simple sum function: `=SUM(Annual Depreciation)`.

Updating and Maintaining the Schedule

Excel's sorting and filtering capabilities allow easy management of the depreciation schedule. Sort by 'Purchase Date' to track assets nearing the end of their useful life. Use conditional formatting to highlight assets that have reached their residual value, indicating they may be candidates for replacement.

AD

To maintain the schedule, update it periodically (quarterly or annually) to reflect new acquisitions, disposals, or changes in asset values. Excel's ability to create linked templates can facilitate regular updates without starting from scratch.

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
Download Depreciation Calculator Excel Template - ExcelDataPro
Download Depreciation Calculator Excel Template - ExcelDataPro
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

Tracking and Reporting Depreciation

Excel's pivot tables and charts can help transform raw data into meaningful insights. Create a pivot table to summarize depreciation by asset class, location, or other relevant categories. Generate bar or line charts to visualize trends in depreciation and accumulated depreciation.

For statutory reporting, use Excel's export features to generate reports in the required format. The Companies Act, 2013, mandates that depreciation should be disclosed in the 'Profit and Loss Statement' and 'Balance Sheet'. Ensure the schedule aligns with these reporting requirements.

AD

Ensuring Compliance

To adhere to the Companies Act, 2013, ensure all fixed assets are included in the depreciation schedule. Regularly review and update the schedule to reflect changes in asset values or acquisition/disposal of assets. Lastly, validate the schedule with the annual accounts or consult with a chartered accountant to ensure compliance with the act.

How to Use Depreciation (DB) Formula in Excel
How to Use Depreciation (DB) Formula in Excel

In the dynamic business landscape, a well-maintained depreciation schedule in Excel is not just a compliance tool but a strategic asset for informed decision-making. Track and analyze depreciation trends to optimize asset utilization, plan replacements, and improve overall business efficiency.

AD