ATT. Invoicing spreadsheet update. Oct 19 2012 13:09:17

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.

Skills: Data Entry, Data Processing, Excel

See more: where do we get data entry projects, spreadsheet services, region 13, i need data entry projects number, how to get the data entry projects, how to get data entry projects from companies, how many days after, first energy, companies that need data entry services, where to get data entry projects, data entry services companies, budget spreadsheet, spreadsheet input, spreadsheet 2, Lighting Company, how to get an invoice, how get data entry projects, efficient energy, att, aging, spreadsheet sales, spreadsheet fortune 500, check spreadsheet, need update working, update spreadsheet data

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

Project ID: #2581004

1 freelancer is bidding on average $35 for this job


Hired by the Employer

$35 USD in 3 days
(110 Reviews)