Shared House Accounts (Dealing with people Moving Out/Moving In)

	A	B	C	D	E	F	G	H	I	J	K	L
1			Alice	Bob	Carol	Dave	Alice	Bob	Carol	Dave	error
2		Currently Owed	£0.00	£13.66	£150.76	-£164.42					£0.00
3			PAID				LIABILITY				check
4		Subtotals	£83.63	£427.87	£632.28	£166.16	£83.63	£414.21	£481.52	£330.58	£0.00	Comments

5	29/01/2010	Carried over from previous accounts		£6.67	-£6.67						£0.00	Carol owed Bob £6.67 from previous spreadsheet
6	03/02/2010	Cleaner		£20.00			£6.67	£6.67	£6.67		£0.00	Bob paid the cleaner £20, expense shared
7	10/02/2010	Cleaner			£20.00		£6.67	£6.67	£6.67		£0.00	Carol paid her this week
8	14/02/2010	Toilet paper, kitchen paper, washing up liquid	£5.32				£1.77	£1.77	£1.77		£0.00	Alice bought shared supplies
9	17/02/2010	Cleaner	£20.00				£6.67	£6.67	£6.67		£0.00	Alice paid cleaner
10	17/02/2010	bleach and washing up liquid		£2.20			£0.73	£0.73	£0.73		£0.00	Bob bought kitchen stuff
11		Alice moves out, and Dave moves into her room
12	24/02/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00	Bob pays cleaner, but expense now divided between Bob, Carol, Dave
13	06/03/2010	Cleaner			£10.00	£10.00		£6.67	£6.67	£6.67	£0.00	Carol lends Bob £10 so that he has enough to pay the cleaner
14	06/03/2010	kitchen towels			£1.43			£0.48	£0.48	£0.48	£0.00
15	28/02/2010	1 year's internet		£230.00				£76.67	£76.67	£76.67	£0.00	Bob takes out an internet subscription on a one year contract, to share
16	10/03/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
17	10/03/2010	Bob bought Carol lunch		£9.00					£9.00		£0.00
18	17/03/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
19	21/03/2010	6 months water bill				£156.16		£52.05	£52.05	£52.05	£0.00
20	22/03/2010	Council Tax Jan - Feb			£109.17			£36.39	£36.39	£36.39	£0.00
21	22/03/2010	Council Tax Feb - Mar			£129.63			£43.21	£43.21	£43.21	£0.00
22	22/03/2010	Gas and Electricity bill 23 Jan - 05 Mar			£366.72		£61.12	£122.24	£122.24	£61.12	£0.00	Utility bill covers some time when Alice was living there, some time when Dave was
23	24/03/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
24	30/03/2010	Kitchen towels and washing up liquid			£2.00			£0.67	£0.67	£0.67	£0.00
25	31/03/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
26	07/04/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
27	14/04/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
28	21/04/2010	Cleaner		£20.00				£6.67	£6.67	£6.67	£0.00
29	29/04/2010	Alice clears her debt by paying Carol	£58.31						£58.31		£0.00	Alice gives Carol £53.81 to cover her debt to everyone
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