ABCDEFGJKLMNOPQRSTUVWXYZ
1
DateCategory
Artist/Vendor/Name
DescriptionQtyAmountPer Bank
2
3
9/21/2023TOTL CASH BALANCE BOA Operating- BOOK$275,150<- vs. ->$287,866
4
5
Prior Week's Items
6
PayablesPrior Week AP Aging not paid-$5,000
7
8
9/21/2023Weekly Forecast Cash Balance- Books$270,150
9
10
WEEK of Thrs 9/21/23 to Wed 9/27/23
11
TicketsTicketing CoWeekly Sales- Online Advance Sales$55,825
12
TicketsVenue Box OfficeNight of Show Walk Up- Est 50qty/ show$6,250
13
14
9/21/2023ShowAC/DCSettlement- Guarantee (net of deposits)-$6,806
15
Settlement- Percentage-$2,063
16
Expenses- 3rd Party Vendors-$500
17
Beverage Revenues- 80% of drop @ $18/$7,681
18
19
9/22/2023ShowGarth BrooksSettlement- Guarantee (net of deposits)-$6,806
20
Settlement- Percentage
21
Expenses- 3rd Party Vendors-$500
22
Beverage Revenues- 80% of drop @ $18/$7,681
23
24
9/23/2023ShowBeastie BoysSettlement- Guarantee (net of deposits)-$6,806
25
Settlement- Percentage-$2,063
26
Expenses- 3rd Party Vendors-$500
27
Beverage Revenues- 80% of drop @ $18/$7,681
28
29
9/26/2023ShowIndigo GirlsSettlement- Guarantee (net of deposits)-$6,806
30
Settlement- Percentage
31
Expenses- 3rd Party Vendors-$500
32
Beverage Revenues- 80% of drop @ $18/$4,190
33
34
9/27/2023ShowSoul Asylum Settlement- Guarantee (net of deposits)-$6,806
35
Settlement- Percentage
36
Expenses- 3rd Party Vendors-$500
37
Beverage Revenues- 80% of drop @ $18/$5,737
38
39
ShowBeverage Cost of Goods Sold- Product 20%-$6,109
40
ShowArtist Deposits due ( for shows in 2 weeks)5-$3,781
41
9/22/2023PayrollBiWeekly Hourly Show E/Ees (+ E/EE burden)-$25,000
42
PayablesVarious-$6,250
43
44
9/27/2023Weekly Forecast Cash Balance- Books$283,399
45
46
WEEK of Thrs 9/28/23 to Wed 10/4/23
47
TicketsTicketing CoWeekly Sales- Online Advance Sales$55,825
48
TicketsVenue Box OfficeNight of Show Walk Up- Est 50qty/ show$6,250
49
50
51
9/28/2023ShowReplacements Settlement- Guarantee (net of deposits)-$6,806
52
Settlement- Percentage-$2,063
53
Expenses- 3rd Party Vendors-$500
54
Beverage Revenues- 80% of drop @ $18/$7,681
55
56
9/29/2023ShowGolden SmogSettlement- Guarantee (net of deposits)-$6,806
57
Settlement- Percentage
58
Expenses- 3rd Party Vendors-$500
59
Beverage Revenues- 80% of drop @ $18/$4,190
60
61
9/30/2023ShowTrickySettlement- Guarantee (net of deposits)-$6,806
62
Settlement- Percentage-$2,063
63
Expenses- 3rd Party Vendors-$500
64
Beverage Revenues- 80% of drop @ $18/$7,681
65
66
10/3/2023ShowAni DiFrancoSettlement- Guarantee (net of deposits)-$6,806
67
Settlement- Percentage
68
Expenses- 3rd Party Vendors-$500
69
Beverage Revenues- 80% of drop @ $18/$5,737
70
71
10/4/2023ShowWu Tang ClanSettlement- Guarantee (net of deposits)-$6,806
72
Settlement- Percentage
73
Expenses- 3rd Party Vendors-$500
74
Beverage Revenues- 80% of drop @ $18/$7,682
75
76
ShowBeverage Cost of Goods Sold- Product 20%-$6,091
77
ShowArtist Deposits due ( for shows in 2 weeks)5-$3,781
78
9/29/2023PayrollBiWeekly Salaried E/Ees (+ E/EE burden)-$3,606
79
10/1/2023Payables Rent & Occupancy Costs-$27,500
80
PayablesVarious-$6,250
81
82
10/4/2023Weekly Forecast Cash Balance- Books$290,560
83
84
WEEK of Thrs 10/5/23 to Wed 10/11/23
85
TicketsTicketing CoWeekly Sales- Online Advance Sales$45,825
86
TicketsVenue Box OfficeNight of Show Walk Up- Est 50qty/ show$6,250
87
88
89
ShowVariousSettlement- Guarantee (net of deposits)5-$34,031
90
Settlement- Percentage2-$4,125
91
Expenses- 3rd Party Vendors5-$2,500
92
Beverage Revenues- 80% of drop @ $18/$30,726
93
94
ShowBeverage Cost of Goods Sold- Product 20%-$5,702
95
ShowArtist Deposits due ( for shows in 2 weeks)5-$3,781
96
10/6/2023PayrollBiWeekly Hourly Show E/Ees (+ E/EE burden)-$25,000
97
PayablesVarious-$6,250
98
99
10/11/2023Weekly Forecast Cash Balance- Books$291,972
100