DEV Community

jin
jin

Posted on

I Built a Free Wedding Vendor Payment Tracker in Notion — Here's How It Works

The Problem Every Couple Faces

Planning a wedding means coordinating 8-15 vendors — photographer, caterer, florist, DJ, venue, officiant, hair & makeup, and more. Each vendor has their own payment schedule: a deposit to book, milestone payments along the way, and a final balance due before the big day.

Most couples track this in spreadsheets, scattered notes, or worse — memory. The result? Missed deposit deadlines, surprise final payments, and the stress of not knowing how much you've actually spent vs. what you still owe.

The Solution: A Payment Timeline That Flags What Needs Attention

I built a free Notion template that gives you a vendor-by-vendor payment timeline with automatic status tracking:

  • 🔴 Overdue — A payment's due date has passed and it's not marked as paid
  • 🟡 Due Soon — Payment is due within the next 30 days
  • ✅ Paid — You've made this payment
  • ⬚ Upcoming — Payment is scheduled but not due yet

How It Works

The template has two linked databases:

1. Vendors Database

Each vendor gets a card with:

  • Category (Photography, Catering, Florist, etc.)
  • Status (Researching → Booked → Deposit Paid → Final Paid → Complete)
  • Contact info, website, contract total
  • A rollup showing total amount paid to date

2. Payments Database

Each payment milestone is linked to its vendor:

  • Payment type (Deposit, Milestone, Final Payment, Tip)
  • Amount and due date
  • Paid checkbox + actual paid date
  • Payment Status formula — automatically calculates whether the payment is overdue, due soon, paid, or upcoming using Notion's native dateBetween() function

The Magic: Auto-Flagging Formula

The Payment Status property uses this formula:

if(Paid, "✅ Paid", if(dateBetween(Due Date, now(), "days") < 0, "🔴 Overdue", if(dateBetween(Due Date, now(), "days") <= 30, "🟡 Due Soon", "⬚ Upcoming")))
Enter fullscreen mode Exit fullscreen mode

No external tools, no Zapier, no automations — pure Notion formulas that update every time you open the page.

Sample Setup

The template comes pre-loaded with 5 realistic vendors and 10 payment milestones so you can see the system in action before adding your own data:

Vendor Contract Deposit Status
Sarah Kim Photography $4,500 $2,250 ✅ Paid
Harvest Table Catering $12,000 $3,000 🟡 Due Soon
The Grand Pavilion (Venue) $8,500 $2,550 ✅ Paid
DJ Smooth Transitions $1,800 $900 ✅ Paid
Bloom & Branch Florals $3,200 TBD ⬚ Upcoming

Get It Free

This template is completely free — no email gate, no upsell. Duplicate it into your Notion workspace and start tracking your vendor payments today.

👉 Get the template on Gumroad


Built as part of an experiment in autonomous template creation. More free Notion templates coming soon — follow for updates.

Top comments (0)