Closed

Consolidate multiple bank csv/xls/pdf downloads.

Consolidate multiple bank csv/xls/pdf downloads.

The exercise is to extract data from a range of downloaded transaction files and insert these into a single cumulative dataset. The cumulative dataset should then be able to automatically update a Pivot Table in a Microsoft Excel workbook.

The platform is a Windows 10 64-bit PC.

The downloads are carried out at least monthly. There are variations within the structure and the field formatting between each bank download file. Most of them are .xls or csv format. At present, only one of them is a PDF bank statement report, but that could change in the future.

The process should be able to cater for additional bank accounts being opened in the future and for variations in the structure and formatting of the fields within the downloaded files.

The common fields that are required for the cumulative dataset are: Bank Name; Account Number; Transaction date; Transaction amount; Currency; Description 1; Description 2.

Note, in some downloaded files the Transaction Amount is split into two separate fields (Paid and Received, or other such words). When the Transaction Amount is not split, and negative sign is used. It is important that negative and positive amounts are consistent across the dataset.

The dataset will have additional fields for manual entry to allow for the analysis. For example: Additional description; Reconciled; Accounting code; etc. These additional fields will be included in the Pivot Table.

The process would have to ensure that no duplicate transactions were created in the cumulative dataset. In checking for duplicates the user with have to be alerted to each one to manually check in case there is actually a true repeat transaction.

After the dataset is updated all the downloaded files should be deleted except for the PDFs.

A high level of automation is required for this with the absolute minimum of manual intervention by the user.

The successful freelancer will have to be able to demonstrate having carried out similar work in the past.

Skills: Excel VBA

See more: xls pdf flashpaper, csv xls, xls pdf data base, doc xls pdf jpg ppt pmb, trasnfer csv xls, csv xls export import, recreate xls pdf, java forum xls pdf, java xls pdf, macro bank recon xls, csv xls script java, freelance java doc xls pdf, pdf csv xls, php pdf csv xls

About the Employer:
( 4 reviews ) Barrhead, United Kingdom

Project ID: #20390086

11 freelancers are bidding on average £32 for this job

periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

£90 GBP in 3 days
(10 Reviews)
4.6
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sampl More

£30 GBP in 2 days
(11 Reviews)
4.6
ielucerotrad1

I can do the job! I assume bank downloads be be manual and worksheet will process this files. I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Office and VBA including intera More

£60 GBP in 7 days
(1 Review)
1.7
rogeriokussano

Hello, I read all scope for this project and looks feasible to be delivered. My only concern is regarding to the PDF files you have mentioned. I would like to understand better if this PDF content is something re More

£23 GBP in 3 days
(0 Reviews)
0.0
KPISolucionesRD

Hi! I'm a professional with more than 5 yeras of experience working with Automations using python and VBA Excel I just checked your requirement and I can help you. I can create a VBA Macro that can join all your excel More

£20 GBP in 5 days
(0 Reviews)
0.0
ghodratmodirian9

Hello dear sir/madam I’m ready to do your project right now as fast / carefully as you want. I have validation method to deliver my projects to the best quality. I had got this experience and have sample to show you. B More

£10 GBP in 2 days
(0 Reviews)
0.0
sunshine7677

Dear Client, I can do this. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s have a quick ch More

£20 GBP in 1 day
(0 Reviews)
0.0
abhishek1196

I have prior experience of making an automated premium calculator for an insurance company. The active excel sheet allowed the user to fill in the details and submit the proposal showing the premium amount which was ca More

£15 GBP in 3 days
(0 Reviews)
0.0
Sharan143

Have good excel vba knowledge in banking and finance risk department Relevant Skills and Experience Excel vba

£18 GBP in 3 days
(0 Reviews)
0.0
Seeniea

I can do it. I'm a good python scraper. scraping data and download anydata I can. Let me do it. Thanks.

£15 GBP in 1 day
(0 Reviews)
0.0
GopalJp

I have eight years experience in accounting and bookkeeping industries including global or offshore accounting and Taxation as well. Allow me to successfully carry out outsourced accounting and bookkeeping activities More

£50 GBP in 5 days
(1 Review)
0.0