Kenya VAT Masters

Kenya VAT Masters

Effective from 1-Jan-2021, as per the general VAT rate of 16%, you can update the VAT rate to 16% in the masters, record transactions, and export the same to the new VAT template version 14.0.0.

 

Stock Group

Stock Items are classified into stock groups to reflect their classification based on some community.

  1. Gateway of Tally > Create > type or select Stock Group > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Stock Group > and press Enter.
  2. Enter the Name of the stock group.
  3. Select the required group from Under.
  4. Set the option Set/Alter VAT Details to Yes.
  5. In the Stock Group Creation screen, press F12 (Configure) > Set VAT details to Yes.
  6. Specify the VAT rate for the stock group in the VAT Details screen. You can use a VAT classification or define the required VAT details.

 

To create a user defined classification, enable the option to define tax and commodity details in masters

  1. Press F11 (Features) > set Enable Value added Tax (VAT) to Yes.
    If you do not see this option:
    • Set Show more features to Yes.
    • Set Show all features to Yes.
  2. Set the option Define VAT commodity and tax details as masters to Yes.
  3. Accept the screen. As always, you can press Ctrl+A to save.

 

To Create VAT Classifications

  1. Gateway of Tally > Create > type or select VAT Classifications > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > VAT Classifications > and press Enter.
  2. Enter the Name of the new classification.
  3. Enter the applicability date with the corresponding tax rates in Applicable From and Tax Rate columns. The Stat Classification Creation screen appears as shown below:
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

To define Nature of Transactions and commodity details in the Stat Classification Creation screen

  1. In the Stat Classification Creation screen, press F12 (Configure) to enable commodity details. The Configuration screen appears as shown below:
  2. Set the option Enable nature of transaction to Yes.
  3. Set the option Provide Commodity details to Yes.
  4. Press Ctrl+A to return to the Stat Classification Creation screen.
  5. Select the required Nature of Transaction.
  6. Enter the Commodity Name and Commodity Code. The Stat Classification Creation screen appears as shown below:
  7. Accept the screen. As always, you can press Ctrl+A to save.

To specify VAT details in stock group

  1. Open the stock group in alteration mode.
  2. In the VAT Details screen that appears on enabling the option Set/Alter VAT details in stock group, select the user defined VAT classification.
    Note: The VAT Classification created by selecting Nature of Transaction will not be appear for selection in stock group. 
  3. Specify VAT details
    • Enter the Tax rate. If the Tax rate entered is above 0, the Tax type automatically appears as Taxable.
    • Enter 0 as the Tax Rate, to select Exempt or Zero Rated as the taxability. 

 

To provide commodity details

  1. Press F12 (Configure) to view the Configuration screen.
  2. Set the option Provide commodity details to Yes.
  3. Press Alt+W (Details) to specify different VAT rates with separate Applicable From dates.

 

To specify different VAT rates with separate Applicable From dates

  1. Press Alt+W (Details) to view VAT Rate Details screen.
  2. Enter Applicable From date.
  3. Enter Commodity Name.
  4. Enter Commodity Code.
  5. Select Type of Goods.
  6. Select Category.
  7. Enter Tax Rate. The VAT Rate Details screen appears as shown below:
  8. Enter the Tax rate.
    Note: Press Enter without specifying the rate to select Exempt or Zero Rated in the Taxability column.
  9. Accept the screen. As always, you can press Ctrl+A to save.

Stock Item

In TallyPrime, you can create a stock item and define the corresponding details like units of measurement and VAT applicability as required.

  1. Gateway of Tally > Create > type or select Stock Item > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Stock Item > and press Enter.
  2. Enter the Name of the stock item.
  3. Select the required group in the Under field. If the selected stock group is with tax rate and commodity details, these are applied to the stock item. If Primary is selected, the tax and commodity details specific to the stock item can be defined.
  4. Select the required unit of measurement in Units field.
  5. Set the option VAT Applicable to Applicable.
  6. Set the option Set/Alter VAT Details to Yes.
  7. In the VAT Details screen, select a user defined VAT classification, or specify the VAT rate.
  8. Accept the screen. As always, you can press Ctrl+A to save.

 

To enable the option to define tax and commodity details in masters

  1. Gateway of Tally > press F11 (Features) > set Enable Value added Tax (VAT) to Yes.
    • If you do not see this option:
      • Set Show more features to Yes.
      • Set Show all features to Yes.
  2. Set the option Define VAT commodity and tax details as masters to Yes.
  3. Accept the screen. As always, you can press Ctrl+A to save.

 

To create a user defined classification

  1. Gateway of Tally > Create > type or select VAT Classifications > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > VAT Classifications > and press Enter.
  2. Enter the Name of the new classification.
  3. Enter the applicability date with the corresponding tax rates in Applicable From and Tax Rate columns. The Stat Classification Creation screen appears as shown below:
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

To define Nature of Transactions and commodity details in the Stat Classification Creation screen

  1. In the Stat Classification Creation screen, press F12 (Configure) to enable commodity details.
  2. Set the option Enable Nature of transaction to Yes.
  3. Set the option Provide Commodity details to Yes. The Configuration screen appears as shown below:
  4. Press Ctrl+A to return to the Stat Classification Creation screen.
  5. Select the required Nature of Transaction.
  6. Enter the Commodity Name and Commodity Code. The Stat Classification Creation screen appears as shown below:
  7. Accept the screen. As always, you can press Ctrl+A to save.

 

To Specify VAT details

On selecting a user defined VAT classification, the Stock Item Creation screen is displayed.

  • Enter the Tax rate. If the Tax rate entered is above 0, the Tax type automatically appears as Taxable.
  • Enter 0 as the Tax Rate, to select Exempt or Zero Rated as the taxability.

 

To provide commodity details

  1. Press F12 (Configure) to view the Configuration screen.
  2. Set the option Provide commodity details to Yes.
  3. Press Alt+W (Details) to specify different VAT rates with separate Applicable From dates.

 

To specify different VAT rates with separate Applicable From dates

  1. Press Alt+W (Details) to view VAT Rate Details screen.
  2. Enter Applicable From date.
  3. Enter Commodity Name.
  4. Enter Commodity Code.
  5. Select Type of Goods.
  6. Select Category.
  7. Enter Tax Rate. The VAT Rate Details screen appears as shown below:
  8. Enter the Tax rate.
    Note: Press Enter without specifying the rate to select Exempt or Zero Rated in the Taxability column.
  9. Accept the screen. As always, you can press Ctrl+A to save.

Party Ledger

A business deals with customers, wholesalers, retailers and many such business parties on a day-to-day basis. You need to create party ledgers to record transactions that you make, which may involve receipts or payments, or supplies or receipts from these parties.

Creating a Supplier Ledger

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the supplier ledger.
  3. Select Sundry Creditors from the List of Groups, in the Under field.
  4. Set Maintain balances bill-by-bill to Yes.
  5. In the Ledger Creation screen, press F12 (Configure) > set Maintain balances Bill-by-Bill to Yes.
    If you do not see this option, ensure that Enable Bill-wise entry is set to Yes in F11 for your company.
  6. Enter the Default Credit Period, if any.
  7. Set Check for credit days during voucher entry to Yes, if required.
  8. Enter the Mailing Details.
  9. Select the required Country.
  10. Provide bank details, if required.
  11. Enter the PIN.
  12. Set the option Set/Alter VAT Details to Yes. To view VAT Details screen
    1. Select the Type of Dealer from the Type of Dealer list.
    2. Enter the VAT No.
      The VAT Details screen appears as shown below:
    3. Press Enter to save.
  13. To enter the exemption details of the supplier:
    1. Press F12 (Configure) in the VAT Details screen.
    2. Set the option Allow exemption details to Yes.
    3. Press Ctrl+A to return to the VAT Details screen.
    4. Select the Type of Exemption.
    5. Enter the Exemption Certificate No., if required.
      The VAT Details screen appears as shown below:
    6. Press Enter to return to the Ledger Creation screen.
  14. Provide the relevant details. The Ledger Creation screen appears as shown below:
  15. Accept the screen. As always, you can press Ctrl+A to save.

 

Creating a Customer Ledger

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the supplier ledger.
  3. Select Sundry Debtors from the List of Groups, in the Under field.
  4. Set Maintain balances bill-by-bill to Yes.
  5. Enter the Default Credit Period, if any.
  6. Set Check for credit days during voucher entry to Yes, if required.
  7. Enter the Mailing Details.
  8. Select the required Country.
  9. Provide bank details, if required.
  10. Enter the PIN.
  11. Set the option Set/Alter VAT Details to Yes. To view the VAT Details screen:
    1. Select the Type of Dealer from the Type of Dealer list.
    2. Enter the VAT No. The VAT Details screen appears as shown below:
    3. Press Enter to save.
  12. To enter the exemption details of the customer:
    1. Press F12 (Configure) in the VAT Details screen.
    2. Set the option Allow exemption details? to Yes.
    3. Press Ctrl+A to return to the VAT Details screen.
    4. Select the Type of Exemption.
    5. Enter the Exemption Certificate No., if required. The VAT Details screen appears as shown below:
    6. Press Enter to return to the Ledger Creation screen.
  13. Provide the relevant details. The Ledger Creation screen appears as shown below:
  14. Accept the screen. As always, you can press Ctrl+A to save.

 

Purchase and Sales Ledger

You can create common ledgers for sales or purchases without specifying tax details. These can be used to record all types of purchases or sales. You have to specify tax rates in the purchase and sales ledger masters if you need separate ledgers for different tax rates.

 

Creating a Purchase Ledger

Common purchase ledger

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the purchase ledger.
  3. Select Purchase Accounts, in the Under field.
  4. Set Is VAT applicable to Applicable.
  5. Set the option Set/Alter VAT Details to No. The Ledger Creation screen is displayed as shown below:
  6. Accept the screen. As always, you can press Ctrl+A to save.

 

To create a purchase ledger with the nature of transaction, commodity details and tax rate

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the purchase ledger.
  3. Select Purchase Accounts, in the Under field.
  4. Set Is VAT Applicable to Applicable.
  5. Set the option Set/alter VAT Details to Yes.
  6. Press F12 (Configure) to view the screen to enable commodity details. The Configuration screen appears as shown below:
  7. To enable commodity details:
    1. Enable the option Provide commodity details.
    2. Press Ctrl+A to return to the Tax/rate details screen.
    3. The VAT rate can be specified in either of the following ways:
      • To create a user defined classification
      • Enable the option to define tax and commodity details in masters.

 

To enable the option to define tax and commodity details in masters

  1. Press F11 (Features) > set Enable Value added Tax (VAT) to Yes.
    If you do not see this option:
    • Set Show more features to Yes.
    • Set Show all features to Yes.
  2. Set the option Define VAT commodity and tax details as masters to Yes.
  3. Accept the screen. As always, you can press Ctrl+A to save.

 

To create a user defined classification

  1. Gateway of Tally > Create > type or select VAT Classifications > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > VAT Classifications > and press Enter.
  2. Enter the Name of the new classification.
  3. Enter the applicability date with the corresponding tax rates in Applicable From and Tax Rate columns. The Stat Classification Creation screen appears as shown below:
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

To define Nature of Transactions and commodity details in the Stat Classification Creation screen

  • In the Stat Classification Creation screen, press F12 (Configure) to enable commodity details.
    The Configuration screen appears as shown below:

 

To enable Nature of Transactions and commodity details

  1. Set the option Enable nature of transaction to Yes.
  2. Set the option Provide commodity details to Yes.
  3. Press Ctrl+A to return to the Stat Classification Creation screen.
  4. Select the required Nature of Transaction.
  5. Enter the Commodity Name and Commodity Code.
    The Stat Classification Creation screen appears as shown below:
  6. Accept the screen. As always, you can press Ctrl+A to save. 

 

To Specify VAT details

  1. Open the purchase ledger in alteration mode.
  2. The VAT Details screen appears on enabling the option Set/Alter VAT Details. You can either select the user defined VAT classification or specify the VAT details.
    • Select the Nature of transaction.
      Note: Select Purchase Exempt or Purchase - Zero Rated to choose Exempt or Zero Rated as the Tax type.
    • Enter the Commodity name and Commodity code.
    • Enter the Tax Rate. The Tax Type automatically appears as Taxable. The VAT Details screen appears as shown below:
    • Accept the screen. As always, you can press Ctrl+A to save.

 

Creating a Sales Ledger

Common sales ledger

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the sales ledger.
  3. Select Sales Accounts, in the Under field.
  4. Set Is VAT applicable to Applicable.
  5. Set the option Set/Alter VAT Details to No. The Ledger Creation screen is displayed as shown below:
  6. Accept the screen. As always, you can press Ctrl+A to save.

 

To create a sales ledger with the nature of transaction, commodity details and tax rate

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the purchase ledger.
  3. Select Sales Accounts, in the Under field.
  4. Set Is VAT Applicable to Applicable.
  5. Set the option Set/alter VAT Details to Yes.
  6. Press F12 (Configure) to view the screen to enable commodity details:
    The Configuration screen appears as shown below:
  7. To enable commodity details:
    1. Enable the option Provide commodity details?.
    2. Press Ctrl+A to return to the Tax/rate details screen.

The VAT rate can be specified in either of the following ways:

  • To create a user defined classification
  • Enable the option to define tax and commodity details in masters.

 

To enable the option to define tax and commodity details in masters

  1. Press F11 (Features) > set Enable Value added Tax (VAT) to Yes.
    If you do not see this option:
    • Set Show more features to Yes.
    • Set Show all features to Yes.
  2. Set the option Define VAT commodity and tax details as masters to Yes.
  3. Accept the screen. As always, you can press Ctrl+A to save.

 

To create a user defined classification

  1. Gateway of Tally > Create > type or select VAT Classifications > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > VAT Classifications > and press Enter.
  2. Enter the Name of the new classification.
  3. Enter the applicability date with the corresponding tax rates in Applicable From and Tax Rate columns. The Stat Classification Creation screen appears as shown below:
  4. Accept the screen. As always, you can press Ctrl+A to save.

 

To define Nature of Transactions and commodity details in the Stat Classification Creation screen

  • In the Stat Classification Creation screen, press F12 (Configure) to enable commodity details.
    The Configuration screen appears as shown below:

 

To enable Nature of Transactions and commodity details

  1. Set the option Enable nature of transaction to Yes.
  2. Set the option Provide commodity details to Yes.
  3. Press Ctrl+A to return to the Stat Classification Creation screen.
  4. Select the required Nature of Transaction.
  5. Enter the Commodity Name and Commodity Code. The Stat Classification Creation screen appears as shown below:
  6. Accept the screen. As always, you can press Ctrl+A to save. 

 

To Specify VAT details

  1. On selecting a user defined VAT classification, the Ledger Creation screen is displayed.
  2. Specify VAT details.
    • Select the Nature of transaction.
      Note: Select Sales Exempt or Sales - Zero Rated to choose Exempt or Zero Rated as the Tax type.
    • Enter the Commodity name and Commodity code.
    • Enter the Tax Rate. The Tax Type automatically appears as Taxable. The VAT Details screen appears as shown below:
    • Accept the screen. As always, you can press Ctrl+A to save.

 

VAT Ledger

You can follow the steps given below to create a common VAT ledger. To create a VAT ledger with the rate specified, enter the tax rate in Percentage of Calculation field. Based on the tax rate entered, the tax amount is calculated in the invoice.

  1. Gateway of Tally > Create > type or select Ledger > and press Enter.
    Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
  2. Enter the Name of the VAT ledger.
  3. Select Duties & Taxes in the Under field.
  4. Select VAT as Type of duty/tax.
  5. Press Enter to skip the Percentage of Calculation field. The Ledger Creation screen appears as shown below:
  6. Accept the screen. As always, you can press Ctrl+A to save.

Did you find this article useful?

  • Introduction to VAT (Kenya)

    Introduction to VAT (Kenya) Value Added Tax (VAT) is a tax levied on goods and services supplied or ...
  • Purchases Under Kenya VAT

    Purchases Under Kenya VAT After activating Kenya VAT for your company, you can record different kind...
  • Sales Under Kenya VAT

    Sales Under Kenya VAT You can record and print different kind of sales transactions based on buyer t...
  • Kenya VAT Form-3

    Kenya VAT Form-3 VAT Form-3 VAT Form-3 is the monthly VAT return filed by dealers in Kenya. You can ...