Auto Finance Canada, a leading car dealership and financing company, required a centralized system to analyze employee performance and track sales data. Initially, all data was stored in Excel sheets, making it difficult to manage, analyze, and scale. The AFC App was developed to solve these challenges by automating data tracking, integrating with AirTable, and providing real-time insights to the CEO and senior management.
This system is built using Next.js and AirTable, ensuring scalability, automation, and easy data accessibility. The platform continues to evolve, with upcoming features such as a sales point system and a reward store for employees.
✅ Real-Time Employee Sales Tracking – Analyze individual and team sales performance.
✅ Automated Data Synchronization – Direct integration with AirTable for live data updates.
✅ Performance Analytics Dashboard – CEO and managers can track revenue, deals, and targets.
✅ Gross Revenue & Sales Insights – Monthly comparisons and division-wise breakdowns.
✅ Team & Division Performance Ranking – Compare employees, teams, and branches.
✅ Point System & Rewards (Upcoming) – Sales reps earn points based on revenue generated.
🔹 Frontend & Backend: Next.js
🔹 Database & Data Management: AirTable (Replaces Excel-based tracking)
🔹 API Integration: AirTable API for data synchronization
🔹 Authentication: Secure user access for executives & managers
🔹 Deployment: Hosted on Firebase