Barclays.Net statement file import

Interface name	Barclays.Net statement file import
Bank	Barclays
File format	CSV Transactions

In Barclays.Net, select the CSV Transactions File Format for the desired time range.

Warning

Please note if you are using Microsoft Excel to preview file before uploading it, Excel might reinterpret date formats based on your system settings. Saving the file after previewing will prevent it from being imported in Iplicit.

The original CSV file provides the dates in the "dd/MM/yy" date format. (e.g.: "31/01/20"). When you open this file in Excel, it will be displayed instead as 31/01/2020. Saving this file from Excel will cause the import to fail with an error: "Cannot convert 31/01/2020 to date using format: dd/MM/yy".

Example

"Barclays.Net Transaction exported at 09:00 11/08/20"
"GROUP","ACC ID","ACCOUNT NO","TYPE","BANK CODE","CURR","ENTRY DATE","AS AT","AMOUNT","TLA CODE","CHEQUE NO","STATUS","DESCRIPTION"
"","","12345678","","12-34-56","GBP","03/08/20","Close",1234.56,"XXX","","C","XXXXXXX XXXXX XXXXXXX"
"","","12345678","","12-34-56","GBP","03/08/20","Close",1234.56,"XXX","","C","XXXXX XXXXXXXXXX XXXXXXX XXXXXX"
"","","12345678","","12-34-56","GBP","03/08/20","Close",123.00,"XXX","","C","XXXXX XXXXXX XXXXXXXX XXXXXXXX"
"","","12345678","","12-34-56","GBP","03/08/20","Close",-1234.56,"XXX","","C","XXXXXXXXX XXXXXXX XXXX"
"","","12345678","","12-34-56","GBP","07/08/20","Close",-1234.56,"XXX","","C","XXXXXXXXXX XXXX XXXXXX"
"","","12345678","","12-34-56","GBP","07/08/20","Close",1234.56,"XXX","","C","XXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXX"