CA Ravindra Patil

Techno-Tip #8 by CA Ravindra Patil (92093-00789)                         (16-09-2018) How to open New version Tally data in Old version of Tally Paste data into data directory Open tally If any company automatically opened close it by pressing Alt+F1 Now you will be at “Company Info.” Window Press Alt + Ctrl + R – it will navigate to Rewrite Company Select the company to rewrite It will as “Rewrite?” select Yes It will ask “Backup before rewriting?” select Yes Select the destination folder to backup if not already selected or simply type C:\ or D:\ or E:\ Your company is not rewritten. Open the company and enjoy your work.

Techno-Tip #7 by CA Ravindra Patil (92093-00789)                         (17-03-2018) Protect a word document and mark the parts that can be changed in Word 1. On the Review tab, in the Protect group, click Restrict Editing. 2. In the Editing restrictions area, select the Allow only this type of editing in the document              check  box. 3. In the list of editing restrictions, click No changes (Read only). 4. Select the part of the document where you want to allow changes.      Tip: To select more than one part of the document at the same time, select the part that you want, then press CTRL and select                 more parts while you hold down the CTRL key. 5. Under Exceptions select the Everyone check box in the Groups list. 6. Und...

_Techno-Tip #6 by CA Ravindra Patil (92093-00789)                        (10-03-2018)_ *Cell Reference in Excel* 1. Excel has a cell reference style C1R1     Where C1=Column 1 & R1=Row 1 2. When we drag/copy and paste the formula cell reference also change automatically.      e.g. C1=A1+B1, if we copy cell C1 & paste in cell F5 formula will change to D5+E5 it’s called              relative reference 3.  If you want to make the cell reference as absolute reference (means reference will not change             with drag/ copy & paste) we have to assign $ sign to column & row label      e.g. C1=$A$1+$B$1, here if you copy formula of cell C1 & paste in F5, formula in cell F5 will             ...

Techno-Tip #5 by CA Ravindra Patil                          (03-03-2018) Keys and Shortcuts Keys for Fast Navigation in Excel 1. Arrow Keys = move up, down, left & right 2. Page up/down = go one page up/down in same sheet 3. Alt + page up/down = go one page left/right 4. Ctrl + Arrow Keys = go to end of continuous range 5. Ctrl + Page up/down = Go to previous or next sheet 6. Shift F11 = insert new sheet 7. F5 = go to specified location (either cell reference/name) 8. Ctrl + [ = trace precedent 9. Ctrl + ] = trace dependent 10. Ctrl + F3=Name Manger =Apply name to selected range. 11. Home = go to first cell of selected row. 12. Ctrl + Home = Go to first cell of Sheet 13. Ctrl + end = go to last edited cell in sheet Tip: Use Shift with above combinations for selection

File Yours and Family's Income Tax Return before 31st March, if pending. From 1st April 2018, It will not be possible to file return for FY 2015-16 nd 2016-17. Only 1 year return can be filed i.e. FY 2017-18 So if you are planning for Loan, Foreign Trip, Term Insurance etc. Where return of last 3 years are required, better to file your return now.

Kindly file GSTR3B for the month of July, 2017 up to 24th February, 2018. GST Act provides for Cancellation of GST Registration under following circumstances: 1. A registered person violates the Act or any rules under it. 2. A person under the Composition Scheme who doesn’t furnish returns for 3 consecutive tax periods. 3. Any registered person who doesn’t furnish returns for a continuous period of 6 months. 4. Any person who takes voluntary registration but doesn’t start business within 6 months from the date of registration.

*Mandatory Filing of Income Tax Return* *_Please note that the law has changed and ITR for AY 2017-18 CANNOT be filled beyond 31st March 2018._* In any of the following situations (as per the Income Tax Act) it is mandatory for you to file an Income Tax Return in India: 1. Your gross total income (before allowing any deductions under section 80C to 80U) exceeds Rs.2,50,000 in the FY 2016-17. This limit is Rs 3,00,000 for senior citizens ( who are more than 60 years old but less than 80 years old) or Rs 5,00,000 for super senior citizens (who are more than 80 years old) 2. You are a company or a firm irrespective of whether you have income or loss during the financial year. 3. You want to claim an income tax refund 4. You want to carry forward a loss under a head of income. 5. You have exempt long term capital gains from – sale of equity shares in a company OR sale of unit of equity oriented mutual funds, OR sale of unit of business trust, of more than Rs 2,50,000 in a f...