A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Instructions: Save your own copy of this sheet by clicking File > Make a Copy. Record your monthly expenses in the chart below. Add and subtract roommates as needed. Adjust the split percentages as needed for your circumstances. | |||||||
2 | Brought to you by Accredited Debt Relief | |||||||
3 | ||||||||
4 | Rent / Utilities | Who Paid | Amount | How to split | Roommate 1 | Roommate 2 | Roommate 3 | Roommate 4 |
5 | Rent | Roommate 1 | $2,500.00 | Variably | 40% | 20% | 20% | 20% |
6 | Amount to reimburse the roommate who paid | $1,000.00 | $500.00 | $500.00 | $500.00 | |||
7 | Electric Bill | Roommate 2 | $70.00 | Equally | 25% | 25% | 25% | 25% |
8 | Amount to reimburse the roommate who paid | $17.50 | $17.50 | $17.50 | $17.50 | |||
9 | Gas Bill | Roommate 3 | $120.00 | Equally | 25% | 25% | 25% | 25% |
10 | Amount to reimburse the roommate who paid | $30.00 | $30.00 | $30.00 | $30.00 | |||
11 | Internet | Roommate 4 | $70.00 | Equally | 25% | 25% | 25% | 25% |
12 | Amount to reimburse the roommate who paid | $17.50 | $17.50 | $17.50 | $17.50 | |||
13 | Other | $0.00 | Equally | 25% | 25% | 25% | 25% | |
14 | Amount to reimburse the roommate who paid | $0.00 | $0.00 | $0.00 | $0.00 | |||
15 | ||||||||
16 | ||||||||
17 | Variable Expenses | |||||||
18 | E.g. Groceries 3/10 | Roommate 1 | $275.00 | Equally | 25% | 25% | 25% | 25% |
19 | Amount to reimburse the roommate who paid | $68.75 | $68.75 | $68.75 | $68.75 | |||
20 | E.g. Household Products 3/15 | Roommate 3 | $55.00 | Equally | 25% | 25% | 25% | 25% |
21 | Amount to reimburse the roommate who paid | $13.75 | $13.75 | $13.75 | $13.75 | |||
22 | E.g. Friday Night Pizza and Beer | Roommate 4 | $40.00 | Equally | 25% | 25% | 25% | 25% |
23 | Amount to reimburse the roommate who paid | $10.00 | $10.00 | $10.00 | $10.00 | |||
24 | Other | $0.00 | Equally | 25% | 25% | 25% | 25% | |
25 | Amount to reimburse the roommate who paid | $0.00 | $0.00 | $0.00 | $0.00 | |||
26 | ||||||||
27 |