Deferred Stay Calculation and Entry Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Timber Trail Rentals
2	Journal
3	September 24, 2023
4												24/9/2023	Ending		Ending		Ending
5		Date	Transaction Type	Num	Adj	Name	Memo/Description	Account #	Account	Debit	Credit	30/9/2023	Balance	31/10/2023	Balance	4/11/2023	Balance
6		09/24/2023	Invoice	42149376	No	direct - Karlon - 42149376			Accounts Receivable (A/R)	11,999.89
7					No		Online Booking Fee \| 2023-09-24 to 2023-11-04 \| 41 nights		Other Guest Fee Revenues:Booking Fees		785.04	114.88	670.16	593.57	76.59	76.59	-
8					No		Reservation \| 2023-09-24 to 2023-11-04 \| 41 nights		Trust Liabilities:Owner Payables:01 Net Owner Income:a. Net Commissionable Revenue:Rents		9,639.00	1,410.59	8,228.41	7,288.02	940.39	940.39	-
9												1,525.47		7,881.59		1,016.98
10
11										Check-in Method
12													Sept	Oct	Nov
13											Booking Fees		670.16	(593.57)	(76.59)
14											Rents		8,228.41	(7,288.02)	(940.39)
15											Deferred Rev		(8,898.57)	7,881.59	1,016.98
16											Management Commission (Owner)		(1,645.68)	1,457.60	188.08
17											Management Commission Revenue		1,645.68	(1,457.60)	(188.08)
18
19										Check-Out Method
20													Sept	Oct	Nov
21											Booking Fees		(114.88)	(593.57)	708.45
22											Rents		(1,410.59)	(7,288.02)	8,698.61
23											Deferred Rev		1,525.47	7,881.59	(9,407.06)
24											Management Commission (Owner)		282.12	1,457.60	(1,739.72)
25											Management Commission Revenue		(282.12)	(1,457.60)	1,739.72
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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