Yacht Guidebook - Charter budget

	A	B	C	D	E	F
1	Your yacht charter budget
2	YACHT GUIDEBOOK / Google Sheets / 8 September 2026 / v1.2
3	Build an expense plan from your own quote. Keep advances and refundable money separate. Enter totals for the full trip and whole group. Multiply daily and per-person rates by the relevant days and people first.
4	Edit amber cells. For Extra, enter a confirmed amount or planning allowance. For Included / Not needed, leave the amount blank or enter 0. Keep unknown amounts blank. Use one currency.
5
6	Trip / yacht			Currency		For example EUR. No conversion.
7	Dates / duration			Paying shares		Enter a positive whole number of paying shares.
8
9
10	Trip expense	Treatment	Your amount	Counted expense	Basis	Notes / source
11	Yacht charter fee	Unknown
12	Tax not in the yacht fee	Unknown
13	Mandatory base / cleaning pack	Unknown
14	Hired skipper / crew	Unknown
15	Delivery / one-way charge	Unknown
16	Non-refundable damage waiver	Unknown
17	Fuel / operating allowance	Unknown
18	Berths / mooring allowance	Unknown
19	Food / provisions	Unknown
20	Optional crew gratuity	Unknown
21	Flights	Unknown
22	Transfers / hotel	Unknown
23	Travel insurance	Unknown
24	Other trip expenses	Unknown
25
26	Known expense subtotal				Only resolved rows. Missing costs are excluded.
27	Rows still to resolve			14
28	Planning expense total				Appears when rows, currency and paying shares are resolved.
29	Base share per payer				Base share in cents. See the allocation below.
30	Payers adding 0.01				These payers add 0.01 to the base share. Everyone else pays the base share.
31
32	Arrange separately	Applies?	Amount	Known amount	Due date	Payment / refund terms
33	APA advance	Unknown
34	Refundable security deposit	Unknown
35
36	No grand total combines these amounts: APA funds expenses already planned. The deposit remains refundable under the contract.
37
38
39
40	HOW TO USE AND SHARE
41	The blank file contains no market prices. Enter your quote or planning allowance and identify the source in the notes.
42	APA is an expense advance, reconciled against actual spending. Do not add it again to expenses already budgeted above.
43	A refundable security deposit is money or card capacity held separately. Confirm payment dates, settlement and refund terms with the operator.
44	You may use, adapt and share this original template, including in your work. Credit Yacht Guidebook, link to the source and label your changes.
45	This permission covers our template, not third-party sources or images. Formula cells are not locked. Keep an unchanged blank copy.
46	Source page and current copy: https://yachtguidebook.com/cost/#budget-spreadsheet
47	https://yachtguidebook.com/glossary/apa/
48	https://yachtguidebook.com/glossary/security-deposit/
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100