Invoice payment excel sheet

Kapalı İlan edilme: 6 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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

Proje NO: #16095354

Proje hakkında

80 teklif Uzak proje Aktif 6 yıl önce

Bu iş için 80 freelancer ortalamada €20 teklif veriyor

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 Daha Fazla

€33 EUR in 0 gün içinde
(918 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(211 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(499 Değerlendirme)
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, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(43 Değerlendirme)
7.8
RSwapnil

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(279 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(230 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(83 Değerlendirme)
6.7
caabdul

Hi, I can do it. Thanks

€22 EUR in 0 gün içinde
(55 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(71 Değerlendirme)
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 Daha Fazla

€23 EUR in 2 gün içinde
(68 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(38 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(29 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(18 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(13 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(6 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
1.6