Interactive Google Sheets Dashboard

Description:

I run a cleaning and property maintenance business in Sydney and I need a professional Google Sheets workbook that tracks:

1. Income
• Easy input for each payment
• Auto-sum totals
• Auto-categorised by month
• Ability to view past months

2. Expenses
• Supplies (Bunnings, Aldi, chemicals, tools)
• Fuel
• Equipment
• Other costs
• Auto-sum totals
• Auto-monthly breakdown

3. Wages
• Staff name
• Hours worked
• Rate
• Fuel allowance per day
• Toll allowance per day
• Total pay auto-calculated
• Monthly wages summary

4. Dashboard (must be EASY to read)
• Total income (all time)
• Total expenses
• Total wages
• Net profit
• Income this month
• Expenses this month
• Wages this month
• Net this month
• Month selector to view previous months

5. Monthly Summary Sheet
• Income by month
• Expenses by month
• Wages by month
• Net profit by month

6. Client Summary Sheet
• Which client pays the most
• Profit per client
• Total monthly income by client

⸻

Requirements
• Must work in Google Sheets
• Must be simple to update (just enter values, no complicated steps)
• All sheets must link together correctly
• Formulas must be stable and easy to maintain
• Clean, modern layout

⸻

What I will provide
• Sample income
• Sample expenses
• Sample wages
• List of clients
• My current workflow
• Any notes needed to design the system

⸻

Goal

I want a clean business system that:
• Tracks everything automatically
• Shows my profit clearly
• Lets me compare months
• Shows me which client is most profitable
• Helps me manage cashflow

⸻

Ideal Freelancer
• Strong Google Sheets / Excel experience
• Can build dashboards
• Can automate monthly summaries
• Has experience with business or finance tracking
• Good communication

⸻

If possible, please send examples of dashboards or Google Sheet systems you have built.