# Photo studio bookings Excel (free) + online

> Free Excel sheet for a photo studio: session packages, photographer and room clash alerts, delivery tracking with due dates, extras sold, balances and revenue.

Source: https://softwiro.com/blog/photo-studio-bookings-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Photo studio bookings in Excel (free): packages, clashes, delivery tracking and balances

One workbook for session packages, photographers and rooms, double-booking alerts, delivery due dates, prints and albums sold, and revenue per photographer.

13 November 2026 6 min read

## In short

- Pick the package, photographer and place; the end time, price, extras, balance and delivery due date appear by themselves.
- A photographer or a room booked on overlapping times shows a red clash flag on both bookings.
- Each session moves from shot to selection, editing and delivered, with a late flag once the due date passes.
- Prints and albums sold join the client's total, and the summary shows revenue per photographer and package with charts.

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](https://softwiro.com/templates/photo-studio-bookings) 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

1. Settings: enter today's date, any date inside the month you want summarised, and the prices of prints and albums in the extras catalogue.
2. Packages: for each package, its length in minutes, price, number of edited photos, included prints and delivery days.
3. Photographers and Places: the photographers and their specialities, and the studios and outdoor locations.
4. 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.
5. Updating the status: as work moves, change the status from "booked" to "shot", "selecting photos", "editing" and "delivered", and enter the real delivery date.
6. Extras: log prints and albums sold by booking number so they join the client's total.
7. 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](https://softwiro.com/templates/appointments-scheduler) fits better, and a similar double-booking idea appears in the [beauty salon bookings article](https://softwiro.com/blog/beauty-salon-bookings-free-excel-online.html).

## Try it now

[Open the sheet and try it online, or download the Excel file](https://softwiro.com/templates/photo-studio-bookings). 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](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: photo studio bookings (1/3)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-1.jpg)[![Cheat sheet: photo studio bookings (2/3)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-2.jpg)[![Cheat sheet: photo studio bookings (3/3)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/photo-studio-bookings/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How does the sheet detect a photographer or room booked twice?

It works each booking's end time from the package length. If another active booking for the same photographer, or in the same place, overlaps that time, both rows show a red clash flag. A booking that starts exactly when another ends is not a clash, and cancelled or no-show bookings are ignored.

### How do I know which sessions are late for delivery?

Set the status as work moves: shot, selecting photos, editing, delivered. The due date is the session date plus the package's delivery days. If the due date has passed and the session is still in one of the first three stages the alert shows late, and the summary counts them.

### Where do I log prints and albums sold?

In the Extras sheet: enter the booking number, pick the item from the catalogue and type the quantity. The price and total appear, and the amount is added to the booking total and balance.

### Does it work out photographer commission?

No. It works out each photographer's revenue, sessions and hours. Multiply the revenue by your agreed rate outside the sheet, or request a custom version with commissions.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
