Find Jobs
Hire Freelancers

Excel algorithm for automatic Bank Statement data extraction and categorization -- 2

$30-250 AUD

In Progress
Posted over 9 years ago

$30-250 AUD

Paid on delivery
Immediate start a plus I need someone to do all required formulas and programming to facilitate Excel performing the following functions: 1. Read bulk bank statements in CSV format 2. Evaluate between up to 4 fields per column to find correlations 3a. Present the list of correlated data with two single fields where the user can either choose an existing selection or create a new one. 3b. Upon classification, present all additional matches for bulk confirmation 4. Create functions and programming as required to achieve a quarterly profit & loss report (template to be provided upon start) 5. Add to above the ability to smoothly manage intelligent classification of transaction type (expense, interest, income etc) and sub-type (stationary, transport, utility etc) and create an automated a report as per a sample to be provided for a bonus $40
Project ID: 6714564

About the project

22 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello I am new at Freelancer.com and motivated to build up my ranking so I am offering a low price. I have worked on similar tasks a lot. If you have any questions please let me know. Best, Milos
$50 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
22 freelancers are bidding on average $146 AUD for this job
User Avatar
A proposal has not yet been provided
$72 AUD in 4 days
4.9 (419 reviews)
7.7
7.7
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel file. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$70 AUD in 7 days
4.9 (265 reviews)
7.6
7.6
User Avatar
Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro and Formulas. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in India. Data Integration and Compilation is my prime job over there. Making reports in Excel and Powerpoint is my routine job, which gives me an edge to carry out the project. I am a new Freelancer so I have the earnest desire to carry out the project successfully. So please consider my proposal and give me a chance to boom in the market of Freelancer. Kindly contact me for further details. Thanks and Regards Tonmoy Roy Electrical Engineer
$83 AUD in 5 days
4.9 (428 reviews)
7.2
7.2
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 AUD in 10 days
4.9 (115 reviews)
6.2
6.2
User Avatar
hey there, please share sample CSVs of bank statements, we can get this automated (including reports), please reply, we will discuss further, thank you !
$77 AUD in 3 days
4.8 (157 reviews)
5.9
5.9
User Avatar
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me with your actual data and final instruction and negotiation. Thank you.
$150 AUD in 3 days
4.8 (72 reviews)
5.5
5.5
User Avatar
Hello, I have done such projects, you can see my portfolio. I would like to see sample of your file, and to discuss details of project with you. Please consider me for your project. Thanks, TOm______________________________
$250 AUD in 7 days
4.9 (34 reviews)
5.3
5.3
User Avatar
I have created many macros in Excel. However, as of now, I have not fully understood your requirements. It would have been helpful if you had included a sample bank statement and the desired output as a part of the project
$250 AUD in 10 days
4.5 (50 reviews)
5.0
5.0
User Avatar
Can start on it immediately. Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. I strive for 100% user satisfaction as much as possible.
$250 AUD in 2 days
5.0 (6 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$250 AUD in 1 day
4.7 (4 reviews)
3.5
3.5
User Avatar
Dear Employer, I was a Quality Auditor for a BPO company and most of the tasks that I was doing involves the creation and automation of reports using Excel Macro and VBA. I have 3 years of experience in this field and an additional year of VBA development as a freelancer. I have done dashboard reports before which also outputs as an attached PDF report and then automatically created an Email using Outlook. I am available for an interview through Skype. Please message me so that we can start the project right away.
$200 AUD in 3 days
4.2 (2 reviews)
3.5
3.5
User Avatar
Hi there! My name is Conrad Gillard and I would like to help you with your project to develop a VBA program to analyse bank statements. I have extensive experience with VBA programming to process data, and I am confident that I can develop the macro that you require. I guarantee that I will complete this project within 5 days of you awarding it to me. To give you an example of my abilities, I recently completed a Freelancer project to extract data from an Excel file and generate a PowerPoint presentation, while allowing the user to specify their preferences. This project also required the development of a simple interface and the use of VBA. If you check my profile you will see that I received extremely positive feedback on this project, due to the fact that I exceeded the clients expectations in terms of developing a reliable and user friendly spreadsheet. The client was also pleased by the fact that I responded promptly to all communications, and completed the job quicker than my promised schedule. Finally, you may be wondering why my bid is lower than average. The answer is that I am currently in the phase of establishing a reputation for myself as one of the best Freelancers. As I mentioned, if you check my profile you will see that the first 8 employers who gave me the opportunity to prove my skills were extremely impressed. Thank you for your time to read my proposal and I look forward to working with you! Regards Conrad
$200 AUD in 5 days
5.0 (8 reviews)
2.8
2.8
User Avatar
Give me the bulk bank statements. Remember to tell me that what fields are in the CSV files and how much characters are in each filed ? so that I can extract the correct data and make the correlations and other necessary calculations for you. Thanks
$100 AUD in 7 days
5.0 (10 reviews)
2.9
2.9
User Avatar
I have a lot of experience in excel and vba and worked on complex projects. I would like to work with you. Please let me know further. Regards, Selvan
$74 AUD in 5 days
5.0 (4 reviews)
2.6
2.6
User Avatar
Hello, i am expert in vba , i can help it payment after job completion waiting your answer Regards
$65 AUD in 1 day
4.8 (7 reviews)
2.5
2.5
User Avatar
I am a Microsoft certified C# professional. I have experience also in Excel VBA. I understood the requirement and i am interested to take up this task, please let me know if you are interested and for negotiations
$277 AUD in 5 days
5.0 (1 review)
1.0
1.0
User Avatar
Looking for lowest bid or looking for someone who can really do the job? Look no further, let's get the work done already. I have worked on many vba projects.
$45 AUD in 3 days
5.0 (3 reviews)
0.9
0.9
User Avatar
Overview myself is pleased to submit this proposal for service to support mr/mrs , in achieving it's goal for improving customer satisfication by ( provide excel working ) . The objective < need 1# To Catch the deadline time > < need 2# to able work with team or individual > < need 3# to able work with professionality > Avaiable skill : Microsoft excel Microsoft word C++ programming Java programming Html programming PHP programming data entry Copy typing Copy working
$166 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I understand the needs of your project. I am very skilled and experienced, and I'm a freelancer who is right for the job. I'm going to finish your project, Please contact me to discuss further details. Thank you
$200 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This will be my first every job that i am bidding online, recently I have start a "ExcelExpert Consultants" here in Colombo, Sri Lanka,
$111 AUD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
0.0
0
Payment method verified
Member since Oct 1, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.