Event payment milestone tracker
Deposits, progress payments and final balances are due on different dates, and the treasurer only finds out when a supplier emails a reminder.
The short answer
A payment milestone tracker is a single table of every payment the event owes: supplier, trigger, amount, due date, approval and status, set against the cash you actually hold.
Keep money you have separate from money you hope to receive. A pending sponsor pledge or unpaid registration is not cash until it has arrived.
What the tracker does
It lets the treasurer see the next three payments, the approval each needs and the balance after each one. It also shows the secretariat which supplier milestones depend on a decision, such as final headcount.
It is a coordination tool. It does not make payments and does not replace your accounting records.
Columns to include
| Column | What goes in it |
|---|---|
| Supplier and reference | Name and the order or quotation number it relates to. |
| Milestone and trigger | For example deposit on signing, balance seven days before the event, or on delivery. |
| Amount and tax treatment | As shown on the document, with tax stated separately if the supplier shows it. |
| Due date | From the supplier's document, not from memory. |
| Approval | Who must approve, and whether it has been given. |
| Status | Not due, approved, paid, or disputed. |
| Dependency | What must happen first, such as final headcount or receipt of goods. |
Cash received and cash expected
Add two blocks beside the payments. The first shows money in the bank. The second shows expected receipts such as registration fees due or sponsor pledges, each labelled pending or confirmed.
Calculate the balance from cash in hand only, then show a second line that adds expected receipts. If the first line goes negative on a payment date, the tracker has done its job. The cash payment schedule builder does this layout for you.
A weekly routine
- Update statuses from the finance team's records, not from supplier emails.
- Check due dates in the next 30 days and confirm approvals are in place.
- Check dependencies: has a headcount, scope change or delivery been confirmed?
- Update cash in hand and expected receipts, moving pledges to confirmed only on written confirmation.
- Send the treasurer a one-line summary of what is due and what is at risk.
Where to link out
Deposits that may or may not be refundable belong in the deposit commitment register. Purchase orders sit with the purchase order request. Cancellation scenarios are tested in the cancellation exposure worksheet.
Worked example · Fictional example
A tracker for a 300-delegate conference
Fictional organisation and figures, illustrative only.
Persatuan Fiktif Perancang Bandar holds RM 40,000 in its event account. Its tracker shows a venue deposit of RM 15,000 paid, an AV deposit of RM 6,000 due next week and a venue balance of RM 18,000 due 14 days before the event.
A sponsor has signed a pledge for RM 25,000 but has not paid. The tracker shows the balance after the AV deposit as RM 34,000 in cash, and RM 59,000 only if the pledge arrives. The venue balance is therefore not treated as covered until the sponsor payment is banked.
Use this yourself
Payment milestone tracker
Copy this table and add a row for each payment. Keep cash in hand and expected receipts in separate blocks beneath it.
| Supplier and ref | Milestone and trigger | Amount | Due date | Approval | Status | Depends on |
|---|---|---|---|---|---|---|
| Venue, order V-01 | Deposit on signing | RM 15,000 | Past due, paid | Treasurer, given | Paid | None |
| AV supplier, order AV-02 | Deposit on order | RM 6,000 | Next week | Treasurer, pending | Approved after check | Final scope |
| Venue, order V-01 | Balance 14 days before event | RM 18,000 | 14 days before event | Treasurer and chair | Not due | Final headcount |
| Cash in hand | Bank balance | RM 34,000 after AV deposit | Update weekly | Finance | Confirmed | None |
| Sponsor pledge | Expected receipt, not cash | RM 25,000 | Not yet paid | Not applicable | Pending | Sponsor payment |
Handle it in-house, or bring in help?
Your team can usually handle this when
- Few suppliers and a treasurer who checks the account weekly.
- Payment dates are simple and approvals are quick.
- No major receipts depend on pledges.
Outside planning help earns its fee when
- Many suppliers with dependent milestones and several approvers.
- Expected income is uncertain and the balance is tight on some dates.
- No one owns the link between programme decisions and payment dates.
Need someone to keep the tracker current?
A conference project lead can build the payment milestone tracker from your supplier documents, keep dependencies and approvals up to date, and flag dates where confirmed cash does not cover the payment. Payments themselves are made and approved by your finance team.
Questions organisers ask
Can sponsor pledges count towards the balance?
Show them separately as pending. Count them as cash only when the money has been received.
Who should own the tracker?
The treasurer owns the cash and approvals. The secretariat or project lead keeps dates and dependencies updated, so both need access.
How often should it be updated?
Weekly in the last three months, and after any supplier variation or payment.
Does the tracker deal with tax?
It records tax as the supplier's document shows it. How tax is treated is a question for your accountant.
Related resources
Content record: Draft. Written from the cited sources and checked by automated rules; not yet independently reviewed.