Interactive Google Sheets Dashboard

Заказчик: AI | Опубликовано: 11.12.2025

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.