You run a photo studio, or you are a photographer with a small team, and you want to know at any moment: who is shooting today and where, whether a photographer or a room was booked twice by mistake, which session's photos are late against the date you promised the client, how much each client still owes, and how much each photographer brought in this month. The free photo studio bookings sheet answers all of that from one bookings log. (The page is in Arabic; the workbook is Arabic, right to left.)
The problem it solves
Photo bookings are harder than salon bookings because a session needs three things at once: a photographer, a room or location, and a package with a length. If the same photographer is booked on two overlapping sessions, or the same studio is booked for two sessions with different photographers, you only find out when both clients are standing in front of you. Then comes a second job after the shoot: picking the photos, editing and delivering, and promises get lost because nobody remembers which session is stuck with whom. In between sit deposits, balances and an album sold after the session that never reaches the client's account.
How the sheet works, step by step
- Settings: enter today's date, any date inside the month you want summarised, and the prices of prints and albums in the extras catalogue.
- Packages: for each package, its length in minutes, price, number of edited photos, included prints and delivery days.
- Photographers and Places: the photographers and their specialities, and the studios and outdoor locations.
- Bookings: one row per booking with a running number. Pick the package, photographer and place from the lists and the end time, package price, extras, total, balance and delivery due date appear.
- Updating the status: as work moves, change the status from "booked" to "shot", "selecting photos", "editing" and "delivered", and enter the real delivery date.
- Extras: log prints and albums sold by booking number so they join the client's total.
- Summary: the month's sessions and value, collected and outstanding amounts, alerts, work stages and revenue per photographer and package.
What each sheet holds
- Packages: the session length the end time is worked from, and the delivery days the due date is worked from.
- Bookings: the heart of the sheet, with two red columns for clashes: photographer clash and room clash. The delivery alert column says "late", "delivered late" or "update the status".
- Extras: each print, album or frame with its quantity and its catalogue price.
- Summary: three charts: value per photographer, current work stages and each package's share.
A walk-through on the sample numbers
The names and numbers below are sample data inside the sheet, not real people. The chosen month is October and today's date in Settings is 12 November.
- October sessions: 15 confirmed sessions, one cancelled booking and one client who did not show. Booking value is 57,250, of which 8,250 is extras (albums, prints, a frame and extra photos). The average session is about 3,817.
- A booking: the Salma and Mohamed engagement: the engagement package is 5,000, a 30-page album 1,800 and two 30x45 prints 500, so the total is 7,300 and it was paid in full.
- Collected and outstanding: October collected is 50,550, including a 2,000 deposit kept from a client who did not show. October clients still owe 8,700, and all clients across all months owe 19,400. For example, Yasmin Tarek's newborn session totals 4,700, she paid 1,000, so 3,700 is left.
- Clashes: Karim Saad is down on 17 October for a portrait session 10:00-11:00 and a family session 10:30-12:00, so both bookings show a red "clash". Studio 1 on 24 October holds an engagement session 12:00-15:00 and a product session 14:00-16:00 with different photographers, so the room clash shows.
- Delivery: 11 sessions are delivered; one (Dina Wael) was delivered on 14 October against a due date of 13 October, so it reads "delivered late". On 12 November 5 sessions are late, including Sara and Islam's engagement session whose due date was 3 November and is still in editing.
- Photographer revenue: Mai Adel 17,000 from 4 sessions, Ahmed Fathy 16,000 from 3, Nora Samir 13,800 from 3 and Karim Saad 10,450 from 5. Karim has the most sessions and the lowest revenue because his packages are shorter and cheaper.
- Packages: the three newborn sessions bring 14,200, the highest, then engagement at 12,300, while the four portrait sessions bring only 6,100.
How the numbers are worked out
- End time = start + package length.
- Booking total = package price + extras, and balance = total - paid (paid includes the deposit).
- Delivery due date = session date + the package's delivery days.
- Two bookings clash if their times overlap for the same photographer or in the same place. A cancelled or no-show booking is left out of clashes and of value.
Common mistakes
- Leaving the status "booked" after the shoot: the sheet says "update the status", and if you ignore it nobody tracks delivery.
- Repeating a booking number: the Extras sheet links by number, so sales would be added to both bookings.
- Typing a package name differently: pick from the list so "package not found" does not appear.
- Forgetting extras after delivery: an album that is not logged shows in neither the balance nor the revenue.
- Leaving an old date as today: type =TODAY() in Settings so late-delivery alerts follow the real date.
When to move to a system
The sheet is enough until your team grows and the photographer, editor and reception need to work at the same time, or you want clients to book from your page and see only free slots, or choose their photos from a private gallery instead of WhatsApp. Then Softwiro can build software around your way of working. If your business is general appointments rather than photo sessions, the general appointments sheet fits better, and a similar double-booking idea appears in the beauty salon bookings article.
Try it now
Open the sheet and try it online, or download the Excel file. Clear the examples, type your packages, photographers and the first five real bookings of this week, and check the clash columns before you confirm a slot to a client. It holds 1000 bookings, 40 packages, 40 photographers and 30 places. If you want a version made for your studio, request it here.





