5 Jul 2008
How do I generate e-TDS / e-TCS Forms in Tally 9?
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: | ||||||||||||||||||||
|
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., |
| |||||||||
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) | ||||||||||||||||||
|
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. | ||||||||||||
|
2. | Party’s IT No. | ||||||
|
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: TDS in Tally9
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
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: others
Subscribe to Posts [Atom]