I need assistance in developing an application to do the following for the purposes of bank account reconciliation:
Every morning we extract our statements from different banks. Because we have approximately 40 accounts in various currencies from five different banks, the formatting of the files is not consistent, though the files themselves are generally all CSVs. In some cases they may be pasted directly into an XLS spreadsheet.
From these various extracts, I want to generate a "Consolidated Statement" showing all activity from all accounts in the one place with consistent columns of:
Once this data is consolidated, I'd also like a quick macro to be able to turn it into a csv for upload into another system.
While this doesn't have to be in Excel, I'm unsure of any better alternatives at the moment. Happy for suggestions though.
If you decide to bid, DO NOT "FOLLOW UP" or contact me more than once to discuss your bid. I will contact you if I need more info.
IF YOU CONTACT ME AFTER YOU HAVE PLACED YOUR BID, I WILL AUTOMATICALLY REMOVE YOU FROM THE LIST OF BIDDERS.
37 freelancers are bidding on average $187 for this job
Hi, i can do it. I'm programmer for years and very familiar with VBA for excel. Please send sample statement. I can make a demo for you to check with them. Best regards, Cuong NH
Hi, as an expert in excel vba coding, I am interested with your project. I believe you prefer to work with a top-rated freelancer here. kindly check my profile before deciding. awaiting your confirmation. regards,