Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Event budget open in Sheets, in the light themeEvent budget open in Sheets, in the dark theme

What is in it

Each cost of a wedding, party or conference with its supplier, the estimate, the actual price, what has been paid and what is still to pay, against the total you set. The figures are examples to type over.

Event budget
Type over the examples. Still to pay is the actual price, or the estimate until there is one, less what has been paid.
Total budget12000
ItemSupplierEstimateActualPaid so farStill to payDue by
Venue[Supplier]350038001000=IF(AND(C6="",D6=""),"",IF(D6="",C6,D6)-E6)
Catering[Supplier]3000500=IF(AND(C7="",D7=""),"",IF(D7="",C7,D7)-E7)
Drinks[Supplier]9000=IF(AND(C8="",D8=""),"",IF(D8="",C8,D8)-E8)
Photography[Supplier]11001100300=IF(AND(C9="",D9=""),"",IF(D9="",C9,D9)-E9)
Music[Supplier]6000=IF(AND(C10="",D10=""),"",IF(D10="",C10,D10)-E10)
Flowers and decoration[Supplier]5000=IF(AND(C11="",D11=""),"",IF(D11="",C11,D11)-E11)
Clothes[Supplier]9000=IF(AND(C12="",D12=""),"",IF(D12="",C12,D12)-E12)
Invitations and stationery[Supplier]200185185=IF(AND(C13="",D13=""),"",IF(D13="",C13,D13)-E13)
Transport[Supplier]3000=IF(AND(C14="",D14=""),"",IF(D14="",C14,D14)-E14)
Accommodation[Supplier]4000=IF(AND(C15="",D15=""),"",IF(D15="",C15,D15)-E15)
Other[Supplier]3000=IF(AND(C16="",D16=""),"",IF(D16="",C16,D16)-E16)
=IF(AND(C17="",D17=""),"",IF(D17="",C17,D17)-E17)
=IF(AND(C18="",D18=""),"",IF(D18="",C18,D18)-E18)

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Still to pay
=IF(AND(C6="",D6=""),"",IF(D6="",C6,D6)-E6)
Total: Estimate
=SUM(C6:C25)
Total: Actual
=SUM(D6:D25)
Total: Paid so far
=SUM(E6:E25)
Total: Still to pay
=SUM(F6:F25)
Expected cost: Still to pay
=E27+F27
Left in the budget: Still to pay
=B3-F28

Filling it in

  • Set the total first and allow around a tenth of it for things nobody thought of.
  • Replace each estimate with the actual price as soon as a supplier quotes, and the remaining budget becomes real.
  • Note when each balance is due. Venues and caterers often want the last payment weeks before the day.

More templates

All 32 templates