Create a "Weekly Sales & Monthly Profit" reporting spreadsheet or database for a small business.

In Progress Posted Aug 19, 2015 Paid on delivery
In Progress Paid on delivery

I want a reasonably simple spreadsheet or database set up for me. I realize that for now, an excel spreadsheet will be simpler, but I think as it grows and more data is entered into it, it will be easier to make historical comparisons and see trends (week vs week, quarter vs. quarter etc) better with a database, allowing me to make my own queries. I like the way Excel provides charts and graphs to view compariosns too - so I am definitely open to any ideas for the best solution. I know how I want it laid out and I know what data I want it to report - please see attached document, so it should be a reasonably quick job. If it looks nice too, great! Windows desktop software is also an option. I would also like to be able to easily share the data, or allow other people to see it and open it or change it, but I would need it to be password protected and I would need to set the user privilege levels. What is the best way to share this? Have a software that anyone can open? Facebook? MS Excel? How to update it and save old weeks? I do not want to overwrite each week. By the end of the year, I need 52 separate files. Please let me know your thoughts, and if I can have this by then end of the week. Thank you.

Database Programming Excel Microsoft Access Software Architecture

Project ID: #8302699

About the project

7 proposals Remote project Active Aug 19, 2015

Awarded to:

renesontiongson

Hi! excel automation is my masterpiece in my accounting field. Pleasure if you choose me to work with you. Thank you.

$30 AUD in 1 day
(23 Reviews)
4.0

7 freelancers are bidding on average $83 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 AUD in 2 days
(290 Reviews)
7.4
P0L

Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$75 AUD in 2 days
(49 Reviews)
5.5
aprildickson

Hi, I was very impressed with your Microsoft Word calcuations, however to improve on this I would suggest utilising the MYOB Account Right Software. There are hundreds of reports that can be created in this program and More

$10 AUD in 1 day
(0 Reviews)
0.0
someka

The best way will be: - Keep the raw data in excel - Create pivot tables to analyze the data - Share the pivot tables with your colleagues (which connects with your database) - In the future you can take your data More

$35 AUD in 1 day
(0 Reviews)
0.0