Invoice payment excel sheet

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I have some work, in an Excel spreadsheet. Sheet A has 3 coloumns (client name, invoice number , amount that the client has to pay me)

Sheet B has bank statement lines with the amount that client pay or the payment i did

What i need,

i need to add a coloumn in sheet b that can give me the possibility to select the customer and the unpaid invoices

Excel

Project ID: #16095354

About the project

80 proposals Remote project Active 6 years ago

80 freelancers are bidding on average €20 for this job

jaylancer43

Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-stor More

€33 EUR in 0 days
(918 Reviews)
9.4
nazmussakib

Hi excel expert here, Can you please send me the excel file so i can look over it and confirm you .. Waiting for your reply. Thanks, Sakib

€23 EUR in 1 day
(211 Reviews)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€30 EUR in 1 day
(499 Reviews)
8.0
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

€29 EUR in 1 day
(43 Reviews)
7.8
RSwapnil

Dear Employer, Ready to start the project. Please provide excel files. Looking forward to work with you. thanks.

€25 EUR in 1 day
(279 Reviews)
7.9
aubrey03

I am an Excel specialist with a lot of experience. You may check my reviews to see the quality of my work.

€30 EUR in 1 day
(230 Reviews)
7.1
ujjwalmalik

Hi There, I have understood the task.I understand you need a drop down in sheet B b that can give you the possibility to select the customer and the unpaid invoices. I am a excel expert having 5+ years of experience More

€23 EUR in 1 day
(83 Reviews)
6.7
caabdul

Hi, I can do it. Thanks

€22 EUR in 0 days
(55 Reviews)
6.1
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved excel. Key fea More

€30 EUR in 1 day
(71 Reviews)
6.1
pm9887

Hi, I have vast experience in lead generation, internet research, market research, data entry, data processing and all kind of backend support. You can check my competencies. I can give you best quality output with f More

€23 EUR in 2 days
(68 Reviews)
5.8
NSExpert

Hi My name is Sakila. I can do work in spreadsheet. I understand that the job is to match 2 excel sheets and give you list with customer and the unpaid invoices. I would just like to add that this is a serious and More

€20 EUR in 1 day
(38 Reviews)
5.5
imanolie

hi there, I can write a small script to do this automatically by modifying the excel b with data from Excel a. I can finish it in a couple of hours. please let me know if you think I am a match

€31 EUR in 1 day
(10 Reviews)
5.0
magentapowa

Hello I would love to help you on this project. I can create a formula that will take as input the customer name and by indexing amount to pay in Sheet A minus amount paid in Sheet B will give you the result you want. More

€15 EUR in 1 day
(29 Reviews)
4.3
rezaulalam573

Hello Sir/Ma'am, I already read your project description & realize that I'm the perfect one for your project skill. I can do this project as per your requirement you provided. I'm available right now to start your p More

€23 EUR in 1 day
(18 Reviews)
3.5
Virend7586

Hello, I have a Professionally experienced and high skilled team for Excel task, Admin Assistant, Data Entry, Amazon Listing, Copy - Paste Work, Google Research Trick , Email Research, Data Conversion & Article, Typ More

€12 EUR in 1 day
(13 Reviews)
3.8
HadiDar786

Hello , i will do this job for you i can start work now i will add colum in sheet b and exactly do that you want ...Message me

€15 EUR in 1 day
(10 Reviews)
3.6
Maheshpatel107

Hello, I have read and understand your requirements, I can create it for you in quick time within today I have 4.5 years experience of software development with Excel macros also. Thanks Mahesh

€24 EUR in 1 day
(10 Reviews)
3.0
fb56168fbd6cd6a

Hello. Since it's a very easy task, I can do this job quickly for the low price. I am looking forward to working with you.

€16 EUR in 1 day
(2 Reviews)
2.9
m941

Hello Sir, I found your "Invoice payment excel sheet" job post and I’m very interested in your project as an MS-Excel data cleaning as per your rules with experienced. I think you’ll find I have the skill you’re look More

€8 EUR in 1 day
(6 Reviews)
2.6
nirusati

CAN CREATE THE PAYMENT STATUS EXCEL SHEET AS PER REQUIREMENT SKILLED EXCEL PERSON AND CAN AUTOMATE IT WITH FORMULAS TOO WILL ENSURE THE PROCESS IS COMPLETELY DOCUMENTED TOO

€10 EUR in 1 day
(5 Reviews)
1.6