Type search words and press enter

Round-off Sales Invoice Value Under GCC VAT

As per law, the VAT amount must be calculated on the VAT rate applicable for each stock item. In accordance with this, in Tally.ERP 9, the VAT amount gets calculated on the VAT rate applied for each stock item. However, you might notice a difference in decimal value between the total of VAT amount calculated on each stock item, and the VAT amount calculated on the total taxable value of all the stock items. In such cases, you can use an expense ledger in the invoice, to round-off the difference in the decimal value.

1. Create a ledger for Invoice Rounding.

a. Gateway of Tally > Accounts Info. > Ledger > Create .

b. Group it under Indirect Expenses .

c. Set the option Type of Ledger to Invoice Rounding .

d. Select the Rounding method and enter the Rounding limit .

e. Accept the screen. As always, you can press Ctrl+A to save.

2. Record the sales invoice with the round off ledger.

a. Gateway of Tally > Accounting Vouchers > F8 (Sales).

b. In the Party A/c name field, select cash/bank/party ledger.

c. Select the sales ledger.

d. Select the stock items, and enter the quantities and rates.

e. Select the VAT ledger. The VAT amount appears automatically.

f. Press Alt+I (Tax Analysis). In the Tax Analysis screen, the VAT amount calculated for each stock item appears as shown below:

g. Press Esc to return to the sales invoice.

On calculating 5% VAT rate on the total taxable value of 12,008.80 , the VAT amount would be 600.44 . Hence, the invoice value would be 12,609.24 .

You can arrive at this invoice value by using the round-off ledger.

h. Select the round-off ledger. The amount appears automatically. You can change the amount to -0.01 . Now the invoice value appears as 12,609.24 , as shown below:

i. Accept the screen. As always, you can press Ctrl+A to save.

3. Print the invoice as per FTA.

a. Press Page Up to view the invoice in alteration mode.

b. Press Alt+P (Print) > press Backspace and set the Invoice Format to Invoice Format 2 .

c. Press Alt+I (Preview) to preview the invoice, or press Enter to print. The invoice with round-off ledger value appears as shown: