This tool will help you to create the CSV file for uploading PLI/RPLI Pay Recovery data to McCamish. GST figures will get rounded to meet the new requirement.
First update the Excel file named source with the Pay Recovery data received from the Accounts branch.
Please note that this tool currently supports monthly premium only and if there are more than one months premium, you will have to enter them in separate lines.
Please refer to the tables given below while entering the data in the columns Pmt_Year and Pmt_Frequency
Pmt_Frequency | |
MONTHLY PREMIUM | M |
QUARTERLY PREMIUM | Q |
HALF YEARLY PREMIUM | H |
YEARLY PREMIUM | A |
Pmt_Year | |
FIRST YEAR PREMIUM | F |
SUBSEQUENT PREMIUM | S |
After entering data in the source Excel file, save the file and close it.
Then execute the batch file named “run”.
The tool will start and will ask things like FY GST, RY GST, State Code, Office Code etc. Hit enter to continue with the default values.
If you want to change anything, just type it in and hit enter.
After the execution, tool will create the CSV file and open it automatically for you, if there were no errors during the runtime.
Note: If any Windows 7 users faced the error “api-ms-win-crt-runtime-l1-1-
Sooraj K S (sooraj007ks@gmail.com)
0 comments:
Post a Comment