Trip Accounting and Reporting MASTER.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Trip Name:			Bal Due Date:
2	Trip Dates:			Penalty Date:
3							Deposit			Balance		Late Fee		Refund		Cancellation Fee
4		S/FM	First Name	Last Name	Status	X = M'ship Verified	Amount	Date	M'ship Dues	Amount	Date	Amount	Date	Amount	Date	Amount	Date	Total Receivedd	Requests	Release?	email
5	1(TL)				New													$0.00
6	2(ATL)				New													$0.00
7	3				New													$0.00
8	4				New													$0.00
9	5				New													$0.00
10	6				New													$0.00
11	7				New													$0.00
12	8				New													$0.00
13	9				New													$0.00
14	10				New													$0.00
15	11				New													$0.00
16	12				New													$0.00
17	13				New													$0.00
18	14				New													$0.00
19	15				New													$0.00
20	16				New													$0.00
21	17				New													$0.00
22	18				New													$0.00
23					New
24					New																	Need membership
25					New												Total Received	$0.00
26					New
27
28											Trip Reconciliation
29											To Be Completed at Close of Trip
30
31
32
33											$/each		Total
34							1	TL/Skipper					$0.00
35							1	ATL (non Skipper)					$0.00
36							2	Skippers (Other than TL/ATL)					$0.00
37							14	Regular Crew					$0.00
38
39										Projected Trip Revenue			$0.00
40
41
42							Funds Allocation
43								Amount collected					$0.00
44								Late fee included in above					$0.00
45								Cancellation fees included in above					$0.00
46								Membership fees included in above					$0.00
47
48										Actual Trip Revenue			$0.00
49
50										Over/Under			$0.00
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