Annexure 48 is a quarterly annexure. It has to be filed before the 30th day of the month succeeding the quarter. It displays the details of local purchases, both taxable and exempt, and also purchases made from unregistered dealers during the return period.
Download the template of Annexure 48 from the E-Services Templates link of the commercial taxes department website .
● Purchases recorded with the following Nature of transactions are captured in Annexure 48:
o Purchase Exempt
o Purchase Taxable
o Purchase from Unregistered Dealer
● The option Is LOC Purchases? is set to No in the Statutory Details screen of the purchase invoice and debit note.
To export data to Annexure 48
1. Copy the excel template FORMVAT 48.xls to the folder in which Tally.ERP 9 is installed.
2. Double-click FORMVAT 48.xls template to o pen the file. The annexure template appears as shown below:
3. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT XI .
4. Click A : Annexures .
5. Select Annexure-48 and press Enter .
6. Press Ctrl+E to export the data to the template. Before exporting the data, Tally.ERP 9 will display the number of rows to be added in the template based on the data being exported.
7. Add the number of rows shown in the field No. of rows to be added to the template.
o Click Add Rows (+) in the VAT 48 sheet of the template.
o Press Ctrl+S to save the changes and close the template.
8. Press Enter to export data to the template. The relevant details are captured in VAT 48 sheet of the template.
Ensure macros are enabled before validating the data in the template.
Note: Macros are used to automate frequently-used tasks, such as, calculations, verification and analysis of data. The J&K VAT annexure excel templates have macros to verify data correctness and create upload file.
To validate the data exported to the template
1. Double-click FORMVAT 48.xls template to open the file.
2. Click Validate in the VAT 48 sheet. If there are no errors, the message No error found in sheet. Do you want to generate Upload file? appears.
3. Click Yes .
4. Click Save . The upload file gets generated in .csv format in the same location.
A brief explanation about the annexure columns is given below:
Column Name |
Description |
Name |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice. |
TIN |
Displays the VAT TIN predefined for the party ledger or as entered in the Party Details screen of the invoice. |
Invoice No.* |
Displays the: ● Supplier Invoice no. entered in the invoice. ● Original Invoice No. entered in the debit note recorded for purchase returns. |
Invoice Date* |
Displays the: ● Date entered for the Supplier Invoice no. in the invoice. ● Date entered for the Original Invoice No. in the debit note recorded for purchase returns. |
0% |
Displays the net assessable value of purchases and purchase returns recorded by: ● Selecting Purchase Exempt as the Nature of transaction . ● Set the option Is LOC Purchases? to No in the Statutory Details screen of the purchase invoice. |
1% |
Displays the net assessable value of purchases and purchase returns recorded with 1% tax rate by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
5% |
Displays the net assessable value of purchases and purchase returns recorded with 5% tax rate by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
13.5% |
Displays the net assessable value of purchases and purchase returns recorded with 13.5% tax rate by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
40% |
Displays the net assessable value of purchases and purchase returns recorded with 40% tax rate by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
Other % |
Displays the tax rate of purchases and purchase returns recorded with other than 0%, 1%, 5%, 13.5% and 40% by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
Amount (Other %) |
Displays the net assessable value of purchases and purchase returns recorded with other than 0%, 1%, 5%, 13.5% and 40% by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
Total |
Displays auto calculated value. |
VAT Charged |
Displays the VAT amount of purchases and purchase returns recorded by: ● Selecting the following Nature of transactions: o Purchase Taxable o Purchase from Unregistered Dealer ● Setting the option Is LOC Purchases? to Yes in the Statutory Details screen of the purchase invoice. |
ITC Amount |
Displays the VAT amount entered in the purchases and purchase returns. If the VAT is 0%, then the amount appears as 0.00. |
Invoice Total |
Displays auto calculated value. |
System Calculated VAT Charged |
Displays auto calculated value. |
System Calculated ITC Charged |
Displays auto calculated value. |
System Total |
Displays auto calculated value. |
'Annexure 48 (Jammu & Kashmir)' has been shared with