Saral Tax India | Taxation info in saral language

Excel 2 Tally Voucher Series Generator

0 download, excel, excel-2-tally, tally, utility 5:16 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
<b><span style="font-size: large;">Excel to Tally Voucher Entry and Voucher Series generator</span></b></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img alt="Excel 2 Tally Voucher Series Generator" border="0" data-original-height="324" data-original-width="616" height="210" src="https://1.bp.blogspot.com/--QvPJnUs2Tg/XeT40327CMI/AAAAAAAAMbI/QWFOjovNWu8R_yYTWtLNfCnx-gsnVqNVwCNcBGAsYHQ/s400/Xl2Tally%2BVoucher%2BSeries%2BGenerator.jpg" title="Excel 2 Tally Voucher Series Generator" width="400" /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
This utility will help for making basic entry of sales, purchase, payment, receipt, journal etc. you have to just import the Html file from tally then import the HTML file in this utility so there will be no error while importing the data in tally.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>Download Button is given at the end of Post </b></div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img alt="Excel to Tally Voucher Entry and Voucher Series generator" border="0" data-original-height="489" data-original-width="543" src="https://1.bp.blogspot.com/-_XWfS-bMsdc/XeT4I2bX8CI/AAAAAAAAMbA/l8ZwsjVenoI5RZzF94xlDSDCG2PtzZ2kgCNcBGAsYHQ/s1600/Expense%2BSeries%2Bmenu.JPG" title="Excel to Tally Voucher Entry and Voucher Series generator" /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b><span style="font-size: large;">Features :</span></b></div>
<br />
<ol style="text-align: left;">
<li style="text-align: justify;">Make Debit Credit Entries via voucher sheet.</li>
<li style="text-align: justify;">Make voucher series or repetitive nature expenses entries for tally in utility and generate the XML file.</li>
<li style="text-align: justify;">This utility can make Payment, Receipt, Purchase, Sales, Journal, Contra entries.</li>
<li style="text-align: justify;">select the upper and below range amount it will calculate the total for monthly, daily or weekly entry type. then if you approve it will create the XML file.</li>
</ol>
<br />
<div style="text-align: justify;">
<b style="font-size: x-large;">How to Use</b></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<img alt="Excel 2 Tally export list of account from tally" border="0" data-original-height="302" data-original-width="547" src="https://1.bp.blogspot.com/-LVZPnNHirNI/XeT3zY2sv2I/AAAAAAAAMa0/VV3s68-4BZMT5sYH-HfeQHBtlCv4PvMmwCNcBGAsYHQ/s1600/exporting%2Blist%2Bof%2Baccount%2Bhtm%2Bfile%2Bfrom%2Btally.JPG" title="Excel 2 Tally export list of account from tally" /></div>
<ol style="text-align: left;">
<li style="text-align: justify;">For using this utility first of all after opening  Tally company go to <b>Display</b>>><b>List of Accounts</b>>></li>
<li style="text-align: justify;">then Select format <b>HTML (Web-Publishing )</b> >>Export location can be changed will be required when importing in the utility.</li>
<li style="text-align: justify;">output file name by default is master.htm skip it.</li>
<li style="text-align: justify;">then the type of master should be Ledgers.</li>
<li style="text-align: justify;">Then Open XL2Tally Vch Series utility enable the macro.</li>
<li style="text-align: justify;">Click on Import Button select ledger.</li>
<li style="text-align: justify;">then select HTML file saved in tally folder location or the location you stated in the previous step. Click import.</li>
<li style="text-align: justify;">then click on create voucher series button.</li>
<li style="text-align: justify;">Select Debit Ledger, Select Credit Ledger</li>
<li style="text-align: justify;">Select Voucher Type</li>
<li style="text-align: justify;">Type Common Narration or delete the default Narration</li>
<li style="text-align: justify;">Select Date Range if monthly entries selected then select financial year.</li>
<li style="text-align: justify;">enter minimum and maximum range amount.</li>
<li style="text-align: justify;">Select Repeat frequency daily, weekly etc. you can also check or un-chek the days.</li>
<li style="text-align: justify;">then click on create XML it will show the total amount of entries if you click yes then it will create the XML file on the location of utility, if you select no then it will recalculate the total amount.</li>
<li style="text-align: justify;">then for import entries in tally go to<b> Tally >> Import of DATA >> Import Voucher >> Enter the location of XML file</b> viz D://vch.xml then enter your entries will be imported. done.</li>
</ol>
<br />
<div class="separator" style="clear: both; text-align: center;">
<img alt="Excel 2 Tally Voucher Series Generator" border="0" data-original-height="420" data-original-width="471" src="https://1.bp.blogspot.com/-9HljxBz-JKs/XeT3zGrLMmI/AAAAAAAAMaw/UvhigjLUwgwNCrs6Txs4cDKH5g_TcLbIwCNcBGAsYHQ/s1600/vch%2Bseries%2Bmenu.JPG" title="Excel 2 Tally Voucher Series Generator" /></div>
<br />
<button class="button"><a blank="" href="http://bit.ly/vch-series" rel="nofollow" target="_">Download in Excel</a></button></div>

Excel 2 Tally Voucher Series Generator

Excel to Tally Voucher Entry and Voucher Series generator This utility will help for making basic entry of sales, purchase, paymen...

GSTR-9 & GSTR -9C simplified & last dates extended

0 gst, gstr-9, notification 5:02 PM

GSTR-9 & GSTR -9C simplified & last dates extended

GSTR-9 & GSTR -9C more simplified & last dates of submission extended PIB Link

Tally.ERP 9 Gold at Discounted price for CA!

0 icai, info, tally 10:19 AM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<img border="0" data-original-height="324" data-original-width="616" src="https://1.bp.blogspot.com/-nRrPRtsSr5Q/XcOh-rcphhI/AAAAAAAAL3M/5Zx7NqwkeLoFcnx9tN0lpM4cmQK49rNWQCNcBGAsYHQ/s1600/Tally%2Bgold%2Bat%2Bspecial%2Bprice.jpg" /></div>
<br />
<div style="text-align: justify;">
ICAI with Tally has worked out a Discounted pricing for Tally.ERP 9 Multi-User Addition. Some key highlights of the special limited period offer.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>Highlights</b></div>
<ol style="text-align: left;">
<li style="text-align: justify;"><b>This Scheme is only for Tally Erp 9 Multi-User viz. Gold Version not for Single user version.</b></li>
<li style="text-align: justify;"><b>On Tally Erp 9 Gold </b><b>80% discount </b>will be given to all full-time <b>practising CAs/CA firms</b> for <b>purchases made on or before 31st March 2020</b>, after that date a 50% discount will be given.</li>
<li style="text-align: justify;"><b>80% discount will be given to</b><b> CAs setting up practice</b> newly (who have enrolled for practice on or after 1st January 2018) for encouraging them at the beginning of their Practice.</li>
<li style="text-align: justify;"><b>50% discount will be given </b>on Tally Software Services (TSS) licenses renewals for purchased under any special CA schemes from Tally</li>
</ol>
<b style="text-align: justify;"><span style="font-size: large;">Conditions for Special Price :</span></b><br />
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>CA firms can get Tally.ERP 9 Gold Discounted price license on fulfilling the following Conditions:</b></div>
<ol style="text-align: left;">
<li style="text-align: justify;">Proprietorship or partnership firms registered with ICAI</li>
<li style="text-align: justify;">Verified Firm Registration Number (FRN)</li>
<li style="text-align: justify;">One license for head office and one license for each branch office registered with ICAI can be obtained.</li>
</ol>
<b style="text-align: justify;">Individually practising CA can get Tally.ERP 9 Gold special priced license on fulfilling the below conditions:</b><br />
<ol style="text-align: left;">
<li style="text-align: justify;">Availability of a full-time Certificate of Practice (COP) issued by Institute.</li>
<li style="text-align: justify;">Verified Membership Number.</li>
<li style="text-align: justify;">One license for the Chartered, provided the Chartered is not a partner in any other Partnership firm.</li>
</ol>
<div style="text-align: justify;">
<b><span style="font-size: large;">list of Persons who are not eligible for the Discounted priced Tally:</span></b></div>
<br />
<ol style="text-align: left;">
<li style="text-align: justify;">Branch office of a Chartered Accountant Partnership firm which is not registered with Institute.</li>
<li style="text-align: justify;">Branch offices of the proprietorship CA firm that are registered as ‘Second office’ with ICAI.</li>
<li style="text-align: justify;">Part-time practising CA.</li>
<li style="text-align: justify;">Non-practising CA.</li>
<li style="text-align: justify;">Full-time practising CA who are partners in a proprietary or partnership firms are not eligible for the individual license based on their membership number</li>
<li style="text-align: justify;">Chartered Accountants who are employed in a private concern.</li>
<li style="text-align: justify;">A CA/Chartered firms who have already been issued a discounted Price license against their Firm Registration Number /Membership Number under previous special schemes of Tally.</li>
<li style="text-align: justify;">Clients/customers of a Chartered Accountant</li>
</ol>
<div style="text-align: justify;">
<b><a href="https://tallysolutions.com/community-licensing/" target="_blank">Go for Link to check your eligibility</a></b></div>
</div>

Tally.ERP 9 Gold at Discounted price for CA!

ICAI with Tally has worked out a Discounted pricing for Tally.ERP 9 Multi-User Addition. Some key highlights of the special limited per...

Compulsory e-payment facility for above 50 Crore turnover

0 269su, banks, cash, income-tax, income-tax-news, info 10:19 AM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
As per the circular No. FTS - 1275045/2019 of Ministry of Finance dated 18th Oct 2019 enables the Compulsory payment via an electronic mode of payments for business with turnover more than 50 crore rupees with effect from 1st November 2019.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
For this effect Section 269SU has been inserted in the Income Tax Act 1961 vide the Finance (No. 2 ) Act 2019 in which it provides the provision for accepting the payment through prescribed electronics modes whose turnover is more than Rs. 50 Crore.</div>
<div style="text-align: justify;">
Along with this, a new provision Section 10A has been inserted in the Payment and Settlement System Act 2007 in which it prohibits the Bank or Payment System provider for charging on a payment made as per Section 269SU of the Income-tax Act 1961.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
For the implementation of Section 269SU application are invited from the Bank and Payment System providers so that they can modify the payment system as per Section 269SU of Income Tax Act 1961.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
The application shall be made in the given format and duly signed by authorised signatory :</div>
<div style="text-align: justify;">
1. Name of Bank or Payment System Provider.</div>
<div style="text-align: justify;">
2. Complete address of Bank or Payment System Provider.</div>
<div style="text-align: justify;">
3. Pan of Bank or Payment System Provider.</div>
<div style="text-align: justify;">
4. Registration number or license details for providing Payment System.</div>
<div style="text-align: justify;">
5. What Payment system is proposed u/s 269SU brief details about it</div>
</div>

Compulsory e-payment facility for above 50 Crore turnover

As per the circular No. FTS - 1275045/2019 of Ministry of Finance dated 18th Oct 2019 enables the Compulsory payment via an electronic mod...

How to Split workbook into sheets in Excel

0 excel, tips, vba-code 6:26 PM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
Splitting many workbooks in an excel sheet to a different worksheet is a most tedious job. if we want to split the sheet1, sheet2, sheet3 in different workbook then we have to manually open a new workbook and move and copy worksheet.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
We have one VBA code which will do all the work for you with a click and create a workbook from many numbers of worksheets. it will create Sheet1, sheet2, sheet3 workbook.</div>
<div style="text-align: justify;">
<b>Below is given VBA code</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-ZSMGADM0YWE/Xeo6MXsUnNI/AAAAAAAAMmM/19nmctS-rpAM_tWaQl4MI5Mug4vE_dVMwCNcBGAsYHQ/s1600/split%2Bworksheet.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="255" data-original-width="402" src="https://2.bp.blogspot.com/-ZSMGADM0YWE/Xeo6MXsUnNI/AAAAAAAAMmM/19nmctS-rpAM_tWaQl4MI5Mug4vE_dVMwCNcBGAsYHQ/s1600/split%2Bworksheet.JPG" /></a></div>
For this VBA code, open excel file go to developer tab ( if no developer tab is shown then go to excel option from file tab then go to the popular tab and click on checkbox show developer tab in ribbon)<br />
in an alternative way press Alt+F11 >> then insert a new Module then copy above code and paste here. then run this code.<br />
<a href="https://drive.google.com/uc?export=download&id=17Yufa3XsT2xrWGqHA7VV3aV-z6hJZQUZ" target="_blank"><b>Download The Code</b></a><br />
worksheet split will be done.</div>

How to Split workbook into sheets in Excel

Splitting many workbooks in an excel sheet to a different worksheet is a most tedious job. if we want to split the sheet1, sheet2, sheet3 ...

Tax benefits on loan for housing property

0 budget, budget-2019, deduction 11:00 AM

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
To fulfil objective ‘Housing for all’ of the Government and to enable every person to buy a Residential house at low cost, a new section 80EEA is inserted in the Act. This section provides an extra deduction of Rs <b>one lakh fifty thousand (1,50,000/-) </b>apart from Section 80C but some conditions are attached to this section which is as follows :<br />
<br />
1. The person taking deduction u/s 80EEA does not have any residential house property as on the date of sanction of loan.<br />
2. house property stamp duty value is not more than Rs forty-five lakh Rupees (45,00,0000/-)<br />
3. loan sanction should be during the period of 1st April 2019 to 31st March 2020.<br />
<br /></div>
<div style="text-align: justify;">
This Section will be effective from 1st April 2020.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
So for as in the Income Tax Act you have three Sections in which you can claim Home loan Interest and Principal deduction.<br />
<br />
1. <b>U/s 24:</b> Under the Head Income from house property Section 24 interest paid on housing loan for purchase or construction or reconstruction deduction of up to Rs Two Lakhs (Rs 2,00,000) can be taken if the property is self-occupied. If the property is not self-occupied then there is no upper limit so you can claim whole interest paid as deduction u/s 24.<br />
2. <b>U/s 80C:</b> Section 80C provides a deduction for Principal of Housing Loan. Under section 80C you can claim Rs One lakh fifty thousand (Rs 1,50,0000) as a deduction. Deduction under this section will be available only when the loan is taken for purchase or construction of new residential house property.<br />
3. <b>80EE: </b>In this section deduction of Rs One lakh fifty thousand ( Rs 1,50,000) can be taken for house property.</div>
</div>

Tax benefits on loan for housing property

To fulfil objective ‘Housing for all’ of the Government and to enable every person to buy a Residential house at low cost, a new section 8...