Closed

Google sheet update for financial sales and expenses

GOOGLE SHEETS EXPERT NEEDED

- this is the sheet that you will be working on[login to view URL]

- this is the sheet format i prefer to have, similar design.. where the main page shows all the figures entered from the other pages

[login to view URL]

1. Input of daily sales, dynamic and static income needs a better way of inputting and displaying back to me in google sheets.

2. Use forecasting / projections on google sheets to forecast future sales.

- You can use my historical data of our sales from past 36 months..

- forecast via your model with our weekly sales from past 36 months

- Put the data onto a new google sheet in a easy to read format showing predicted sales vs actual

Using the methods below for forecasting:

How to forecast

- [login to view URL]

- [login to view URL]

3.

These are the 7 sheets from the spreadsheet above

1. Sales

2. Sales charts

3. Sales target

4. Sales projections

5. Monthly profit

6. Expense input

7. Drop down

Let me explain what each sheets does

1. Sales: this is where I enter daily sales each day we process orders which is usually Sunday to Thursday each week, I enter the daily sales in column L. Column M, O, S, U, R are this shipping costs. You can see the formulas when you click the cells to further clarify.

2. Sales charts: This is all the information entered into ‘Sales’ sheet which shows on graphs with some drop boxes from column Z > BM. There is drop boxes to shows differences between each period selected ie 2019 vs 2020

1. Sales target: sales needed today, this week or this month to be the same as last period last year. Theres a drop box here to get specific days

3. Sales projections: shows sales till todays date, same period last year and then the % difference between both periods. The projection chart using the same growth rate to predict into the future. Its meant to show the projection which it does but the actual and % doesnt seem to work correctly anymore.

4. Montly profit: Shows expenses entered in sheet called ‘Expense input’ minus off the sales calculation in sheet called ‘sales’ from column AG(sales profit). It has a option to manually adjust or use the info from the sheet entered exactly. Its give some small stats like total expenses each month, profit, avg $ order (calculates incorrectly)

5. Expenses input: These are the other expenses we pay from our bank account each month, week or year. Theres a drop down box to adjust for mth, week or yearly. As mentioned in point 4, this is the totals showing in Monthly profit sheet.

6. Drop down: I dont know how this works, I think its a lookup sheet that a previous freelancer did

Improvements to be made

Overall way data is entered. I have preset data on ‘sales’ sheets and other data on ‘expense input’ sheet

There should one one sheet for input of expenses, another sheet for sales (could be a dashboard type), projection sheets, and sales chart sheet (could be another dashboard showing all charts we currently use, average order, average items per order. The charts page is ok but its messy because all the data is showing on the left side.

Expenses sheet, I need to get the google financial working

On the sales sheet I need to get 2 extra columns included

On chart sheet, the charts need to display easier, better with more details from the sales charts page

Projections needs to project forecasts

- Before we begin its important to note my financial year is 1st July to 30th June each year for correct calculations

Skills: Data Analysis, Data Entry, Data Science, Excel, Google Sheets

See more: google maps update, coldfusion google calendar update, wordpress plugin google map update issues, google sheets link, google sheets contact list template, google sheets sales template, sign in sheet google doc, financial statement template google sheets, google sheets ledger template, google sheets accounting template, how to create google sheet, google promote update, joomla google maps update, demo financial line chart google api, financial statement analysis google vsyahoo, google directory update, plotting sales territory google maps, point sales based google apps, sales management google apps, sales page google

About the Employer:
( 7 reviews ) Bangkok, Thailand

Project ID: #25510701

34 freelancers are bidding on average $158 for this job

schoudhary1553

Hello, I can help you with Google sheet update for financial sales and expenses 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 comp More

$120 AUD in 3 days
(356 Reviews)
8.0
elqueabandona

Hi, how are you?, my name is Cristian and i am Excel/VBA expert. You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elqueabandona Contact me More

$200 AUD in 4 days
(262 Reviews)
7.0
humayoonsheikh4u

Google spreadsheet & Sales professional, Sir, I have gone through the project requirement and Willing to do it as per your requirement. I am an Excel as well as Google spreadsheet professional with Sales and Marketing More

$250 AUD in 5 days
(12 Reviews)
4.1
Chaitanya1769

Graduated from one of the top Engineering universities in India with an acceptance rate of less than 1%. Worked in the Finance domain as a Market Analyst and derivatives trader for 3 years. Highly proficient in Excel, More

$140 AUD in 7 days
(1 Review)
3.3
emilianoreyes70

Hello! I am a entrepenour and Excel/VBA/Macro ans Google Scrpit , Google Sheets expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dyn More

$220 AUD in 7 days
(7 Reviews)
3.5
valeed92

Dear Sir I am ACCA Member and expert in MS Excel, Accounting and Finance tasks. I have 5 years of experience of 5 years of Big 4 audit firm. I can do your task of accounting perfectly. Lets discuss further in Chat bo More

$60 AUD in 2 days
(2 Reviews)
1.4
Mohsiniqbalk

Greetings. I'm C.a finalist having 2 years of experience in forecasting and Accounting and also have online software experience like ERP, Quick-Books etc and expert in Microsoft office. I'll provide you finished produc More

$230 AUD in 4 days
(1 Review)
1.0
ysartika

Accountant with over 7 years experience in managing complex business accounts. I possess excellent calculative skills & have an eye for detail. Analytical and strong MS Office skill especially Excel. Analytical and str More

$140 AUD in 7 days
(0 Reviews)
0.0
nancypiggycai

——- update ——- Dear Sir, Your project is interesting and gives me a chance to try out. I do have 3 years of using SQL and BI tools to build reports and dashboards for customers, check out my portfolio to review some More

$250 AUD in 5 days
(0 Reviews)
0.0
SYoosoof207

Hi There, I'm an Investment Analyst with 4+ years experience in financial analysis and financial modelling. I can build a financial model on Google sheets with data inputs according to your requirements, mana More

$222 AUD in 2 days
(0 Reviews)
0.0
MunibACCA

I'm qualified Chartered Certified Accountant, heaving 5 years relevant experience. I'm member of international federation of accountants. Mutual Standing will be highly appreciated. Feel free to contact.

$128 AUD in 7 days
(0 Reviews)
0.0
Mahdi39

I have more than 3 years of experience with MS excel. I am good at data mining, copy - pasting, data analysis, data entry and [login to view URL] you sir.

$100 AUD in 3 days
(0 Reviews)
0.0
freelanceIC

Dear Sir/Madam, I am a data scientist specialized in epidemiology and public health. Author and coauthor of several scientific papers published in international scientific peer reviewed journals. With experience worki More

$200 AUD in 7 days
(0 Reviews)
0.0
gautamsaxena86

I will do this work on time with 100% accuracy . you can rely on me. further I will provide you discount in your your future projects. thanks

$278 AUD in 3 days
(0 Reviews)
0.0
shafi1210

Dear Employer, Hope you are doing well. I have gone through the project details and the files links and understand them well. To consider my bidding, I would like to draw your kind attention to the following facts More

$200 AUD in 7 days
(0 Reviews)
0.0
mdanisurrahman22

I am a hard worker and experienced in banking sector with excel [login to view URL] software is operating by me. You can hire me for your business. Relevant Skills and Experience i have 20 years of banking experience.

$156 AUD in 3 days
(0 Reviews)
0.0
sseharawat

Dear Sir, I have good knowledge of MS office. i have total more then 12+ years experience to handle this.

$140 AUD in 7 days
(0 Reviews)
0.0
ashwin237

I have worked for sales process and have done analysis on Sales dynamic Relevant Skills and Experience Data Analytical Skills Skill mapping

$156 AUD in 3 days
(0 Reviews)
0.0
hencilnsilva

Dear sir / maam, I have work for underwriting company for years .. where I had to work on MS office. If you would give me the opportunity I would work my best. Thank you Relevant Skills and Experience I'm also rel More

$156 AUD in 3 days
(0 Reviews)
0.0
ansam007

Accurate, reliable and timely service with up-to-date use of technology with 5 years of proven experience.

$156 AUD in 3 days
(0 Reviews)
0.0