Subscribe to this Tally Blog by Email and Enter the Lucky Draw, click on this link

5 Jul 2008

 

How do I generate e-TDS / e-TCS Forms in Tally 9?

Procedure for generating e-TDS/e-TCS forms in Tally

To generate the above report, you need to have the "File Validation Utility" files. These files are available in the website of NSDL (National Securities Depository Limited) who has developed to verify whether the e-TDS return files prepared by the deductors / collectors conform to the prescribed format.
There are two separate files available for validating the e-TDS which can be downloaded from the site.
1. File Validation Utility for Quarterly Returns
2. File Validation Utility for Annual Returns
Note: The e-TDS/TCS FVU is a Java based utility.JRE (Java Run-time Environment),versions:
SUN JRE: http://java.sun.com/products/archive/j2se/1.4.2_03/index.html or
http://java.sun.com/products/archive/j2se/1.4.2_04/index.html or
http://java.sun.com/products/archive/j2se/1.4.2_02/index.html or
IBM JRE: http://www-128.ibm.com/developerworks/java/jdk/
should be installed on the computer where the e-TDS/TCS FVU is being installed. Java is freely
downloadable from : http://java.sun.com and
http://www.ibm.com/developerworks/java/jdk or
you can ask your vendor providing computer facilities (hardware) to install the same for you.
1. File Validation Utility for Quarterly Returns:
Once you download the above file and execute the same, the following three files would be extracted, viz,
1. TDS FVU Readme.rtf:This file contains instructions for setup of the e-TDS FVU.
2. e-TDS FVU Setup.exe:This is a setup program for installation of FVU.
3. TDS_FVU_STANDALONE.jar:This is the FVU program file.
These files are required for installing the e-TDS/TCS FVU
Save the above three files in the Tally folder. Double click "TDS FVU Setup.exe" file > It will prompt with a message "Successfully created TDS_FVU.bat" and will create a batch file of the same name.
Steps to generate Quarterly e-TDS Returns:
1. Reconcile the TDS ledger(s). i.e., from Gateway of Tally go to Display > Statement of Accounts > TDS Outstandings > TDS Computations > Select a TDS ledger > Press Alt+F5 or Click on "F5 Challan Reconcile" button available on the right side.
2. Next, it will list the TDS payment voucher. Update the following fields for each payment made, i.e.,
Bank Challan No.
Challan Date.
Bank Name.
BSR Code.
3. Save the above updation. (Accept = Yes)
4. Next, Gateway of Tally > Display > Statutory Reports > TDS Reports > ETDS Forms > Report Generation (Export Screen) will appear.
5. Enter the details for the following fields:
6. Format: SDF (Fixed Width)
Output File Name : Tally.txt
Personal Responsible details: Fill in the same
Other Details: For e.g. if you are exporting for a quarter i.e., Apr to Jun,
Mention the period from: 1-4-2007 To: 30-6-2007
Challan Date: 7-7-2007 (E.g.)
Form Name: 26Q [Other forms that can be exported are Form 26, 27 & 27Q]
Enter Place & Date (E.g. Bangalore, 7-7-2007]
Upload Type: Regular
Export = Yes
7. Go to Tally folder > Open NSDL Utility file (i.e.,) Run the batch file 'TDS_FVU.bat' > a pop-up window will appear [see picture below] > Under "Input File Name with Path" mention the exported file name with path (for e.g. D:\Tally\tally.txt). Under “Error/Upload & Statistics Report File Path” mention the path of tally folder (e.g. D:\Tally\)

8. Next highlight on "Validate" button and Click the same or press Enter. > If the information fed by you is correct > You will get a 'success' message (as per the picture below), and a file named 'Tally.html' will be generated in Tally folder. Open this file to view the e-TDS form.
9. If the information fed by you is not correct, you will get an error message stating the reason for failure (see, an e.g. error message picture below), and a file named 'Tallyerr.html' will be generated in tally folder. Open this file to view the details of error message and rectify accordingly.
Please note that the following fields are mandatory (with valid data):
1. Company TAN No.
IT No.
Address (without special characters)
State
PIN
Telephone No.
E-mail ID
2. Party’s IT No.
Address (without special characters)
State
PIN
3. Person Responsible details in Export Configuration.
4. Challan Reconciliation with valid data in all columns (eg. If Cheque no. is 000012, then it has to be entered as same and not just 12)
5. Selection of proper Date range and Challan Till in the Export Configuration.



http://www.winjit.com/ Winjit technologies is an authorized service centre of Tally. We provide various services on Customization in Tally 7.2, 9.0.Please email tally@winjit.com

For all your customisations, Tally Customisations. Support Inquries, Call US

Labels:


18 Jun 2008

 

Tally 9 Announces Stat.900 Version 71 (Release Notes of What is new ?)

Enhancements:
VAT/CST
Maharashtra
In Maharashtra Form 231 new payment challans are provided as Part-II and

Part-III

Gujarat

VAT Return Forms 201, 201A and 201B have been provided with new enhancements and functionality


Uttar Pradesh

Annexure A and Annexure B can be exported to Excel in the prescribed format.


Goa

A new VAT Classifications Input VAT @ 15%, Purchase @ 15%, Output

VAT @ 15% and Sales @ 15% has been provided

Issues Resolved

Composite VAT
Karnataka
The Box Nos. 2.1 and 2.3 of VAT Form 120 were showing incorrect figures

when URD Purchase entries are passed. The total Tax amount shown in Box

No. 2.9


This issue is resolved and the correct amount is captured in Box Nos. 2.1, 2.3

and 2.9 of Form 120 for Composition VAT return.



In Form VAT 120, when a sales entry is passed with VAT Classification Sales

- Composition VAT @ 1%, the sales amount is captured as a negative values in Box No. 2.3.


When Purchases entries with VAT Tax class Purchase From URDs - Taxable

Goods (Composition) and sales entries with VAT classification Sales -

Composition VAT @ 1% & Sales - Composition VAT @ 4% are entered, Box No. 2.1 captures incorrect values.


The above issues are resolved and the Box No. 2.1 and 2.3 captures correct values in VAT 120 Composition Return.

VAT/CST

Gujarat

When a Journal Voucher is passed with VAT flag Interest Payable and Penalty Due, the interest and penalty amounts in respect of VAT were captured in CST Return also.


This issue has been resolved and two new flags Interest Payable on CST and Penalty Payable on CST have been provided so that the Interest and Penalty payable on CST are captured in the respective boxes of the CST Return.


The Additional Tax does not get calculated when a Sales and Purchase transaction is passed using an Accounting Invoice.


This issue is resolved and Additional Tax is calculated in the Accounting

Invoice mode.


The Additional Output Tax is calculated on the total value of goods when an

Excise Sales transaction is recorded using a Voucher Class.


This issue is resolved and the Additional Output Tax is calculated on the

Assessable value of goods.


In Form 201C the values are captured based on the Item


This issue is resolved and the values are captured based on the commodity name.


Karnataka



The VAT payment details were captured in Box No. 13.10 instead of Box No.

5.1 and an extra line of text Payment Details as per 13.10 was also printed

in VAT Form 100.


This issue is resolved and the VAT payment details are captured in Box No.

5.1 and the extra line of text is removed from VAT Form 100.




When a Debit Note or Credit Note is passed for difference in rate, the assessable value was not captured in Form VAT 100.


This issue is resolved and the assessable value is captured in Box No. 2.1 of

VAT Return Form 100.


When a Credit Note for Consignment Transfer - Sales Return is passed,

the value is captured in Taxable Turnover – Box No. 3.9.


This issue is resolved and the value is not captured in Box No. 3.9. of VAT

100


When a Debit Note is passed to increase the sale value in an Inter-State transaction the assessable value specified in debit note is also captured in Total turnover (Local).


This issue is resolved and the assessable value is not captured in Box No.2 (Total Turnover (Local)) of VAT 100.


Kerala


In the e-VAT return files the Assessable Value of Goods captured includes the VAT Amount also.


This issue is resolved and the Assessable Value of Goods captured does not include the VAT Amount.


While exporting data to files Sales.txt and Purchase.txt an error message

Sales.txt / Purchase.txt does not exist was displayed.


This issue is resolved and the error message is not displayed.


Madhya Pradesh



While generating VAT Returns Form 10 the period is not printed as specified

in the VAT Payment Details screen.


This issue is resolved and the period is printed as specified in the VAT Payment Details screen.


The period was incorrectly printed in box Quarter/Month for 2nd, 3rd and 4th Quarter in the VAT Return Form 10, though the Print Preview showed it correctly.


This issue is resolved and the correct period is printed in the box Quarter/ Month.


When VAT Form 10 is printed for the Third Quarter, the Quarter/Month

shows incorrect period and the Gross Turnover for the entire year is printed

in Box No. 1.


This issue is resolved and the correct period and amount is printed in the respective boxes.


Maharashtra



When an Inter-State Excise transaction is recorded, the Excise amount was captured twice in Column 5(e) of the VAT Form 231.


This issue is resolved and the Excise amount appears in column 5(e).


When an Excise Sale is recorded with VAT/Tax Class Consignment

/Branch Transfer Outwards the assessable value of goods (Excise duty, Education Cess and Secondary Education Cess) is not captured in the VAT Computation Report and VAT Form 231.


This issue is now resolved and the Assessable Value of Goods is captured in the VAT Computation Report and VAT Form 231.


When a Journal Voucher with VAT Flag Non-Creditable Purchases is

recorded the value is not getting deducted from the Box No 7(a) of Form 231.


This issue is resolved and the value of non-creditable purchases is reduced from box no 7(a) of form 231.


In page three of VAT Form 231 the words Authorised Signatory is appearing twice.


This issue is resolved and the words Authorised Signatory appears once only.


When a Journal Entry with VAT Flag Reduction in Value of Purchases Used for Others U/r 53 with VAT class being Not Applicable for Purchase A/c and Input VAT, the value appears in box no. 9c of Form 231.


This issues is resolved and the value does not appear in box no. 9 of Form

231



Tamil Nadu



When a purchase transaction is passed in an Accounts only company the

Rate of Tax and Category are not displayed in VAT Annexure I.


This issue is resolved and the Rate of Tax and Category are captured in the

VAT Annexure I for the Accounts only company also.


The bifurcations for different VAT rates were not captured in the VAT Annexure I & II, even when the Purchase and Sales entries were passed with different VAT rates.


This is resolved and the different VAT rates are captured in the VAT

Annexure I & II.


Uttar Pradesh



When a sales Invoice with Voucher Class for multiple items is entered, in VAT Annexure B the Gross Sales Amount does not match with the Total Amount.


This issue is resolved and the Gross Sales Amount is captured correctly in the

Total amount Column of VAT Annexure B.


In VAT Annexure B the Return / Additions total does not match with the actual value entered.


This issue is resolved and the values are appearing as per the entry made.


1 Jun 2008

 

Release Notes for Tally 9- Stat.900 Version 70


Enhancements

Composite VAT


Gujarat

For Composite Dealers involved in the Works Contract, a new VAT/Tax

Classification "Work Contract - Composition Tax @ 0.6%" is introduced applicable from 17th August, 2006. The Transactions with this classification will be captured in VAT Return Form 216.


VAT/CST India


Gujarat

An additional field "Addl. Tax Exempted ?' is provided in the Stock Item Master Creation for Items subject to Additional Tax under CST Act. If the option is set to"No' Additional tax will not be computed for that item.

Functionality Enhancements are done to the VAT Form 201 to capture the values in the respective Boxes.


Maharashtra

As per the VAT notification dated 14th March, 2008, the VAT Form 221 is discontinued and a new VAT Form 231 is introduced.



Uttarakhand

As per the Government Notification issues on 31March 2008, the following new

VAT classifications are provided for items, which are charged at the CST Rates for

Local Purchase and Sale, effective from 1st April, 2008.


° Output VAT @ 3% - for Sales @ 3%

° Output VAT @ 2% - for Sales @ 2%

° Input VAT @ 3% - for Purchases @ 3%

° Input VAT @ 2% - for Purchases @ 2%


The VAT Return Form III captures the transactions carried using these classifications.

Service Tax

As per the Finance bill on 10th May, 2008, following new Service Category's are added to the STAT Master under the List of Service Category effective from

16/05/2008:


° Information Technology Software Service

° Management of Investment in ULIP

° Recognized Stock Exchange Service

° Recognized or Registered Association Service

° Processing and Clearing House Agent Service

° Supply of Tangible Goods Service


The Service Category Internet Telephony Service is renamed to Internet

Telecommunication Services.


The Sales Transactions subjected to Service Tax, passed using a Journal Voucher will be captured in the ST3 Return Form.


The transactions pertaining to Service Tax, entered using the Credit Notes will be captured in ST3 Return Form.




Issues Resolved




Composite VAT


Gujarat


The Print Configuration screen does not shows the default period for the VAT

return Forms 202 and 216.


This issue has been resolved and the Print Configuration screen shows the correct period for Quarterly VAT Return Forms 202 and 216 for the Composition dealers.


VAT/CST India




Delhi


The value of Tax Amount displayed in the print preview mode is different from that printed in Box No. 4c of Form 1 of the CST Return for Delhi.


This issue is now resolved and the same value of Tax Amount appears in print preview mode and the printed return form.




Gujarat


The CST amount paid during the previous month was displayed in Column 11 of the CST Return for the subsequent month in the State of Gujarat.


This issue is now resolved and the CST amount paid is not captured in Column 11

of the CST Return for the subsequent month.


When an inter state sales return entry is passed the value of goods and the tax amount were not captured in the Calculation of Central Sales Tax.


This issue is now resolved and the inter state sales return values are captured in the Calculation of Central Sales Tax.


Karnataka


While printing four copies of the Tax Invoice, each copy of the Invoice was captioned as Original, Duplicate, Triplicate and Quadruplicate.


This issue is now resolved and the invoice copies are captioned as Original - Buyer's Copy, Duplicate - Seller's Copy, Triplicate - Transporter's Copy and Quadruplicate œ "Extra Copy' and any other additional copy will have "Extra Copy' caption.





Kerala


When an interstate sales entry is passed, only tax amount was captured in column 14 of Form 8.


This issue is now resolved and the Total Invoice amount for inter-state Sales transaction is captured in column 14 of Form 8.


In VAT Form 8, Column 12, the Net taxable value was displayed twice. In Form

8B, Column 10, the Grand Total was displayed twice. These issues are resolved.



Punjab


When an entry is passed for the Purchase of Capital Goods from a Taxable or a Registered Dealer, the purchase value is captured in both Exempted and Taxable column of VAT FORM 24.


This issue has been resolved and the purchase value of Capital Goods is captured only in the Taxable Column of VAT Form 24.




In case of multiple Purchases from the same Supplier for items taxable at single

VAT rate, the VAT Annexure 24 captured the details in multiple lines.


This issue is resolved and now the VAT Annexure 24 displays the sum total of turnover at respective VAT rates in one line.


Rajasthan


The Part - II of VAT Form 8 is exported correctly in Excel format.


Uttar Pradesh


When a sales voucher inclusive of VAT voucher class is recorded with multiple items falling under the same VAT rate. The value of the first item is captured in Taxable Values of Goods column.


This issue is now resolved and invoice value is captured in Taxable Values of

Goods column.


29 May 2008

 

User defined Voucher types in Tally9

Did you know…?

If you have created user-defined voucher types and want to add more during voucher entry, Tally allows you to do so.

In the voucher entry screen, as shown below, press Alt+C before selecting Voucher Type from the list


This leads to Voucher Type Creation (Secondary) screen that allows you to create a new voucher type.


 

Difference between Financial Year and Books beginning from in Tally 9

What do the following fields indicate?


Financial Year From – indicates the start of the financial year for the company, in this case, 1st April 2005

Books Beginning From – The date entered in this field will restrict the user from passing any entry prior to this date. In other words no voucher can be passed before 1st July 2005, though the financial year begins from 1st April 2005.


 

Tally 9 Copy Narration

Do you know...?

In Tally, you can recall the current voucher's narration in two ways.

a)      Press Ctrl+R to recall the previously saved voucher.

b)      Press Alt + R to recall the previously saved voucher for the first ledger in the current voucher.

For example, in a payment voucher, you can save the first voucher debiting Conveyance as shown in the following figure with narration as "Conveyance charges paid"


The second voucher is entered, debiting Staff Welfare with narration "Staff welfare paid"


The third voucher is entered, debiting Conveyance.


Press Ctrl+R to recall the previous voucher's narration, Staff welfare paid, or press Alt+R to recall the previous voucher narration for Conveyance ledger, Conveyance charges paid.

In the narration field, press Ctrl+ or Ctrl + to navigate to the first letter of the word.


21 May 2008

 

Make 2000 Credits for spreading the word

Make 2,000 Credits for Spreading the Word
Want to earn an easy 2,000 Entrecard credits? Just blog about the new Entrecard feature and ebook and they’ll credit your account.
We are holding a contest to help us spread the word on our “add new blog” feature and our new E-Book, so anyone who posts on their blog, mentions our new “add a blog” feature, and posts a link to our new ebook on their blog wins 2000 credits. Just leave a comment on this blog post with the link for us to see.
Credits will be paid to all winners on June 25th. I have a feeling the number of blogs in the Entrecard system is about to increase dramatically.

http://www.winjit.com/ Winjit technologies is an authorized service centre of Tally. We provide various services on Customization in Tally 7.2, 9.0.Please email tally@winjit.com

For all your customisations, Tally Customisations. Support Inquries, Call US

Labels:


This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]