Find Jobs
Hire Freelancers

Dynamic Reconciliation EXCEL Macro

$30-250 AUD

Closed
Posted about 3 years ago

$30-250 AUD

Paid on delivery
We download CSV/EXCEL Files from 4-5 various systems and need to reconcile data between the systems to match our inventory & accounting system. There are certain steps and manipulation that needs to be done prior to the data being ready for the reconcilation. The purpose of the Macro will be automate the entire process and make it very easy to manage
Project ID: 29439042

About the project

43 proposals
Remote project
Active 3 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
43 freelancers are bidding on average $132 AUD for this job
User Avatar
Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$220 AUD in 4 days
4.9 (568 reviews)
8.5
8.5
User Avatar
Hello I am experienced in automating data manipulation and reconciliation via VBA. Can we please discuss your request? i can start now John
$50 AUD in 1 day
5.0 (189 reviews)
6.5
6.5
User Avatar
Hi. I have written many automation apps for formatting files including CSV, Excel. Can format any CSV, Excel templates to any other CSV, Excel templates. Ready to write your project. Will complete within 1 day
$90 AUD in 1 day
5.0 (238 reviews)
6.7
6.7
User Avatar
Hi, As I understand you would like to process 4/5 CSV/Excel files and reconcile the data using Excel macros. It would help to discuss further on the requirement. I am well versed with writing macros in Excel, Word etc.. I have written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$90 AUD in 3 days
4.9 (242 reviews)
6.8
6.8
User Avatar
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming,data processing, excel macros. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hearing from you. Regards
$100 AUD in 5 days
4.9 (78 reviews)
6.2
6.2
User Avatar
I am full time freelancer, providing automation consultancy to SME/MSME companies. I can develop an Excel based automation tools to automate business processes including calculation of large data and pivot tables. Below is a brief introduction of myself. I am postgraduate with more than 7 years of experience in advance excel based templates and tools, MIS reporting, business automation, dynamic dashboards, VBA, Excel macros and data processing. Please go through my portfolio to have a better understanding of my expertise from my completed projects. My portfolio URL:- https://www.freelancer.com/u/bhupendrayadav. I have developed advance excel based (VBA) automation tool for E&Y and Decathlon also. You can get your work done with highest quality and after development support at lowest price. Looking forward to work with you.
$100 AUD in 1 day
4.9 (52 reviews)
5.9
5.9
User Avatar
I have extensive amount of experience in Data Entry, Excel, Internet Research, Research, Web Search, Lead Generation, email listing, Data Mining Project Emails. I would like to work on this project and can complete with 100% accuracy within the time frame. Quality is assured. “Waiting for your reply”. Kind Regards, Batairy
$30 AUD in 1 day
5.0 (53 reviews)
5.4
5.4
User Avatar
Hi there, Need an Excel-based (Excel VBA) application that will automatically integrate the five reports/ data sets imported from different systems so that it can be managed easily? Please contact me if this is any of what you need. I'll be standing by to help. -Ige
$120 AUD in 3 days
5.0 (43 reviews)
5.4
5.4
User Avatar
Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfolio) that main goals were to capture information from websites. I can start now. Therefore, I would like to discuss about project details. Looking forward to hearing from you! Thanks in advance. Best Regards, Swarnali
$30 AUD in 1 day
5.0 (36 reviews)
5.5
5.5
User Avatar
Hi I am a Certified Public Accountant (CPA) and an expert in Excel and VBA application. I can help you with this macro project. Contact me to discuss. Regards!
$70 AUD in 1 day
5.0 (32 reviews)
4.7
4.7
User Avatar
Hi, Greetings! ✅checked your project details. I can do your work I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis and MIS Management. I have strong analysis, and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high. Please Ping me chat box for further discussion. Thank you.
$150 AUD in 3 days
5.0 (40 reviews)
4.8
4.8
User Avatar
Although I am relatively new to Freelancer, I have 25 years experience developing Excel, Access and VBA Scripts for a major computer corporation. Specializing in Inventory Control. I have created numerous Inventory Reconciliation Applications. I will provide a quality product at a reasonable price. I will be happy to provide a sample for your review prior to starting the project. Just message me through Freelancer and we will see what we can work out.
$100 AUD in 3 days
5.0 (5 reviews)
4.5
4.5
User Avatar
Hello Mate ❤ I have done a Lots of Macro Tasks Asalam-o-Alaikum ,I read the information carefully,I understand your requirement,I am Available to start this task ,I have done such works before, Just text me I'm willing to work, I can manage with my best of Abilities, Why you Choose me On time On Desire On Solution Thanks Muzammal Hussain
$200 AUD in 2 days
3.9 (20 reviews)
5.5
5.5
User Avatar
Hi, I understand that you are looking to filter and consolidate data from 4-5 files. I found the job very interesting and would like an opportunity to understand it better. It would be great if we could discuss the job detail via chat to help me understand it better. Looking forward for an opportunity to work on you project. Thanks. Sincerely, JM
$140 AUD in 7 days
5.0 (26 reviews)
3.9
3.9
User Avatar
Greetings! I trust that you have a common field (like SKU) to support the reconciliation across 4-5 sheets. Please share your Excel files (mock or real) for understanding how the files are linked so that we can automate the reconciliation process. Thank you, Iqbal
$100 AUD in 7 days
4.3 (13 reviews)
4.3
4.3
User Avatar
I love to do this kind of job! I'm here in freelancer for this reason. Visual basic and excel are my best tools to create automatic tasks. I worked in three different companies and I know very well what is inventory and an accounting system. Share your csv and excel files, I want to give a look at what you need. Bye, Alberto.
$82 AUD in 7 days
5.0 (5 reviews)
3.4
3.4
User Avatar
==== Able to start work right away ==== Hi, there I have read your job specification very carefully. I have over 6-years experiences in data processing using Excel macro. I am 100% sure to complete this job perfectly on time and on budget. I am ready to get started my work right away. I hope your kind contact to discuss more. Best regards Ming Wang
$50 AUD in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
Hi. I will suggest to use excel Power Query for data retrieval from systems and the manipulation. Please chat for more detail. Johnny
$140 AUD in 3 days
5.0 (4 reviews)
3.0
3.0
User Avatar
Hi, I am an expert in VBA macro programming and excel data processing and manipulation. I have worked on formatting data into a suitable format many times. It will be helpful to discuss the reconciliation process for further understanding the requirements. kindly contact to discuss further.
$60 AUD in 7 days
5.0 (10 reviews)
2.8
2.8
User Avatar
Greeting! My name is Vipin Kumar Garg and I am a software engineer (MCA). I have 20+ Yrs. Exp. in MS Excel VBA (Macro) and MS Access. I have developed around 500 macros & modules for the global sales team, paper mill, manufacturing companies and upload data on websites, send Emails as automatic, etc. I have worked in 200 million data in SQL Server. Created google sheets for an automation process. Examples: -  Market, Portfolio, Funnel, Revenue, Vision and True North for (Sales Playbook)  Module for paper size cutting (stop for wastage)  Macro for purchase paper reels (as per requirement)  Macro for finance balance sheets for maintaining as (opening, closing & GST)  Module for data entry (inward & outward material PMS & IMS)  Macro for send automatic Emails for customers by the sales department  Module for PIR as production process as machine wise.  Customize the ribbon in excel VBA with XML by “Custom UI Editor for Microsoft Office”  Scraped data from websites in excel with formatting  Created database in MS access and SQL server I am a new freelancer but I have good experience, please let me know a time for discussion with you
$100 AUD in 7 days
3.8 (1 review)
1.9
1.9

About the client

Flag of AUSTRALIA
Carlingford, Australia
5.0
5
Payment method verified
Member since Jul 11, 2017

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.