Find Jobs
Hire Freelancers

Automated account reconciliation

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I'd like for you to write a simple web-based or VBA that will help me to reconcile the bank account every month. INPUT: - bank statement in excel format - account statement in excel format - date range Process - identify all transactions on the bank statement that show up on the account statement Output - if transaction amounts match, mark them as green on the bank statement report - if transaction amounts do not match, mark them as read on the bank statement report
Project ID: 18180608

About the project

39 proposals
Remote project
Active 5 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
Hi, I can buid a VBA script to import the files and do the reconciliation with one click on a button. If you will give me the opportunity to work on your project I am sure you will be satisfied by the quality of my work. Best regards, Florin Enache
$100 USD in 2 days
5.0 (23 reviews)
5.7
5.7
39 freelancers are bidding on average $131 USD for this job
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to correlate the bank and account statements. I can write the required code myself. I will charge you $200 and can deliver within five days (a single milestone to release once you're satisfied with the final result). I'm among the most experienced, and skilled Access developers on this platform. I have completed 264 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 a to 9 pm daily (including weekends), Athens time. I'm looking forward to working with you. Sincerely, Paris Pallas
$200 USD in 5 days
4.9 (423 reviews)
8.2
8.2
User Avatar
Hello, Hope you are doing well. I can help with you in your project Automated account reconciliation. I can assure you the quality job. I have good experience in Data Processing, Excel, Visual Basic. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$220 USD in 3 days
4.9 (491 reviews)
8.4
8.4
User Avatar
Hi there, I am European Freelancer and one of the top in Web Scraping category. Feel free to check my profile for reference of my previous work. I will develop a Python script which will login into your bank account, process the data, and send you an email report. I will schedule the task to run every month as cron job. Let's get in touch to discuss more details. Thanks, Mirko
$300 USD in 5 days
5.0 (58 reviews)
8.4
8.4
User Avatar
Hi, I can do an Auto Reconciliation Module in Microsoft Excel. I served as CFO, Controller, and Chief Accountant at global parent companies. I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, and taxation. I am also a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. During my career, I have gained valuable experience in diverse sectors, including VC’s, private investors, start-ups, retailers, power plants, farms, insurance companies, universities, construction businesses, real estate agents, medical equipment manufacturers, and traders, among others. My combined experience, knowledge, and creativity will lead to exceptional results that will exceed your expectations.
$250 USD in 3 days
4.9 (95 reviews)
7.5
7.5
User Avatar
Dear Sir/Madam, Hope you are doing well! It's my pleasure to submit my proposal on your project Account Reconciliation. I have experience and skills on Microsoft Excel, Data processing, Process development, VBA module or Macros, Formulas. I can assure you quality work with 100% accuracy and satisfaction. Please consider my profile. Thanks Gopal
$111 USD in 5 days
5.0 (27 reviews)
6.7
6.7
User Avatar
Hi, As you are looking for a VBA macro design to reconcile the bank account every month, I will build one for you. I have multiple years of experience in Excel and VBA macros. I have designed multiple automation projects. Please share your bank and account statements and I will build the Excel tool with button to do the reconciliation automation for you. Please give me this opportunity to work on your project. Thanks, Mohan
$149 USD in 3 days
5.0 (93 reviews)
6.5
6.5
User Avatar
PhD in computer science having seven years of experience in Excel development like : Excel calculators designing. Excel. dashboards designing. Excel. models designing. Excel automation. Excel Reporting systems. sir I can deliver you totally dynamic system.
$250 USD in 1 day
4.8 (93 reviews)
6.5
6.5
User Avatar
Hello, I am Excel and VBA expert. I can do this project by VBA. Can you share sample files (bank and account statements)? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$115 USD in 3 days
5.0 (98 reviews)
6.2
6.2
User Avatar
I am based out of NYC, NY, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex PYTHON/VB/VBA/.Net/Design/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in PYTHON/VBA/VB/.NET, SQL, Adobe packages, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), PYTHON, VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice d
$111 USD in 3 days
4.9 (88 reviews)
6.2
6.2
User Avatar
I will write you a VBA Macro that will achieve what you are after. Using a simple algorithm to compare the Transactions and Account to highlight the mismatches. If you have any questions, I would be happy to discuss via PM.
$55 USD in 3 days
5.0 (43 reviews)
6.1
6.1
User Avatar
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$175 USD in 5 days
4.9 (33 reviews)
5.3
5.3
User Avatar
Hi Good Day! A serious freelancer here! I can help you to complete this project in 1-2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$50 USD in 2 days
4.7 (78 reviews)
5.5
5.5
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience VB, excel
$98 USD in 2 days
4.6 (54 reviews)
5.8
5.8
User Avatar
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"
$180 USD in 3 days
5.0 (20 reviews)
4.8
4.8
User Avatar
About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Userform, Pivot, Graphs, Chart & Formulas. • Macro coding for complex tasks possible. • Have worked directly with client for an MNC IT Company. • High Accuracy. • Work in tight deadline. • Can start working immediately. • Minor modification possible even after Payment.
$75 USD in 2 days
4.9 (29 reviews)
4.0
4.0
User Avatar
Hi Sir, I have Excel expertise that can fulfill all your requirement mentioned in the Description. I already have built 2 systems like this using VBA and Excel Formulas. I can show you the templates right away. I can work to your satisfaction with 2 weeks of support after delivering the project. That may help you with the errors and changes (it usually comes to list when you start working with it). I can start work right away and can deliver you as earliest.
$150 USD in 6 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hello, So you have a long list of transactions in your bank statement and you need to have a tool to clear the payments with invoices, this is in my imagination. I have a very modern and efficient solution for your case, please let me know if you are interested so we discuss it further. Thank you Waseem
$70 USD in 3 days
4.9 (6 reviews)
3.4
3.4
User Avatar
automated account reconcillation High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
$222 USD in 4 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hi! I could create a simple google sheets automation for you! This should involve a few comparison formulas and two separate sheets for bank and account statements. If you'd like me to include any other additional functions, I could add them to the sheet as long as they're not too complex. If there's anything else you'd like to know, please feel free to drop me a message. I would love to hear from you soon :)
$100 USD in 3 days
5.0 (4 reviews)
2.5
2.5
User Avatar
================================================ ========== YOU FOUND YOUR FREELANCER ========== ================================================ 1. First of all, why me? We've more than 20 years of experience in data and development. 2. Do you understand the job? Yeah, crystal. Input and Report job for check bank transactions. Don't worry, we got it. 3. How much time do you need? 3 days. 4. How much it's gonna cost? $100 USD. ATTENTION! Price for no surprises. We guarantee the results. 5. Do you have some sample of our work? Yes. Please take a look of our portfolio. 6. Which tools or concepts are you familiar? Excel, Visio, .NET, Node JS, Python, SQL Server, Web scrapping, Machine Learning, IoT, Big Data and AI. Let do this! Marcelo Roza graduate System Information - FAHUPE postgraduate Web Development - UNIRIO postgraduate IT Management - UERJ
$100 USD in 3 days
5.0 (1 review)
1.8
1.8

About the client

Flag of UNITED STATES
MIDDLE VILLAGE, United States
4.9
14
Payment method verified
Member since Oct 24, 2006

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.