
We need an Excel sheet which allows us to input our sales and expense stats
- or -
Post a project like this2414
£50(approx. $67)
- Posted:
- Proposals: 8
- Remote
- #2211390
- Awarded
Professional Graphic designer, photo editor, clipping path, images background removes, Photo cleanup/ touch up, Image Manipulation

Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦

13718272275251194678714064162373639242318523776802344742




Description
Experience Level: Intermediate
We would like to record our daily and weekly stats in the form of an Excel sheet, which we can manually update.
We should be able to input our sales figures on a daily basis. We should be able to add this on a per client basis, but also see the total sales figure of all clients as one (both daily and 7-day weekly). We should be able to add new clients as and when they come.
We would like this on a 7-day weekly format for the year, so as follows:
Week 1: Mon Tue Wed Thu Fri Sat Sun
Week 2: Mon Tue Wed Thu Fri Sat Sun
Week 3: Mon Tue Wed Thu Fri Sat Sun
Week 4: Mon Tue Wed Thu Fri Sat Sun
And so on until..
Week 52: Mon Tue Wed Thu Fri Sat Sun
We would like the same Excel sheet(s) to incorporate our direct expenses, such as: Fuel and Labour, and a third category as Miscellaneous. We should be able to input these in the same way as for Sales - on a daily/weekly basis.
The final section of this stats Excel sheet should give us the opportunity to see the information in UK Fiscal Quarters in the form of profit/loss.
We would like any proposal to include unlimited revisions until we are satisfied with the final template.
We should be able to input our sales figures on a daily basis. We should be able to add this on a per client basis, but also see the total sales figure of all clients as one (both daily and 7-day weekly). We should be able to add new clients as and when they come.
We would like this on a 7-day weekly format for the year, so as follows:
Week 1: Mon Tue Wed Thu Fri Sat Sun
Week 2: Mon Tue Wed Thu Fri Sat Sun
Week 3: Mon Tue Wed Thu Fri Sat Sun
Week 4: Mon Tue Wed Thu Fri Sat Sun
And so on until..
Week 52: Mon Tue Wed Thu Fri Sat Sun
We would like the same Excel sheet(s) to incorporate our direct expenses, such as: Fuel and Labour, and a third category as Miscellaneous. We should be able to input these in the same way as for Sales - on a daily/weekly basis.
The final section of this stats Excel sheet should give us the opportunity to see the information in UK Fiscal Quarters in the form of profit/loss.
We would like any proposal to include unlimited revisions until we are satisfied with the final template.

Bookmyobc Ltd
99% (271)Projects Completed
301
Freelancers worked with
166
Projects awarded
59%
Last project
15 Dec 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Do you require entire data analysis in a single excel worksheet or 2/3 different worksheet in a single workbook?
736200
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies