While uploading my bank statement for auto reconciliation, I am observing few errors. What could the issue be?

While doing auto-reconciliation, there are a few common errors that you might observe.

1. Unable to parse file 

[This error comes if the file format is not .csv or .xlsx]

Solution: Save the file in the mentioned format only

2. Invalid data found in row xx

[This error comes if the format is wrong]

Solution:

• Remove headers from the file
• The Date should be in the order of “day<>month<>year” separated by “-” or “/”
• Numerical fields are mentioned in text format. Convert them to number format

3. Invalid amount found in row xx

[This error comes if the amount format is wrong]

Solution:

• Convert all number fields to number
• Convert amount to plain number format without comma