Bank Manager: ‘Invalid CSV file format. Format: The CSV file should only have 3 columns: Date, Description and amount…..’ error importing bank statements using Bank Manager

Learn how to fix the ‘Invalid CSV file format. Format: The CSV file should only have 3 columns: Date, Description and amount…..’ Bank Manager import error, in Sage 200 Evolution.

This article discusses how to fix the Bank Manager import error: 

This error is especially relevant when the CSV(Bank Manager option was selected.

.

However, the same type of wording may also occur for other Bank Manager banking options.

 

 

 

Consider the following advice to resolve the above error: 

On the import file: 

Bank Manager may be interpreting the blank columns after the 'Amount' column as additional columns to import. 

 

To resolve this, do the following: 

1. Select the blank columns beyond the intended data range.

2. Right-click and choose Delete. 

3. Save the changes and close the import file.

4. The above import error should now be resolved.