Photography Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Session & Payment Tracker — enter every currently booked session: the client name, session type, date, deposit already collected, final balance amount and due date, and the gallery delivery date if it's scheduled. For sessions already delivered, add any print order totals and whether the lab invoices have been paid. This step takes 20–30 minutes for most active photographers and immediately shows you total deposits collected for future work, total final balances outstanding, and upcoming print payouts from gallery platforms. That three-number summary is your starting cash position for the 13-week projection and tells you more about your near-term cash than a bank balance alone — a photographer with $8,000 in the bank and $12,000 in outstanding final balances is in a very different position than one with $8,000 and no receivables.

Move to the 13-Week Cash Flow sheet and fill in weekly inflows and outflows. Use the Session & Payment Tracker as your source: deposit amounts for bookings due to be paid in the next 13 weeks go into the deposit row, final balance payments go into the balance due row based on their contract due dates, and expected print payout dates from Pixieset or ShootProof go into the print order row (most platforms batch payouts weekly or monthly — check your platform settings and enter those on the actual payout dates, not the order dates). Enter your fixed monthly expenses in the weeks they're due: Adobe CC and gallery platform subscriptions, studio rent, equipment loan payments, insurance installments, and marketing spend. For print lab invoices, enter them in the week you expect to submit the order to the lab — typically 1–3 days after a client completes a gallery order.

At month-end, update the Monthly Cash Flow sheet with actuals and reconcile the Session & Payment Tracker against your CRM or booking system — mark off any deposits collected, final payments received, and print payouts remitted. After a full season of data, the Annual Summary will show your CODB per hour, ARPC, print attach rate, and the deposit-versus-delivery payment gap chart that defines your working capital cycle. The CODB calculation is the number most photographers find revelatory: if your total annual business expenses are $28,000 and you shot 200 hours of paid sessions, your CODB is $140 per shooting hour — meaning a 2-hour portrait session must generate at least $280 just to cover costs before you take a dollar of income. Most photographers undercharge not because their rates are unreasonable but because they've never calculated what it actually costs to run their business.

Photography businesses have a cash flow structure unlike almost any other service business: revenue arrives in multiple disconnected tranches — a deposit at booking, a balance at delivery, and trailing print sales weeks or months later — while expenses arrive on fixed monthly schedules that don't slow down during the off-season. A wedding photographer who books a $3,500 wedding in February collects a $1,000 deposit immediately, waits six months to shoot the wedding in August, collects the $2,500 balance at the wedding or shortly after, delivers the gallery in September, and then receives $400 in album and print orders in October and November. That single booking generates four cash events spread across nine months. Multiply that by 25–40 weddings per year across overlapping booking cycles and you have a cash flow structure that is nearly impossible to manage from a bank balance alone — you need a system that maps when each tranche arrives.

The metric most photographers ignore until it becomes a problem is CODB per hour — Cost of Doing Business per shooting hour. Most photographers calculate their pricing by thinking about what they want to earn, adding a rough margin for expenses, and arriving at a session fee. That approach is backwards. The right starting point is calculating total annual business costs — software, gear depreciation, studio costs, insurance, marketing, travel, lab costs, and all other expenses — and dividing by the number of shooting hours you sell per year. That number is the floor below which every session loses money. A photographer with $24,000 in annual expenses who shoots 150 hours per year has a CODB of $160 per hour; a 4-hour portrait session must generate at least $640 before a single dollar of profit is possible. When you know your CODB, pricing decisions become straightforward — you're not guessing, you're covering costs and adding a target margin.

The cash management discipline that prevents a photography business from being cash-starved in January looks like this: treat advance deposits as committed future obligations, not as discretionary income — the deposit is securing a future delivery date, and spending it before the session is delivered creates a liability if the session falls through; build a cash reserve during peak season to cover the operating costs of January and February when bookings slow but software subscriptions, insurance, and equipment payments continue; track print lab invoices against gallery delivery dates so you know which lab payments are coming before the gallery platform payout arrives; and project forward 13 weeks at minimum to identify the weeks when session volume is low and fixed expenses are high. This template is designed to support that discipline — not just recording history, but giving you a real-time picture of where your cash is going and when it's coming back.