Spreadsheet: 853868d1703833125-formula-to-calculate-net-expenses-per-person-sample-expense-report
Sheet: Expense Report

Sample Expense Report
 |  |  |  | 1. Enter all the names within your group --> | Name | A | B | C | D | E | F | G | H | I | J | K
 |  |  |  |  | Total Balance |  |  |  |  |  |  |  |  |  |  |  | <-- Do NOT touch
 |  |  |  |  | 7. Pay These People
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Do NOT touch
 |  | Be sure to fill them in accordingly (These are placeholder information right now.)
 | 2. Enter in transaction information | 3. Enter the Total Price | 4. Enter the TOTAL # of ppl you want to split with including the person who paid | This is a function. Do NOT touch. | 5. Write in the name of the person who paid(No Spaces) | 6. Checkbox who else was in the group for the transaction. (Do no include the person that paid)
# | Description | Price | # of people | Price Per Person | Who to Pay |  |  |  |  |  |  |  |  |  |  |  | <-- Do NOT touch. This autofills
1 | Expense 1 | 1 | 4 |  | A | False | True | True | True | False | False | False | False | False | False | False
2 | Expense 2 | 2 | 6 |  | A | False | True | True | True | True | True | False | False | False | False | False
3 | Expense 3 | 3 | 6 |  | A | False | True | True | True | True | True | False | False | False | False | False
4 | Expense 4 | 4 | 4 |  | A | False | True | True | True | False | False | False | False | False | False | False
5 | Expense 5 | 5 | 1 |  | A | False | True | False | False | False | False | False | False | False | False | False
6 | Expense 6 | 6 | 5 |  | A | False | True | True | True | True | False | False | False | False | False | False
7 | Expense 7 | 7 | 1 |  | A | False | False | False | False | False | False | False | False | False | False | False
8 | Expense 8 | 8 | 1 |  | A | False | False | False | False | False | False | True | False | False | False | False
9 | Expense 9 | 9 | 1 |  | A | False | False | True | False | False | False | False | False | False | False | False
10 | Expense 10 | 1 | 1 |  | A | False | False | False | True | False | False | False | False | False | False | False
11 | Expense 11 | 11 | 4 |  | A | False | True | False | True | True | False | False | False | False | False | False
12 | Expense 12 | 12 | 3 |  | A | False | False | True | True | False | False | False | False | True | False | False
13 | Expense 13 | 13 | 5 |  | A | False | True | True | True | False | True | False | False | False | False | False
14 | Expense 14 | 14 | 4 |  | A | False | False | True | False | True | True | False | False | False | False | False
15 | Expense 15 | 15 | 4 |  | A | False | True | False | False | True | True | False | False | False | False | False
16 | Expense 16 | 16 | 4 |  | A | False | True | True | True | False | False | False | False | False | False | False
17 | Expense 17 | 17 | 5 |  | A | False | True | True | False | True | True | False | False | False | False | False
18 | Expense 18 | 18 | 9 |  | A | False | True | True | True | True | True | True | True | True | False | False
19 | Expense 19 | 19 | 3 |  | A | False | True | False | True | False | False | False | False | False | False | False
20 | Expense 20 | 20 | 1 |  | A | False | False | False | False | False | False | False | True | False | False | False
21 | Expense 21 | 21 | 1 |  | A | False | False | False | False | False | True | False | False | False | False | False
22 | Expense 22 | 22 | 5 |  | A | False | True | True | True | True | False | False | False | False | False | False
23 | Expense 23 | 23 | 6 |  | A | False | True | True | True | True | True | False | False | False | False | False
24 | Expense 24 | 24 | 1 |  | A | False | False | False | True | False | False | False | False | False | False | False
25 | Expense 25 | 25 | 1 |  | A | False | False | True | False | False | False | False | False | False | False | False
26 | Expense 26 | 26 | 1 |  | A | False | False | False | False | False | False | False | False | True | False | False
27 | Expense 27 | 27 | 1 |  | A | False | False | True | False | False | False | False | False | False | False | False
28 | Expense 28 | 28 | 1 |  | A | False | False | False | False | True | False | False | False | False | False | False
29 | Expense 29 | 29 | 1 |  | A | False | False | False | False | False | False | False | False | True | False | False
30 | Expense 30 | 30 | 1 |  | A | False | True | False | False | False | False | False | False | False | False | False
31 | Expense 31 | 31 | 1 |  | A | False | False | False | False | False | False | False | False | True | False | False
32 | Expense 32 | 32 | 2 |  | A | False | False | False | False | True | False | False | False | False | False | False
33 | Expense 33 | 33 | 4 |  | C | True | True | False | True | False | False | False | False | False | False | False
34 | Expense 34 | 34 | 4 |  | C | True | True | False | False | True | False | False | False | False | False | False
35 | Expense 35 | 35 | 5 |  | C | True | True | False | True | True | False | False | False | False | False | False
36 | Expense 36 | 36 | 3 |  | C | True | False | False | False | True | False | False | False | False | False | False
37 | Expense 37 | 37 | 6 |  | C | True | True | False | True | True | True | False | False | False | False | False
38 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
39 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
40 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
41 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
42 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
43 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
44 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
45 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
46 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
47 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
48 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
49 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
50 |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False
 | GRAND TOTAL