Bank Reconciliation Bank Import Error

[GreenSquare]

I’m trying to import a csv with only 4 lines. I’m receiving the error message in the first image. And the last image shows the current data exchange definition. Anyone have any ideas to resolve this?

[pjllaneras]

Hi @GreenSquare,

Please check that file type is “Variable Text” and column separator" is “Comma” for that data exchange definition.

[GreenSquare]

Hi @pjllaneras

It is indeed both as you described.

[Michelle_Serna]

Try changing the yyyy/mm/dd to yyyy/MM/dd. mm is generally minutes, not months.

[dharmesh_patel]

Hi @Greensquare

Try this setup for Date

Data Type - Text

Data Format - Blank

Length - 10