Deposit Schedule Template
v1 · May 2026 · Word + Excel
Deposit Schedule Negotiation Template — Word + Excel Cash-Flow Model
Four structures, combined clause language, refund-zone heatmap, NPV modeler. Drop into your next red-line round.
Not legal advice. Drafting starting points only. Review with qualified counsel in the governing jurisdiction before signing. Civil-code references (Spanish Art. 1454, French Art. 1590, German BGB Section 339) are public statutes; deposit-specific case law is sparse in most EU jurisdictions.
How to use this template: Sections 1–4 are the four deposit structures with clause language. Section 5 is the combined deposit + refund + force-majeure clause. Section 6 is the refund-zone heatmap (printable as a desk reference). Section 7 is the cash-flow model that prices each structure at your contract value and discount rate. Click "Copy clause" to paste into your contract editor with track changes on. The full article is at hotel-deposit-schedule-negotiation.
1. Four deposit structures (clause language)
01 30/30/30/10 — Planner-friendly Hotel acceptance: medium
When to use: Long-window contracts (9+ months), planners with quarterly budget approvals, agencies handling multiple events. Smoothest cash-flow profile.
"Group shall pay the Total Contract Value of [€_____] in four (4) instalments as follows: (i) thirty percent (30%) on the date of signing of this Agreement; (ii) thirty percent (30%) one hundred and eighty (180) days prior to the Event start date; (iii) thirty percent (30%) ninety (90) days prior to the Event start date; (iv) ten percent (10%) within seven (7) calendar days of the Event end date upon receipt of final reconciliation invoice. Refundability of each instalment shall be governed by Section [X] (Refund Schedule) of this Agreement."
NPV saving versus 50/25/25 default: 1.8–4.0% of contract value (12–18 month window)
Why hotels accept: The 90 percent pre-event total matches what 50/25/25 delivers. The hotel loses some working-capital benefit but gets the same total commitment.
02 25/25/25/25 — Balanced Hotel acceptance: easy
When to use: Standard corporate procurement processes where equal milestones are administratively simpler. Pairs naturally with a 100/75/50/25 refund schedule.
"Group shall pay the Total Contract Value of [€_____] in four (4) equal instalments of twenty-five percent (25%) each at the following milestones: (i) on the date of signing of this Agreement; (ii) one hundred and eighty (180) days prior to the Event start date; (iii) ninety (90) days prior to the Event start date; (iv) thirty (30) days prior to the Event start date. The associated refund schedule shall be 100%/75%/50%/25% refundable per respective milestone date, with no refund on amounts paid inside thirty (30) days pre-Event."
NPV saving versus 50/25/25 default: 0.8–2.5% of contract value
Why hotels accept: Symmetric structure is easy to defend internally. Hotels prefer 25% at signing over 30% but accept the gap because the four-milestone total still hits 100% pre-event.
03 10/40/40/10 — Back-loaded Hotel acceptance: hard
When to use: Known repeat planner/agency, short window (under 9 months), competitive destination with multiple property options. Largest NPV saving of the four structures.
"Group shall pay the Total Contract Value of [€_____] in four (4) instalments as follows: (i) ten percent (10%) on the date of signing of this Agreement; (ii) forty percent (40%) one hundred and eighty (180) days prior to the Event start date; (iii) forty percent (40%) ninety (90) days prior to the Event start date; (iv) ten percent (10%) within seven (7) calendar days of the Event end date. Group warrants that the ten percent (10%) signing instalment constitutes a binding commitment and not merely an expression of interest."
NPV saving versus 50/25/25 default: 3.5–6.0% of contract value
Why hotels resist: 10% signing deposit is low enough that hotels worry about planner walk-away. Counter by attaching a reputation-backed warranty (last sentence) and/or proposing it as a "frequent buyer" benefit.
04 50/25/25 — Hotel default Hotel acceptance: instant (their template)
When to use: Avoid unless the contract value is small (under 20,000 EUR), the window is short (under 4 months), or all alternatives have been refused. Included here as the baseline for NPV comparison.
"Group shall pay the Total Contract Value of [€_____] in three (3) instalments as follows: (i) fifty percent (50%) on the date of signing of this Agreement; (ii) twenty-five percent (25%) ninety (90) days prior to the Event start date; (iii) twenty-five percent (25%) within seven (7) calendar days of the Event end date upon receipt of final reconciliation invoice."
NPV cost: baseline (other structures are measured against this)
The hidden cost: 50% at signing is a six-month interest-free loan to the hotel on a 12-month contract. At ECB main rate plus a typical corporate spread, that funding is worth 2–3% of the deposit amount per six months — value transferred from planner to hotel.
05 Master clause (stitches deposit, refund, FM into one block) Hotel acceptance: medium
When to use: Every contract over 50,000 EUR. Single coherent block prevents the most common contract drafting error: scattered deposit/refund/FM language that doesn't cross-reference cleanly.
"Section [X] — Deposit Schedule and Refundability.
(a) Deposit Schedule. Group shall pay the Total Contract Value of [€_____] in four (4) instalments: thirty percent (30%) at signing; thirty percent (30%) at one hundred and eighty (180) days pre-Event; thirty percent (30%) at ninety (90) days pre-Event; ten percent (10%) at final reconciliation (within seven (7) days post-Event).
(b) Refundability on Group-initiated cancellation. Refund of paid instalments shall apply as follows: one hundred percent (100%) if cancellation occurs more than 180 days pre-Event; seventy-five percent (75%) between 180 and 120 days; fifty percent (50%) between 120 and 90 days; twenty-five percent (25%) between 90 and 60 days; non-refundable thereafter. Refund applies pro rata to instalments paid prior to the cancellation date.
(c) Force Majeure refund. On Force Majeure cancellation as defined in Section [Y]: one hundred percent (100%) refund of all paid deposits if declared more than sixty (60) days pre-Event; fifty percent (50%) refund if declared within sixty (60) days; twenty-five percent (25%) refund if declared within seven (7) days. Refund shall be effected within thirty (30) calendar days of written notice of the Force Majeure event.
(d) Lock and assignment. The deposit schedule and refundability tiers shall not be modified except by written amendment signed by both parties. Hotel shall not accelerate deposit milestones. On change of Hotel ownership, Hotel shall provide sixty (60) days written notice; Group shall have the right to terminate this Agreement within thirty (30) days of such notice with full refund of all paid deposits."
Recommended starting point for contracts over €50k
The four protections in one block: (1) deposit schedule itself; (2) Group-cancellation refund schedule; (3) Force-Majeure refund schedule; (4) Lock against acceleration and change-of-ownership trigger.
3. Refund-zone heatmap
How to read: Rows show when a deposit instalment was paid; columns show when cancellation is declared. Cell value is the percentage refundable. Print this page and keep on the desk during the red-line round.
Enter contract value, window in months, and discount rate (use the ECB main refinancing rate plus your corporate spread, typically 6–9% for mid-market planners). The model computes NPV for each of the four structures and highlights the best/worst.
5. Pre-signature checklist (10 items)
Deposit total pre-event matches contract value minus any post-event reconciliation portion (typically 5–10%).
Each milestone date is explicit (signing date + offsets pre-Event), not "as agreed."
Refund schedule is in the same section as the deposit schedule, not buried in a separate clause.
Force-majeure refund is explicitly stacked on top of cancellation refund (not a substitute).
Force-majeure trigger references the governing jurisdiction's civil code (Spain Art. 1105, France Art. 1218, Germany BGB 313).
Deposit lock clause prevents hotel from accelerating milestones.
Change-of-ownership clause gives planner termination right with refund.
Interest accrual on held deposits is addressed (either ECB rate minus spread, or held in interest-bearing escrow).
Allocation order is explicit (deposit applies first to room-nights, then F&B, then ancillaries).
Payment method is specified (card vs wire) with merchant-fee allocation in writing.