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:
Auto Calculation Working as per Companies Act 2013
Download Auto Calculation Working as per Companies Act 2013
At CAKART www.cakart.in you will get everything that you need to be successful in your CA CS CMA exam – India’s best faculty video classes (online or in pen drive) most popular books of best authors (ebooks hard copies) best scanners and all exam related information and notifications.Visit www.cakart.in and chat with our counsellors any time. We are happy to help you make successful in your exams.
Click here to download FREE CA CS CMA books.