Related topics |
In Tally.ERP 9, you can export the return details to the MS Word format specified by the VAT authorities.
Export the VAT return
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Return .
2. Press Ctrl+P to export the e-return details in MS Word format.
3. Press Enter to create the MS Word file.
A brief explanation about the form fields is given below:
Field Name |
Description |
Company Name |
Displays the Mailing Name entered in the company creation/alteration screen. |
Address |
Displays the Address entered in the company creation/alteration screen. |
VAT Account Number |
Displays the 15-digit TIN entered in the company creation/alteration screen or Statutory and Taxation screen. |
Tax Return Period |
Displays the period shown in the Export Report screen while exporting the returns. |
VAT on Sales
Field Name |
Description |
VAT on Sales |
|
1 - Standard rated Sales |
Displays the details of sales and sales returns recorded with the Nature of transaction - Domestic Taxable Supplies or Domestic Supplies - Transfer of Right to Use . Journal vouchers recorded with: ● Nature of adjustment - Increase of Tax Liability and Additional Details - On Account of Advance Receipts . Displays the assessable value and credit value of VAT ledger. ● Nature of adjustment - Decrease of Tax Liability and Additional Details : o Cancellation of Tax Liability for Advance Receipts . Displays the assessable value and debit value of VAT ledger. o Bad Debts . Displays the assessable value and debit value of VAT ledger. |
2 - Private Healthcare / Private Education / First house sales to citizens |
Displays the details of sales and sales returns recorded with the following settings: ● In Statutory & Taxation screen, click F12: Configure , set Show additional details? to Yes and save. Set Is business into services for which tax is exempted for citizens? to Yes . ● Sales ledger > select Nature of transaction - Domestic Zero Rated Supplies > set Is sales made to citizens? to Yes . ● In sales invoice, set the option Provide VAT details? to Yes and enter the National Identity ID . |
3 - Zero rated domestic sales |
Displays the details of sales and sales returns recorded with the Nature of transaction - Domestic Zero Rated Supplies . |
4 - Exports |
Displays the details of sales and sales returns recorded with the Nature of transaction - Exports or Intra GCC Supplies |
5 - Exempt sales |
Displays the details of sales and sales returns recorded with the Nature of transaction - Domestic Exempt Supplies . |
6 - Total Sales |
Displays autocalculated values. |
Field Name |
Description |
VAT on Purchases |
|
7 - Standard rated domestic purchases |
Displays the details of purchase and purchase returns recorded with the Nature of transaction : ● Domestic Taxable Purchases ● Domestic Purchases - Transfer of Right to Use ● Domestic Taxable Purchases - Capital Goods (when grouped under Fixed Assets ). |
8 - Imports subject to VAT paid at customs |
Displays the assessable value and VAT entered in journal voucher recorded for VAT paid on customs, in the following sequence of steps: 1. Import of goods - Record purchase from party located outside GCC, using purchase ledger defined with Imports Taxable or Intra GCC Taxable Purchases as the nature of transaction. Enter the Taxable Value including customs amount in the VAT Details screen). Set the option Provide VAT details? to Yes and Is VAT Paid at Customs? to Yes . Note: The transaction will not appear in Reverse Charge Summary when the option Is VAT Paid at Customs? is set to Yes . 2. Record a payment voucher by clicking S : Stat Payment with the Payment Type set to VAT paid to Customs for Imports or Intra GCC Purchase . Debit the ledger grouped under Current Assets and credit the cash or bank ledger. 3. Journal vouchers to capture the value in the report. Select Nature of adjustment - Increasing Input Tax and Additional Details - Claiming Vat paid to Customs . Debit the VAT ledger and credit the current assets ledger. Displays the assessable value and credit value of VAT ledger. |
9 - Imports subject to VAT accounted for through reverse charge mechanism |
Displays the details of purchase and purchase returns recorded with: ● The Nature of transaction - Imports Taxable or Intra GCC Taxable Purchases . ● Journal vouchers recorded with: o Nature of adjustment - Increasing Input Tax and Additional Details - Imports or Intra GCC Purchase . Displays the debit value of VAT ledger. o Nature of adjustment - Increase of Tax Liability & Input Tax Credit and Additional Details - Imports or Intra GCC Purchase . Displays the debit value of VAT ledger. |
10 - Zero rated purchases |
Displays the details of sales and sales returns recorded with the Nature of transaction - Domestic Zero Rated Purchases . |
11 - Exempt purchases |
Displays the details of sales and sales returns recorded with the Nature of transaction - Domestic Exempt Purchases . |
12 - Total Purchases |
Displays autocalculated values. |
13 - Total VAT due for current period |
Displays autocalculated value (box 6 - box 12). ● Positive value indicates VAT payable. ● Negative value indicates VAT refundable. |
14 - Corrections from previous periods (between SAR + 5000) |
Displays the value (between SAR + 5000) of journal vouchers recorded with the: ● Nature of adjustment - Increase of Tax Liability and Additional Details set to: o Corrections/Amendments . Debit the expense ledger and credit the VAT ledger. o Others . Debit the expenses ledger and credit the VAT ledger. o Interest . Debit the current liabilities ledger and credit the expenses ledger. o Penalty . Debit the current liabilities ledger and credit the expenses ledger. ● Nature of adjustment - Increasing Input Tax and Additional Details set to: o Corrections/Amendments . Debit the VAT ledger and credit the expense or current assets ledger. o Others . Debit the VAT ledger and credit the expense or current assets ledger. ● Nature of adjustment - Decrease of Tax Liability and Additional Details : o Corrections/Amendments . Debit the VAT ledger and credit the expense or current assets ledger. o Others . Debit the VAT ledger and credit the expense or current assets ledger. ● Nature of adjustment - Reversal of Input Tax and Additional Details : o Corrections/Amendments . Debit the expense or current assets ledger and credit the VAT ledger. o Others . Debit the expense or current assets ledger and credit the VAT ledger. |
Box 15 - VAT credit carried forward from previous periods |
Displays the: ● Opening debit balance of VAT ledger. ● Input tax credit brought forward from previous return period. ● Value of journal voucher recorded with the Nature of adjustment - Opening Balance . Debit the VAT ledger and credit the current assets ledger. |
Box 16 - Net VAT due (or reclaimed) |
Displays autocalculated values. |