Supplier payment tracker UK: deposits, balances and due dates for weddings and events

A supplier payment tracker (some templates call it a vendor payment tracker) answers three questions at a glance: who you have booked, what you still owe each of them, and when that money has to leave your account. This guide shows the columns to use in Excel or Google Sheets, simple formulas for balance due and a payment status, how to log contracts, insurance and cancellation terms, a month-by-month cash-flow view, and how a tracker differs from a budget spreadsheet. It works for weddings, parties, conferences and corporate events. It is a planning method, not legal, tax or financial advice.

What this guide is (and is not)

Supplier tracker vs budget spreadsheet vs payment schedule tab

ToolOne row perAnswersUse it when
Budget spreadsheetCost line (booked or not)Are we within budget? What is the cost per guest?From the first estimate, including things not yet booked
Payment schedule tabPayment (deposit and balance are separate rows)What is due next, and when?Inside a budget file, for a short list of payments
Supplier payment trackerBooked supplierWho is booked, is the contract signed, is insurance seen, what is still owed, what is overdue, what leaves the account each month?Once suppliers are booked, especially with several deposits, balances and contracts to chase

Plenty of people use both: the budget for the big picture, the tracker for the suppliers. If you only have three or four suppliers, the payment schedule tab described in the wedding budget spreadsheet UK guide may be all you need.

Columns for a supplier payment tracker

One row per supplier. These headings are a practical DIY layout; rename or drop any you do not need.

ColumnWhat goes in it
SupplierBusiness name, contact name, phone and email
Category / serviceVenue, catering, photographer, band or DJ, florist, cake, AV, transport, hair and make-up, stationery
Quote ex-VAT (£)Only if the supplier quotes before VAT
VAT (£)The VAT on that quote, if they charge it; 0 if they are not VAT-registered or the item is exempt
Total (£)What you will actually pay, VAT included
Contract signedYes / No, plus the date and where the signed copy is saved
Insurance seenYes / No: whether you (or the venue) have seen the supplier's insurance certificate, if one is needed
Deposit %If the deposit is a percentage of the total; leave blank for a fixed sum
Deposit (£), due, paidAmount, due date (DD/MM/YYYY) and the date you paid it
Balance (£), due, paidAmount, due date and the date you paid it; add a row or column for any interim payment
Still owed (£)Total minus everything paid
StatusAll paid / Due soon / Overdue / Contract not signed / On track
NotesCancellation terms, late payment terms, final numbers deadline, what the price includes, payment method and reference

Illustrative sample rows (made-up figures)

The rows below are made-up examples to show how the columns fit together. They are not typical UK supplier prices, deposit levels or recommended terms.

SupplierServiceTotalContractInsuranceDeposit (due / paid)Balance (due)Still owedStatus
Example HallVenue£3,600Yesn/a£900 (01/10/2026 / paid 28/09/2026)£2,700 (01/04/2027)£2,700On track
Example CateringCatering£2,400YesYes£500 (25/10/2026 / not paid)£1,900 (15/04/2027)£2,400Due soon
Example Photo CoPhotography£1,200NoYes£250 (not set)£950 (01/04/2027)£1,200Contract not signed
Example FloristFlowers£450Yesn/a£100 (paid)£350 (paid)£0All paid

Simple formulas for Excel and Google Sheets

Both programs use the same formulas here. Assuming row 2 has quote ex-VAT in C, VAT in D, total in E, contract signed (Yes/No) in F, deposit % in H, deposit £ in I, deposit due in J, deposit paid date in K, balance £ in L, balance due in M, balance paid date in N, still owed in O and next due date in P:

Excel or Google Sheets? Google Sheets is easier if two of you (or a committee) update it from your phones; Excel suits one person. An .xlsx file opens in both: upload it to Google Drive and use File › Save as Google Sheets.

Contracts and insurance: the two columns people skip

Cancellation and late payment terms (method)

Each supplier's contract sets out what happens if a payment is late or the booking is cancelled, so record those terms rather than relying on memory:

  1. Copy the cancellation terms into Notes: whether the deposit is refundable, any sliding scale by notice period, and the date by which you would have to cancel to lose less.
  2. Note any late payment fee or interest clause and how the supplier wants to be paid (bank transfer reference, card, payment link).
  3. Add a reminder a week or two before each due date, and pay early if a due date falls near a bank holiday or your payday.
  4. If plans might change, ask the supplier in writing before you miss a payment.

If a business is paying the supplier (a corporate event, for example), GOV.UK's late commercial payments guidance (checked 14 October 2026) explains when a business-to-business payment counts as late, and that suppliers can claim statutory interest of 8% plus the Bank of England base rate unless the contract sets a different rate. That guidance is about payments between businesses; for a personal wedding or party, the terms in each contract are what to check. This page is not legal advice.

Cash-flow view: what leaves your account each month

The most useful tab in any supplier tracker is a simple monthly total, because deposits and balances tend to bunch up in the last few months before the day. Put the first day of each month in column A of a second tab (01/11/2026, 01/12/2026 and so on), then in B2:

=SUMIFS(Suppliers!$I$2:$I$40,Suppliers!$J$2:$J$40,">="&A2,Suppliers!$J$2:$J$40,"<"&EDATE(A2,1))+SUMIFS(Suppliers!$L$2:$L$40,Suppliers!$M$2:$M$40,">="&A2,Suppliers!$M$2:$M$40,"<"&EDATE(A2,1))

That adds every deposit and balance due in that month (rename "Suppliers" to your sheet's name). Put what you expect to have saved or budgeted by each month in column C, and you can see a shortfall months before it happens. The how to budget a UK wedding guide (step 6) explains why balances bunch up and how to plan for it.

Wedding, corporate, Christmas party and hen do variants

Keeping the tracker honest

DIY tracker vs a ready template vs a bundle

More: wedding budget spreadsheet UK · event budget spreadsheet UK · how to budget a UK wedding · corporate event budget UK · venue booking checklist · wedding planning checklist UK · Christmas party checklist UK · event run sheet template UK

Free tools for this

Frequently asked questions

What should a supplier payment tracker include?

One row per booked supplier with service, contact, total price (VAT included), contract signed, insurance seen, deposit amount, due date and date paid, balance amount, due date and date paid, still owed, status and notes. A summary and a month-by-month cash-flow tab make it far more useful.

Is there a wedding vendor payment tracker template for Excel or Google Sheets?

Yes. You can build the columns and formulas in this guide yourself, or use our Event Supplier & Payment Tracker: an Excel and Google Sheets file with a Suppliers sheet, automatic status, a summary and a 12-month cash-flow table, in £ with UK dates. It works for weddings and other events.

What is the difference between a supplier tracker and a wedding budget spreadsheet?

A budget spreadsheet has a row for every cost line, including estimates for things not yet booked, and tells you whether you are within budget. A supplier tracker has a row per booked supplier and tells you who is booked, whether the contract is signed, what you still owe and what is due when.

How do I track deposits and balances for wedding suppliers?

Give each supplier a deposit amount, due date and paid date, and a balance amount, due date and paid date. Calculate still owed as the total minus whatever has a paid date, and work out the next due date. Flag anything overdue or due within two weeks.

How do I make a payment status column in Excel or Google Sheets?

Use nested IF formulas: show All paid if nothing is owed, Contract not signed if the contract column is not Yes, Overdue if the next due date is before TODAY(), Due soon if it is within 14 days, otherwise On track. Conditional formatting can colour each status.

How do I see how much I need to pay suppliers each month?

Add a cash-flow tab with the first day of each month in a column and use SUMIFS to add every deposit and balance due between that date and the next month (EDATE). Compare it with what you will have saved by then to spot a shortfall early.

What happens if I pay a supplier late?

It depends on the contract, so copy each supplier's late payment and cancellation terms into the tracker. Between businesses, GOV.UK explains that suppliers can claim statutory interest of 8% plus the Bank of England base rate unless the contract sets a different rate. This is not legal advice.

Is the Event Supplier & Payment Tracker financial or legal advice?

No. It is a fill-in Excel and Google Sheets planning template that tracks the suppliers, contracts and payments you enter. It does not check contracts or replace legal, tax or financial advice, and this guide is not advice either.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.