Shared Expense Tracker (for Housemates!)

Explore

Community Fund Tracker

Hey there! Each resident pays $180/month to the community fund and receives discounts or reimbursements for things they've bought for the house. Joel runs the accounting, so direct your questions (and checks!) to him. Here's how it works:

⁠

Community Fund Tracker⁠

tracks things people buy for the house. If you buy something, add it there.

⁠

Checks received⁠

tracks payments to and from the fund. Positive amounts are checks that you've given Joel, and negative amounts are what Joel's given you. When a check is written acknowledging a discount or reimbursement, Joel stamps the corresponding items in the CF Tracker with a "Reimbursed On" date.

⁠

Per-person balance⁠

summarizes your expenses, payments, and what you owe/are-owed.

We are in month:

⁠

i.e. checks are due through the month of

November

⁠

Fund Summary

Utilities so far:

@PG&E 9/21 @Cal Water 9/28 @PG&E 10/22 @Cal Water 10/27

⁠

Utilities costs:

$500.32

⁠

Expenses:

$1,777.81

⁠

Total costs:

$2,278.13

⁠

Community Fund income (through end of

November

⁠

$2,520.00

⁠

(note: this is expected income, not "checks received")

Community Fund balance:

$241.87

⁠

(note: not all utilities and expenses for November are in yet)

Community Fund Tracker

Community Fund Tracker

⁠

Checks received

Checks received

⁠

What everyone's spent and owes:

"Net Due" is the important number - it's how much money you should pay Joel to be even through

November

⁠

If you want to see how something is calculated, click the

⁠

in the column header.

Other columns:

"Expenses" are what you listed in the

Community Fund Tracker⁠

- it's what the house should pay you back for.

"Dues" are your total Community Fund dues from your move in through

November

⁠

"Paid" is the total you've written Joel checks for.

Per-person balance

Per-person balance

Person

Move-In

Expenses

Dues

Dues - Expenses

Paid

Net Due

Checks received through

Adam Davis

10/1/17

$150.45

$360.00

$209.55

$44.55

$165.00

October

Felix Marlin

9/1/17

$176.53

$540.00

$363.47

$453.44

-$89.97

November

James Booth

9/1/17

$805.43

$540.00

-$265.43

-$175.43

-$90.00

November

Joel Davis

9/1/17

$945.72

$540.00

-$405.72

$0.00

-$405.72

August

Polly Rose

9/1/17

$200.00

$540.00

$340.00

$0.00

November

There are no rows in this table

$2,520.00

Sum

-$420.69

Sum

⁠

Fund Summary

Community Fund Tracker

Checks received

What everyone's spent and owes:

Per-person balance

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.