Excel or Access Sales Annual Tracker

$30-250 USD

Completed

Posted

over 10 years ago

$30-250 USD

Paid on delivery

I have 4 locations that I would like to track daily sales for in a spreadsheet. The purpose of the spreadsheet is to compare last years sales with this years sales. I would like a single page entry form that will essentially send the data to the proper space in Excel and then all calculations will be made from that point. Each location will also have its own sheet and each sheet will show a monthly recap along with a visual graph comparison. 'LY- Sales' and 'CY Sales' as well as 'LY- Number' of Tickets and 'CY-Number of Tickets' for each location are my data collection pieces. Negative numbers need to show in red. Percentage difference will also need to show negatives in red. In addition to the above I would like to include Daily sales goals (LY-Sales +10%) This spreadsheet will be shared and needs to be visually appealing. Data entry will take place by a non tech savy person so this process needs to be simple and easily accessible. I have uploaded a VERY VERY basic version of what I would like but this is the extent of what I can do myself. It should help you get the idea of what I am wanting.

Excel

Microsoft Access

Project ID: 5220008

About the project

4 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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:

@dannyvarley

Sorry I messed up my last bid! Maybe now we can get back on track. Put down 14 days to be safe but probably next week for completion.

$255 USD in 14 days

5.0

(1 review)

2.8

4 freelancers are bidding on average $168 USD for this job

@Virtualworker50

***message me to discuss the project in detail*** Respected Sir, It would be pleasure for me to render my services to you for automating the daily sales data (with graphs) into compareable form with previous year data as well as cover future targets. I have read your full project detail and know what exactly you required. I assure you the QUALITY AND TIMELY work. I really want to do this job for you in order to have long term working relationship with you here on freelancer. Please inbox me for further discussion of the project detail or anything else you want to ask. Best regards, Imran

$150 USD in 3 days

4.8

(12 reviews)

3.9

@smartxheikh

I am an ACCA having experience working on this sort of assignments. I can deliver this with quality plus any other positive information necessary of required. we will discuss in detail Dear Employer you can trust me for this job

$200 USD in 2 days

4.8

(10 reviews)

3.8

@ganes07

Dear Hiring Manager, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Word, MS Excel. My typing speed is more than 35 words per minute. I believe my skills would be ideal for your project. I can complete this job within the required time period.

$66 USD in 3 days