Wedding Photography Business Google Sheets System

I'm looking for an expert to create a comprehensive Google Sheets system for my wedding photography business. The system should help me manage:

- Client/Package & Payments: Track clients, packages, and automate payments.
- Function-wise Crew Allocation: Allocate crew members based on functions.
- Freelancer Rates/Payments: Manage freelancer rates and payments.
- Expenses: Keep track of all business expenses.
- Profit/Loss Tracking: Monitor profit and loss.
- Dashboard: Provide an overview of all the above.

Requirements:
- Automated formulas
- Drop-down menus
- Filters
- Easy scalability

Ideal skills and experience:
- Proficiency in Google Sheets
- Experience in building automated spreadsheets
- Attention to detail
- Background in finance or project management is a plus

Please include:
- Past work in similar projects
- Current work and payment structures

Looking forward to your bids!

I run a wedding photography & cinematography business and I need a professional, easy-to-use Google Sheets management system.

I do NOT want a basic spreadsheet. I need a properly structured, formula-based system where I can enter information once and track my complete wedding business from one place.

The Google Sheet should have these main sections:

1. CLIENT / WEDDING MASTER SHEET

Track every wedding/client:

* Client / Couple Name
* Job ID
* Wedding Date
* Package Amount
* Amount Received
* Amount Remaining
* Payment Schedule
* Total Estimated Expenses
* Total Actual Expenses
* Expected Profit
* Actual Profit
* Profit Margin
* Booking / Payment Status
* Notes

All totals and balances should calculate automatically.

2. FUNCTION / EVENT PLANNER

For every wedding, I need to track each individual function separately.

Columns should include:

* Job ID
* Couple Name
* Function Name (Haldi, Mehendi, Sangeet, Wedding, Reception, Engagement, Ring Ceremony, etc.)
* Date
* Morning / Afternoon / Day / Evening / Night
* Start Time
* End Time
* Bride Side / Groom Side / Both
* Location
* Required Photo Cameras
* Required Video Cameras
* Candid
* Cinematic
* Drone
* Content Creator
* Same Day Edit
* Total Crew Required
* Status
* Notes

I should be able to see exactly how many people are required for every function and when they are required.

3. CREW / FREELANCER ALLOCATION + PAYMENT

This is very important.

I need to know exactly which person is working on which function.

For every crew member:

* Crew Member Name
* Role (Photographer, Videographer, Candid, Cinematic, Drone Operator, Editor, Content Creator, etc.)
* Job / Couple
* Function
* Date
* Side
* Shift / Time Slot
* Start Time
* End Time
* Agreed Payment
* Amount Paid
* Remaining Amount
* Payment Status
* Notes

I should be able to answer questions like:

* Where is a particular photographer working?
* Which person is assigned to Haldi?
* Who is working at the wedding?
* How many people are booked for a particular function?
* How much have I agreed to pay each freelancer?
* How much have I already paid them?
* How much is still pending?
* How much is one particular person costing me across all weddings/functions?

4. EXPENSE + PROFIT TRACKER

Every expense should be linked to a particular wedding and, wherever possible, a particular function.

Examples:

* Freelancer payment
* Drone
* Travel
* Hotel
* Equipment rental
* Album
* Frame
* Editing
* Cinematic
* Candid
* Same Day Edit
* Printing
* Food
* Miscellaneous

Columns:

* Job ID
* Couple
* Function
* Date
* Expense Category
* Vendor / Person
* Estimated Cost
* Actual Cost
* Amount Paid
* Amount Pending
* Payment Status
* Notes

The sheet should automatically calculate:
Package Revenue – Total Actual Expenses = Actual Profit

And also show estimated profit before the wedding is completed.

5. PAYMENT TRACKER

I also need a separate payment tracking section for clients.

It should show:

* Couple
* Package Amount
* Payment %
* Payment Due
* Due Date
* Amount Received
* Remaining
* Payment Status
* Notes

For example, if a package is ₹1,15,000 and I receive 40%, the sheet should automatically calculate the remaining 50% and 10%.

6. CREW RATE / FREELANCER MASTER

I want a master list of all freelancers.

For each person:

* Name
* Role
* Normal Rate
* Negotiated Rate
* Contact Details
* Notes

When I assign that person to a function, I should be able to select their name from a dropdown and enter/auto-populate their agreed rate.

7. DASHBOARD

I need a professional dashboard showing:

* Total Active Weddings
* Total Booked Revenue
* Total Amount Received
* Total Amount Receivable
* Total Freelancer Cost
* Total Other Expenses
* Total Business Expense
* Expected Profit
* Actual Profit
* Pending Crew Payments
* Upcoming Functions
* Upcoming Payments

I should be able to filter the dashboard by:

* Wedding / Couple
* Month
* Function
* Status

IMPORTANT REQUIREMENTS

The system should be:

* Google Sheets compatible
* Easy for a non-technical person to use
* Formula-based and automated
* Have dropdown menus wherever possible
* Have filters
* Have conditional formatting for Pending / Paid / Completed / Due items
* Avoid unnecessary complexity
* Have clean professional formatting
* Be scalable so I can add 50–100+ weddings and many freelancers/functions without breaking formulas
* No complicated manual calculations
* I should be able to duplicate/add a new wedding easily

Please build the system in a way that I only enter the actual data, while calculations such as balance, crew cost, expenses, profit and payment status happen automatically.

I would also like the final Google Sheet to have clear instructions explaining where I should enter new clients, functions, crew members, payments and expenses.