{"id":18881,"date":"2026-04-27T08:00:00","date_gmt":"2026-04-27T01:00:00","guid":{"rendered":"https:\/\/beup.space\/?p=18881"},"modified":"2026-05-11T21:50:32","modified_gmt":"2026-05-11T14:50:32","slug":"quan-ly-booking-studio-chup-anh-bang-excel","status":"publish","type":"post","link":"https:\/\/beup.space\/en\/quan-ly-booking-studio-chup-anh-bang-excel\/","title":{"rendered":"Managing a photographer's schedule and actual profitability with Excel"},"content":{"rendered":"

\u23f1 7 minutes read<\/p>\n

<\/p>\n

\n

Short answer:<\/strong> Managing a photography studio with Excel allows photographers to track the entire booking lifecycle, calculate the actual cost of each session (including editing time, equipment depreciation, and travel), and analyze profitability by session type. Photographers who do 10-30 sessions per month don't need expensive software; a well-structured Excel file is enough to identify profitable sessions and make informed decisions about pricing and booking mix.<\/p>\n<\/div>\n

Most freelance photographers go through a similar phase: a packed schedule, regular clients, but at the end of the quarter, their account balance doesn't match the amount of work they've put in. The issue often isn't the low shooting prices, but rather the failure to account for the true costs of each session \u2014 especially the most invisible expense: editing time after the shoot.<\/p>\n

Shooting a wedding takes 8 hours, and editing takes an additional 8-12 hours. This second part is not included in the quote, does not appear on the invoice, but it is real time \u2014 time that could be used for additional bookings or not at all. By not valuing edit time, photographers are essentially paying themselves 0 dong for the part of the process that takes up the most time.<\/p>\n

Without a tracking system, all sessions appear equal on the surface. A 3.5 million dong portrait and a 12 million dong wedding are both recorded as “income”, but their actual profits may differ entirely, often in the opposite direction of expectations.<\/p>\n

\n

Article contents<\/p>\n

    \n
  1. Revenue and actual profit are two different numbers<\/a><\/li>\n
  2. The most profitable session type is often not the one being booked the most<\/a><\/li>\n
  3. Three key numbers determine the optimal direction of the studio<\/a><\/li>\n
  4. How data is organized determines what decisions can be made<\/a><\/li>\n
  5. Frequently asked questions<\/a><\/li>\n<\/ol>\n<\/div>\n
    \n

    Revenue and actual profit are two different numbers<\/h2>\n
    \n

    The real cost of a session<\/strong> including: edit time valued at the photographer's hourly rate, travel costs, equipment depreciation allocated per session, and direct costs like album labs or printing. Gross revenue minus all these costs equals the actual profit of the session.<\/p>\n<\/div>\n

    For example, a wedding that earns 8 million dong. Subtracting 7 hours of photo editing at a rate of 150,000 dong per hour gives 1.05 million dong just for editing. Adding 200,000 dong for round-trip travel and allocating the depreciation of a 70 million dong Sony A7IV camera over 5 years (around 1.17 million per month), plus an additional 700,000 dong per month for lenses and flash equipment, each session bears an additional 300,000-500,000 dong in equipment costs.<\/p>\n

    The actual number from a single wedding, as described above, drops from 8 million to around 6-6.5 million dong before considering any other overhead. This is still a profitable session. But the picture changes significantly when comparing across session types, and this is information that most photographers currently lack.<\/p>\n

    \n

    The most profitable session type is often not the one being booked the most<\/h2>\n

    One of the most important insights when starting to track session costs is discovering the margin difference between portraits and weddings. The initial assumption is often that portraits are quicker, simpler, and less stressful, so they must have better margins. Reality often proves the opposite.<\/p>\n

    Weddings have a higher absolute price than portraits, but edit time is also longer. What matters is the ratio of edit time to revenue: a 3.5 million dong portrait may require 5-7 hours of editing to deliver the promised number of photos, while a 12 million dong wedding typically requires 8-10 hours. When considering profit per working hour, weddings are often 30-40% higher. Photographers who fill their schedules with portraits because they seem “faster” may be unintentionally choosing lower-paying work.<\/p>\n

    This doesn't mean that portrait sessions are always less profitable. With a standardized culling and editing process, portraits can still achieve good margins. The problem is that without tracking, it's impossible to know this. Decisions about session mix, pricing, and monthly maximums are being made without foundational data.<\/p>\n

    Summary:<\/strong> The real profit of each session type can only be compared when considering edit time based on hourly rates, equipment depreciation, and direct costs. Most photographers make pricing and booking mix decisions without this information.<\/p>\n

    \n

    Three key numbers determine the optimal direction of the studio<\/h2>\n

    Instead of tracking everything from the start, there are three core metrics that photographers need to understand to make informed decisions about their studio operations.<\/p>\n

    The first key metric is average real cost per session, broken down by session type<\/strong>This is the basis for calculating break-even points when pricing and determining how many sessions are needed per month to reach income targets. Without this number, photographers may take on more work than necessary because they don't know what their limit is.<\/p>\n

    The second key metric is gross margin % by session type<\/strong>Margin is calculated by subtracting real costs from revenue and dividing by revenue. With this number for each session type, photographers can see which ones contribute most to their actual profit and adjust their booking mix accordingly.<\/p>\n

    The third key metric is monthly equipment depreciation vs revenue<\/strong>This is a hidden cost that most photographers don't factor in. A Sony Full-frame camera kit with two specialized lenses and a flash system can cost between 150-250 million dong, with an average depreciation period of 5-10 years. When allocated monthly, this is a real cost that must be recovered through pricing, but if not tracked, it remains invisible.<\/p>\n

    \n

    A skilled photographer knows more than just how to take great photos. They also understand the true cost of each working hour, which types of sessions are most profitable for their studio, and when to raise prices instead of increasing bookings.<\/p>\n<\/div>\n

    \n

    How data is organized determines what decisions can be made<\/h2>\n

    The problem is not that photographers lack information. Information exists everywhere: booking schedules in calendar apps, payment notes in messaging apps, equipment invoices in emails. The problem is that dispersed information has no analytical value. When it's impossible to cross-reference between revenue, costs, and session types, it's impossible to answer any meaningful questions about business efficiency.<\/p>\n

    The necessary data structure for a freelance studio is simple enough to maintain yet comprehensive enough to make decisions. The booking section needs to track the entire lifecycle from inquiry to final payment, with deposits calculated automatically and warnings for overdue payments. The session cost section needs to be linked via Booking ID so that each session knows its actual costs. The equipment section is entered once and automatically depreciates by month and by equipment type.<\/p>\n

    When these three components are connected correctly, a comprehensive dashboard can automatically pull data and display gross profit by month, margin percentage by session type, overdue debt list, and performance comparison between periods. There's no need to recalculate manually each time you need to review the numbers. Whenever there's a new booking or a session is completed, just add a row and the numbers will update automatically.<\/p>\n

    This is the difference between having data and having actionable information. For a freelance studio with 10-30 sessions per month, a correctly structured Excel file is enough to achieve this without needing complex studio management software with monthly subscription costs.<\/p>\n

    \n
    \n

    \u270d Key Takeaways<\/p>\n