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:
tracks things people buy for the house. If you buy something, add it there.
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.
summarizes your expenses, payments, and what you owe/are-owed.

We are in month:
00
3
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
3
Checks received
1
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 - 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
1
Search
Person
Move-In
Expenses
Dues
Dues - Expenses
Paid
Net Due
Checks received through
1
AD
Adam Davis
10/1/17
$150.45
$360.00
$209.55
$44.55
$165.00
October
2
FM
Felix Marlin
9/1/17
$176.53
$540.00
$363.47
$453.44
-$89.97
November
3
JB
James Booth
9/1/17
$805.43
$540.00
-$265.43
-$175.43
-$90.00
November
4
JD
Joel Davis
9/1/17
$945.72
$540.00
-$405.72
$0.00
-$405.72
August
5
PR
Polly Rose
9/1/17
$200.00
$540.00
$340.00
$340.00
$0.00
November
There are no rows in this table
$2,520.00
Sum
-$420.69
Sum

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.