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

$10-30 AUD

In Progress

Posted

over 8 years ago

$10-30 AUD

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 9 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:

@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

4.9

(23 reviews)

4.0

7 freelancers are bidding on average $83 AUD 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

4.9

(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

5.0

(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 I can get your company set up. Once I have set your company file, enetered all data, and double checked the data, I can then generate numerous reports that will assist you in analysing individual job costings, sales, budgets, BAS, etc. I can set up your company file, enter and review your data, provide you with initial reports and then show you how to do the same. I can give you a copy of the checklists I use when completing the work, so that you can complete the processes yourself.

$10 AUD in 1 day

0.0

(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 to an access database. This is how i used to do in my company You dont need to recruit me to finish this. Drop me a message, give me a bit time and i can complete it. If you are happy, we can finish the process. (as i need some good references im my profile, i provide this service) I have a 5,5 years of business analyst and princing experience in a global company. I have prepared several sales reports. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,

$35 AUD in 1 day