In bank statement imports, the date format should be MM/DD/YYYY. But even if the date format is correct, the error message will show. The error message is “The file could not be imported, because the date is not in the correct format”. To solve this problem, Insert an apostrophe (‘) before the date/s (e.g. ’01/31/2021)… Continue reading Date Format Issue in Import
Tag: Bank Statement Import
CSV Import error ‘Unexpected Error’
When Importing the Bank Statements, the ‘Unexpected Error’ may receive. The possible reason for this one may be special characters in the Memo value. Remove the special characters from the statement file and reimport. To clean the memo field you can use the trim function. Ex: TRIM(CLEAN(F2))
‘Unexpected Error’ on Bank Statement CSV import
When importing the bank statements, user may encounter this error. One of the reasons for this one may be the line breaks on any of the CSV file columns. That is the header may be in two lines. For example, for the column Invoice Number(s), the header may be like InvoiceNumber(s). Change the format and… Continue reading ‘Unexpected Error’ on Bank Statement CSV import