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 entry excel, invoice excel, data entry billing, excel invoice data entry, 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, excel invoice reconciliaiton, 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 ) Santa Cruz, United States

Project ID: #2581159

15 freelancers are bidding on average $176 for this job

weblazer

Good day im interested to do this project please check Private message for details. Thank you

$180 USD in 21 days
(67 Reviews)
7.3
jeweljitu

****Letz start..... Low price .....Immediate start........ Check PMB.****

$150 USD in 5 days
(107 Reviews)
5.9
sharpresearcher

Experts here. Ready to start right away. Thanks

$200 USD in 5 days
(15 Reviews)
5.1
vikashgadia

We r excel macro expert. With 13 years of experience

$120 USD in 5 days
(15 Reviews)
3.6
try2t

Dear zliske, Please check pm and sample.

$250 USD in 30 days
(1 Review)
2.9
surfinsarah

I am very skilled at typing and data processing. I feel I am a wonderful candidate for your project. I would love the opportunity to show you my work. Thank you for your consideration.

$250 USD in 10 days
(1 Review)
2.8
SaranyaEden

I've already worked in few similar projects before and have earned a very good reputation from my employer. I'm really looking forward to work with you and complete this assigment of yours in a very remarkable way. If More

$175 USD in 10 days
(2 Reviews)
1.8
babyruth18

i am interested and ready start..

$250 USD in 1 day
(1 Review)
1.0
fabehaanas

Hi; EVERYONE SAYS THEY CAN DO IT; BUT WE WILL LOVE TO GET IT DONE FOR YOU. we have full confidence that we can get it done in the specified time & budget . I have gone through your posted project details & have the More

$30 USD in 20 days
(0 Reviews)
0.0
beingsuperlative

I have worked on excel and I can accomplish the task in the given time.

$150 USD in 20 days
(0 Reviews)
0.0
kmjackson

I would be happy to complete this for you! Experienced in Excel and very accurate.

$100 USD in 10 days
(0 Reviews)
0.0
DianaMJ

Dear Sir, We are interested in your project and ready to start and fulfill your requirement on time. Please check your inbox for details. Regards, Diana

$250 USD in 7 days
(0 Reviews)
5.4
meletia

I AM A HARDWORKING AND DETERMINE PERSON WHO WILL GET THE JOB DONE FOR YOU AND I ALSO UNDERSTAND WHAT YOU NEED TO BE DONE. I ALSO HAVE EXPERIENCE WITHE EXCEL AND ACCOUNTING

$250 USD in 8 days
(0 Reviews)
0.0
SeanXiang

1. I like your job. 2.My major is computer science & technology.I am proficient in CVS,Excel,Access,VBA.

$250 USD in 6 days
(0 Reviews)
0.0
dininduprasanna

I understand how critical the job. If I miss any payment in the invoice reconciliation . . . Just imagine. . Don't worry. . Excel is excellent for comparing and analyzing data. Though I'm new to freelancer, it's not t More

$30 USD in 1 day
(0 Reviews)
0.0
luisafonso63

I'm interested. I've experience in excel files,

$200 USD in 7 days
(0 Reviews)
0.0