Dealer Address
1101 12/1/2008 33020387654 ABC Ltd
Dealer Name
Shamu
1002 32060898765
This is an offline system and do not require INTERNET connectivity while filling the details. The invoice details can be either entered individually or copied from any other Excel sheet or systems like MS Access or Tally or similar applications. Separate sheets for Sales and Purchase are provided.
Before starting data entry in Excel sheet, please do / check the following:
For Excels other than 2007, goto option Tools --> Macros --> Security and check the security level. If security level is in high change it to low. Save and close the excel and open once again to reflect the changes. If the Security level is not changed to low, then the VALIDATE button may shown as INACTIVE.
ABC Ltd, Chennai
For Interstate / Export / Import / Stock Transfer Transactions: All columns are mandatory. If TIN is available enter the details other wise enter TIN as 88888888888 (11 digits) . The VAT Amount Paid can be zero. Examples are,
General Instructions while filling the Spread Sheet for uploading of invoice data along with eReturns
With Registered Dealers: Invoice No, Invoice date, Registration No, Value of Goods, VAT Amount Paid and Cess Amount are mandatory. Dealer Name and Address fields are optional. The "Total Amount" Would be calculated by the system. Also the invoice details have to be furnished only invoice wise and not commodity wise or schedule wise.Individual Bills Should be Entered. Please note that the Invoice Date should be entered in the format "dd-mm-yyyy" (Eg: 01-12-2008). Examples are,
8 Bills for Un-Registered Dealers: All the Fields in the Excel Sheet are Mandatory. The TIN Number should be entered as 77777777777 (11 digits). The "Total Amount" Would be calculated by the system. Also the invoice details have to be furnished only invoice wise and not commodity wise or schedule wise. Individual Bills Should be Entered Please note that the Invoice Date should be entered in the format "dd-mm-yyyy" (Eg: 01-12-2008). Examples are,
For Excel 2007 users, the security level can be changed by Click on Microsoft Office Button , and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category,then enable macro. Save and close the excel file and open once again to reflect the changes.
The mandatory fields in Invoice details are,
Invoice No Invoice Date (dd-mm-yyyy) Registration No 12/2/2008 77777777777 12/2/2008 1001 12/1/2008 32010707362
Dealers Using Applications like Tally for generating the Excel File has to change the format of all cells to 'Text' by selecting all the cells by using 'Ctrl + A' and right clicking on the cell and selecting the option 'Format Cells'
General Instructions for generating the excel from Other Applications
Mananchira,Kozhikode
8B Bills(Customer Bills): Enter TIN as 99999999999 (11 digits), Dealer Name and Address could be entered as "Retail Sales" . All 8B Bills need to be consolidated and entered as one single entry. Invoice No – Last Invoice Number, Invoice Date - Last Invoice date, TIN – 99999999999, Name &Address – Retail Sales, Value, VAT Amount, Cess Amount – Sum of all 8B bills. Examples are,
1003 12/1/2008 77777777777 Ramu Pattom,Trivandrum
Note: System Would Allow only a single entry for 99999999999
12/2/2008 88888888888 XYZ Ltd XYZ Ltd, Delhi
After completing the invoice entry, click the Validate Purchases / Sales button (extreme right side of the Excel sheet) to verify the data
correctness. A message “File written to C:\KVATS" will be shown on successful validation of data and respective text file will be generated in the dealer's PC (in the path C:\KVATS). Separate text files will be generated for Sales and Purchase details. These text files need to be attached through the link "Upload Sales / Purchase" in the Online eFiling Application to upload along with the return form.
Value of Goods VAT Amount Paid CESS Amount 1000 40 0.4 2000 80 0.8 1000 40 0.4 2000 80 0.8 1000 0 0 Dealer Address
This is an offline system and do not require INTERNET connectivity while filling the details. The invoice details can be either entered individually or copied from any other Excel sheet or systems like MS Access or Tally or similar applications. Separate sheets for Sales and Purchase are provided.
Before starting data entry in Excel sheet, please do / check the following:
For Excels other than 2007, goto option Tools --> Macros --> Security and check the security level. If security level is in high change it to low. Save and close the excel and open once again to reflect the changes. If the Security level is not changed to low, then the VALIDATE button may shown as INACTIVE.
ABC Ltd, Chennai
For Interstate / Export / Import / Stock Transfer Transactions: All columns are mandatory. If TIN is available enter the details other wise enter TIN as 88888888888 (11 digits) . The VAT Amount Paid can be zero. Examples are,
General Instructions while filling the Spread Sheet for uploading of invoice data along with eReturns
With Registered Dealers: Invoice No, Invoice date, Registration No, Value of Goods, VAT Amount Paid and Cess Amount are mandatory. Dealer Name and Address fields are optional. The "Total Amount" Would be calculated by the system. Also the invoice details have to be furnished only invoice wise and not commodity wise or schedule wise.Individual Bills Should be Entered. Please note that the Invoice Date should be entered in the format "dd-mm-yyyy" (Eg: 01-12-2008). Examples are,
8 Bills for Un-Registered Dealers: All the Fields in the Excel Sheet are Mandatory. The TIN Number should be entered as 77777777777 (11 digits). The "Total Amount" Would be calculated by the system. Also the invoice details have to be furnished only invoice wise and not commodity wise or schedule wise. Individual Bills Should be Entered Please note that the Invoice Date should be entered in the format "dd-mm-yyyy" (Eg: 01-12-2008). Examples are,
For Excel 2007 users, the security level can be changed by Click on Microsoft Office Button , and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category,then enable macro. Save and close the excel file and open once again to reflect the changes.
The mandatory fields in Invoice details are,
Dealers Using Applications like Tally for generating the Excel File has to change the format of all cells to 'Text' by selecting all the cells by using 'Ctrl + A' and right clicking on the cell and selecting the option 'Format Cells'
General Instructions for generating the excel from Other Applications
Mananchira,Kozhikode
8B Bills(Customer Bills): Enter TIN as 99999999999 (11 digits), Dealer Name and Address could be entered as "Retail Sales" . All 8B Bills need to be consolidated and entered as one single entry. Invoice No – Last Invoice Number, Invoice Date - Last Invoice date, TIN – 99999999999, Name &Address – Retail Sales, Value, VAT Amount, Cess Amount – Sum of all 8B bills. Examples are,
2000 0 0 Note: System Would Allow only a single entry for 99999999999
XYZ Ltd, Delhi
After completing the invoice entry, click the Validate Purchases / Sales button (extreme right side of the Excel sheet) to verify the data
correctness. A message “File written to C:\KVATS" will be shown on successful validation of data and respective text file will be generated in the dealer's PC (in the path C:\KVATS). Separate text files will be generated for Sales and Purchase details. These text files need to be attached through the link "Upload Sales / Purchase" in the Online eFiling Application to upload along with the return form.
Invoice No (Mandatory) Invoice Date (DD-MM-YYYY) (Mandatory) Seller Registration No (Mandatory)
Seller Dealer Name (Mandatory for Unregistered)
Seller Dealer Address (Mandatory for Unregistered)
Value of Goods (Mandatory)
Vat Amount Paid (Mandatory)
Cess Amount (Mandatory)
Invoice No (Mandatory) Invoice Date (DD-MM-YYYY) (Mandatory) Buyer Registration No (Mandatory)
Buyer Dealer Name (Mandatory for Unregistered)
Buyer Dealer Address (Mandatory for Unregistered)
Value of Goods (Mandatory)
Vat Amount Paid (Mandatory)
Cess Amount (Mandatory)
