Photography Business Google Sheet Manager

Freelancer Required – Google Sheets Management for Wedding Photography Business

I am looking for a freelancer who can manage and regularly update an existing Google Sheets system for my wedding photography business.

The Google Sheet is already created and has connected/automated sections. I need someone who can understand the existing system, work with the formulas/automation already in place, and keep the complete business data updated accurately on a monthly/ongoing basis.

What the Sheet Needs to Track

1. Bookings & Client Details

* Client name and booking details
* Wedding/package details
* Total booking/package amount
* Advance/payment received
* Pending/balance amount
* Payment status
* Upcoming bookings and functions

2. Function & Event Planning
For every wedding/function, we need to maintain:

* Function date
* Function type
* Start/end timing
* Location/venue
* Bride/Groom side or function details
* Which team members are assigned
* Complete event schedule/calendar

3. Team / Freelancer Allocation

* Which photographer/videographer/editor/team member is assigned to which function
* Date and timing of their assignment
* Role/designation
* Agreed payment for each team member
* Amount already paid
* Pending payment
* Total crew cost for each wedding/function

The main purpose is that I should be able to easily see who is working where, on which date, for which function, and how much that person is being paid.

4. Payments & Receivables

* Total booking value
* Amount received
* Payment dates
* Pending amount
* Upcoming payments
* Total money received from all bookings
* Amount still receivable from clients

5. Business Expenses
All business-related expenses need to be recorded and categorized, including:

* Team/freelancer payments
* Travel/transport
* Equipment-related expenses
* Venue/event-related expenses
* Albums/printing
* Extra deliverables
* Editing/post-production
* Other miscellaneous business expenses

We should be able to see where the money is being spent and how much is being spent in each category.

6. Deliverables / Pending Work
Track additional and pending deliverables such as:

* Albums
* Frames
* Cinematic films
* Wedding films
* SDE
* Drone
* Final videos
* Other extra deliverables

The sheet should help track what has been completed, what is pending, and any related cost/payment.

Final Business Overview / Profit Tracking

At the end, I need the sheet/dashboard to clearly show:

* Total bookings
* Total booking value
* Total amount received
* Total amount pending
* Total business expenses
* Total team/freelancer cost
* Other expenses
* Revenue
* Actual profit
* Upcoming bookings
* Upcoming client payments
* Upcoming team payments
* Pending deliverables

Basically, I should be able to open the Google Sheet at any time and understand:

How much business I have → how much money has come in → how much is still pending → where the money has gone → how much the team has cost → what work is pending → and ultimately how much profit I am actually making.

Freelancer’s Responsibility

The freelancer will be responsible for regularly updating and maintaining the existing Google Sheet accurately based on the information provided by me/my team.

This is an ongoing/monthly requirement, not a one-time data-entry job.

The person should be:

* Very comfortable with Google Sheets
* Good with formulas, filters, dropdowns and linked/automated sheets
* Able to understand an existing spreadsheet system
* Good at organizing business data
* Very accurate with numbers and payments
* Comfortable tracking multiple weddings/functions simultaneously
* Able to identify missing/inconsistent data
* Able to maintain the sheet without disturbing existing formulas/automation
* Reliable with regular updates

Experience with photography, wedding, event or service-based businesses will be a plus, but is not mandatory.

Work Nature

This is an ongoing monthly freelance role. The workload will depend on the number of bookings and transactions, but the main requirement is to keep the complete Google Sheet updated and organized so that the business finances, bookings, team allocation and pending work are always up to date.

Please share:

1. Your experience with Google Sheets/business management
2. Examples of similar Google Sheets work, if available
3. Your monthly charges
4. How often you can update the sheet
5. Your availability for ongoing work