VAT 3 Return Online

To export data to EVAT Withheld template,

Go to Gateway of Tally > Display > Statutory Reports > VAT > E-VAT Forms > E-VAT Return

The EVAT Withheld option will display the Export Report screen. Press Backspace to make changes export location, Output File Name etc.

Navigate to the Export Location path and open the template - VAT 3_Return_Online.xls. The template with the exported data displays as shown:

Importing CST File and Validating Data

For each annexure chosen for exporting data from Tally.ERP 9 to template - VAT 3_Return_Online.xls the .csv file will get generated. Follow the steps given below to import the .csv files and validate the data.

  1. In A_Basic_Info worksheet, click NEXT button

  2. In B_General_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - General_Rated_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  3. In C_Other_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Other_Rated_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  4. In D_Zero_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data.

  1. In E_Exempted_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Exempted_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  2. In F_General_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - General_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  3. In G_Other_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Other_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  4. In H_Zero_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Zero_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  5. In I_Exempted_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Exempted_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.

  6. In J_VAT_Imported_Services_Dtls worksheet, click NEXT button.

  7. In K_VAT_Payment_Credits worksheet, click NEXT button.

  8. In L_Sales_M_Purchases worksheet, click NEXT button.

  9. In N_VAT_Due worksheet, click VALIDATE button.

The errors found while validating data will be captured in the second worksheet - Errors. Once the errors are corrected, click VALIDATE button in N_VAT_Due worksheet. Once the data gets successfully validated, the message appears as shown:

Click Yes. A dialogue box will be displayed with the path of the .zip file.

 

A_Basic_Info - Section A : Return Information

Personal Identification Number*

The PIN entered in the Company Operations Alteration screen of F11: Features > Statutory & Taxation features is captured here.

Type of Return*

The Return Type selected in the Type of Return field of Export Report screen is captured here.

Entity Type*

The Entity Type selected in the Entity Type field of Export Report screen is captured here.

Return Period From*

The date entered in the From (blank for beginning) field of Export Report screen is captured here.

Return Period To*

The date entered in the To (blank for end) field of Export Report screen is captured here.

B_General_Rated_Sales_Dtls - Section B : Sales and Output Tax on Sales for the Period (General Rate)

The details of entries recorded using VAT/Tax class - Sales @ 16% is captured here.

PIN of Purchaser

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales @ 16% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Purchaser

The name of purchaser entered in the Buyers field of Party Details screen is captured here.

ETR Serial Number

The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales @ 16% is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales @ 16% is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Sales @ 16% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable sales (of VAT/Tax class - Sales @ 16%) the assessable value of only the taxable sale is displayed here.

Relevant Invoice Number

The original invoice number entered in the Original Invoice No. of Credit and Debit Note while recording returns and de-escalations is captured here.

Relevant Invoice Date

The original invoice date entered in the Original Invoice Dt. field of Credit and Debit Note while recording returns and de-escalations is captured here.

C_Other_Rated_Sales_Dtls - Section C : Sales and Output Tax on Sales for the Period (Other Rate)

The details of entries recorded using VAT/Tax class - Sales @ 12% is captured here.

PIN of Purchaser

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales @ 12% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Purchaser

The name of purchaser entered in the Buyers field of Party Details screen is captured here.

ETR Serial Number

The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales @ 12% is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales @ 12% is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Sales @ 12% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable sales (of VAT/Tax class - Sales @ 12%) the assessable value of only the taxable sale is displayed here.

Relevant Invoice Number

The original invoice number entered in the Original Invoice No. of Credit and Debit Note while recording returns and de-escalations is captured here.

Relevant Invoice Date

The original invoice date entered in the Original Invoice Dt. field of Credit and Debit Note while recording returns and de-escalations is captured here.

D_Zero_Rated_Sales_Dtls - Section D : Sales for the Period (Zero Rated)

Section D1 : Local or Exempted Availed

Type of Sales

For sales recorded using VAT/Tax class -

PIN of Purchaser

The PIN defined in the Party Ledger master selected while recording the sales entries is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Purchaser

The name of purchaser entered in the Buyers field of Party Details screen is captured here.

ETR Serial Number

The Device No. entered for the device type - ETR in entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.

Exemption Certificate Number

The information entered in the Exemption Certificate No. field of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.

Section D2 : Exports

PIN of Purchaser

This field will be blank as PIN will not be provided in the purchaser (importer) ledger master.

Name of Purchaser

The name of purchaser entered in the Buyers field of Party Details screen is captured here.

ETR Serial Number

The Device No. entered for the device type - ETR in entries recorded using VAT/Tax class - Exports is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Exports is captured here.

Customs Entry Number

The information entered in the Export Entry No. field of entries recorded using VAT/Tax class - Exports is captured here.

Port of Exit

The information entered in the Port of Discharge field of Party Details screen for entries recorded using VAT/Tax class - Exports is captured here.

Destination Country

The information entered in the Country To field of Party Details screen for entries recorded using VAT/Tax class - Exports is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Exports is captured here.

E_Exempted_Sales_Dtls - Section E : Sales for the Period (Exempt)

The details of entries recorded using VAT/Tax class - Sales - Exempt is captured here.

PIN of Purchaser

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales - Exempt is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Purchaser

The name of purchaser entered in the Buyers field of Party Details screen is captured here.

ETR Serial Number

The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales - Exempt is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales - Exempt is captured here.

Sales Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Sales - Exempt is captured here.

F_General_Rated_Purchases_Dtls - Section F : Purchases and Input Tax for the Period (General Rate)

Type of Purchases

For purchases recorded using VAT/Tax class -

PIN of Supplier

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases @ 16% and  Purchases - Imports @ 16% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Supplier

The name of supplier entered in the Supplier field of Party Details screen is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases @ 16% and  Purchases - Imports @ 16% is captured here.

Customs Entry Number

The description entered in the Customs Entry No. field of entries recorded using VAT/Tax class - Purchases - Imports @ 16% is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Purchases @ 16% and  Purchases - Imports @ 16% is captured here.

Relevant Invoice Number

The original invoice number entered in the Original Invoice No. of Debit and Credit note while recording returns and de-escalations is captured here.

Relevant Invoice Date

The original invoice date entered in the Original Invoice Dt. field of Debit and Credit Note while recording returns and de-escalations is captured here.

G_Other_Rated_Purchases_Dtls - Section G : Purchases and Input Tax for the Period (Other Rate)

Type of Purchases

The purchases recorded using VAT/Tax class - Purchases @ 12% is captured here with Type of Purchases as Local.

PIN of Supplier

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases @ 12% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Supplier

The name of supplier entered in the Supplier field of Party Details screen is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases @ 12% is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Purchases @ 12% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable purchases (of VAT/Tax class - Purchases @ 12%) the assessable value of only the taxable purchase is displayed here.

Relevant Invoice Number

The information entered in the Original Invoice No. of Debit while recording returns and de-escalations is captured here.

Relevant Invoice Date

The information entered in the Original Invoice Dt. field of Debit Note while recording returns and de-escalations is captured here.

H_Zero_Rated_Purchases_Dtls - Section H : Schedule for Purchases for the Period (Zero Rated)

Type of Purchases

For purchases recorded using VAT/Tax class -

PIN of Supplier

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases - Zero Rated is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Supplier

The name of supplier entered in the Supplier field of Party Details screen is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases - Zero Rated and Imports is captured here.

Customs Entry Number

The description entered in the Customs Entry No. field of entries recorded using VAT/Tax class - Imports is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Purchases - Zero Rated and Imports is captured here.

I_Exempted_Purchases_Dtls - Section I : Purchases for the Period (Exempt)

Type of Purchases

The details of purchases recorded using VAT/Tax class - Purchases - Exempt is captured here with Type of Purchases as Local.

PIN of Supplier

The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases - Exempt is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.

Name of Supplier

The name of supplier entered in the Supplier field of Party Details screen is captured here.

Invoice Date

The invoice date is captured here in dd/mm/yyyy format.

Invoice Number

The invoice number is captured here.

Description of Goods/Services

The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases - Exempt is captured here.

Taxable Value (Ksh)

The assessable value of entries recorded using VAT/Tax class - Purchases - Exempt is captured here.

J_VAT_Imported_Services_Dtls - Section J : VAT Claimable on Services Imported into Kenya

This Annexure will be blank.

K_VAT_Payment_Credits - Section K : Details of VAT Paid

This Annexure will be blank.

L_Sales_M_Purchases

Based on the transactions recorded, the values will be automatically captured here.

N_VAT_Due - Section N : Calculation of VAT Due

The values will be captured here automatically.