Awarded

ATT Project Oct 19 2012 14:30:10

Greetings Teena

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. I reposted project so you could see file. Excel Tab 1. is project status and Tab 2. Is invoicing

Skills: Data Entry, Data Processing, Excel

See more: many days, first energy, excel energy, data entry services companies, lighting company, get invoice, efficient energy, att, aging, fortune 1000 excel spreadsheet, project timeline, spreadsheet fortune 500, matching excel file, energy project, data matching project, 2012 fortune 500 spreadsheet, project management budget, matching excel, invoice data entry work, project status company, excel invoice data entry, data entry invoice excel, fortune 1000 data, input invoice data, data entry billing

About the Employer:
( 0 reviews ) Santa Cruz, United States

Project ID: #2581137

1 freelancer is bidding on average $35 for this job

teenasethi

Hired by the Employer

$35 USD in 3 days
(110 Reviews)
5.9