Commission reconciliation tool for a yoga content creator
- Location
- British Columbia, Canada
- Year
- 2023
- Engagement
- Profitability Improvement: Labour Optimization
Large yoga content creator and training school experiencing high growth in subscriptions and revenue. Teachers were paid on varying commissions by product / class type resulting in confusion and inaccurate financials. Company required reconciliation file for purchases and commissions.
Our team validated product list and commission schedule. We standardized course nomenclature and other data for consistency and flawless calculations. We built Google Sheet linked to other APIs, USD/CAD exchange rate, and dynamic commission/product schedule.
Case snapshot
File had near-seamless integration with existing data exports and tracking
Trades, Home and Personal Services
Case snapshot
Functionality was expanded for additional scope over 3 months
Trades, Home and Personal Services
Case snapshot
Client requested additional work to streamline other finance processes
Trades, Home and Personal Services