CSV bank stat into Sage L50

Posted by mark1975 PM | on Wed, 02/04/2008 - 13:58 1264 4 comments | report

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.
Mark Reynolds

Comments

There are 4 comments. Login or register to view them.

Thanks

mark1975 | Thu, 03/04/2008 - 13:38

Updating bank from csv

james_associates | Thu, 03/04/2008 - 10:39

Receiving Multiple Standaing Orders

mjcpage | Wed, 02/04/2008 - 17:56

Excel?

neileg | Wed, 02/04/2008 - 15:33