Guide for All type of Adjustments

1. Keep this Calender and Date format like this for better Excel work. otherwise you may encounter date format Exception in excel while run Any Adjustments
   
2. In excel you have to enable macro in File> Options> Trust Center> Trust Center Settings> Macro Settings (if not enabled all Adjustments work will get failed) After close app will automatically reset to disable. check below last image
   
3. Prepare Creditors List
   
4. Select csv or excel file as per need
   
   
5. Select Creditors excel file which is created (See Task Bar for excel icon and click)
   
   
   
6. Repeat the process selecting until different asks
   
7. Open File generated file and see for errors in Ready Datasheet
   
   
8. If you see #NA in Name field (Ready Datasheet), that means NEW GSTIN not present in Creditors list, lets update in Both Creditors Sheet as well as in your Original Creditors list Excel file for future proof.
   
   
9. After Close Office_Tools app will automatically set back to disable state for safety