CSV import in Bank Manager

SOLVED

Good Day

I have prepared a Excel spreadsheet with all the banking transaction details with the layout 

row- date- period-statement description-GCS-account-ledger description-reference- project- receipt -payment 

Converted all the information in this format and and performed bank recons in excel as its a lot of transactions .

Then converted the file to CSV for import after taking out my extra reconcilliation workings but still cant upload it successfully into pastel express, version 19 build 19.3.3

Please share a template of a excel layout to be converted to csv that will be succesful

Thanking all guidance and advice in advance.