Consolidate multiple bank csv/xls/pdf downloads.

Geschlossen Veröffentlicht vor 4 Jahren Bezahlt bei Lieferung
Geschlossen Bezahlt bei Lieferung

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.

Excel VBA

Projekt-ID: #20390086

Über das Projekt

9 Vorschläge Remote Projekt Aktiv vor 4 Jahren

9 Freelancer bieten im Durchschnitt £35 für diesen Job

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 Mehr

£30 GBP in 2 Tagen
(15 Bewertungen)
5.6
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 Tagen
(14 Bewertungen)
4.8
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 Mehr

£60 GBP in 7 Tagen
(3 Bewertungen)
2.4
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 Mehr

£23 GBP in 3 Tagen
(0 Bewertungen)
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 Mehr

£10 GBP in 2 Tagen
(0 Bewertungen)
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 Mehr

£20 GBP in 1 Tag
(0 Bewertungen)
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 Mehr

£15 GBP in 3 Tagen
(0 Bewertungen)
0.0
Sharan143

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

£18 GBP in 3 Tagen
(0 Bewertungen)
0.0