Find Jobs
Hire Freelancers

Sales and revenue reports on excel

$250-750 USD

Closed
Posted almost 5 years ago

$250-750 USD

Paid on delivery
i run a small agent office that runs from commissions. i need someone that is an expert at excel to take quarterly commission sheets from 2015 thru 2019 Q1 and create an aggragate excel that breaks down sales $, yardage quantity, article, delivery and customer. i need to be able to look at it by customer, by year, by quarter. we sell fabric and garments to US market
Project ID: 20361811

About the project

70 proposals
Remote project
Active 5 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
70 freelancers are bidding on average $402 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$400 USD in 5 days
4.9 (387 reviews)
8.1
8.1
User Avatar
Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work. I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for great business deal. "
$250 USD in 2 days
4.9 (389 reviews)
7.7
7.7
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
$250 USD in 3 days
4.9 (283 reviews)
7.5
7.5
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that consolidates data from several quarterly commission sheets. I plan to use a combination of formulas and VBA code to accomplish this. I will charge you $250* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. I am in the top 2% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$350 USD in 5 days
4.9 (255 reviews)
7.6
7.6
User Avatar
Hi, I can create for you a Sales Commission Module in Excel to calculate commissions to salespersons based on sales, personal parameters, by sales or collections (including by partitional payments). I will add a procedure to connect between salespersons to customers including transferring customers to other salespersons from any date. The sales and commission reports will show the outstanding commission for each salesperson and his sales which were not paid yet by the customers. The module will have tables with information as follows: Customer list (Customer name, salesperson name).Sales by invoices (invoice no, invoice date payment terms, amount)Salespersons list (name, commission rate, minimum sales, sale or cash)list of payments by customer (date, amount)List of payment to salespersons (salesperson name, date, amount). I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
$500 USD in 7 days
4.9 (107 reviews)
7.3
7.3
User Avatar
Dear client I would love to help you in this project. My experience in excel and automation will surely help me in this project. Waiting to hear from you. Roy
$250 USD in 3 days
4.9 (436 reviews)
7.2
7.2
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$380 USD in 3 days
5.0 (287 reviews)
7.2
7.2
User Avatar
Hi, I'm a Certified Public Accountant having more than experience of ten years in accounting, finance, audit and taxation. Please check my profile for more reviews and discuss in detail over chat right now as I did similar work on past. I'm expert in advanced excel.
$500 USD in 5 days
4.7 (126 reviews)
6.7
6.7
User Avatar
Hi I am good in your required project, I also have a huge amount of working experience of more than 7 years. To ensure please visit my profile and check customers satisfaction level. https://www.freelancer.com/u/toplinesolutions To begin, please send me a message. I will complete your project within your given deadline. THANK YOU.
$250 USD in 1 day
5.0 (45 reviews)
5.6
5.6
User Avatar
$ 250 ONLY !!!!! [BBA & MBA in Accounting, Excel Expert] Sir, Please contact me, I can send you DRAFT project file to ensure my expertise. If you are 100% satisfied first, then award me the project. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$250 USD in 1 day
5.0 (162 reviews)
5.8
5.8
User Avatar
Hello, I can merge these quarterly sheets and make sure that the file allows analyzing this data in PivotTables, with slicers to easily apply the most often used filters (for example years). Are the quarterly sheets well-structured and the same will appear in the future? If yes, I could write a macro to transfer the data to the aggregate sheet. I'm an Excel VBA developer with over 8 years of experience. I am proficient in creating automated and easy to manage Excel files. Best regards, Ryszard
$250 USD in 3 days
5.0 (62 reviews)
5.3
5.3
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .
$555 USD in 3 days
5.0 (7 reviews)
5.0
5.0
User Avatar
Hi, I am very good in accounting and finance having 6 years of working experience in a multinational organization. Apart from that we have a team of skilled CA, ACCA, MBA's People and all are well experienced. we done this type of work on regular basis. And very good hands with Excel, Quickbooks, Oracle, Excel, MYOB etc. Expert in making model of sales and revenue or forecast model. I will share some models with you. I understand the value of deadline and do not compromise on quality. I feel very fit for this project. For further you can visit my profile. Please contact with me. Thanks
$250 USD in 1 day
4.8 (33 reviews)
5.1
5.1
User Avatar
Hi there, Greetings! I am an experienced Excel - Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Office applications. Let's get on a chat if you are available. Thank you, Rayyan
$500 USD in 7 days
5.0 (17 reviews)
4.9
4.9
User Avatar
Hello, I am an accountant with advance excel skills. I can convert pdf files and format them to your liking. I write complex formulas, pivot tables and Vlookups as well as VBA Macros. Please contact me and we will get started.
$722 USD in 7 days
4.8 (14 reviews)
5.0
5.0
User Avatar
I am experience SPSS, Minitab, STATA, Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You may go through Finance Trading Statistical Analysis, Academic Research Paper and Water Bottle Market Survey file (https://www.freelancer.com/u/EngrShahidul.html), for my relevant skill please. Let me know your data and objective of study (requirement of analysis), so that I can think of job.
$250 USD in 3 days
4.9 (47 reviews)
5.0
5.0
User Avatar
I Will Do Data Entry,Data Analysis,Data Mining,Internet Research I specialize in : ? Offline and Online Data Entry ? Data Mining ? Data Analysis ? Copy Paste Task ? Data Capturing From Any Website ? Google Spreadsheet Entry ? Property Research ? Data Extraction ? Manual typing Work ? Product listing ? Image to Word or Excel ? PDF to Word or Word to PDF ? PDF to Excel or Excel to PDF ? Scanned Pages to Excel/Word ? Any Type of Data Entry Projects.
$250 USD in 7 days
5.0 (9 reviews)
4.2
4.2
User Avatar
Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$250 USD in 1 day
5.0 (25 reviews)
3.8
3.8
User Avatar
Hello, I AM AVAILABLE RIGHT NOW. If you like we can discuss this project. I am excel expert and can do filters, stats, graphs, macros, pivot tables etc... I am technology specialist with several years experience in the fields of Data Science, Web Development, SEO, Bulk Emails, Document Processing, Web Security and server management. I work on low cost and deliver on time. My first preference is QUALITY. And I can provide your desired results for this project. Let me know if we can talk... Thank you.
$250 USD in 3 days
5.0 (11 reviews)
3.4
3.4
User Avatar
Hi there! I've read your project request and I can see that you want a summary of three or four years' commissions, broken down by various factors, such as dollar value, customer, yardage, article, quantity, delivery, and so on. I'm sure that when you have this analysis it will help you to assess the past four years' business and to plan for the future. I'm experienced in using Microsoft Excel to store and process data, and I'm familiar with nearly all the built-in functions of this application. I believe I'll be able to help you get your task completed in a way that will make your future business practices more functional and profitable. Looking forward to hearing from you Karen
$300 USD in 5 days
4.9 (13 reviews)
3.6
3.6

About the client

Flag of UNITED STATES
Brooklyn, United States
0.0
0
Member since Jul 16, 2019

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.