Find Jobs
Hire Freelancers

Fill in a Spreadsheet with Data + Produce a Summary of the Data

$30-250 NZD

Completed
Posted over 7 years ago

$30-250 NZD

Paid on delivery
I have 23 invoices each containing on average 46 products I have purchased. The approximate total number of items is 1,058. An example item on a receipt might be “Fresh Product – Bananas – 0.600 kg). In addition I have further approximately 55 receipts each containing on average 13 items. Approximate total: 715 items. For example “Lamb Knuckles – 2 pieces” All the items are food I have purchased over the last six months. The receipts and invoices are attached as scanned pdfs. There is one extra big file I will send to you - it is too big to upload. What I need: The basic details of each item (the name AND weight OR number of items but not a full description) loaded into an excel spreadsheet. The items should be broken up into the month they were bought. Please ensure numbers are separated from descriptions so there should be at least X columns: Example: Item Name: Chocolate Weight of Item (if applicable) 240g Type of Item: Bar Number of items: 5 Total Weight: 5 x 240g = 1200g So this means there are 5 bars of chocolate, each weighing 240g, for a total of 1200g. Another example Item Name: Flour Weight of Item (if applicable) 1000 grams Type of Item: Bag Number of items: 3 So this means there are 3 bags of flour each weighing 1000 grams. At the end of each month I need a summary of the total number of items purchased and their weight (a summary for each month) Then I need an overall total for all items for all months (one big summary at the end) Please see the attached example spreadsheet. I also need the total total cost (not per item) of ALL the items (the total cost of all receipts). I need you to use formulas in excel not just data entry and manually adding up the numbers SO if there are 5 cans at 200g each I need the spreadsheet to multiply 5 x 200 = 1000g And the summaries should all use formulas too, not manual addition. I already have a list of most of the items in excel, this should speed things up a LOT. Please see attached files - Example Book 2. Do not apply unless you are good with excel and you understand my instructions please.
Project ID: 11377717

About the project

40 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
Hi, I have more than 14 years of data entry and Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 NZD in 10 days
4.9 (175 reviews)
6.5
6.5
40 freelancers are bidding on average $163 NZD for this job
User Avatar
Hi there. I am a full time excel professional and am rated best service provider in excel projects. I read project description carefully and also checked attached sample products image and spreadsheet. Entering about 1058 its from 23 invoice and about 715 items from 55 receipts will be done with 100% accuracy. The final results of spreadsheet will be via formulas and everything will be entered in explained format and month wise. these is all manual task and it will take about 4 days to complete. Please check my feedbacks for my expertise in similar excel projects done. I will appreciate if we can discuss more via chat. Happy to do sample work before project awarding. Best, Ethan
$222 NZD in 3 days
4.9 (431 reviews)
8.5
8.5
User Avatar
Hello, We will use formula's and PIVOT tables for better results. I have more than 4 years of data administration experience. I have done many similar project like this one. You may check my profile for positive feedback. I believe I can do this task and can continue for the future projects as well. Looking forward to talk to you. Aisha
$155 NZD in 10 days
4.9 (274 reviews)
8.4
8.4
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I have understood your requirement that you need separate files for every month. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$90 NZD in 2 days
4.9 (394 reviews)
8.2
8.2
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$150 NZD in 3 days
4.9 (428 reviews)
8.1
8.1
User Avatar
Hi, I can enter each and every product detail with gram/piece information with price accurately. I am good in both data entry and excel formula's . This project WELL suits to my experience. Looking forward to hear from you. thanks
$210 NZD in 3 days
4.9 (361 reviews)
8.2
8.2
User Avatar
Excel expert at your service. I am one of the top freelancer in Excel and VBA. I can help you implement solution for this. Looking forward for your reply. Please check my past reviews for your reference.
$250 NZD in 2 days
4.9 (335 reviews)
7.7
7.7
User Avatar
Sir i am ready to start your task its very easy for me i hope i can help you in this project and give you good job,so please contact me,thanks
$100 NZD in 3 days
4.9 (271 reviews)
7.2
7.2
User Avatar
Just read you job desc. It fits to my skill set. Maybe it can take a bit time (data entry part) the rest is quite straightforward. lets talk
$300 NZD in 6 days
5.0 (149 reviews)
7.2
7.2
User Avatar
Hello, We will convert your PDFs into excel using formulas and manual entries, and will have summary as you specified. We are ready to do a sample work too, if you wish us to do sample work, please let us know. We are experienced excel professionals will make your job easier with our accurate deliverables of the project. Thank you, data2007
$221 NZD in 10 days
5.0 (94 reviews)
7.1
7.1
User Avatar
Hello there! If you need somebody who is fast in data entry without sacrificing accuracy and also very proficient with excel formulas and functions then I can definitely assist you with your project. Feel free to message me the details. I can start ASAP.
$222 NZD in 7 days
5.0 (163 reviews)
6.7
6.7
User Avatar
I have gone through the project details and understand what you are trying to achieve. We have completed a number of similar a projects to yours. I'd like to speak with you to confirm project details. A little about us, We are a team (19 operators) here, giving all data entry, research and scraping service world wide with best quality output ,we are experienced enough to collect the data from several source, from a deep investigation. We would like to talk in details and give the total structure about how we ll do this job along with a sample, LETS TALK HERE FOR DISCUSSING THE JOB Thanks Dg
$150 NZD in 3 days
4.7 (229 reviews)
7.1
7.1
User Avatar
Hello Sir, Give me full detail about project. If you need, will show sample now. I am waiting for your message. Hope we can meet here. Thanks.
$250 NZD in 7 days
5.0 (138 reviews)
6.6
6.6
User Avatar
Hi My expert team is ready for the task. We understood the work. Can we discuss please. Thank you. ...............................
$250 NZD in 5 days
4.8 (103 reviews)
6.6
6.6
User Avatar
Hello, Read and understood project details and got your requirements very well. We have a lot of experience of Data Entry, Data Processing, Web Search, Web Scraping and Market Research. We have done plenty of similar jobs in the past successfully. We can do this job with full accuracy. We are ready to do sample entries for your satisfaction. Hope to be getting considered for this. Best Regards, Karan Aahuja First Choice Web
$50 NZD in 3 days
4.9 (112 reviews)
6.5
6.5
User Avatar
I am very professional data entry and web researcher on freelancer.com. Here I completed a lot of project with good reputation. Very motivated, honest and hard worker. This is my main profession. So I take this seriously. Now I am trying to prove in here. Please give me an opportunity to doing this. Really appreciating a project here. I can start right now.
$155 NZD in 10 days
4.9 (68 reviews)
6.1
6.1
User Avatar
Hello We believe in quality work that meet the clients Expectations and satisfied the clients. We would like to work on this project, as we have understand your project requirement very well, we can do it easily as your Expectations. Thanks Subhash
$155 NZD in 3 days
4.9 (52 reviews)
5.4
5.4
User Avatar
Hello sir I have gone through the description can do this task as mentioned in project description. kindly contact me Thank you.
$211 NZD in 3 days
4.9 (60 reviews)
5.5
5.5
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the project. Thank you so much.
$100 NZD in 3 days
4.8 (75 reviews)
5.6
5.6
User Avatar
We have expertise in providing wide array of data entry and data processing services which include error-free on-line & offline data entry, handwritten data entry, spreadsheet based data entry, forms data entry, pdf data entry, eCommerce data entry, web data collection, data mining etc. We have completed several national & international projects within deadline by maintaining stringent quality checking. Please check our portfolio.
$155 NZD in 3 days
4.7 (34 reviews)
5.7
5.7
User Avatar
Hello Sir, I read project description and understood core requirements of this project. Invoice details to be extracted from given scanned PDF files and to be transcribed in the excel spreadsheet with two types of calculation. Calculation to be performed by using excel formulas. I have vast experience of similar projects and I assure you, 100% accurate and satisfactory result will be delivered within given time frame. If you want to discuss further on this job, I will be available at your convenient time. I look forward to working with you on this project soon. Thanks, hemi
$158 NZD in 5 days
5.0 (39 reviews)
5.1
5.1

About the client

Flag of NEW ZEALAND
Auckland, New Zealand
5.0
1
Payment method verified
Member since Jan 27, 2016

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.