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)
- Is: the supplier and payment side of planning: one row per supplier, the contract and insurance checks, every deposit and balance with its due date, what is overdue, and what is due each month.
- Is not: setting your total or splitting it by category (that is how to budget a UK wedding), a full budget with every cost line and estimates (wedding budget spreadsheet UK or event budget spreadsheet UK), or business bookkeeping (sole trader bookkeeping spreadsheet UK).
- Product note: the Event Supplier & Payment Tracker (£4.50) records each supplier's total price rather than a separate VAT column, so enter the VAT-inclusive figure you will actually pay. It is a fill-in template that tracks what you enter; it does not check contracts or give legal or financial advice.
Supplier tracker vs budget spreadsheet vs payment schedule tab
| Tool | One row per | Answers | Use it when |
|---|---|---|---|
| Budget spreadsheet | Cost 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 tab | Payment (deposit and balance are separate rows) | What is due next, and when? | Inside a budget file, for a short list of payments |
| Supplier payment tracker | Booked supplier | Who 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.
| Column | What goes in it |
|---|---|
| Supplier | Business name, contact name, phone and email |
| Category / service | Venue, 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 signed | Yes / No, plus the date and where the signed copy is saved |
| Insurance seen | Yes / 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, paid | Amount, due date (DD/MM/YYYY) and the date you paid it |
| Balance (£), due, paid | Amount, due date and the date you paid it; add a row or column for any interim payment |
| Still owed (£) | Total minus everything paid |
| Status | All paid / Due soon / Overdue / Contract not signed / On track |
| Notes | Cancellation 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.
| Supplier | Service | Total | Contract | Insurance | Deposit (due / paid) | Balance (due) | Still owed | Status |
|---|---|---|---|---|---|---|---|---|
| Example Hall | Venue | £3,600 | Yes | n/a | £900 (01/10/2026 / paid 28/09/2026) | £2,700 (01/04/2027) | £2,700 | On track |
| Example Catering | Catering | £2,400 | Yes | Yes | £500 (25/10/2026 / not paid) | £1,900 (15/04/2027) | £2,400 | Due soon |
| Example Photo Co | Photography | £1,200 | No | Yes | £250 (not set) | £950 (01/04/2027) | £1,200 | Contract not signed |
| Example Florist | Flowers | £450 | Yes | n/a | £100 (paid) | £350 (paid) | £0 | All 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:
- VAT on a standard-rated quote:
=C2*0.2, only where the quote says "plus VAT". GOV.UK lists the standard rate as 20% (VAT rates); not every supplier or item is charged VAT. - Total:
=C2+D2, or type the inclusive price straight in. - Deposit from a percentage:
=E2*H2(format H as a percentage), or type the fixed sum. - Balance:
=E2-I2. - Still owed:
=E2-IF(K2<>"",I2,0)-IF(N2<>"",L2,0)(a payment counts once it has a paid date). - Next due date:
=IF(K2="",J2,IF(N2="",M2,"")). - Status:
=IF(O2<=0,"All paid",IF(F2<>"Yes","Contract not signed",IF(P2="","Check dates",IF(P2<TODAY(),"Overdue",IF(P2-TODAY()<=14,"Due soon","On track"))))). Add conditional formatting so Overdue turns red and Due soon turns amber. - Summary row:
=SUM(E2:E40)for total contracted,=SUM(O2:O40)for still owed, and=COUNTIF(F2:F40,"No")for unsigned contracts.
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
- Contract signed: do not pay a deposit until you have the terms in writing. Log the date you signed and save the PDF where both of you can find it. Unsigned contracts are the first thing to chase.
- Insurance seen: many venues ask outside suppliers (caterers, bands, bouncy castles, marquee and AV firms) for proof of public liability insurance. Ask your venue what it needs, and note whether you have seen the certificate and when it expires.
- What is included: copy the key inclusions into Notes (hours, staff, delivery and set-up, travel), so a later invoice can be checked against them.
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:
- 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.
- Note any late payment fee or interest clause and how the supplier wants to be paid (bank transfer reference, card, payment link).
- 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.
- 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
- Wedding: the venue, caterer, photographer, band or DJ, florist and cake usually carry the biggest deposits and balances. Keep the full budget in a wedding budget spreadsheet (the UK Wedding Budget Planner (£5.50) is a ready one), and work through bookings in order with the wedding planning checklist UK and the venue booking checklist. The UK Wedding Planner Bundle (7 templates) (£21.95) includes the budget planner, this supplier tracker and five more wedding templates.
- Corporate events and conferences: add columns for purchase order number, approver and whether the invoice has gone to finance. The VAT and reclaim side is covered in the corporate event budget UK guide, and the cost lines in the event budget spreadsheet UK guide. The Event Budget Planner (UK, with VAT) (£4.95) splits net, VAT and gross on every line.
- Office Christmas party: fewer suppliers but tight dates; note the final numbers deadline and pre-order date for each. See the Christmas party checklist UK and office Christmas party planning, and check cost per head with the free Christmas party cost per head calculator.
- Hen or stag do: the organiser often pays deposits for the group. Track the venues and activity bookings here, and the group's shares with the free hen do cost calculator and the how much does a hen do cost UK guide.
Keeping the tracker honest
- Add a supplier the day you book them, not when the first invoice arrives.
- Log a payment the day you make it, with the date paid; that is what moves the status on.
- Check the summary once a week: anything overdue, anything due in the next 30 days, any unsigned contracts or missing insurance.
- Keep receipts and invoices in one folder and note the file name in Notes.
- Sense-check quotes before you book: the free event budget and VAT calculator adds or strips VAT, and the wedding budget calculator shows whether a supplier fits your split.
DIY tracker vs a ready template vs a bundle
- DIY: build the columns and formulas above in a blank Excel or Google Sheets file, then add the cash-flow tab. It costs nothing except an evening.
- Ready template: the Event Supplier & Payment Tracker (£4.50) already has the Suppliers sheet, automatic status, summary and 12-month cash-flow table, with example rows to overwrite and a Start Here tab.
- Bundle: planning a wedding, the UK Wedding Planner Bundle (7 templates) (£21.95) includes the supplier tracker with the budget planner, venue scorecard, guest list, run sheet, checklist and seating plan. Organising events for work or a committee, the Event Planner Pro Bundle (7 templates) (£24.95) includes it with six more event templates.
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
- Wedding Budget Calculator UK
- Event VAT Calculator UK (Budget & Break-Even)
- Venue Hire Cost Comparison (UK)
- Wedding Planning Timeline (UK)
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.