Annexure-G is a quarterly annexure which includes all t sales returns transactions, made for medicines from registered dealers, that needs to be filed along with the quarterly return form FORM-200.
Annexure-G displays transactions where
● The nature of transactions is any of the below:
o Sales Taxable
o Sales Exempt
● Type of goods is medicine.
To export Annexure-G
1. Go to Gateway of Tally > Display > Statutory Report > VAT > Form VAT 200.
2. Click A: Annexure.
3. Select Annexure-G, and press Enter.
4. Click E: Export. Ensure that excel template is available at the Export Location.
5. Press Enter to export.
The fields in the annexure are described below:
Column name |
Description |
Dealer Tin number |
Displays the VAT TIN of the assessee, as recorded in the TIN field in the Company VAT Details screen in F11: Features > Statutory & Taxation. |
Period from |
Displays the From date of the return period. |
Period to |
Displays the To date of the return period. |
Name of the Purchaser |
Displays the buyer's name, as recorded in the field Name in the ledger of the party selected in the transaction. |
TIN number |
Displays the VAT TIN of the buyer, as recorded in the VAT TIN No. field in the VAT Details screen in the party ledger master or in the TIN/Sales Tax No. field in the Party Details screen of the sales transaction. |
Invoice No. |
Displays the Original invoice no. recorded in the credit note. |
Date of the invoice |
Displays the Date recorded against the Original invoice no. in the credit note. |
Purchaser's Goods Return challan No. |
Displays the Challan No. recorded in the Statutory Details screen of the credit note. |
Challan Date |
Displays Challan Date recorded in the Statutory Details screen of the credit note. |
Credit Note No. |
Displays the voucher number of the credit note recorded for the sales return. |
Credit Note Date |
Displays the voucher date of the credit note date recorded for the sales return. |
Rate of tax (A) |
Displays tax rate applicable to the goods returned. The default rate charged for medicine is 5% and 5.5% (applicable from 4th Nov 2016). |
Taxable value Excluding Tax (B) |
Displays the assessable value of the goods returned. |
Maximum Retail Price (MRP) (C ) |
Displays the MRP value of the goods returned. In case MRP is not enabled, the taxable turnover is captured. |
Vat\Tax Charged (D=A*C) |
Displays auto populated tax amount for the goods returned based on Rate of tax (A) and Maximum Retail Price (MRP) (C ). |
Used Sugam P number |
Displays the e-Sugam Number recorded in the Statutory Details screen of the purchase voucher. |
Local sales return done by Unregistered Dealers |
|
Taxable Value Excluding Tax |
Displays the value of sales return transactions made for medicine, by an unregistered dealer. The option Unregistered is selected in the field Type of Dealer in the VAT Details screen of the party ledger. |
MRP Retail Price (MRP) |
Displays the MRP value of medicine returned by an unregistered dealer. In case MRP is not enabled, the taxable turnover is captured. |
VAT\TAXcharged |
Displays the tax amount calculated on the MRP value of goods returns by the unregistered dealer. |
For Consumer |
|
Taxable Value Excluding Tax |
Displays the value of the sales return transaction made for medicine, by the consumer. The option Consumer is selected in the field Type of Dealer in the VAT Details screen of the party ledger. |
MRP Retail Price (MRP) |
Displays the MRP value of medicine returned by the consumer. |
VAT\TAXcharged |
Displays the tax amount calculated on the MRP value of goods returns by the consumer. |
Grand Total |
|
Total Taxable Value Excluding Tax |
Displays auto populated total taxable sales value excluding tax, for all the dealer types. |
Total Maximum Retail Price (MRP) |
Displays the total MRP sales made to all types of dealers. |
Total VAT/Tax Charged |
Displays output tax in the sales return invoice recorded against registered dealers. |