Sheet 1: Help

	
	
	
	
	
	
	

		
Quick Guide to use this utility for eReturn
		
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Pre requisites :- 
		


		


		


		


		


		


		


		


		


		


		


	
	

		
1
		
Use Excel version 2016 and 2013 only.
		


		


		


		


		


		


		


		


		


		


	
	

		
2
		
Enable Macros to use this utility.
		


		


		


		


		


		


		


		


		


		


	
	

		
3
		
Excel accepts Date in DD/MM/YYYY format only, If it is not accepting date in DD/MM/YYYY format then change the System date format using following steps:
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.1 Click on : date and time
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.2 Change date and time Setting 
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.3 Change date and time
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.4 Change calendar settings 
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.5 Region and Language
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.6 Select Format : English (United States)
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3.7 Short date : M/d/yyyy
		


		


		


		


		


		


		


		


		


		


	
	

		
4
		
Enable Calculation as Automatic by clicking File>Options>Formulas>Calculation Options>Workbook Calculation> Automatic
		


		


		


		


		


		


		


		


		


		


	
	

		
DISABLING THE PROTECTED VIEW(IF EXCEL OPENS IN PROTECTED VIEW)
		


		


		


		


		


		


		


		


		


		


		


	
	

		
1
		
Click the File menu button, and then click Options
		


		


		


		


		


		


		


		


		


		


	
	

		
2
		
Click Trust Center, click Trust Center Settings, and then click Protected View(If present)
		


		


		


		


		


		


		


		


		


		


	
	

		
3
		
Uncheck "Enable Protected View for files originating from the Internet."
		


		


		


		


		


		


		


		


		


		


	
	

		
4
		
Uncheck "Enable Protected View for files located in potentially unsafe locations."
		


		


		


		


		


		


		


		


		


		


	
	

		
5
		
Restart your Excel Utility
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
MACROS :- ENABLING MACROS IN EXCEL 2016
		


		


		


		


		


		


		


		


		


		


		


	
	

		
1
		
Click the File menu button, and then click Options
		


		


		


		


		


		


		


		


		


		


	
	

		
2
		
Click Trust Center, click Trust Center Settings, and then click Macro Settings
		


		


		


		


		


		


		


		


		


		


	
	

		
3
		
Click the option "Enable all Macros"
		


		


		


		


		


		


		


		


		


		


	
	

		
4
		
Restart your Excel Utility
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button for any Help.
		


		


		


		


		


		


		


	
	

		


		


		


		

 
		
		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		
button for clearing the filled data in sheet.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button for going to next sheet.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button for going to previous sheet.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button after filling data to validate the data .
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button after Validate data to Generate XML sheet .
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
 button to add rows in existing table.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Click on 
		

 
		
		
button to remove rows from existing table.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Color Codes :-
		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
-
		
Drop Down
		


		


		


		


	
	

		


		


		


		


		


		


		
-
		
Alphabets
		


		


		


		


	
	

		


		


		
-
		
Numbers
		


		


		


		


	
	

		


		


		
-
		
Date
		


		


		


		


	
	

		


		


		
-
		
Alphanumeric
		


		


		


		


	
	

		


		


		
-
		
Auto-populated 
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
NOTE :- 
		
1. Please read the Comments provided with every cell,for data type and length of field allowed, before filling the data.
		


		


		


		


		


		


		


		


		


		


	
	

		


		
2. Kindly Upload XML sheet only.
		


		


		


		


		


		


		


		


		


		


	
	

		


		
3. Quarter details of a financial year.
		


		


		


		


		


		


		


		


		


		


	
	

		


		
     First Quarter : Apr - Jun
		


		


		


		


		


		


		


		


		


		


	
	

		


		
     Second Quarter : Jul - Sep
		


		


		


		


		


		


		


		


		


		


	
	

		


		
     Third Quarter : Oct - Dec
		


		


		


		


		


		


		


		


		


		


	
	

		


		
     Fourth Quarter : Jan - Mar
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	



Sheet 2: Basic Details

	
	
	

		
Basic Details
		
	

		
Dealer TIN *
		

	Please enter numeric values of length 11 and it  should start from 33 (TN code).

	

	
	

		
Tax Period From *
		

	Please enter date in dd/mm/yyyy format and it should not be future date.

	

	
	

		
Tax Period To *
		

	Please enter date in dd/mm/yyyy format and it should not be future date.