Saral Tax India | Taxation info in saral language

Highlight Active Row And Column in excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<center>
<img src="https://3.bp.blogspot.com/-10xeYhya_5A/XIehgtjFeJI/AAAAAAAAIEE/8w3zeR1YsWY4YJ3o0keeMO1hxWOTZPGbACLcBGAs/w500/highlight%2Bactive%2BRow%2B%2526%2Bcoloumn%2B.jpg" /></center>
<br />
Most of us working on excel and if we have a lot of data in excel then we need to guess in which cell we are working....<br />
here is one simple method..<br />
Just copy the below code and open the excel sheet in which you want to highlight the text then click <b>Alt+F11</b> or click on view code on developer tab.<br />
then paste in the Code view section of sheet1 or in the sheet in which you are working then save the file in <b>xlsm </b>or Xls format.<br />
<br />
<center>
<img src="https://1.bp.blogspot.com/-T8DYoO29Esc/XIfOb4tu00I/AAAAAAAAIEQ/9EeTB5cUYyM69Zy93pQNwy55G6v_AyQEACLcBGAs/w320/highlight%2Bactive%2Brow%2Band%2Bcoloumn.JPG" /></center>
<br />
<center>
<button class="button"><a blank="" href="https://drive.google.com/uc?export=download&id=1LNS0uJdD5TQFDtraELGXk0Kl-qdnFTYL" target="_">Download</a></button></center>
<br />
<center>
<a href="https://4.bp.blogspot.com/-GOZDD_p_pNs/XIfO9XFYX0I/AAAAAAAAIEY/w7WaJxcgCXIxwFL7wIo75QH3zRfK7R2wQCLcBGAs/s1600/highlight%2Bactive%2Brow%2Band%2Bcoloumn%2B1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img src="https://4.bp.blogspot.com/-GOZDD_p_pNs/XIfO9XFYX0I/AAAAAAAAIEY/w7WaJxcgCXIxwFL7wIo75QH3zRfK7R2wQCLcBGAs/w540/highlight%2Bactive%2Brow%2Band%2Bcoloumn%2B1.JPG" width="640" /></a></center>
</div>

Highlight Active Row And Column in excel

Most of us working on excel and if we have a lot of data in excel then we need to guess in which cell we are working.... here is one si...

Discount amount instead of Percentage in tally invoice

1 accounts, download, tally 8:00 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<center>
<img alt="how to show discount amt in invoice instead of percentage" src="https://4.bp.blogspot.com/-Et8ruTtfAh4/XIUTgTSXCII/AAAAAAAAIDY/jmj3ofmN2L0MhxsU8gtVAyo38Tih-fFEACLcBGAs/w500/show%2Bdiscount%2Bcoloumn%2Bas%2Bamt%2Bin%2Btally.jpg" title="How to show discount column in Invoice" /></center>
<br />
In this post we will learn how to show discount column in invoice <br />
<br />
To display a separate column for entering discount in invoices, please follow the steps given below: <br />
<br />
Go to <b>Gateway of Tally</b> > Press <b>F11: Features </b>-> <b>Press F2 </b>or click on <b>Inventory Features</b>.<br />
Set the parameter Separate Discount column on Invoices to Yes<br />
<br />
<center>
<img alt="how to show discount column amount instead of percentage in tally invoice" src="https://4.bp.blogspot.com/-7Hhm6kTB8wg/XIFNHGRIbSI/AAAAAAAAICY/XdyIaTEYUIcCfrHS5WA16qOTe5z87jiMQCLcBGAs/s1600/Discount%2Bcoloumn%2Bin%2Binvoice.JPG" title="how to show discount column in tally invoice" /></center>
<br />
Now below is tdl code for tally that convert Discount Column percentage to discount amount.<br />
<br />
<center>
<button class="button"><a blank="" href="https://drive.google.com/uc?export=download&id=1HCfbJE7QokESy-KeZ4URD9HITJ0UqXzg" target="_">Download</a></button></center>
<br />
<span style="font-size: large;"><b>How to Install TDL in Tally</b></span><br />
TDL file can be install in 2 way<br />
<br />
<b>1st:  Using Tally.ini</b><br />
<br />
<ol style="text-align: left;">
<li>Open Tally.ERP 9 folder, for e.g., C:\Tally.ERP9</li>
<li>Open Tally.ini file located in Tally Erp installation folder</li>
<li>find <b>User TDL=</b></li>
<li>Ensure that the option User TDL =Yes</li>
<li>Include TDL filename with directory path and save</li>
</ol>
<b>2nd Using F12 Configuration</b><br />
<ol style="text-align: left;">
<li>From Gateway of Tally menu Select F12:Configure</li>
<li>Select the menu item <b>TDL Configuration </b>or <b>Product & Features Menu</b></li>
<li>Click F4:Local TDLs on button bar</li>
<li>Add the file name with directory path e.g. C:\Tally.ERP9\discount.txt</li>
</ol>
</div>

Discount amount instead of Percentage in tally invoice

In this post we will learn how to show discount column in invoice To display a separate column for entering discount in invoices, plea...

Link your Pan with Bank Account No Refund if Not Linked

0 banks, income-tax, income-tax-news, pan 1:00 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<b><span style="font-size: large;">Link your pan card with your bank account</span></b></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<b>Get your refund directly, swiftly and securely in your bank account</b></div>
<div style="text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img alt="Without linking pan with bank no refund will be processed" border="0" data-original-height="364" data-original-width="600" src="https://4.bp.blogspot.com/-e1qH3QyhOZg/XHeUttwsxgI/AAAAAAAAIBA/tPpxkfJicHMnOrEd02myJThsko2xMtS3QCLcBGAs/s1600/Pan%2Blink%2Bto%2Bbank.jpg" title="Link your PAN  with Bank account" /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: justify;">
Income Tax Department will Issue only e-refunds from 01.03.2019 Refunds will be given only to bank accounts (savings/current/cash/OD) which are linked with PAN. <span style="text-align: left;">If your bank is integrated with the e-filing portal, pre-validation can be done directly through EVC (Electronic Verification Code) and net-banking route. </span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
To check if your bank account is linked with your PAN, login to e-filing portal, go to Profile setting → Pre-validate your bank account</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>If not yet linked, provide your PAN details to your bank branch</b></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
You must also pre-validate your bank account. Login to e-filing portal, go to Profile setting → Pre-validate your bank account, and till up the details</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
→ If your bank is integrated with the e-filing portal, pre-validation will be done directly through EVC and net banking route</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
→ If your bank is not so integrated, then Income Tax Department will validate the bank account from the details filled up by you</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>Note : Remember Link your pan card with Aadhar card also mandatory and last date is 31.03.2019</b></div>
<br />
The department has asked the taxpayers to link their PAN with bank accounts in order to get the income tax refund directly, swiftly and securely in their bank account.<br />
<br />
How to link your Bank with PAN:-<br />
<br />
1st step:- Login to  e-filing portal www.incometaxindiaefiling.gov.in<br />
<br />
2nd step:- Click on login here and enter your details to log in. The user ID is your PAN.<br />
<br />
3rd step:- Once logged in, click on profile settings and click on pre-validate your bank account<br />
<br />
4th step:- Enter your bank details i.e. bank account number, IFSC, bank name, mobile number, and email id. Remember your PAN, name, mobile number and email id must match with the details as given in your bank account to successfully pre-validate your bank account. </div>

Link your Pan with Bank Account No Refund if Not Linked

Link your pan card with your bank account Get your refund directly, swiftly and securely in your bank account Income Tax Dep...

EPF recommends crediting of 8.65% rate of interest on Accumulations in the EPF Member’s Account for the year 2018-19

0 80-c, epf, income-tax, income-tax-news 8:00 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<b>Central Board of Trustees, EPF recommends crediting of 8.65% rate of interest on Accumulations in the EPF Member’s Account for the year 2018-19</b></div>
<div style="text-align: center;">
Posted On: 21 FEB 2019 6:03PM by PIB Delhi</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: justify;">
The 224th meeting of the Central Board of Trustees, EPF was held here today under the chairmanship of Union Minister of State for Labour and Employment (I/C) Shri Santosh Kumar Gangwar.  The Central Board recommended crediting of 8.65 % rate of interest on the EPF accumulations in the EPF member’s account for the year 2018-19.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The Central Board ratified the amendment in EPF Scheme 1952, as approved in the 141st   meeting of Financial Investment and Audit Committee (FIAC) held on February 12, 2019, to enable accounting of Investment in Exchange Traded Funds (ETFs) (Equity & Related Investment).</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The Central Board ratified the approval of Chairman, CBT, EPF for continuation of C-DAC as a consultant to carry out the second phase of Computerisation Project. The Board gave extension to M/s Standard Chartered Bank as custodian of the EPFO securities on the existing terms and conditions of agreement for the period up to March 31, 2019. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The Central Board approved revised estimate for the year 2018-19 and budget estimates for the year 2019-20 and recommended it to the Central Government for approval. The Board gave consent to have performance review of the Portfolio Managers from a separate agency in addition to review by M/s CRISIL Limited.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The Central Board took note of the proposal for recommendation for grant of exemption to six establishments under Section 17(2) of the EPF & MP Act, 1952 read with Para 27A of the EPF Scheme, 1952 by the Appropriate Government . The Board took note of the proposal for recommendation for grant of exemption under Section 17(2) of the EPF & MP Act 1952 read with Para 27A of the EPF Scheme,1952 to M/s Software Technology Parks of India with effect from June 05, 1994 by the Appropriate Government.</div>
</div>

EPF recommends crediting of 8.65% rate of interest on Accumulations in the EPF Member’s Account for the year 2018-19

Central Board of Trustees, EPF recommends crediting of 8.65% rate of interest on Accumulations in the EPF Member’s Account for the year 20...

Income Tax Calculator FY 2019-20

0 80-c, 80CCD, budget, budget-2019, calculator, deduction, download, income-tax, income-tax-news 5:00 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><img border="0" data-original-height="845" data-original-width="1600" height="211" src="https://1.bp.blogspot.com/-k405X2pn3GI/XGUzdi-JBbI/AAAAAAAAH8s/5OEsBTAdfZ4kYmM9TmcZNlWXr5OKFiD6ACLcBGAs/s400/income%2Btax%2Bcalculator.jpg" style="margin-left: auto; margin-right: auto;" width="400" /></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Income Tax Calculator</td></tr>
</tbody></table>
<br />
<div style="text-align: justify;">
Interim Budget 2019-2020 Speech has been presented by Piyush Goyal , Minister of Finance on February 1, 2019. Although no changes has been made in made in tax slabs Rate, but a rebate u/s 87a has been allowed till maximum amount of Rs. 12500 to the Taxable persons having taxable income up to Rs 500000/- the limit was Rs 2500/- till taxable income of Rs 350000/- in the previous year.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
But if your taxable income crosses the limit of Rs 5,00,000/- then you will have to Pay tax on Rs 5,00,000/- if Your Taxable income Rs 5,00,001/- then tax would be Rs. 13000/- its a tricky move by Finance Minister CA Piyush Goyal.</div>
<div style="text-align: justify;">
<br />
<br /></div>
<div style="text-align: justify;">
<b>Along with this Some main points are :</b></div>
<div style="text-align: justify;">
1. TDs on Fixed Deposit U/s 194A limit Increased to Rs 40,000/- from Rs 10,000/-        </div>
<div style="text-align: justify;">
2. Tds on Rent U/s 194I limit increased to Rs 2,40,000/- from Rs 1,80,000/-        </div>
<div style="text-align: justify;">
3. Standard Deduction for Salaried Person only Rs 50,000/- Flat last year it was Rs. 40,000/-        </div>
<div style="text-align: justify;">
4. Limitation of purchasing residential house u/s 54 for Capital is extended… if Capital Gain is more Than Rs 2 Crore then investment can be done in 2 residential houses. This benefit can be availed once in a life time.</div>
<div style="text-align: justify;">
5. Tax Rebate of Rs 12500/- is given u/s 87A but for this amendment in the act is required.        </div>
<div style="text-align: justify;">
6. Benefit u/s 80IB has increased to one more year i.e. 2020</div>
<div style="text-align: justify;">
7. Benefit has given to unsold inventory has increased to one year to two years.</div>
<div style="text-align: justify;">
8. Exempt on tax on second self-occupied house</div>
<br />
Income Tax Calculator For FY 2019-20 in excel with auto calculation.<br />
<br />
<button class="button"><a blank="" href="https://drive.google.com/uc?export=download&id=1b_4_SmLUImlO3X451uTo3fc1na3A_Llq" target="_">Download Calculator</a></button><br />
<br />
<table id="paleBlueRows"><caption></caption><thead>
<tr><th colspan="1" id="t885280_row_0col_0">Tax Rate</th> <th colspan="1" id="t885280_row_0col_1">Individual</th> <th colspan="1" id="t885280_row_0col_2">60+ but below 80</th> <th colspan="1" id="t885280_row_0col_3">Age 80 +</th> </tr>
</thead><tbody>
<tr><th colspan="1" id="t885280_row_1col_0">Old Tax</th> <td colspan="1" data-header="Individual" headers="t885280_row_1col_0 t885280_row_0col_1">13000</td> <td colspan="1" data-header="60+ but below 80" headers="t885280_row_1col_0 t885280_row_0col_2">10400</td> <td colspan="1" data-header="Age 80 +" headers="t885280_row_1col_0 t885280_row_0col_3">0</td> </tr>
<tr><th colspan="1" id="t885280_row_2col_0">New Tax</th> <td colspan="1" data-header="Individual" headers="t885280_row_2col_0 t885280_row_0col_1">0</td> <td colspan="1" data-header="60+ but below 80" headers="t885280_row_2col_0 t885280_row_0col_2">0</td> <td colspan="1" data-header="Age 80 +" headers="t885280_row_2col_0 t885280_row_0col_3">0</td> </tr>
<tr><th colspan="1" id="t885280_row_3col_0">Change</th> <td colspan="1" data-header="Individual" headers="t885280_row_3col_0 t885280_row_0col_1">-13000</td> <td colspan="1" data-header="60+ but below 80" headers="t885280_row_3col_0 t885280_row_0col_2">-10400</td> <td colspan="1" data-header="Age 80 +" headers="t885280_row_3col_0 t885280_row_0col_3">0</td> </tr>
</tbody></table>
<br />
<table id="paleBlueRows"><caption>If Total Income is Rs 5,00,001/-</caption> <thead>
<tr>             <th colspan="1" id="t887756_row_0col_0">Tax Rate</th>             <th colspan="1" id="t887756_row_0col_1">Individual</th>             <th colspan="1" id="t887756_row_0col_2">60+ but below 80</th>             <th colspan="1" id="t887756_row_0col_3">Age 80 +</th>        </tr>
</thead> <tbody>
<tr>             <th colspan="1" id="t887756_row_1col_0">Old Tax</th>             <td colspan="1" data-header="Individual" headers="t887756_row_1col_0 t887756_row_0col_1">13000</td>             <td colspan="1" data-header="60+ but below 80" headers="t887756_row_1col_0 t887756_row_0col_2">10400</td>             <td colspan="1" data-header="Age 80 +" headers="t887756_row_1col_0 t887756_row_0col_3">0</td>        </tr>
<tr>             <th colspan="1" id="t887756_row_2col_0">New Tax</th>             <td colspan="1" data-header="Individual" headers="t887756_row_2col_0 t887756_row_0col_1">0</td>             <td colspan="1" data-header="60+ but below 80" headers="t887756_row_2col_0 t887756_row_0col_2">0</td>             <td colspan="1" data-header="Age 80 +" headers="t887756_row_2col_0 t887756_row_0col_3">0</td>        </tr>
<tr>             <th colspan="1" id="t887756_row_3col_0">Change</th>             <td colspan="1" data-header="Individual" headers="t887756_row_3col_0 t887756_row_0col_1">-13000</td>             <td colspan="1" data-header="60+ but below 80" headers="t887756_row_3col_0 t887756_row_0col_2">-10400</td>             <td colspan="1" data-header="Age 80 +" headers="t887756_row_3col_0 t887756_row_0col_3">0</td>        </tr>
</tbody> </table>
<b>Note :</b> No tax Because Rounded off Section will be applicable rounding nearest to Rs 10/-<br />
<br />
<br />
<table id="paleBlueRows"><caption>If Total Income is Rs 6,00,000/-</caption> <thead>
<tr>             <th colspan="1" id="t693895_row_0col_0">Tax Rate</th>             <th colspan="1" id="t693895_row_0col_1">Individual</th>             <th colspan="1" id="t693895_row_0col_2">60+ but below 80</th>             <th colspan="1" id="t693895_row_0col_3">Age 80 +</th>        </tr>
</thead> <tbody>
<tr>             <th colspan="1" id="t693895_row_1col_0">Old Tax</th>             <td colspan="1" data-header="Individual" headers="t693895_row_1col_0 t693895_row_0col_1">33800</td>             <td colspan="1" data-header="60+ but below 80" headers="t693895_row_1col_0 t693895_row_0col_2">31200</td>             <td colspan="1" data-header="Age 80 +" headers="t693895_row_1col_0 t693895_row_0col_3">20800</td>        </tr>
<tr>             <th colspan="1" id="t693895_row_2col_0">New Tax</th>             <td colspan="1" data-header="Individual" headers="t693895_row_2col_0 t693895_row_0col_1">33800</td>             <td colspan="1" data-header="60+ but below 80" headers="t693895_row_2col_0 t693895_row_0col_2">31200</td>             <td colspan="1" data-header="Age 80 +" headers="t693895_row_2col_0 t693895_row_0col_3">20800</td>        </tr>
<tr>             <th colspan="1" id="t693895_row_3col_0">Change</th>             <td colspan="1" data-header="Individual" headers="t693895_row_3col_0 t693895_row_0col_1">0</td>             <td colspan="1" data-header="60+ but below 80" headers="t693895_row_3col_0 t693895_row_0col_2">0</td>             <td colspan="1" data-header="Age 80 +" headers="t693895_row_3col_0 t693895_row_0col_3">0</td>        </tr>
</tbody> </table>
<button class="button"><a blank="" href="https://drive.google.com/uc?export=download&id=1b_4_SmLUImlO3X451uTo3fc1na3A_Llq" target="_">Download Calculator</a></button></div>

Income Tax Calculator FY 2019-20

Income Tax Calculator Interim Budget 2019-2020 Speech has been presented by Piyush Goyal , Minister of Finance on February 1, 2019. A...

HIGHLIGHTS OF BUDGET 2019

0 budget, budget-2019 6:00 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<b><span style="font-size: large;">HIGHLIGHTS OF BUDGET 2019</span></b></div>
<br />
<b><span style="font-size: large;">Tax</span></b><br />
<br />
<ol style="text-align: left;">
<li>Within 2 years, Tax assessment will be done electronically</li>
<li>IT returns processing in just 24 hours</li>
<li>Minimum 14% revenue of GST to states by Central Govt.</li>
<li>Custom duty has abolished from 36 Capital Goods</li>
<li>Recommendations to GST council for reducing GST rates for home buyers</li>
<li>Full Tax rebate upto 5 lakh annual income after all deductions.</li>
<li>Standard deduction has increase from 40000 to 50000</li>
<li>Exempt on tax on second self-occupied house</li>
<li>Ceiling Limit of TDS u/s 194A has increased from 10000 to 40000</li>
<li>Ceiling Limit of TDS u/s 194I has increased from 180000 to 240000</li>
<li>Capital tax Benefit u/s 54 has increased from investment in one residential house to two residential houses.</li>
<li>Benefit u/s 80IB has increased to one more year i.e. 2020</li>
<li>Benefit has given to unsold inventory has increased to one year to two years.<br /><br /><b><span style="font-size: large;">Other Areas</span></b><br /></li>
<li>State share has increased to 42%</li>
<li>PCA restriction has abolished from 3 major banks</li>
<li>2 lakhs seats will increase for the reservation of 10%</li>
<li>60000 crores for manrega</li>
<li>1.7 Lakh crore to ensure food for all</li>
<li>22nd AIIMS has to be opened in Haryana</li>
<li>Approval has to be given to PM Kisan Yojana</li>
<li>Rs. 6000 per annum has to be given to every farmer having upto 2 hectare land. Applicable from Sept 2018. Amount will be transferred in 3 installments</li>
<li>National kamdhenu ayog for cows. Rs. 750 crores for National Gokul Mission</li>
<li>2% interest subvention for farmers pursuing animal husbandry and also create separate department for fisheries.</li>
<li>2% interest subvention for farmers affected by natural calamities and additional 3% interest subvention for timely payment.</li>
<li>Tax free Gratuity limit increase to 20 Lakhs from 10 Lakhs</li>
<li>Bonus will be applicable for workers earning 21000 monthly</li>
<li>The scheme, called Pradhan Mantri Shram Yogi Mandhan, will provide assured monthly pension of Rs. 3,000 with contribution of Rs. 100 per month for workers in unorganized sector after 60 years of age.</li>
<li>Our government delivered 6 crores free LPG connections under Ujjawala scheme</li>
<li>2% interest relief for MSME GST registered person</li>
<li>26 weeks of Maternity Leaves to empower the women</li>
<li>More than 3 Lakhs crores for defence</li>
<li>One lakh digital villages in next 5 years</li>
<li>Single window for approval of India film makers</li>
</ol>
</div>

HIGHLIGHTS OF BUDGET 2019

HIGHLIGHTS OF BUDGET 2019 Tax Within 2 years, Tax assessment will be done electronically IT returns processing in just 24 hours Min...