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.
14 freelancers are bidding on average $92 for this job
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.
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