The College Fest Treasurer's Guide: Managing Ticket Revenue & Passing Faculty Audits

The Responsibility of the Student Treasurer

Being elected Treasurer of a college club, technical chapter, or fest committee is a major leadership responsibility. You are not only managing festival cash flow—you are accountable to faculty advisors, university deans, and external sponsors.

At the conclusion of every festival, student treasurers must submit a Financial Settlement Report. Discrepancies between claimed ticket sales and actual bank deposits can freeze club funding for years.

Here is how student treasurers use Spark to build an airtight, audit-proof financial record.

---

1. The Anatomy of an Audit-Proof Event Ledger

Auditors and faculty committees look for four essential data points for every rupee collected: 1. Traceable Identity: Full Name, College Roll Number, and verified Email. 2. Verified Banking Reference: The 12-digit UTR for UPI payments or receipt ID for cash. 3. Exact Price & Discounts: The base tier price, any applied promo code, and the final recorded amount. 4. Approval Timestamp: Who on the student committee approved the payment and when.

---

2. Eliminating Spreadsheet Discrepancies

When student clubs use Google Forms: Attendees accidentally type wrong amounts (e.g., entering ₹30 instead of ₹300). Organizers accidentally overwrite cell formulas. * Offline cash collected at physical desks never gets recorded, leading to missing funds.

In Spark, every transaction is logged in an immutable PostgreSQL database: All price mutations require an explicit override reason. Free and promo-discounted tickets are explicitly flagged with the discount percentage and voucher code. Walk-in cash payments are recorded via the Box Office Desk*, creating an immutable audit trail.

---

3. Generating the Post-Event Audit Pack

At the conclusion of your event: 1. Open /dashboard/events/:id and navigate to the Registrations tab. 2. Click Export CSV to download the verified transaction ledger. 3. Spark exports a structured spreadsheet containing: `ticket_code` attendee_name `email` & `phone` college `tier_name` payment_method (direct_upi, cash, free) `payment_reference` (12-digit UTR) discount_amount & final_price * approved_at 4. Attach this export directly to your bank account statement. Every rupee deposited corresponds to an approved ticket code, enabling immediate faculty sign-off.