Invoice with Subtraction Formula Issue

	F	H	I	K	L	N	O	Q	R	V	Z	AD	AE	AG	AH	AL	AN	AP	AT	BB
1
2																				Rental
3		BINGO CA$INO - WICHITA KS																		Rental
4
5
6			Location										License #
7
8			Name of Org/Sponsor				Rockhounds						Emails
9
10			Date				11/19/2020						Sponsor Manager
11
12													Bingo Manager
13			Invoice #
14			Invoice #										Total Sponsors Running Bingo				6
15
16					20 SET MINIS
17
18						Mini % Payout Amount								Single = 60 2For1 = 120
19						50%								120
20
21						Cost			Beginning Balance	Unsold	Sold	Gross Receipts			Paper Cost	Total Faces		Tax On Paper
22
23		Mini Reg 2 for 1				$ 20.00			100	32	96	$ 1,920.00			48.96	11520		$ 23.04
24		TABLET 20 SET 2FOR1								28
25		Mini Set 1 Black				$ 4.00			5	5	0	$ -			0.000	0		$ -
26		Mini Set 2 Aqua				$ 4.00			10	10	0	$ -			0.000	0		$ -
27		Mini Set 3 Green				$ 4.00			20	20	0	$ -			0.000	0		$ -
28		Mini Set 4 Yellow				$ 4.00			20	20	0	$ -			0.000	0		$ -
29		Mini Set 5 Pink				$ 4.00			20	20	0	$ -			0.000	0		$ -
30
31										Game 1	Game 2	Game 3			Game 4			Total Pay
32		Mini Payout Schedule						Mini Set 1 Black		$ 48.00	$ 48.00	$ 48.00			$ 48.00			$ 192.00
33								Mini Set 2 Aqua		$ 48.00	$ 48.00	$ 48.00			$ 48.00			$ 192.00
34								Mini Set 3 Green		$ 48.00	$ 48.00	$ 48.00			$ 48.00			$ 192.00
35								Mini Set 4 Yellow		$ 48.00	$ 48.00	$ 48.00			$ 48.00			$ 192.00
36								Mini Set 5 Pink		$ 48.00	$ 48.00	$ 48.00			$ 48.00			$ 192.00
37
38					15 SET MINIS
39
40						Mini % Payout Amount								Single = 45 2For1 = 90
41						70%								45
42
43						Cost			Beginning Balance	Unsold	Sold	Gross Receipts			Paper Cost	Total Faces		Tax On Paper
44
45		Mini Reg 2 for 1				$ 15.00					0	$ -			0.00	0		$ -
46		TABLET 15 SET 2FOR1
47		Mini Set 1 Blue				$ 5.00					0	$ -			0.000	0		$ -
48		Mini Set 2 Grey				$ 5.00					0	$ -			0.000	0		$ -
49		Mini Set 3 Black				$ 5.00					0	$ -			0.000	0		$ -
50
51										Game 1	Game 2	Game 3			Game 4	Game 5		Total Pay
52		Mini Payout Schedule						Mini Set 1 Blue		$ -	$ -	$ -			$ -	$ -		$ -
53								Mini Set 2 Grey		$ -	$ -	$ -			$ -	$ -		$ -
54								Mini Set 3 Black		$ -	$ -	$ -			$ -	$ -		$ -
55
56				30 Pack/$5 cut 9on
57
58		(1) 9ons				$ 5.00			100	38	62	$ 310.00			$ 26.78	4464		$ 8.93
59
60		End of Night Speed Mini
61		2on5up				$ 5.00			50	50	0	$ -			$ -	0		$ -
62
63										Game 1	Game 2	Game 3			Game 4	Game 5		Total Pay
64		5 Games						Payout Schedule		$ -	$ -	$ -			$ -	$ -		$ -
65
66					Custom Bingo
67
68								Bingo Cards				Games
69								1on				1up
70
71						Cost			Beginning Balance	Unsold	Sold	Gross Receipts			Paper Cost	Total Faces		Tax On Paper
72		1on1up									0	$ -			$ -	0		$ -
73		TABLET
74
75	Game 1																		Total Pay
76	$ -																		$ -
77
78
79					Custom Bingo 2
80
81								Bingo Cards				Games
82								1on				1up
83
84						Cost			Beginning Balance	Unsold	Sold	Gross Receipts			Paper Cost	Total Faces		Tax On Paper
85		1on1up									0	$ -			$ -	0		$ -
86		TABLET
87
88	Game 1																		Total Pay
89	$ -																		$ -
90
91
92					Custom Bingo 3
93
94								Bingo Cards				Games
95								1on				1up
96
97						Cost			Beginning Balance	Unsold	Sold	Gross Receipts			Paper Cost	Total Faces		Tax On Paper
98		1on1up									0	$ -			$ -	0		$ -
99		TABLET
100