Expense Report.xlsx

	A	B	C	D	E	F	G	H	I
1	Client Requests:
2	Request 1	Show total deposits for each payee
3	Request 2	Automatically enter transaction data for each payor to corresponding payor sheets
4
5
6	DATE	CATEGORY	DESCRIPTION	NOTES/KEY WORDS	BID AMOUNT	DEPOSIT	RECEIPTS	PAID BY	DATE
7	21-Nov-23	Tree Service	Tree Service	A Services		$ 500.00		8779 - J Entity
8	22-Nov-23	Tree Service	Tree Service	A Services		$ 500.00		Jn Z
9	22-Nov-23	Tree Service	Tree Service and Dumpster Cleaning	A Services		$ 500.00		Jn Z
10	25-Nov-23	Materials	Transaction #123	B Depot		$ 165.40		8779 - J Entity
11	26-Nov-23	Tree Service	Tree Service	A Services		$ 150.00		Jn Z
12	27-Nov-23	Materials	Receipt #123	C Depot		$ 45.28		1475 - Jn CC
13	27-Nov-23	Labor	Clean up and couch	A Services		$ 450.00		Jn Z
14	4-Dec-23	Materials	Transaction#124	B Depot		$ 189.80		1475 - Jn CC
15	11-Dec-23	Materials	Order # 123	B Depot		$ 496.02		1475 - Jn CC
16	21-Dec-23	Materials	D Smart Capital	D Services	$ 8,344.00	$ 2,000.00		Jn Z
17	11-Dec-23	Roof	E Guys	E Services		$ 1,500.00		1771 FC Contractor
18	11-Dec-23	Window and Door	E Guys	E Services	$ 1,630.00	$ 1,630.00		Jn Z
19	18-Dec-23	Demo	Demo	F Services		$ 1,485.00		Jn Z
20	18-Dec-23	Framing	WG	G Services	$ 550.00	$ 550.00
21	22-Dec-23	Materials	Tub and Faucet	C Depot		$ 463.00
22	4-Jan-24	Materials	Receipt #123	C Depot		$ 430.69
23	4-Jan-24	Materials	Transaction #125	B Depot		$ 407.56
24	8-Jan-24	Materials	Store #111	H Services		$ 14.98
25	9-Jan-24	Materials	Store #112	H Services		$ 76.25
26	9-Jan-24	Materials	Bathrooms Tiles and Mortar	H Services		$ 2,100.00
27	9-Jan-24	Materials	Receipt #001	C Depot		$ 737.56
28	9-Jan-24	AC	Trav	I Services	$ 3,700.00	$ 3,700.00
29	12-Jan-24	Dumpster	20-yard Dumpster	J Services		$ 475.00
30	15-Jan-24	Materials	Receipt #002	C Depot		$ 454.42
31	15-Jan-24	Labor	JN	J Services	$ 7,500.00	$ 1,500.00
32	15-Jan-24	Labor	Plumbing for New Bathroom	J Services	$ 4,500.00	$ 3,500.00
33	15-Jan-24	Materials	Flooring and Base Board	A Materials		$ 2,454.00
34	15-Jan-24	Labor	Stump Grinder	C Services		$ 500.00
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