Financial Reconciliation with Corsizio

What & Why

With Corsizio handling event registrations and payments externally, the admin team needs a clear, consolidated view of who has paid, who has outstanding balances, and how internal records line up with what Corsizio reports. Currently, payment data from Corsizio is synced into (per-attendee) and (per-event aggregates), and gets a payment status during sync — but there is no dedicated admin view to compare these sources, surface discrepancies, or manage outstanding balances.

This task adds a "Corsizio Reconciliation" section to the existing Bookkeeper Portal (which already has a Stripe Reconciliation tab), giving admins a single place to see financial alignment between Corsizio and the internal system.

Done looks like

New "Corsizio" sub-section within the Bookkeeper Portal's Reconciliation tab (alongside the existing Stripe reconciliation)
Summary cards showing: total Corsizio revenue vs internal registration revenue, number of matched/unmatched records, total outstanding balances
Per-event reconciliation table: each Corsizio-linked event shows Corsizio-reported revenue, internal registration totals, difference/discrepancy amount, and registration count comparison
Drillable per-event detail: clicking an event shows individual registrant payment records — Corsizio amount paid vs internal payment status, with visual flags for mismatches (e.g., Corsizio says paid but internal record says pending, or amount differences)
Outstanding balances view: list of registrations with pending/partial payment across all events, showing athlete name, event, amount owed, Corsizio pending amount, and last sync time
Ability to manually mark a registration as "Paid" or update payment notes directly from the reconciliation view (for cases where payment was confirmed outside the system)
A "Sync Now" button that triggers a fresh Corsizio sync for the selected event and refreshes the reconciliation data
Backend API endpoint that cross-references payment fields with payment fields and returns structured discrepancy data

Out of scope

Automatic payment collection or Stripe charging from this view
Modifying Corsizio data (read-only comparison)
Refund processing workflows
Historical reconciliation snapshots or audit trail of reconciliation actions
Changes to the existing Corsizio sync mechanism itself

Relevant files

- - - - -

Canadian Elite Volleyball Academy
elitevolleyball.training

Elite Academy

Sunday, April 19, 2026