For managers and members of University Science Fiction & Fantasy (USFANS) clubs, tracking the flow of club funds is crucial. Transparent and accurate financial records build trust with members, satisfy university auditing requirements, and ensure the club's long-term sustainability. The USFANS spreadsheet template is designed to simplify this process. Here’s a guide on how to use it effectively to track every recharge, payment, and refund.
1. Establishing Your Master Spreadsheet
Begin by setting up a dedicated spreadsheet (using Google Sheets or Excel) with the following core sheets:
- Summary Dashboard:
- Recharges/Income Log:
- Payments/Expenses Log:
- Refunds Log:
- Recharges/Income Log:
2. Tracking Recharges (Income)
Any time money enters the club treasury—from member dues, university allocations, event ticket sales, or merchandise—it must be logged immediately.
Key columns for your "Recharges" sheet:
| Date | Source | Description | Amount | Receipt/Proof | Logged By |
|---|---|---|---|---|---|
| 2023-10-26 | Member Dues | Fall Semester Dues Collection | $150.00 | Link to bank deposit slip | Treasurer |
Best Practice:
3. Logging Payments (Expenses)
All club spending, from pizza for a movie night to buying supplies for a convention booth, needs verifiable documentation.
Key columns for your "Payments" sheet:
| Date | Vendor/Payee | Purpose | Amount | Approval | Receipt Attached |
|---|---|---|---|---|---|
| 2023-11-02 | Local Pizza Co. | Monthly Meeting Food | $65.48 | President OK | Yes |
Best Practice:
4. Recording Refunds
Refunds can be easy to overlook but are essential for accuracy. This includes returning overpaid dues or reimbursing a member for an approved purchase.
Key columns for your "Refunds" sheet:
| Date Issued | Recipient | Related Expense/Reason | Amount | Method | Confirmation |
|---|---|---|---|---|---|
| 2023-11-05 | Jane Smith | Reimbursement for poster printing | $25.00 | Venmo | Transaction ID #XYZ123 |
Best Practice:
5. Ensuring Accuracy and Verification
The true power of this system comes from regular reviews and reconciliation.
- Weekly Updates:
- Monthly Reconciliation:
- Shared Access:
- Annual Audit:
- Monthly Reconciliation:
Conclusion
A well-maintained USFANS financial spreadsheet is more than just a record-keeping tool; it's a foundation for responsible governance. By diligently tracking every recharge, payment, and refund, your club ensures accurate and verifiable spending. This clarity prevents disputes, secures funding, and allows everyone to focus on what matters most—enjoying the world of sci-fi and fantasy together.