Excel (or alternative) consolidation app
This project received 38 bids from talented freelancers with an average bid price of $184 USD.Get free quotes for a project like this
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online