Traders, some times while selling the goods will mention the Rate for the stock sold which will be inclusive of VAT.
Example: National Traders sold 10 Desktop Computers (HP) to Excel Traders and issued the VAT inclusive invoice for Sh. 371200 (where the cost of Computers is Sh. 320011.52 per computer and VAT charged is Sh. 51188.48).
In Tally.ERP 9 you can account VAT inclusive Sales transactions.
To record VAT inclusive sales,
To create voucher class
Go to Gateway of Tally > Accounts Info. > Voucher Types > Alter > Sales
In Voucher Type Alteration screen,
Tab down to Name of Class field
Enter the Name of Class as VAT - Inclusive
Press Enter to view Voucher Type Class screen
In Voucher Type Class screen,
In Exclude these Groups and Include these Groups field select End of List
In Default Accounting Allocations for each Item in Invoice section,
Select the Sales Ledger. Based on the Sales ledger selected the VAT/ Tax Class will be displayed.
In Percentage field define the sales amount percentage e.g. 86.21%
Note: The percentage defined here is indicative that 86.21% of Total invoice amount to be considered as sales assessable value.
Select the Rounding Method, if required. Retain No in Override using Item Default field.
Select the Output VAT Ledger. Based on the VAT ledger selected the VAT/Tax Class will be displayed.
In Percentage field define the sales amount percentage e.g. 13.79%
Note: The percentage defined here is indicative that 13.79% of Total invoice amount to be considered as Tax amount.
Press Enter to save the Voucher Type Class and Voucher Type Alteration.
While recording Sales Voucher using Inclusive Voucher Class ensure the option Use Common Ledger A/c for Item Allocation is set to No in F12: Configuration (Sales invoice Configuration)
To record Sales Inclusive of VAT,
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
In Change Voucher Type screen, select VAT - Inclusive in Class field
Enter the Reference Number and Date.
Select the Party’s A/c Name from the List of Ledger Accounts.
Select the Name of Item taxable @ 16%. Enter the Quantity and VAT inclusive Rate. The amount is automatically displayed in the Amount field.
Set the field Show Statutory Details to Yes to view VAT Calculation.
Enter the details in the field Narration, if required.
Press Y or Enter to accept and save.
The Total Value of the sale is Sh. 371200. Select the entry in alteration mode, move the cursor till the Amount field and check.
The Accounting Details screen displays the amount allocated to sales and VAT ledger. Amount is allocated based on the percentage defined in Voucher Class.
The Sales invoice Print Preview appears as shown:
Observe, Sales Invoice displays the Total Value of the Invoice i.e. Sales Value + VAT Amount.