Error : Portal Error : Input String was not in a correct format
Solution : Portal Error : Input String was not in a correct format .
This error generally happens because of some incorrect data or data with some special character in it.
To solve/fix the error, Divide your entire file into two parts and process each file separately.
Let's assume you are trying to process a file with 500 records and got this error then divide the file into two files with 250 data in each file, One file will process and other will give same error.
Then divide the excel file again which gives you error into two more file , each with 125 records, One will process and other will fail.
Continue...doing this until the number of records are less then 10, So now you can check which exact row is creating this error, if there is any special character or data issue please fix the issue.
If you still have any issue, Please send us email or create ticket with error details.
Import excel to tally using Excel4Tally.com