Find Jobs
Hire Freelancers

Excel Spreadsheet Creation & Reporting - Sales

£250-750 GBP

Cancelled
Posted about 6 years ago

£250-750 GBP

Paid on delivery
We're looking for an Excel Spreadsheet/Data base to be created from scratch, so we can input sales data from multiple reports. This must include and enable the following; - Easily add multiple products (including product details & pricing) from multiple vendors and be able to filter by spec & product type. - Input data (weekly sales, delivery costs, marketing & sales support, Rebates, RMAs etc) from multiple sales reports & documents. I expect this will have to be done manually at our end, we just need the tool creating to do so. - Easily compile reports and demonstrate this through stylish graphs; Revenues, Profits, Costs, RMAs. - Enable performance comparison; Year on Year, Week on Week, Vendor vs Vendor, Product vs Product, Average Sale Prices, Profit per System etc. - Ability to export the graphs for use in QBRs. We work with around 8 different partners and this could increase over time. We could either have one spreadsheet per vendor which links into a master file? Or we could have one file which looks after everything. We would need the ability to add more partners in the future as this grows. I have uploaded a template of one which was created in-house which could give an insight of what we're after, but looking for a much more professional one creating which is easier to use.
Project ID: 16350582

About the project

31 proposals
Remote project
Active 6 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
31 freelancers are bidding on average £452 GBP for this job
User Avatar
Hi, my name is Sevinc. I read your "Excel Spreadsheet Creation & Reporting - Sales" project descriptions carefully before bidding. I checked the attached excel template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
£455 GBP in 10 days
4.9 (333 reviews)
8.0
8.0
User Avatar
Hi there,I am Miljan,IT expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Specializations and skills: Web Scraping(Python,PHP,node.js) Excel (VBA,Macros) Access,Word,Powerpoint Data Entry Data Processing Web Search Market Research Research Leads generating PDF to Excel WordPress Magento Shopify Data Base Programming HTML,CSS,PHP,JavaScript,jQuery,MySql Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job. Feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
£250 GBP in 5 days
4.9 (160 reviews)
7.5
7.5
User Avatar
I am fast and Extremely Detailed Oriented and good with Excel and EXCEL MACRO/VBA. Completed more than 150+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in Sales, Marketing and Advertising. Currently I am working for a Multinational Telecommunication Company as an B2B Marketing Manager.
£300 GBP in 3 days
4.9 (268 reviews)
7.0
7.0
User Avatar
Dear client I have previously carried out a number of projects in excel using macros and formulas. I can certainly help you in this project. Kindly contact me so that we have a discussion. Roy
£500 GBP in 10 days
4.9 (398 reviews)
7.0
7.0
User Avatar
Hello, I can develop User friendly data input and retrieval forms so the user will never have to work directly with the Excel sheet itself. I have done several such projects in the past and I can handle it with ease and proficiency. Please discuss details so we may proceed. I am comfortable to receive full payment after you have thoroughly tested the solution. Please discuss via chat. Thank you, Usman
£500 GBP in 7 days
5.0 (89 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
£555 GBP in 6 days
5.0 (124 reviews)
6.4
6.4
User Avatar
Dear Employer, I'm ready to work on "reporting excel spreadsheet creation" project. Relevant Skills Excel, VBA Milestones 397 GBP - code writing 99 GBP - userfriendly interface I can complete your project on time and within your budget.
£497 GBP in 13 days
5.0 (120 reviews)
6.5
6.5
User Avatar
mphill in computer science and expert in Excel tasks
£500 GBP in 1 day
4.7 (84 reviews)
6.3
6.3
User Avatar
Went through the Excel spheet - Customer Review, Range review sales out and Shipping data. Based on the data entered, the Quarter consolidation QoQ and YoY consolidation for particular product type and for a partner can be summariesed into Customer overivew, using click of button. - Thereby the margins, Salesout Allowance, MDF, Profit can be calculated. - Separate buttons to generate the reports YoY, WoW, Vendor Vs Vendor can be generated. - Regarding how to segerate the partners can decide, but from the first look vendor vs vendor comparison can be easier if all in one worksheet. - Have done similar sales, inventory, tax calculations, product wise comparison in Freelancer projects. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
£300 GBP in 5 days
4.7 (53 reviews)
6.0
6.0
User Avatar
Hi, I read through your requirement You have requirement to do data entry on your sales data as well purchase data (you have mentioned about vendors). Also this will be required to calculate the profits. Then you require reports (dashboards) to get a view of the performance on various dimensions. I would suggest that you should consider a web based system or system like MS-Access for capturing the data entry to ensure the data is maintained and is clean. For the reports we can use excel which can support your requirements. I have about 15+ years of experience in Infosys and have designed complex systems. I have worked on various MS technologies and web based systems. Regards Vaidy
£833 GBP in 45 days
5.0 (15 reviews)
5.2
5.2
User Avatar
Hello Sir, By precession I am from finance background for last 5 years. I’ve advanced level MS Excel skills including but not limited to advance formulas, user interactive templates, dynamic charting, highly effective dashboards, Visual Basic programming and pivot tables etc. I understand your requirement as you are looking for an integrated system to track your sales, vendors and analyse performance. Sir I am willing to start work with your help and regular basis discussions to get it done. You can review my profile and reviews from my previous employers. Kindly text me if you are interested in my proposal. Regards Awais Jehangir
£500 GBP in 10 days
4.6 (37 reviews)
5.3
5.3
User Avatar
Greeting, I have understood your Excel Spreadsheet Creation & Reporting - Sales task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic
£400 GBP in 5 days
4.8 (14 reviews)
5.2
5.2
User Avatar
I have gone through your requirement and i have 2 solutions to offer with minimal manual intervention. 1) I can create single excel dashboard with single consolidated performance & 8 different link for vendor wise performance 2) I can also create single master DB in access then link to your excel dashboard or make it a "Switchboard" In both solutions all reports will be automated, only manual intervention needed to append the raw data on agreed frequency Looking forward to hear from you
£666 GBP in 10 days
3.6 (2 reviews)
1.4
1.4
User Avatar
hello. I have worked on excel databases for more than 10 years. I am smart and reliable. I am new to this site and need to gain reviews so I will work for minimum cost. You will stay satisfied. I need to know all the details to tell the exact time. Hope to cooperate with you
£444 GBP in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
A proposal has not yet been provided
£250 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Yes beloved. I am a computer trainer, Data analyst, Data entrant, Database manager, with proven experience in these fields with a supplement of all the office packages. entrust me, with this work. I shall accomplish the work within the exact period you want it, in the very format you want with the highest degree of accuracy. Looking forward to accomplishing this just in time. am so glad to meet you
£555 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in creating Excel sheets
£277 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£555 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I believe I can help you with your project in Excel. You can check my portfolio to see my past work.
£722 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am working as mis executive in a company so i can do this please send the information of the data
£555 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since Feb 22, 2018

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.