Wedding vendor payment tracker: how to see what you owe and when

A wedding budget tells you what you plan to spend. It does not tell you which vendor wants a deposit next month or whether the balance for the venue is already late. This page shows how to build a wedding vendor payment tracker in a spreadsheet: contracts, deposits, balances, a status per vendor, a budget check per category and a short worked example with invented numbers.

Why a budget alone falls short

Most couples start with a list of categories and a total. That list answers one question: how much do we want to spend on flowers, music or the venue. Once contracts are signed, a second question appears: what do we owe, and by when. Vendors usually ask for a deposit at booking and the balance before the day. Those dates sit scattered across contracts and emails.

A payment tracker puts every contract and every due date in one place. A budget check next to it shows whether the contracts you signed still fit the plan.

What to record for each vendor

One row per vendor keeps the sheet easy to read and to filter.

• Vendor and category. Venue, catering, photography, music, flowers, dress and suit, and so on. Use a short list of categories you can edit.
• Contract total. The full amount agreed with that vendor.
• Deposit amount and due date. Many vendors ask for a first payment at booking.
• Balance due date. The date the remaining amount is requested.
• Paid dates. Leave them empty until the money has gone out. Enter the date when you pay.
• Extra paid. A spare column for anything outside the deposit and balance, such as an extra hour of service. A negative entry can record a refund.

How status works

Status turns dates into a signal you can scan in seconds. Use a report date cell. Type a fixed date to look at a past or future moment, or enter =TODAY() to see the current day.

1. Paid. The deposit and the balance both have a paid date.
2. Overdue. A payment is still open and its due date is before the report date.
3. Due soon. A payment is open and its due date falls inside a window you choose, for example 14 days.
4. Open. Everything else, including contracts that have no dates yet.

The next due date follows the same logic. While the deposit is unpaid, the next due date is the deposit date. After that, it is the balance date.

Add a budget check per category

Next to the vendor list, keep one table with a planned budget per category. A formula adds up the contract totals of all vendors in that category. Two results matter:

• Over plan or within plan. Contracts above the plan show as over plan.
• Left to contract. Plan minus contracts, so you see how much room remains for vendors you have not booked.

This check works best early, before the last contracts are signed.

A dashboard for the whole picture

Collect the main figures on one sheet: total budget, total contracted, paid so far, still to pay, the amount overdue and the amount due soon. If you enter a wedding date, add days to the wedding. A list of the next five payments sorted by due date answers the question most couples ask every week: what is coming up. A chart by category shows where the money sits.

The formulas behind it

Each result comes from a short formula.

• Still to pay = contract total + extra paid, minus everything already paid.
• Next due date = deposit due date while the deposit is unpaid, otherwise the balance due date.
• Days overdue = report date minus due date.
• Amount left to contract = planned budget for the category minus the sum of its contracts.

Worked example (invented numbers)

These figures are made up for illustration. A caterer has a contract total of 4,000. The deposit of 1,000 is due on 1 March and the balance of 3,000 is due on 1 June. The planned budget for catering is 5,000.

1. On 20 May the deposit has a paid date. The next due date is 1 June, which is 12 days away. With a due-soon window of 14 days, the status is Due soon.
2. On 5 June the balance still has no paid date. Days overdue = 4, and the status is Overdue.
3. Budget check: 5,000 planned minus 4,000 contracted leaves 1,000 to contract. The category shows as within plan.

Enter the balance paid date and the status changes to Paid, still to pay drops to zero and the next due date moves on to the next vendor.

What a vendor tracker leaves out

Keep expectations clear. A money tracker does not replace a guest list, a seating plan or a timeline. Costs without a vendor contract, such as a small gift, need their own row. Several instalments with separate due dates fit awkwardly into a deposit and balance layout, so record the later ones in the extra paid column. Multiple currencies, VAT and taxes of any kind sit outside a simple tracker like this.

A ready-made version

If you would rather not build the formulas yourself, the Size Run Studio Wedding Budget and Vendor Payment Tracker follows this structure. It is one Excel workbook with five tabs: Instructions, Settings, Budget, Vendors and Dashboard. Settings hold the total budget, an optional wedding date, the report date, the due-soon window and 12 editable categories. The Vendors tab holds up to 50 vendors. The workbook includes made-up example data to delete before real use, and a one-page Quick Start PDF. It is built for Excel, uses no macros and opens in LibreOffice. It has not been tested in Google Sheets.

*Planning aid only. This page is general information, not financial, tax, accounting, legal or contract advice. Check your own contracts and figures.*

Built for Excel (.xlsx), no macros. Not tested in Google Sheets.

See the Wedding Budget and Vendor Payment Tracker Wedding Budget Tracker on Etsy

Frequently asked questions

How do you track wedding vendor payments in a spreadsheet?

Give every vendor one row with the contract total, the deposit amount and due date, and the balance due date. Enter a paid date when a payment goes out. A status column then compares each due date with a report date and shows Paid, Open, Due soon or Overdue.

What is the difference between a wedding budget and a vendor payment schedule?

A budget is your plan per category. A payment schedule lists what each contract asks you to pay and on which dates. Putting both in one workbook shows whether your contracts fit your plan and which payment comes next.

Can a wedding budget spreadsheet work in Excel?

Yes. The tracker described here is built for Excel, uses no macros and also opens in LibreOffice. It has not been tested in Google Sheets.

Is this financial or contract advice?

No. This page describes a planning tool and a method for record keeping. Check your own contracts and figures, and ask a qualified adviser about your own situation.