
Completed
Posted
Paid on delivery
I need an expert in Excel and VBA to develop a macros for me. This macros will match invoices from one set to another in the same Excel file and perform a reconciliation between both sets and highlight the difference way I want. Key requirements: - Highlight discrepancies in GST tax numbers even when party names are the same - Handle invoice numbers that are in different formats or of different lengths - Automate this process to reduce manual work The main focus for this project is to highlight tax number discrepancies. Currently, the invoice numbers are formatted in different formats. The ideal candidate should have extensive experience in Excel and a deep understanding of how to create and implement macros. Knowledge of tax number formats and invoice reconciliation processes would be a significant advantage.
Project ID: 38860718
19 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I'm a senior VBA developer with extensive experience in Excel and VBA. I'll develop a macro that matches invoices, performs reconciliation, and highlights tax number discrepancies, even when party names are the same. I'll handle invoice numbers in different formats and lengths, ensuring flexibility and adaptability. With my expertise in VBA, I'll automate the process to reduce manual work. I'm familiar with tax number formats and invoice reconciliation processes, ensuring a solution that meets your specific needs. I'll provide detailed documentation and conduct thorough testing to ensure a reliable and efficient solution.
₹1,500 INR in 2 days
3.6
3.6
19 freelancers are bidding on average ₹1,148 INR for this job

Hey there I specialize in statistical analysis using Excel Macros, Data Processing, Excel, Excel VBA and Data Entry and I’m confident I can provide the rigorous insights you need. From data cleaning to detailed hypothesis testing, I can help derive meaningful conclusions that will support your strategic goals. What I Offer: In-Depth Analysis: Descriptive, inferential, and predictive statistical methods Clear Reporting: Detailed, understandable findings to inform your next steps Hands-On Experience: Extensive experience with Excel Macros, Data Processing, Excel, Excel VBA and Data Entry I’d love to discuss your project and the specific outcomes you’re looking to achieve. Best regards, Joseph M.
₹1,609 INR in 1 day
5.4
5.4

Hello, I am an expert in Excel and VBA with extensive experience in automating reconciliation processes. For your project, I will develop a macro to match invoices, reconcile discrepancies, and highlight GST tax number mismatches, even if party names match. The macro will also handle invoice numbers in varying formats, ensuring accurate and efficient processing. With deep knowledge of tax number formats and invoice reconciliation, I can deliver a tailored solution to reduce manual effort and improve accuracy. Looking forward to assisting you!
₹1,400 INR in 3 days
5.0
5.0

Hello, I’m ready to work with you and look forward to your response. Let’s discuss when you're free, and we can start ASAP. Warm Regards, Zahrah
₹600 INR in 1 day
3.4
3.4

As your freelancer of choice, my unrivaled expertise with Excel and data entry make me an exceptional fit for your data-driven project. I have a decade-long experience in dissecting complex data sets to surface meaningful insights, just like the ones you need for your invoice reconciliation task. In my journey as a data maven, I have become proficient in leveraging Excel macros and VBA to automate monotonous tasks, thus saving significant time and effort for my clients. Moreover, my familiarity with various tax number formats and Invoice reconciliation processes further strengthens my suitability for your project. My keen eye for detail combined with a dedication towards delivering high-quality work has earned me the trust of numerous clients over the years. Additionally, I highly respect the value of timeliness in any given project and assure you that expect high-quality results within stipulated time frame. You deserve a streamlined billing process to minimize manual work and maximize accuracy. Together, we can turn this vision into reality. Let’s not just handle the current disparities, but also set up a system that will efficiently serve you as your company grows over time. Choose me as your Excel maestro, and let's dive into transforming your raw data into invaluable assets.
₹600 INR in 1 day
3.6
3.6

Hi, Greetings of the day. My name is Kavita. I have 10+ years of experience in Advanced Excel, VBA, Google sheets and automation. I have worked on multiple projects in Advanced Excel, formulas, Pivot tables, VBA automation and Google sheets. With my extensive experience and expertise in advanced Excel, vba and google sheets, I can surely help you in google sheets formulas and calculations . Please contact for further discussion. Looking forward to work with you on this. Thanks Kavita
₹1,050 INR in 7 days
3.2
3.2

As an experienced data enthusiast and expert in Excel, I strongly believe I possess the necessary skills to execute your project proficiently. With exceptional knowledge in macros creation and implementation, I can certainly automate the invoice reconciliation process as per your requirements. My skillset encompasses handling different formats of invoice numbers and using VBA to highlight discrepancies smartly. What sets me apart is my astute attention to detail, which will be advantageous in managing conflicting tax numbers even when party names are the same. Over the years, I have perfected my skills in content typing and content exiting, which translate well into mitigating any possible errors during data manipulation or conversion; a skill I'm certain you'll find highly valuable for your project. With your specific needs and timeline in mind, I am committed to delivering results promptly and accurately. Efficiency and accuracy are pivotal in financial processes like invoice reconciliation. That proficiency combined with my adaptable approach will ensure fruitful outcomes for this project. I am genuinely excited about the opportunity to work on this intricate task with you. It would be an honor to put my expertise to work for you and deliver beyond your expectations.
₹1,050 INR in 7 days
0.0
0.0

hlo sir i am prabhuI have a technical background and I have worked with such pdf files a lot. I can do the work with accuracy.
₹1,000 INR in 7 days
0.0
0.0

Hello , I am highly experienced in Excel and VBA, specializing in automating reconciliation processes. I understand your requirement to match invoices, highlight GST discrepancies, and handle varying invoice formats. Key Highlights of My Approach: Create a robust macro to automate matching and reconciliation. Normalize invoice numbers for accurate comparisons. Highlight GST mismatches clearly, even if party names are identical. Deliver a user-friendly solution with detailed instructions. With my expertise, I will ensure the process is seamless, saving you time and effort. I am confident in delivering this project efficiently and meeting all your expectations. Let’s discuss your specific needs further to start right away! Regards, iqra maqbool
₹1,050 INR in 7 days
0.0
0.0

I understand your need, you can hire me if you want. I will complete your work with my best. I am a very organized person and to maintain that i always use software like Excel, MS word, power point, and graphic design.
₹1,050 INR in 7 days
0.0
0.0

With over two decades of experience in project management, I have consistently proven myself to be an advocate for efficiency and effectiveness. As a skilled professional in Excel, complete with advanced skills in data analysis and macros creation, I offer the perfect balance of systemic understanding and tailored solutions that you require for this project. My wide range of experiences across both internal and external projects has prepared me to anticipate problems before they arise, ensuring seamless reconciliation between complex sets within Excel. What sets me apart is my ability to adapt my skillset to accommodate different domains and industries - a bridge that is integral for your invoicing needs. Choosing me for this project ensures that you will not just receive a one-time excel solution, but a sustainable automated solution developed to reduce manual intervention significantly, regardless of format or length variations in invoice numbers. My proficiency with Agile methodologies guarantees timely delivery, while my Six Sigma Yellow Belt training reassures not only the quality of - but also the process involved in - the final deliverables. In summary, I am confident that my strong foundation in project management coupled with my deep understanding of Excel and macros will make me the ideal candidate for your need.
₹1,050 INR in 7 days
0.0
0.0

Hi. With my extensive 14+ years of experience in bookkeeping and accounting, I am the best fit for your project. On top of having a deep knowledge of Excel and VBA macros, I specialize in preciseness and meticulousness in works such as reconciling accounts, summarizing transactions and refining financial procedures. In particular, the expertise I developed includes working with varied tax number formats and efficient invoice reconciliation processes that exactly match your unique needs. Using the automation functions of Excel combined with VBA macros, I can successfully create an efficient tool for copying invoices from one set to another, highlighting discrepancies not only with text but also numerically between same party names and different tax numbers. My Expertise:- 1. Expertise in Excel Formulas and Functions for Data Matching 2. Advanced VBA Scripting for Custom Macro Development 3. In-Depth Knowledge of Tax Number Formats and Discrepancy Identification 4. Experience Handling Multiple Invoice Number Formats and Lengths 5. Automation of Complex Data Reconciliation Processes 6. Strong Problem-Solving Skills for Highlighting and Reporting Differences Kindly drop me a message, and you can rest assured that your requirements will be met in the best way possible to ensure your satisfaction. Hope to connect with you soon. Regards, Rekha
₹1,500 INR in 1 day
0.0
0.0

I'm an Excel expert with extensive VBA experience. I'll develop a macro to reconcile invoices, highlighting GST tax number discrepancies, handling varying invoice number formats, and automating the process. My solution will ensure accuracy, efficiency, and minimal manual work. I'm familiar with tax number formats and invoice reconciliation processes. Let's collaborate! I'll deliver a reliable, user-friendly macro, meeting your requirements. Please share your Excel file and detailed specifications.
₹600 INR in 3 days
0.0
0.0

I been work on my company, created different type of vba to automatate administrative process, I would able to help you on this one.
₹1,050 INR in 7 days
0.0
0.0

Hello, I'm sayod razib, with over 15 years of experience in graphic design. I'm here around the clock, ready to assist you with a wide range of graphic design tasks. Proficient in the latest design software such as Adobe Illustrator, Photoshop, In Design, and Coral Draw, I ensure that your projects meet the highest design standards. My expertise extends to various printing techniques and color management, guaranteeing that your projects look stunning.
₹1,050 INR in 7 days
0.0
0.0

I have been working with data entry, excel, writing, translation, transcription for two years. I can also meet the dead line with no problem.
₹1,050 INR in 7 days
0.0
0.0

Hi I will match invoices, reconcile discrepancies, and highlight GST tax number mismatches, even if party names match
₹1,050 INR in 7 days
0.0
0.0

Why I'm the Best Candidate As a detail-oriented and analytical Excel expert, I possess the skills and expertise to deliver high-quality results for this project. My key strengths include: Key Strengths 1. Advanced Excel skills*: Proficient in Excel formulas, pivot tables, charts, and data analysis. 2. Data management: Experienced in data cleaning, formatting, and visualization. 3. Problem-solving: Proven ability to troubleshoot and resolve complex Excel issues. 4. Communication: Effective communicator with excellent written and verbal skills. 5. Timeliness: Committed to meeting deadlines and delivering projects on time. Relevant Experience 1. Successfully managed and analyzed large datasets for [previous client/project]. 2. Created dynamic dashboards and reports for [previous client/project]. 3. Developed and implemented Excel-based solutions for [previous client/project]. Why Choose Me? 1. Quality work: I deliver accurate and high-quality results. 2. Fast turnaround: I meet deadlines and respond promptly to queries. 3. Flexibility: I adapt to changing project requirements and priorities. 4. Proactive:I identify and address potential issues before they impact the project. I am confident that my skills, experience, and passion for Excel make me the best candidate for this project. I look forward to discussing how I can contribute to your success.
₹1,050 INR in 7 days
0.0
0.0

Mumbai, India
Payment method verified
Member since Mar 28, 2021
₹600-1500 INR
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
$8-15 USD / hour
$10-30 USD
$10-30 USD
$250-750 CAD
min £36 GBP / hour
$30-250 AUD
€250-750 EUR
$8-15 USD / hour
₹3000-4000 INR
$2-8 USD / hour
₹1500-12500 INR
$10-30 USD
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 CAD
₹750-1250 INR / hour
$30-250 AUD