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: spreadsheet services, region 13, many days, first energy, data entry services companies, budget spreadsheet, spreadsheet input, spreadsheet 2, lighting company, get invoice, efficient energy, att, aging, spreadsheet sales, spreadsheet fortune 500, check spreadsheet, need update working, update spreadsheet data, 2012 fortune 500 spreadsheet, invoice data entry work, fortune 1000 data, input invoice data, data entry billing, input data invoice, invoice data entry

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)