Financial Reconciliation Dashboard

Canadian Elite Volleyball Academy — Development Update • April 26, 2026

Financial Reconciliation Dashboard

What & Why

Extend the existing Bookkeeper Portal with revenue-by-event-type analytics, outstanding balance tracking, Stripe-to-ledger reconciliation, and exportable financial reports. The academy is replacing external tools and needs a single dashboard where the bookkeeper can see the full financial picture, catch discrepancies between Stripe and the local ledger, track overdue payment plans, and export data for accounting.

Done looks like

• Bookkeeper Portal gains a "Revenue by Event Type" breakdown card showing income grouped by event type (Private Lesson, Camp, Training Team, etc.) with date-range filtering
• An "Outstanding Balances" section listing families with unpaid or overdue payment plan installments, sortable by amount and due date, with the ability to mark installments as paid or send a payment reminder
• A "Stripe Reconciliation" view that compares Stripe checkout sessions against local ledger entries, flagging any mismatches (paid in Stripe but not recorded locally, or vice versa)
• CSV export buttons for: full ledger, revenue-by-event-type summary, outstanding balances, and payroll summary — each respecting the current date-range filter
• All amounts display with Saskatchewan tax breakdown (GST 5% + PST 6%) where applicable

Out of scope

• Invoicing/receipt generation (future work)
• Automated dunning/collections beyond reminders
• Multi-currency support
• Changes to the Stripe checkout flow itself

Relevant files

- - - - - -

Canadian Elite Volleyball Academy
elitevolleyball.training