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
Mate, Excel VBA expert here. Please check PM for details. Thanks!
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet con Daha Fazla
Hello, I am offering you to make these consolidation tool as the set of Excel VBA macros. Please see private message for details.
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
im an experienced .NET programmer for more than 9 years , i have done alot of similar work and developed countless numbers of macros for different business sectors, im confident i can support u with the solution you r Daha Fazla
I'm an expert .NET developer. I will develop a small .NET application according to your requirement. Please see my profile and consider my bid as well.
Mr Nicholas I have more than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Exp Daha Fazla
I have developed many custom Excel VBA applications and have excellent ratings. Excel is a great choice for your needs.
Hi, I can provide you solution using .net it will export CSV File. please provide me your 40 bank account sample file.
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,
we are excel expert we can write a macro to automate the total process
Hi If Its Excel Macro then we are the right person ,Please see PMB
Why pick me? Firstly, my Freelancer feedback to date has been outstanding in all instances. Secondly, I have over 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions. Third Daha Fazla
Hi, i have done many projects like this one before, thanks.
I am very proficient in c, and excel programming. I have 15 years developing experience now, and I have worked for 5 years, please let expert help you.
Thank you for posting this Project at Freelancer.com. I have experience writing Excel applications to combine and synthesize multiple files in different formats, including CSVs. Please see my Portfolio and Feedback H Daha Fazla