Group Expense Accounting Template v1.1

	A	B	C	D	E	F	G	H	I	K	L	M	N	P	Q	R	S	T
1	Group Expense Accounting Template :. Artisan Analysis .: v1.1		www.ArtisanAnalysis.com/tools
2	Getting started: (1) Review the sample items, then clear them out. (2) Enter your group's names at right. (3) Track all shared expenses in the log below.									Overall Balance:				381.39	-131.92	-207.57	-41.90	0.00
3	Your Trip Name Here		Amount			who paid				on behalf of				Balance (green = credit, red = debt)
4	Date	Item	Value	Currency	Dollars	Ma	Fr	Jo	Dy	Ma	Fr	Jo	Dy	Marley	Franklin	Joplin	Dylan

5	7/30	EXAMPLE: one person paid for entire group	100.00		100.00	1				1	1	1	1	75.00	-25.00	-25.00	-25.00	0.00
6	7/30	EXAMPLE: one person paid for part of group	100.00		100.00	1					1	1		100.00	-50.00	-50.00	0.00	0.00
7	7/30	EXAMPLE: multiple people split group expense	100.00		100.00	1	1			1	1	1	1	25.00	25.00	-25.00	-25.00	0.00
8	7/30	EXAMPLE: uneven splitting of payment	100.00		100.00			3	1	1	1	1	1	-25.00	-25.00	50.00	0.00	0.00
9	7/30	EXAMPLE: uneven splitting of expense	100.00		100.00	1					1	1	2	100.00	-25.00	-25.00	-50.00	0.00
10	7/30	EXAMPLE: direct transfer of cash	100.00		100.00				1			1		0.00	0.00	-100.00	100.00	0.00
11	7/30	EXAMPLE: another currency	100.00	Euros	136.00	1				1	1	1	1	102.00	-34.00	-34.00	-34.00	0.00
12	7/30	SCENARIO: split the bill for dinner, but amounts owed are adjusted by each person's food cost	65.00		65.00	1	1	1	1	8	12	14	15	5.64	0.33	-2.32	-3.65	0.00
13	7/30	SCENARIO: a taxi ride, paid by everyone contributing as much cash as they happen to have	25.00		25.00	5	8	10	2	1	1	1	1	-1.25	1.75	3.75	-4.25	0.00
14
15
16
17
18
19
20
21
22
23
24
25
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