Spreadsheets

Client budget versus vendor cost: a sheet for event planners

An event planner sheet that compares client budget with vendor quotes, advances and balances, shows margin per event and lists payments due this week.

Editorial illustration for Client budget versus vendor cost: a sheet for event planners

An event planner earns the gap between what the client pays and what the vendors cost, and loses it quietly when quotes drift or an advance is missed. A sheet with an Events tab and a Vendors tab, joined by an event code, shows margin per event and which vendor payments fall due this week. It works in Excel 365 and Google Sheets.

What goes on each tab?

Events tab: Event code, event name, date, client contract amount, client received, and client balance. Vendors tab: Event code, vendor, service, quote, advance paid, balance and due date.

Vendors columnHeadingNotes
AEvent codeMatches the Events tab
BVendorCaterer, decorator, sound, photographer
CServiceWhat exactly was agreed
DQuoteAgreed amount
EAdvance paidSo far
FBalance=D2-E2
GDue dateWhen the balance must be paid

How do you calculate margin per event?

On the Events tab, add vendor total and margin with SUMIFS:

  • Vendor total: =SUMIFS(Vendors!$D$2:$D$500, Vendors!$A$2:$A$500, A2)
  • Margin: =D2-vendor total
  • Margin percentage: =IF(D2=0, "", margin/D2)

What does a worked example look like?

Say a reception is contracted at ₹6,00,000. The vendor quotes are:

VendorQuoteAdvance paidBalance
Caterer₹2,50,000₹1,00,000₹1,50,000
Decor₹1,40,000₹70,000₹70,000
Photography₹70,000₹20,000₹50,000
Sound and lights₹40,000₹10,000₹30,000

The vendor total is 2,50,000 + 1,40,000 + 70,000 + 40,000 = ₹5,00,000. Margin is 6,00,000 - 5,00,000 = ₹1,00,000, or about 16.7% of the contract. Advances paid so far are ₹2,00,000 and balances still owed are ₹3,00,000. These are sample numbers.

How do you list payments due this week?

Use FILTER on a Due tab, in Excel 365 or Google Sheets:

=FILTER(Vendors!A2:G500, (Vendors!G2:G500>=TODAY())*(Vendors!G2:G500<=TODAY()+7)*(Vendors!F2:F500>0), "Nothing due")

The three conditions are multiplied, so all must be true: the due date is today or later, within the next seven days, and a balance remains. The last argument is the message shown when nothing matches. In older Excel without FILTER, sort the Vendors tab by due date and use a filter on the Balance column to see the same list.

What makes quotes drift?

  • Guest counts rise after the quote is given, especially for catering.
  • Add-ons such as extra lighting or a longer shoot are agreed on the phone.
  • Final bills differ from the quote and nobody updates the Vendors row.

The fix is to change the Quote cell whenever a number changes and to add a Note column with the date and who agreed. The margin then tells you the truth while there is still time to ask the client for a revised contract.

A pre-event checklist

  1. All vendor quotes entered and matched to the contract.
  2. Client advance received, balance date agreed.
  3. Every vendor advance paid or scheduled.
  4. Margin above the amount you are comfortable with, after allowing for surprises.

How do you keep the client updated?

Add a Client view that shows contract amount, amount received, and the next payment due from the client, with no vendor details. Share a copy of that tab, not the whole workbook. The client sees progress and the next date, and you keep your vendor quotes and margin private. Update it after each receipt, so the number you quote on the phone matches the sheet.

Send the client only the Client view, and keep the margin column on a tab that is never shared outside the planning team.

Payments to vendors flow through your bank and card, so a statement import into SpendixAI helps you check that each advance in the sheet really left the account.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports