To upload Sales or Purchase data with VAT, you must use the V7 (i.e. version 7) templates.
Steps
1. Download the Standard templates (all versions) from this link:
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip
2. Unzip the zip file
3. Locate the folder "standard-templates-earlier-versions\v70"
4. The following Sales and Purchase files are available within v70 folder :
Vouchers-V7-Sales-Purchase-Advanced.xls
Vouchers-V7-Sales-Purchase-basic.xls
Vouchers-V7-Sales-Horizontal-format-with-VAT-without-stockitems.xls
Vouchers-V7-Purchase-Horizontal-format-with-VAT-without-stockitems.xls
5. To use a template of older version, you must select the both the XLS and XML file in udi-Magic wizard (in the same screen where you are prompted to select Excel file)
Remarks:
To select the XML file, you must tick / check the option "Use separate file for XML tags"