Auto Calculation Working as per Companies Act 2013

by cakart Last Modified: January 4, 2018

Auto Calculation Working as per Companies Act 2013

Automatic Calculation.

Automatic calculation mode means that Excel will automatically recalculate all open workbooks at each and every change, and whenever you open a workbook.

Usually when you open a workbook in Automatic mode and Excel recalculates you will not see the recalculation because nothing will have changed since the workbook was saved.
An exception is when you open a workbook in Excel 2000 that was saved using Excel 97, or you open using Excel2002/2003 a workbook saved in Excel2000: because the Excel calculation engines are different a Full calculation is done.

Petty Cash Book Format in Excel

Find more Books, Video lectures and Scanners on Accounting Standards @ CAKART

Manual calculation mode means that Excel will only recalculate all open workbooks when you request it by pressing F9 or Ctrl-Alt-F9, or when you Save a workbook.

Depreciation calculation sheet is created for Companies using WDV method and not for SLM method.

It is highly suggested / recommended that instead of adjusting with retained earning, transfer the same in P/L A/c in the form of depreciation and calculate the deferred tax as usual as earlier.

Recommended Read: Cost Accounting and Financial management

Best Recommended Courses For CA CS CMA Professional

Certificate in Business Management using Tally.ERP9 (Online)

Tally ERP 9 Video classes on the topic how to create single ledgers by Viral Jadhav

Certificate in Microsoft Excel for Business Professionals (Online)

Click here and Download A very useful Excel Function Dictionary

Recommended Read: Tally Short Cut Keys

Recommended Read: