Find Jobs
Hire Freelancers

Data Entry, Excel Invoice reconciliaiton

$30-250 USD

Closed
Posted over 11 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 2581586

About the project

14 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $92 USD for this job
User Avatar
Please see your PMB, important information regarding project.
$60 USD in 2 days
4.9 (17 reviews)
5.1
5.1
User Avatar
Hello sir, Please read pm. Thank you.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i understand what you want, but there are little bit confusion so please send me sample for checking. but i am confident that i can do this.
$200 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am ready
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Count on me for this...i've vast exp on handling such matters.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think it can be quite easy and if you want after that job I can create for free a system which recognizes all data and organizes the way you want.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
fast, reliable, trustworthy, accurate
$175 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please consider me for this project. I have very strong knowledge in Excel, as I use it in my daily work.
$50 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm interested in completing this project for you. I'm very skilled in Microsoft Excel and VBA. I've developed spreadsheets and forms for several companies, including the U.S. Air Force. I will make your form effective and efficient. If we work together I guarantee you will not be disappointed! Please see PMB for more details.
$125 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I believe am your woman for this project but hey...you'll just have to find out.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
New free lancer, ready to take up this job on priority.
$110 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a sound knowledge about Excel. Please select me for this job and I'll do it with earliest and with highest accuracy.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Bangladesh
0.0
0
Member since Oct 20, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.