Closed

Data Entry, Excel Invoice reconciliaiton

I work for a Energy services company in the states. We help large fortune 500/ 1000 companies retrofit their facilities with energy efficient lighting. My main role is sales, however we also by necessity, get involved in Project management. We are currently working with ATT, about 100 facilities in the Western Region. What I need is some data entry help in inputting billing status for all the projects onto a spreadsheet containing installation status. Specifically, after matching up the correct project, you would need to, working off of two spreadsheets, pull and input the following information from one spreadsheet to the other. 1. Initial invoice date. 2. initial invoice amount. 3. initial invoice number 4. final invoice date 5. final invoice amount 6. final invoice number. 7. First payment amount 8. First Payment received date. 9. First payment check number. 10. Final payment amount 11. Final payment received date 12. Final payment check number. Occasionally one payment check covers both the initial and the final payment. Lastly, I would like to see an aging column that calculated how many days have passed between the first invoice date and the payment date. Or in cases where we have not received the payment, I would like to see how many days have passed from invoice date and today's date. Let me know if you think this is something that you could do within the budget and timeline. File has one tab for project status and one tab for invoicing status.

Skills: Data Entry, Data Processing, Excel

See more: invoice data entry excel, company invoice data excel, excel invoice reconciliaiton, data entry invoice excel, many days, first energy, excel spreadsheet services, excel energy, data entry projects company, data entry check, correct data entry, companies data entry, billing data entry, final data, services data entry, data entry services companies, sales excel, lighting company, invoice, invoice processing, get invoice, excel work today, excel services, efficient energy

About the Employer:
( 0 reviews ) Bangladesh

Project ID: #2581586

14 freelancers are bidding on average $92 for this job

pkcyber

Please see your PMB, important information regarding project.

$60 USD in 2 days
(17 Reviews)
5.1
arifsumi1

Hello sir, Please read pm. Thank you.

$100 USD in 3 days
(0 Reviews)
0.0
fayyaz14

i understand what you want, but there are little bit confusion so please send me sample for checking. but i am confident that i can do this.

$200 USD in 10 days
(0 Reviews)
0.0
addepallianusha

i am ready

$30 USD in 7 days
(0 Reviews)
0.0
brayat01

Count on me for this...i've vast exp on handling such matters.

$100 USD in 5 days
(0 Reviews)
0.0
Friaseus

I think it can be quite easy and if you want after that job I can create for free a system which recognizes all data and organizes the way you want.

$100 USD in 7 days
(0 Reviews)
0.0
skendertopilla

fast, reliable, trustworthy, accurate

$175 USD in 3 days
(0 Reviews)
0.0
kcarsle

Hello, Please consider me for this project. I have very strong knowledge in Excel, as I use it in my daily work.

$50 USD in 5 days
(0 Reviews)
0.0
Flux8

I'm interested in completing this project for you. I'm very skilled in Microsoft Excel and VBA. I've developed spreadsheets and forms for several companies, including the U.S. Air Force. I will make your form effective More

$125 USD in 7 days
(0 Reviews)
0.0
benzoin69

I am interested to insert all items, subject matter in different columns of spreadsheet with utmost accuracy as well as repeated checking by dint of skill and experience.

$150 USD in 7 days
(0 Reviews)
0.0
mrexcel2012

Hi Iam commerce graduate and expert excel user with knowledge of vba also. I also doing similar job for my company, hence iam sure i can deliver what you require in stipulated time. G

$30 USD in 2 days
(0 Reviews)
0.0
hbickord1

Hello, I believe am your woman for this project but hey...you'll just have to find out.

$30 USD in 2 days
(0 Reviews)
0.0
sundardr13

New free lancer, ready to take up this job on priority.

$110 USD in 6 days
(0 Reviews)
0.0
inudaya

Hi, I have a sound knowledge about Excel. Please select me for this job and I'll do it with earliest and with highest accuracy.

$30 USD in 3 days
(0 Reviews)
0.0