Hey Guys,
First post here so please excuse any errors or naivety.
My job now involves some accounts work, specifically the export of bank accounts into sage. Before entering into sage there is quite a large amount of manual input required in order to get the data in the right format for it to be imported. I'd rather do this on a monthly basis but it becomes a very large job and finding errors becomes tiresome. My question is, can I write a script in excel to take my data and organise it for me?
The stages involved are: remove 3 columns > merge two columns > assign payment type from a choice of 4 > assign destination account in sage > assign nominal code > calculate vat on certain values.
Whilst I appreciate it may take some time for a newbie to write, I don't plan on using it in the near future. At this stage I am still learning what each code means etc and even if script is created there will still have to be some manual input which I am happy with. I'm willing to try, get it wrong, and try again.
Any ideas/suggestions on how I might start going about it?
Steve
Bookmarks