Kapalı

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.

Beceriler: Veri İşleme, Excel, Visual Basic

Daha fazlasını görün: follow application, reconciliation accounts, reconciliation, macro upload, excel formatting, developing 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, consolidated excel, excel 2013 visual, excel 2013 macro, excel macro upload data, csv files processing

İşveren Hakkında:
( 3 değerlendirme ) Royal Exchange, Australia

Proje NO: #4401183

37 freelancer bu iş için ortalamada 187$ teklif veriyor

bharanisrihari

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

in 7 gün içinde385$ USD
(66 Değerlendirme)
6.5
mantislin

Hi sir, please check PM, thx Kimi.

in 5 gün içinde248$ USD
(47 Değerlendirme)
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 Daha fazlası

in 3 gün içinde200$ USD
(39 Değerlendirme)
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.

in 3 gün içinde180$ USD
(64 Değerlendirme)
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

in 10 gün içinde165$ USD
(30 Değerlendirme)
5.0
northwolves

I'm ready to start,se PMB please.

in 2 gün içinde176$ USD
(49 Değerlendirme)
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 Daha fazlası

in 5 gün içinde200$ USD
(11 Değerlendirme)
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.

in 5 gün içinde160$ USD
(11 Değerlendirme)
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 Daha fazlası

in 2 gün içinde148$ USD
(14 Değerlendirme)
4.3
jal540

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

in 10 gün içinde200$ USD
(12 Değerlendirme)
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.

in 3 gün içinde105$ USD
(12 Değerlendirme)
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,

in 5 gün içinde120$ USD
(20 Değerlendirme)
4.1
vikashgadia

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

in 5 gün içinde198$ USD
(15 Değerlendirme)
3.6
jaylancer43

Please check your PM for details. Thanks.

in 3 gün içinde99$ USD
(11 Değerlendirme)
3.4
Solver86

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

in 3 gün içinde80$ USD
(7 Değerlendirme)
3.4
srdas2012

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

in 10 gün içinde200$ USD
(11 Değerlendirme)
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 Daha fazlası

in 7 gün içinde295$ USD
(8 Değerlendirme)
3.3
omaralieissa

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

in 3 gün içinde50$ USD
(7 Değerlendirme)
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.

in 3 gün içinde200$ USD
(2 Değerlendirme)
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 Daha fazlası

in 3 gün içinde110$ USD
(4 Değerlendirme)
2.8