Tracking Advance, Installment and Balance Payments Without Spreadsheets

Wedding and event photography rarely gets paid in one shot. It's usually advance, a mid-way installment, and a final balance on delivery — spread across weeks, sometimes months. A spreadsheet can technically hold this, but it wasn't built to chase it.

What spreadsheets miss

• No reminder when an installment is due — you have to remember to check
• One typo in a formula and totals are silently wrong
• No link between a payment row and the actual client conversation
• Sharing it with staff means sharing every client's numbers, not just theirs

What a proper payment record looks like

Each lead should carry its own payment history: what's been received, what's due and when, and what's still pending — visible the moment you open that client's record, no separate file to cross-reference.

The other piece spreadsheets rarely get right is receipts. A clean, sequential receipt for every payment isn't just professional — for studios formalizing their business, it's what keeps your books audit-ready without extra effort later.

You shouldn't need to remember who owes what. The system should tell you.