Lukket

Invoice payment excel sheet

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

Evner: Excel

Se mere: I want to work at home on C and without taking any payment for it .I have experience as a C programmer . I have my own PC ., i need to create a leave excel sheet, how to know how i work with formulas on excel, payment tracker excel, invoice tracking system, sales invoice tracker excel, invoice management excel, invoice spreadsheet template free, how to keep track of invoices and payments, track invoices and payments excel, invoice tracker in excel format, english, data entry, data processing, software architecture, excel, preparing a spreadsheet excel that helps one to plan custom vacations packages, i need you to fill in a spreadsheet with data its an easy task to enter the data in excel sheet, excel job costing work sheet, excel sheet shift work

Om arbejdsgiveren:
( 5 bedømmelser ) GUASTALLA, Italy

Projekt ID: #16095354

85 freelancere byder i gennemsnit €20 på dette 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 Flere

€33 EUR in 0 dage
(618 bedømmelser)
8.3
RSwapnil

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

€25 EUR på 1 dag
(264 bedømmelser)
7.5
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 på 1 dag
(272 bedømmelser)
7.2
leelakalidas32

Hello. i am Ajay from India without wasting our both time i want to work for your sample file for selection for this [login to view URL] allow me to start sampling .contact me anytime i am always here. Relevant Skil Flere

€20 EUR på 1 dag
(148 bedømmelser)
6.5
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 på 1 dag
(94 bedømmelser)
6.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 Flere

€23 EUR på 1 dag
(53 bedømmelser)
6.2
€10 EUR på 1 dag
(133 bedømmelser)
5.9
caabdul

Hi, I can do it. Thanks

€22 EUR in 0 dage
(47 bedømmelser)
5.8
SShtv

One of the areas of my work is the automation of business processes. For example, I send screenshots of some of my work done. [login to view URL]

€15 EUR på 1 dag
(59 bedømmelser)
5.7
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 Flere

€20 EUR på 1 dag
(38 bedømmelser)
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 på 1 dag
(8 bedømmelser)
5.0
€14 EUR på 1 dag
(19 bedømmelser)
5.0
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Flere

€30 EUR på 1 dag
(64 bedømmelser)
5.2
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, Flere

€29 EUR på 1 dag
(23 bedømmelser)
5.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 Flere

€30 EUR på 1 dag
(38 bedømmelser)
5.4
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 Flere

€23 EUR in 2 dage
(37 bedømmelser)
5.0
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 på 1 dag
(47 bedømmelser)
5.1
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. Flere

€15 EUR på 1 dag
(28 bedømmelser)
4.1
scorpionobaid01

Hello Thanks for invitaion I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experien Flere

€24 EUR in 0 dage
(16 bedømmelser)
4.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 på 1 dag
(16 bedømmelser)
3.7