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

81 proposals Remote project Active 6 years ago

81 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
(784 Reviews)
8.6
RSwapnil

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

€25 EUR in 1 day
(278 Reviews)
7.9
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
(411 Reviews)
7.7
cowboy14

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
(122 Reviews)
7.3
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
(73 Reviews)
6.6
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
(157 Reviews)
6.5
caabdul

Hi, I can do it. Thanks

€22 EUR in 0 days
(50 Reviews)
6.1
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
(33 Reviews)
5.8
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
(56 Reviews)
5.9
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
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
(66 Reviews)
5.6
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
(9 Reviews)
5.0
Excel4You

Hi! I have a great experience in Excel and Visual Basic for Exel, so it will take not more than several hours to complete your project. I'm able to start right now!

€25 EUR in 1 day
(17 Reviews)
4.5
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
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
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
(14 Reviews)
3.3
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