Closed

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
Employer working
Project Budget
N/A
Total Bids
38
Project Description

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:

Date
Account
Currency
CR/DR
Reference/Narrative

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.

MOST IMPORTANTLY

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online