The VAT Form - 3 excel template provided for filing returns has provision to capture details of all VAT annexures in specific sheets of the excel file. When VAT Form - 3 is saved and exported, information related to all annexures is also exported to the same file.
To export data to VAT Form 3
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form-3.
2. Press Ctrl+E to export the e-Return.
3. Select the required Type of Return.
4. Select the required Entity Type.
5. Press Enter to export the data to template.
The different sheets (annexures) and information captured in the template are described in the table below:
Field Name |
Description |
Sheet: A_Basic_Info |
|
Section A: Return Information (A_Basic_Info) |
|
Personal Identification Number |
Displays the PIN entered in the Company Operations Alteration screen. |
Type of Return |
Displays the type based on the Type of Return selected while exporting the e-Return in the Export Report screen of VAT Form-3. |
Entity Type |
Displays the type based on the Entity Type selected while exporting the e-Return in the Export Report screen of VAT Form-3. |
Return Period From |
Displays the from date of VAT Form-3 report period. |
Return Period To |
Displays the to date of VAT Form-3 report period. |
Sheet: B_General_Rated_Sales_Dtls |
|
Section B: Sales and Output Tax on Sales for the Period (General Rate) |
|
PIN of Purchaser |
Displays the PIN of the purchaser entered in the Party Details screen of sales transaction or in the party master. The transactions with Sales Taxable as Nature of transaction and tax rate 16% are considered in this case. |
Name of Purchaser |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording sales of goods or services attracting 16% tax rate. |
ETR Serial Number |
Displays the serial number of the device entered or selected in the Device No. field in the transaction. |
Invoice Date |
Displays the invoice date of the respective sales transaction. |
Invoice Number |
Displays the invoice number of the respective sales transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Amount of VAT (Ksh) (Taxable Value*16%) |
Displays the VAT amount, calculated at 16% on taxable value. |
Relevant Invoice Number |
Displays invoice number of the sales transaction against which sales are returned, as recorded in the Original Invoice No. field of credit note recorded for sales return of goods that attract 16% tax rate. |
Relevant Invoice Date |
Displays invoice date of the sales transaction against which sales are returned, as recorded in the Original Invoice Dt. field of credit note recorded for sales return of goods that attract 16% tax rate. |
Total Sales and VAT to Customers registered for VAT (Ksh) |
Displays the total net value of all sales and sales related transactions attracting 16% tax rate, made to customers who are registered for VAT. |
Total Sales and VAT to Customers not registered for VAT (Ksh) |
Displays the total net value of all sales and sales related transactions attracting 16% tax rate, made to unregistered dealers. This also includes all cash and bank sales transactions. |
Total |
Displays the total net value of all sales and sales related transactions attracting 16% tax rate, made to both registered and unregistered customers. |
Sheet: C_Other_Rated_Sales_Dtls |
|
Section C: Sales and Output Tax on Sales for the Period (Other Rate) |
|
PIN of Purchaser |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. The transactions with Sales Taxable as Nature of transaction and tax rate 12% are considered in this case. |
Name of Purchaser |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording sales of goods or services attracting 12% tax rate. |
ETR Serial Number |
Displays the serial number of the device entered or selected in the Device No. field in the transaction. |
Invoice Date |
Displays the invoice date of the respective sales transaction. |
Invoice Number |
Displays the invoice number of the respective sales transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Amount of VAT (Ksh) (Taxable Value*12%) |
Displays the VAT amount, calculated at 12% on the taxable value. |
Relevant Invoice Number |
Displays invoice number of the sales transaction against which sales are returned, as recorded in the Original Invoice No. field of credit note recorded for sales return of goods that attract 12% tax rate. |
Relevant Invoice Date |
Displays invoice date of the sales transaction against which sales are returned, as recorded in the Original Invoice Dt. field of credit note recorded for sales return of goods that attract 12% tax rate. |
Total Sales and VAT to Customers registered for VAT (Ksh) |
Displays the total assessable value and tax from sales related transactions attracting 12% tax rate, made to customers who are registered for VAT. |
Total Sales and VAT to Customers not registered for VAT (Ksh) |
Displays the total assessable value and tax from sales related transactions attracting 12% tax rate, made to unregistered dealers. This also includes all cash and bank sales transactions. |
Total |
Displays the total net value of all sales and sales related transactions attracting 12% tax rate, made to both registered and unregistered customers. |
Sheet: D_Zero_Rated_Sales_Details |
|
Section D: Sales for the Period (Zero Rated) |
|
Section D1: Local or Exemption Availed |
|
Types of Sales |
Displays Exemption for sales made for a customer, if the Exemption Certificate No. is provided in the party master. Displays Local for sales of goods and service that attract 0% tax rate within Kenya, if the Exemption Certificate No. is not provided for the customer in the party master. The transaction with Sales Zero Rated as Nature of transaction are considered in this case. |
PIN of Purchaser |
Displays the PIN of the purchaser entered in the Party Details screen of the respective transaction or in the party master. |
Name of Purchaser |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording sales of goods or services attracting 0% tax rate. |
ETR Serial Number |
Displays the serial number of the device entered or selected in the Device No. field in the transaction. |
Invoice Date |
Displays the invoice date of the respective sales transaction. |
Invoice Number |
Displays the invoice number of the respective sales transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description during transaction. |
Relevant Paragraph |
Displays the category selected in VAT Details screen of applicable master when type of sales is exemption. For local sales, this field is not applicable. |
Exemption Certificate Number |
Displays the Exemption Certificate No. recorded in the VAT Details screen of the party master in case of exemption sales. For local sales, this field is not applicable. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Total Sales to Customers registered for VAT (Ksh) |
Displays the total assessable value from sales related transactions attracting 0% tax rate, made to customers who are registered for VAT. |
Total Sales to Customers not registered for VAT (Ksh) |
Displays the total assessable value from sales related transactions attracting 0% tax rate, made to unregistered dealers. This also includes all cash and bank sales transactions. |
Total |
Displays the total net value of all sales and sales related transactions attracting 0% tax rate, made to both registered and unregistered customers. |
Section D2: Exports |
|
PIN of Purchaser |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. The transactions with Exports as Nature of transaction are considered in this case. |
Name of Purchaser |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording export sales of goods or services. |
ETR Serial Number |
Displays the serial number of the device entered or selected in the Device No. field in the transaction. |
Invoice Date |
Displays the invoice date of the respective sales transaction. |
Invoice Number |
Displays the invoice number of the respective sales transaction. |
Type of Exports |
Displays the Type of Exports recorded in the sales transaction. Based the type of goods selected in the masters, Goods or Services is displayed respectively. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Custom Entry Number |
Displays the Custom Entry No. entered in the Statutory Details screen of the transaction recorded with Exports as Nature of transaction. |
Port of Exit |
Displays the name of the Port of Exit entered in the Statutory Details screen of the transaction recorded with Exports as Nature of transaction. |
Destination Country |
Displays the name of Destination Country entered in the Statutory Details screen of the transaction recorded with Exports as Nature of transaction. |
Relevant Paragraph |
Displays the category selected in VAT Details screen of sales ledger when the Nature of transaction is Exports. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred in respective export sales transaction. |
Total Exports to Customers registered for VAT (Ksh) |
Displays the total assessable value from export sales related transactions made to customers who are registered for VAT. |
Total Exports to Customers not registered for VAT (Ksh) |
Displays the total assessable value from export sales related transactions made to unregistered dealers. This also includes all cash and bank sales transactions. |
Total |
Displays the total net value of all export sales made to both registered and unregistered customers. |
Total (Section D1 Total + Section D2 Total) |
Displays the sum of Section D1 Total and Section D2 Total. |
Sheet: E_Exempted_Sales_Dtls |
|
Section E: Sales for the Period (Exempt) |
|
PIN of Purchaser |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. The transactions with Sales Exempt as Nature of transaction are considered in this case. |
Name of Purchaser |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording sales of exempt goods or services. |
ETR Serial Number |
Displays the serial number of the device entered or selected in the Device No. field in the transaction. |
Invoice Date |
Displays the invoice date of the respective sales transaction. |
Invoice Number |
Displays the invoice number of the respective sales transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Sales Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Total Sales and VAT to Customers registered for VAT (Ksh) |
Displays the total assessable value from exempt sales made to customers who are registered for VAT. |
Total Sales and VAT to Customers not registered for VAT (Ksh) |
Displays the total assessable value from exempt sales made to uregistered dealers. This also includes all cash and bank sales transactions. |
Total |
Displays the total net value of all exempt sales made to both registered and unregistered customers. |
Section F: Purchase and Input Tax for the Period (General Rate) |
|
Type of Purchase |
Displays Import for purchases (goods only), and Purchase of Capital Goods made from a supplier outside Kenya, with Imports Taxable as Nature of transaction. Displays Local for purchases made from a supplier inside Kenya, with Purchase Taxable as Nature of transaction. The transactions with tax rate as 16% are only considered in this case. |
PIN of Supplier |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. |
Name of Supplier |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording purchases of goods or services attracting 16% tax rate. |
Invoice Date |
Displays the invoice date of the respective purchase transaction. |
Invoice Number |
Displays the invoice number of the respective purchase transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Custom Entry Number |
Displays the Custom Entry No. entered in the purchase transaction with Imports Taxable as Nature of transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred in the respective purchase transaction. |
Amount of VAT (Ksh) (Taxable Value * 16%) |
Displays the VAT calculated at 16% on the assessable value of purchases. |
Relevant Invoice Number |
Displays invoice number of the purchase transaction against which purchase are returned, as recorded in the Original Invoice No. field of debit note recorded for purchase return that attract 16% tax rate. |
Relevant Invoice Date |
Displays invoice date of the purchase transaction against which purchase are returned, as recorded in the Original Invoice Dt. field of debit note recorded for purchase return that attract 16% tax rate. |
Total Purchases and VAT from Suppliers registered for VAT (Local) (Ksh) |
Displays the total assessable value and tax from purchase related transactions attracting 16% tax rate, made from suppliers who are registered for VAT. |
Total Purchases and VAT from Suppliers not registered for VAT (Local) (Ksh) |
Displays the total assessable value and tax from purchase related transactions attracting 16% tax rate, from unregistered dealers. |
Total |
Displays the total net value from all purchases and purchase related transactions attracting 16% tax rate, from both registered and unregistered suppliers. |
Sheet: G_Other_Rated_Purchases_Dtls |
|
Section G: Purchase and Input Tax for the Period (Other Rate) |
|
Type of Purchase |
Displays Import for purchases (goods only) made from a supplier outside Kenya, with Imports Taxable as Nature of transaction. Displays Local for purchases made from a supplier inside Kenya, with Purchase Taxable as Nature of transaction. The transactions with tax rate as 12% are only considered in this case. |
PIN of Supplier |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. |
Name of Supplier |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording purchases of goods or services attracting 12% tax rate. |
Invoice Date |
Displays the invoice date of the respective purchase transaction. |
Invoice Number |
Displays the invoice number of the respective purchase transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Custom Entry Number |
Displays the Custom Entry No. entered in the purchase transaction with Imports Taxable as Nature of transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred in the respective purchase transaction. |
Amount of VAT (Ksh) (Taxable Value * 12%) |
Displays the VAT calculated at 12% on the assessable value of purchases. |
Relevant Invoice Number |
Displays invoice number of the purchase transaction against which purchase are returned, as recorded in the Original Invoice No. field of debit note recorded for purchase return with 12% tax rate. |
Relevant Invoice Date |
Displays invoice date of the purchase transaction against which purchase are returned, as recorded in the Original Invoice Dt. field of debit note recorded for purchase return with 12% tax rate. |
Total Purchases and VAT from Suppliers registered for VAT (Local) (Ksh) |
Displays the total assessable value and tax from purchase related transactions attracting 12% tax rate, made from suppliers who are registered for VAT. |
Total Purchases and VAT from Suppliers not registered for VAT (Import) (Ksh) |
Displays the total assessable value and tax from purchase related transactions attracting 12% tax rate, from suppliers outside Kenya. |
Total |
Displays the total net value all purchases and purchase related transactions attracting 12% tax rate, from both registered and unregistered suppliers. |
Sheet: H_Zero_Rated_Purchases_Dtls |
|
Section H: Schedule for Purchases for the Period (Zero Rated) |
|
Type of Purchases |
Displays Import for purchases (goods only) made from a supplier outside Kenya, with Imports - Zero Rated as Nature of transaction. Displays Local for purchases made from a supplier inside Kenya, with Purchase - Zero Rated as Nature of transaction. |
PIN of Supplier |
Displays the PIN of the purchaser entered in the Party Details screen in the transaction or in the party master. |
Name of Supplier |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording purchases of goods or services attracting 0% tax rate. |
Invoice Date |
Displays the invoice date of the respective purchase transaction. |
Invoice Number |
Displays the invoice number of the respective purchase transaction. |
Type of Imports |
Displays the Type of Imports recorded in the transaction. Based on the type selected in the masters, Goods or Services is displayed respectively. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Custom Entry Number |
Displays the Custom Entry No. entered in the purchase transaction with Imports - Zero Rated as Nature of transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Total Purchases from Suppliers registered for VAT (Local) (Ksh) |
Displays the total assessable value from purchase related transactions with Purchase - Zero Rated as Nature of transaction, made from suppliers who are registered for VAT. |
Total Purchases from Suppliers not registered for VAT (Import) (Ksh) |
Displays the total assessable value from purchase related transactions with Imports - Zero Rated as Nature of transaction, from suppliers outside Kenya. |
Total |
Displays the total net value all purchases and purchase related transactions attracting 0% tax rate, from both registered and unregistered suppliers. |
Sheet: I_Exempted Purchases_Dtls |
|
Section I: Purchases for the Period (Exempt) |
|
Type of Purchase |
Displays Import for purchases (goods only) made from a supplier who is outside Kenya, with Imports as Nature of transaction. Displays Local for purchases made from a supplier inside Kenya, with Purchase Exempt as Nature of transaction. |
PIN of Supplier |
Displays the PIN of the purchaser entered in the Party Details screen of the transaction or in the party master. |
Name of Supplier |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording exempt purchases of goods or services. |
Invoice Date |
Displays the invoice date of the respective purchase transaction. |
Invoice Number |
Displays the invoice number of the respective purchase transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Custom Entry Number |
Displays the Custom Entry No. entered in the respective purchase transaction with Imports as Nature of transaction. |
Taxable Value (Ksh) |
Displays the assessable value including other expenses or duties incurred. |
Total Purchases and VAT from Suppliers registered for VAT (Local) (Ksh) |
Displays the total assessable value from purchase related transactions with Purchase Exempt as Nature of transaction, made from suppliers who are registered for VAT. |
Total Purchases and VAT from Suppliers not registered for VAT (Import) (Ksh) |
Displays the total assessable value from purchase related transactions with Imports as Nature of transaction, from suppliers who outside Kenya. |
Total Purchases from Suppliers on which VAT has not been incurred (Local) (Ksh) |
Displays the total assessable value from purchase related transactions with Purchase Exempt as Nature of transaction, from unregistered dealers. |
Total |
Displays the total net value of all purchases and purchase related transactions with Purchase Exempt and Imports as Nature of transaction, from both registered and unregistered suppliers, and all exempted local purchases from unregistered suppliers. |
Sheet: J_VAT_Imported_Services_Dtls |
|
Section J: VAT Claimable on Service Imported into Kenya (Exempt) |
|
Name of Supplier |
Displays the name of the party as defined in the party ledger or entered in the Party Details screen while recording import of services, with Imports, Imports Taxable and Imports - Zero Rated as Nature of transaction. |
Description of Goods/Services |
Displays the information recorded in the Brief Desc of VAT field in the transaction. Alternatively, commodity name recorded in masters is displayed in the absence of description in transaction. |
Transaction Date |
Displays the transaction date for import of services. |
Invoice Date |
Displays the invoice date of the supplier from whom services are imported as recorded in the Date field against Supplier Invoice No. in purchase invoice recorded for import of services. |
Invoice Number |
Displays the invoice number of the supplier from whom services are imported as recorded in the Supplier Invoice No. field of purchase invoice recorded for import of services. |
Payment Registration Number |
This field is currently left blank. |
Amount of VAT Claimable (Ksh) |
Displays the VAT calculated on the assessable value of the transaction with Imports Taxable as Nature of transaction where type is selected as Services. |
Total VAT Claimable on Import of Services |
Displays the total VAT calculated for all transactions recorded with Imports, Imports taxable, Imports - Zero Rated as Nature of transaction and type of goods as services. |
Sheet: K_VAT_Payment_Credits |
|
Section K: Details of VAT Paid |
|
Section K1: Advance Payment |
|
Payment Registration Number |
Displays registration number given for advance tax payment as recorded in Payment Registration No. field in Stat Payment Details screen of Challan Reconciliation report. The payment transaction with Payment Type as Regular are only considered in this case. |
Date of Deposit |
Displays date of deposit of advance tax as recorded in the Deposit Date field in Stat Payment Details screen of Challan Reconciliation report. |
Amount of VAT Paid (Ksh) |
Displays the amount of advance VAT paid against the respective payment registration number. |
Total |
Displays the total amount of advance VAT paid in the return period. |
Section K2: Self Assessment Tax |
|
Payment Registration Number |
Displays registration number given for self assessment tax payment as recorded in Payment Registration No. field in Stat Payment Details screen of Challan Reconciliation report. |
Date of Deposit |
Displays date of deposit of self assessment tax as recorded in the Deposit Date field in Stat Payment Details screen of Challan Reconciliation report. |
Amount of VAT Paid (Ksh) |
Displays the amount of self assessment tax paid against respective payment registration number. |
Total |
Displays the total amount of VAT paid in the return period. |
Total (Section K1 Total + Section K2 Total) |
Displays the total amount of VAT paid in the return period, including advance VAT paid. |
Section K3: Credit Adjustment Voucher/Inventory Approval Order |
|
Credit Adjustment Voucher/Inventory Approval Order Number |
Displays the Inventory Approval Order No. entered in Refund Adjustment Details screen of the journal voucher or journal voucher number, when Increasing Input Tax is selected as the Nature of adjustment and Opening Stock is selected as Additional Details. |
Date of Voucher |
Displays the voucher date of the journal transaction recorded for credit adjustment or inventory approval. |
Amount of VAT Paid (Ksh) |
Displays the total amount of the journal transaction recorded for credit adjustment or inventory approval. |
Total |
Displays the total for the return period. |
Sheet: L_WHT_Credits |
|
Section L: Details of Withholding VAT Certificate |
|
PIN of Withholder |
Displays the PIN of the withholder entered in the PIN of Agent. field in Refund Adjustment Details screen of the journal voucher recorded by selecting Increasing Input Tax as Nature of transaction and Vat Withheld as Additional Details. |
Name of Withholder |
Displays the party name selected in the Name of Agent field in Refund Adjustment Details screen of the journal voucher recorded by selecting Increasing Input Tax as Nature of transaction and Vat Withheld as Additional Details. |
Withholding Certificate Number |
Displays the withholding certificate number provided by the party as recorded in the Withheld Certificate No. field of Refund Adjustment Details screen of journal voucher recorded by selecting Increasing Input Tax as Nature of transaction and Vat Withheld as Additional Details. |
Date of Certificate |
Displays the date of certificate provided by the party as recorded in the Date of Payment field of Refund Adjustment Details screen of journal voucher recorded by selecting Increasing Input Tax as Nature of transaction and Vat Withheld as Additional Details. |
Amount of VAT Withheld (Ksh) |
Displays value of VAT ledger debited in journal voucher recorded by selecting Increasing Input Tax as Nature of transaction and Vat Withheld as Additional Details. |
Total |
Displays the total for the return period. |
Section M: Sales (Goods and Services) (M_Sales_N_Purchases) |
|
1. Taxable Sales (General Rate) (Total of "Taxable Value" from B_General_Rated_Sales_Dtls) |
Displays taxable value, rate (16%), and tax amount from Section B: Sales and Output Tax on Sales for the Period (General Rate). |
2. Taxable Sales (other Rate) (Total of "Taxable Value" from C_Other_Rated_Sales_Dtls) |
Displays taxable value, rate (12%), and tax amount from Section C: Sales and Output Tax on Sales for the Period (Other Rate). |
3. Sales (Zero Rated) (Total of "Taxable Value" from Section D1 and "Taxable Value" from Section D2) |
Displays the sum of taxable value from Section D1: Local or Exemption Availed and Section D2: Exports. |
4. Sales (Exempt) (Total of "Sales Value" from E_Exempted _Sales_Dtls) |
Displays the total sales valued from Section E: Sales for the Period (Exempt). |
5. Total Sales (1+2+3+4) |
Displays auto computed sum. |
6. Total Output VAT (1+2+3) |
Displays auto computed sum of output tax. |
Section N: Purchases (Goods and Services) (M_Sales_N_Purchases) |
|
7. Taxable Purchases (General Rate) (Total of "Taxable Value" from F_General_Rated_Purchases_Dtls) |
Displays taxable value, rate (16%), and tax amount from Section F: Purchase and Input Tax for the Period (General Rate). |
8. Taxable Purchases (Other Rate) (Total of "Taxable Value" from G_Other_Rated_Purchases_Dtls) |
Displays taxable value, rate (12%), and tax amount from Section G: Purchase and Input Tax for the Period (Other Rate). |
9. Purchases (Zero Rated) (Total of "Taxable Value" H_Zero_Rated_Purchases_Dtls) |
Displays taxable value from Section H: Schedule for Purchases for the Period (Zero Rated). |
10. Exempted Purchases (Total of "Taxable Value" I_Exempted_Rated_Purchases_Dtls |
Displays taxable value from Section I: Purchases for the Period (Exempt). |
11. Total Purchases (7+8+9+10) |
Displays auto computed value of total purchases. |
12. Total Input VAT (7+8+9) |
Displays auto computed value of total input tax. |
Section O: Calculation of VAT Due (O_VAT_Due) |
|
13. Output VAT (6) |
Displays value from 6. Total Output VAT (1+2+3) in section M. |
14. Input VAT (12) |
Displays value from 12. Total Input VAT (7+8+9) in section N.
|
15. VAT Claimable on Services Imported into Kenya (Total of "Amount of VAT Claimable" from J_VAT_Imported_Services_Dtls) |
Displays value from Total VAT Claimable on Import of Service in section J.
|
16. Input VAT attributable to Only Exempt Supplies |
Displays the value of VAT ledger credited in journal voucher recorded by selecting Reversal of Input Tax as Nature of adjustment and Exempted Goods as Additional Details. |
17. Input VAT attributable to Taxable and Exempt Supplies |
Displays the value of VAT ledger credited in journal voucher recorded by selecting Reversal of Input Tax as Nature of adjustment and Taxable and Exempted Goods as Additional Details. |
18. Less: Non - Deductible Input VAT ((((4)/5)*17)+16) |
Displays auto computed value. |
19. Deductible Input VAT (14+15-18) |
Displays auto computed value. |
20. VAT Payable/Credit Due for the period (13-19) |
Displays auto computed value. |
21. Credit Bought Forward from pervious month |
Displays the excess input credit brought forward from previous period. |
22. Total Withholding VAT Credit (Total of "Amount of VAT Withheld" from L_WHT_Credits) |
Displays value from Amount of VAT Withheld (Ksh) in section L. |
23. Add: Refund Claim Lodged |
Displays the value of VAT ledger credited in journal voucher recorded by selecting Refund of Input Tax as Nature of adjustment in the reporting period. In case of no refund, this field is left blank. |
24. Total VAT Payable (20-21-22+23) |
Displays auto computed value. |
25. Total VAT Paid (Total of "Amount of VAT Paid" from K_VAT_Payment_Credits) |
Displays value from Total (Section K1 Total + Section K2 Total) in section K. |
26. Total Credit Adjustment / Inventory Approval Order (Total of "Credit Adjustment / Inventory Approval Order Amount" from K_VAT_Payment_Credits) |
Displays value from Amount of VAT Paid (Ksh) in section K3. |
27. Net VAT Payable / Credit Carried Forward (24-25-26) |
Displays auto computed value. |