Auto Calculation Working as per Companies Act 2013

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

Image result for excel

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 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 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.

Preparing for CA Final? - Must read below
CAKART provides Indias top faculty each subject video classes and lectures – online & in Pen Drive/ DVD – at very cost effective rates. Get video classes from Quality is much better than local tuition, so results are much better. Watch demo videos below -

Leave a comment

Your email address will not be published. Required fields are marked *