.

.

Twelve-month cash flowSan Jose Bike PartyFiscal Year Begins:Jul-09

.

.

Jul-09 [1]Aug-09Sep-09Oct-09Nov-09Dec-09Jan-10Feb-10Mar-10Apr-10May-10Jun-10Jul-10Total

.

Cash on Hand (beginning of month)0258313287371371371451481521554554761761

.

.

CASH-IN (Activity)Vendor

.

T-Shirts Profit DonationsKing of Campus Printing140

.

Volunteer Mtg DonationVolunteers648049

.

Scallywag registration feeParticipants245

.

July Rider Donations [2]Participants73

.

T-Shirts Profit DonationsKing of Campus Printing16017214080

.

Donation cans (4)Particpants130

.

Volunteer Meeting DonationsParticipants35

.

Volunteer Meeting Pizza304033

.

SubZero Bike Express contributionsBicycle Express207

.

.

.

TOTAL CASH-IN0 [3]6828030217500803040330207490

.

Total Cash Available (before cash out)0682338615462371371451481521554554761810761

.

Jul-09 [1]Aug-09Sep-09Oct-09Nov-09Dec-09Jan-10Feb-10Mar-10Apr-10May-10Jun-10Jul-10Total

.

CASH PAID OUTVENDOR

.

ScallyWag CopiesKinkos21

.

MegaphoneFrys88

.

Copyright feesGov't35

.

MegaphonesX3Harborfreight122

.

walkiesX6amazon117

.

Meeting CopiesKinkos11

.

July Ride CopiesKinkos20

.

Campbell Meeting RoomCampbell Library10

.

Spoke CardsSan Jose Printing164

.

Route SheetsKinkos2528

.

Volunteer Appreciation EventGrocery Outlet50

.

Megaphones (2) w/ batteries, hand counterHarbor Freight86

.

Plastic sign boards - 100 x 12" x 18"Port Plastics66

.

Paint for signs25

.

.

SUBTOTAL042425328910000000000

.

TOTAL CASH PAID OUT042425328910000000000

.

Cash Position (end of month)0258313287371371371451481521554554761810761

.

[1] Administrator: Make sure to insert dollar amount in appropriate month. For instance if you receive 25$ Cash in for August put it in the August Category…not March. The Same goes for Cash Paid Out.
[2] Administrator: Insert rows to insert more items
[3] Totals are calculated automatically.