Closed

Excel (or alternative) consolidation app

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.

Skills: Data Processing, Excel, Visual Basic

See more: m&t bank, m & t bank, follow up after application, cr. app, cr.app, reconciliation of accounts, with bank statements, reconciliation, macro to upload, Excel Formatting, developing an app, bank reconciliation, Alternative, basic bank statement excel, excel data reconciliation macro, extract excel files, app basic excel, activity spreadsheet, excel data reconciliation, discuss statement, excel macro csv, consolidation spreadsheet, xls visual basic, 2013 excel visual basic, visual basic currency

About the Employer:
( 3 reviews ) Royal Exchange, Australia

Project ID: #4401183

37 freelancers are bidding on average $187 for this job

bharanisrihari

Mate, Excel VBA expert here. Please check PM for details. Thanks!

$385 USD in 7 days
(66 Reviews)
6.5
mantislin

Hi sir, please check PM, thx Kimi.

$248 USD in 5 days
(47 Reviews)
5.7
nagybatonyi

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 More

$200 USD in 3 days
(39 Reviews)
5.6
slavisatosic

Hello, I am offering you to make these consolidation tool as the set of Excel VBA macros. Please see private message for details.

$180 USD in 3 days
(64 Reviews)
5.4
Nhcuong

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

$165 USD in 10 days
(30 Reviews)
5.0
northwolves

I'm ready to start,se PMB please.

$176 USD in 2 days
(49 Reviews)
5.0
HosElectro

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 More

$200 USD in 5 days
(11 Reviews)
4.5
yeki

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.

$160 USD in 5 days
(11 Reviews)
4.4
Tablassus

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 More

$148 USD in 2 days
(14 Reviews)
4.3
jal540

I have developed many custom Excel VBA applications and have excellent ratings. Excel is a great choice for your needs.

$200 USD in 10 days
(12 Reviews)
4.3
kalpesh2804

Hi, I can provide you solution using .net it will export CSV File. please provide me your 40 bank account sample file.

$105 USD in 3 days
(12 Reviews)
4.2
seaanddream

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,

$120 USD in 5 days
(20 Reviews)
4.1
vikashgadia

we are excel expert we can write a macro to automate the total process

$198 USD in 5 days
(15 Reviews)
3.6
jaylancer43

Please check your PM for details. Thanks.

$99 USD in 3 days
(11 Reviews)
3.4
Solver86

**** Please check PM. Thanks ****

$80 USD in 3 days
(7 Reviews)
3.4
srdas2012

Hi If Its Excel Macro then we are the right person ,Please see PMB

$200 USD in 10 days
(11 Reviews)
3.4
buyaspreadsheet

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 More

$295 USD in 7 days
(8 Reviews)
3.3
omaralieissa

Hi, i have done many projects like this one before, thanks.

$50 USD in 3 days
(7 Reviews)
3.2
hbxfnzwpf

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.

$200 USD in 3 days
(2 Reviews)
2.9
charmw

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 More

$110 USD in 3 days
(4 Reviews)
2.8