Create a program to search an Excel file to match a customer payment to open invoices -- 2
$10-30 CAD
Paid on delivery
I am looking for a skilled programmer to create a program to search an Excel file in .xlsx format and match a customer payment to open invoices. This project will require a user interface, and I prefer the programming language Python. The successful freelancer must have experience with Excel .xlsx files, user interface creation, and programming in Python. The program should compare the customer payment to a list of open invoices and generate a list with the corresponding matches.
An example file is attached. I would like to be able to input a target value that I'm trying to find and have the program search an Excel file that I select. The program would need to search for a combination of customer invoice amounts that could make up that number and then present the results into a new Excel sheet named Results_[date&time].xlsx. Those results would need to include Invoice ID, Customer ID, Customer Name and Amount The program needs to be able to handle changes in the input file where additional columns and data may be included but not needed in the input or output of this.
Thank you for your time, and I look forward to working with a talented freelancer on this project.
Project ID: #37444709
About the project
Awarded to:
Hi, I'm excited about the opportunity to work on your project. Here's my bid: I propose for creating a Python program with a user interface to search and match customer payments to open invoices in Excel (.xlsx) file More
37 freelancers are bidding on average $27 for this job
Hey Jeff M., I'm excited to learn more about your project and help create a program to search an Excel file to match a customer payment to open invoices. With 10+ years of experience in PHP, Laravel, React.js and mor More
Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bo More
Hello, I am eager to offer my programming expertise to create a program that will search an Excel file in .xlsx format, specifically designed for matching customer payments to open invoices. This project will include More
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
Hi there! My name is Ram and I'm a software developer with 8+ years of experience. I understand you're looking for a skilled programmer to create a program to search an Excel file in .xlsx format and match a customer p More
I understand you are looking for someone to create a program to search an Excel file to match a customer payment and open invoices. This project will require a user interface, and I prefer the programming language Pyth More
Hi, Iam data analyst and python developer. I have built similar app with simple interface. Please get in touch to discuss further details Thanks
Hello there, we can build you project with backend (i.e like comparing and matching invoices) with some python code and create UI with a low code python library called streamlit. So all you UI components like Input (te More
Hello, Greetings Jeff M., Good evening! I’ve carefully checked your requirements and really interested in this job. I’m a senior full stack developer working at large-scale apps. I’m offering best quality and highest More
Hello there, I am an experienced programmer with a strong proficiency in Python and extensive knowledge of Excel .xlsx file manipulation. I am excited about the opportunity to create a program that meets your requirem More
Hello there, I have hands on knowledge of python and tkinter more than one year. I build lot of desktop application as well as web applications. So I definitely do your task in 2 days. Reply as soon as possible. Thank More
Hello. I am a python developer. I can do your task in 1 day with Python CSV Package. Please discuss more details on chat.
Hello there! My name is Collins and I'm working at EDMUGI Branding Solution, leading company in designing, branding web development and digital marketing. I understand you're looking for a skilled programmer to create More
Hi I'm a skilled software engineer, and I'm a hard worker, I've seen your job description (( Create a program to search an Excel file to match a customer payment to open invoices -- 2 )) and I'm ready to help you skill More
Dear Client, I am an experienced programmer with a strong proficiency in Python, specifically in handling Excel (.xlsx) files, creating user interfaces, and developing efficient solutions. I am eager to work on your p More
Hello, Jeff M.. How are you? As a software developer, I am very confident in your project, Create a program to search an Excel file to match a customer payment to open invoices -- 2. I have rich experienced in Softwa More