
Closed
Posted
Paid on delivery
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
Project ID: 40753874
9 proposals
Remote project
Active 1 min ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average ₹1,114 INR for this job

Who currently keeps this Sheet alive, and did its formulas/automation come from Apps Script or just in-cell formulas? That changes how safely I can extend it. Your Sheet already has the hard part done: connected sections and automation. What you want next is reliable upkeep plus a clear "who is working where, on which date, and what are we paying them" view across bookings, functions, team allocation and receivables. I'd work inside the existing structure rather than rebuild it: map the current formulas first so nothing breaks, then tidy the crew allocation and payments logic so assigned team members, agreed vs paid vs pending, and total crew cost per function all roll up automatically. Where manual entry is slowing you down, I can add light Apps Script to cut the repetitive steps and flag pending balances. I keep data accurate and the layout readable, so a glance answers your questions. Is the current automation built with Apps Script, or only in-cell formulas? That decides how safely I can extend it.
₹1,226 INR in 1 day
2.9
2.9

Hi, I can keep your wedding photography sheet up to date so the totals always show bookings, money received, pending, team cost, expenses and real profit. How I would work: - First I go through your sheet and formulas and check every total (booking value minus received = pending, crew agreed vs paid, profit after all costs). Anything broken I list for you before changing it. - Then you or your team send new bookings, payments, crew assignments and expenses here in the project chat. I enter them, re-check the totals and tell you what changed. To show how I work, I built a sample with made-up data: my portfolio item "Wedding Photography Business Sheet". Bookings, functions, crew pay, client payments and expenses feed one summary with profit after all costs, upcoming functions and team pay due. Happy to start with one fixed milestone for the first check and month of updates. About how many bookings and functions do you handle per month? VARS Digital
₹1,100 INR in 7 days
0.0
0.0

As a Senior Operations & Spreadsheet Specialist with +20 years of experience in business tracking and studio operations, I will keep your wedding photography sheets accurate, reconciled, and intact without disturbing existing formulas. Direct answers to your 5 points: • 1. Experience & Formula Integrity: Advanced mastery of Google Sheets architecture (QUERY, ARRAYFORMULA, dynamic dropdowns, cross-sheet references). I ensure total numerical consistency across bookings, crew costs, expenses, and your net profit dashboard while actively auditing for missing data or payment lags. • 2. Relevant Work: Extensive experience managing relational trackers for creative production studios, multi-crew event logistics, and milestone deliverable pipelines. • 3. Monthly Rate: [$150 – $250 USD / month] (calibrated to your average monthly booking volume). • 4. Update Frequency: Turnaround within 24 hours of receiving data (2–3 times weekly, or daily during peak wedding season) plus monthly closing reconciliation. • 5. Availability: Immediate, reliable capacity for ongoing monthly collaboration.
₹1,300 INR in 7 days
0.0
0.0

Hi, I can keep your wedding photography Google Sheet updated every month so bookings, payments and crew costs are always current. Each month I will: 1) Enter new bookings, payments received and the event schedule 2) Update crew assignments and payouts per event 3) Update receivables, categorise expenses, and refresh the pending-deliverables list 4) Check that your existing formulas and automations still calculate correctly after the update, and tell you if anything looks off 5) Send you a short monthly note: what was added, which totals changed, and anything that needs your decision (for example unpaid balances) I'll work inside your existing sheet and structure rather than rebuilding it. Let me know how you'll share the monthly inputs (notes, receipts or a form) and roughly how many events you have per month. Hemanth
₹1,200 INR in 7 days
0.0
0.0

Hi, I can keep your wedding photography Google Sheet accurate without touching the formulas already in it. I will open the sheet and map the six areas you listed: bookings and client details, function planning, team allocation, payments and receivables, categorized expenses, and pending deliverables such as albums, frames, films, SDE, and drone work. First step: I will send you a short checklist of the tabs and columns already there, plus any missing fields, so you can confirm before I enter the first month of data. I can update it monthly from notes you or your team send in chat, and flag bookings with no payment, no team assignment, or no deliverable status. I am comfortable with Google Sheets, filters, dropdowns, and linked ranges, and I will not rebuild automation you already rely on. I can start weekly if monthly is too slow. Happy to keep updates in writing here. Best regards, Hung
₹1,400 INR in 7 days
0.0
0.0

Hi, I’m Wulan, a Virtual Assistant and Project Coordinator with experience in event coordination, business administration, data management, and Google Sheets. I also have a personal interest in photography and have been involved in managing a family-owned wedding business. So I understand that wedding photography involves more than just bookings there are client details, event schedules, photographers/videographers, freelancer payments, expenses, deliverables, and many details that need to be tracked carefully. Through my event and project coordination experience, I’m used to managing schedules, client information, team coordination, follow-ups, and multiple tasks at the same time. I’ve also managed my own businesses, including tracking sales, expenses, production, and customer information. I can help keep your existing Google Sheet accurate and organized, while being careful not to disturb existing formulas or automation. I can also check for missing or inconsistent data and make sure bookings, payments, team assignments, expenses, and pending deliverables are kept up to date. I’m available for ongoing monthly support and would be happy to first review your existing Sheet and understand how your current system works. Best, Wulan
₹1,400 INR in 5 days
0.0
0.0

Hi! Keeping a wedding photography business's Sheets system running smoothly sounds like a really rewarding ongoing role, and I'd be careful to protect your existing formulas and automation. What you'll get: • Bookings, functions, team allocation, payments, expenses and deliverables kept accurately updated • Missing or inconsistent data flagged rather than guessed • A short change log of every edit • A one-page overview of money in, money out and pending work • Scope: up to 20 bookings per monthly update, one revision round Free sample: I'll update about 20 rows first so you can see the quality. Are there any automated sections or payment-status values I should leave exactly as they are?
₹600 INR in 3 days
0.0
0.0

Hi, you need someone to keep your wedding-business Google Sheet up to date (bookings, payments, function schedule, team allocation) without breaking the formulas already in place. I can learn the existing sheet, enter each update accurately, and flag any pending balance or double-booked team member. 1) You share the sheet (view/comment first) and how updates reach me. 2) I map the formulas and test one month of entries. 3) I send a short monthly check tab: payments received vs pending, upcoming functions. See my Inventory / Purchasing Reconciliation sample in my portfolio, which has a before/after view. I'll fix the price after seeing a file sample. Which file is the source of truth, and how messy is it?
₹1,200 INR in 7 days
0.0
0.0

Ambala Cantt, India
Member since Apr 4, 2022
₹600-1500 INR
$100-250 USD
$70-120 USD
$15-25 USD / hour
$60-90 USD / hour
$2-8 AUD / hour
₹600-1500 INR
₹7500-10000 INR
$250-750 USD
₹12500-37500 INR
₹1500-12500 INR
$25-35 USD
$30-250 USD
$8-22 USD / hour
₹1500-12500 INR
$30-250 USD
$250-750 USD
$5000-10000 USD
₹15000-20000 INR
₹1500-12500 INR
$15-25 USD / hour