CSV bank stat into Sage L50
Firstly, I know how to download the bank statements into a CSV file and I know how to import a CSV file in the correct format into Sage.
I have around 100ish standinging orders from our clients lodged into our bank each month. Using Sage L50 these are posted manually to the customer accounts - it takes blooming ages!
Is there any way in excel that the customer name from the bank statement can be converted into the client code that exists in Sage. For example, the dowloaded bank statements shows detail as Mr Smith, can this be changed to SMI100?
Thanks, I hope this makes sence.