The Situation
A mid-size financial services firm offering company registration, MSME loans, and funding advisory had grown to over 110 people across sales, backend delivery, and support functions. The business was winning clients. The operations were not keeping up.
Everything ran on Google Sheets and WhatsApp. There were dozens of spreadsheets - one for leads, one for projects, one for payments, one for commissions - none of them connected, none of them consistently maintained, and none of them visible to the people who needed them most.
The 70-person sales team was closing deals. But the moment a deal closed, the chaos began. Backend teams - handling document preparation, presentation creation, compliance work, and website development - had no formal way of knowing a project had started. Someone had to manually tell them. If that message got missed, delayed, or sent to the wrong person, the project sat idle.
Payments added another layer of complexity. Clients paid in parts. Some long-term clients received certain services complimentary. Sales commissions had to be calculated per department - a sales person's commission applied only to their department's portion of the invoice, not the full project value. None of this was tracked automatically. It was tracked manually, imperfectly, and usually late.
Approvals made it worse. Tasks requiring sign-off from a team lead or the CEO had no formal routing. Someone had to know to ask, find the right person, wait for a response, and then manually communicate the outcome back down the chain.
The management team spent significant time every week not managing - but chasing. Chasing status updates, chasing approvals, chasing payment reconciliations, chasing commission calculations.
The Diagnosis
Four structural problems were identified:
No single source of truth. Every department maintained its own version of the data. Spreadsheets diverged. Nobody trusted any single record because nobody could be sure it was current.
No formal task assignment or notification. Tasks existed informally but ownership was unclear. There was no mechanism to formally assign work, notify the right person, and track completion. Communication was the process - and communication was the bottleneck.
No workflow structure. There was no defined operational path from a closed sale to a completed and delivered project. Each project followed a slightly different route depending on who happened to be managing it that day.
No financial automation. Payment tracking, commission calculations, and invoice management were all manual processes running across disconnected spreadsheets. They were time-consuming, error-prone, and always behind.
What We Implemented
The solution was built on Frappe - an open-source enterprise platform - configured specifically for how this business operated across all four problem areas.
CRM and Sales Pipeline
The full client journey was mapped and built into Frappe CRM - from initial lead through prospect qualification to customer conversion. Every sales person had a structured pipeline with clear stages. Leads no longer lived in a spreadsheet. They lived in a system that tracked every interaction, every follow-up, and every deal stage automatically.
Quotations were standardised and generated directly from the CRM. When a deal closed, the system moved the client to customer status and automatically triggered the project creation - no manual handoff required.
Invoicing and Payment Management
Frappe's accounting module was configured to handle the full billing complexity of this business. Partial payments were tracked against the correct invoice. Complimentary services for long-term clients were recorded accurately without affecting revenue reporting. Each payment was allocated to the correct department automatically - ensuring that commission calculations were based on the right figures from the start.
Commission Calculation
Sales commissions were configured as automated rules within the system. Each sales person's commission was calculated against their department's portion of the invoice value only - not the full project amount. What previously required manual calculation at the end of each month now ran automatically and accurately.
Project and Task Management
Every closed deal triggered an automatic project in Frappe's project module - pre-populated with the correct tasks based on the services sold. Tasks were automatically assigned to the relevant department. Team members received system notifications the moment a task was ready for them. No manual message required.
Task dependencies were configured so work flowed in the correct sequence. The presentation team knew when the brief was ready. The development team knew when the design was approved. The compliance team knew when the documents were in order. The system managed the sequencing - not the managers.
Approval Workflows
Tasks requiring sign-off from a team lead or the CEO were configured with formal approval workflows. When a task reached an approval stage, the relevant approver received an automatic notification, reviewed within the system, and approved or returned the task with comments. The outcome was automatically communicated back to the team member. Management was no longer in the communication chain - they were in the decision chain only.
Department Structure and Access Control
Clear departmental hierarchies were defined within the system. Role-based access control ensured each department had visibility of its own work only. The sales team saw the pipeline. The backend teams saw their assigned tasks. The accounts team saw the financials. The management team had full visibility across everything. No department was working in another department's space.
HRMS Module
HR operations were migrated from spreadsheets into Frappe's HRMS module. Attendance, leave management, employee records, and payroll inputs were centralised in one place. The HR and accounts team no longer maintained separate spreadsheets for employee data.
SOPs for Every Role
Standard operating procedures were written for every department and every key role in the business. Not generic documentation - specific, step-by-step guides built around how this business operates, with this system, at this stage of growth. Every process that previously lived in someone's head was documented, reviewed, and published.
The Outcome
The business moved from a state where every project required manual intervention at every step to a state where operations ran through a structured, automated system.
Projects start the same day deals close. The manual handoff from sales to backend was eliminated. Deal closure triggers project creation and task assignment automatically.
Backend teams work from a system, not a message. Task notifications replaced WhatsApp follow-ups. Teams know what they are working on, when it was assigned, and what is coming next - without anyone having to tell them.
Management escalations dropped significantly. Approval workflows handled routing automatically. The CEO and team leads review and decide - they no longer spend time being the communication layer between teams.
Payment and commission accuracy improved immediately. Partial payments, complimentary services, and department-specific commission calculations run automatically. The manual reconciliation process at month end was eliminated.
The full operation is visible in one place. For the first time, management had a single accurate view of the pipeline, active projects, task completion, financials, and team capacity - without pulling data from multiple spreadsheets.
New staff onboarded faster. SOPs gave every new hire a clear reference for how their role operates. Onboarding no longer depended on whoever happened to be available to explain things verbally.
Services Delivered
- ·Operational audit and systems diagnosis
- ·Frappe CRM - lead to customer pipeline
- ·Quotation and invoice management
- ·Partial payment and complimentary service tracking
- ·Automated commission calculation by department
- ·Project and task management with automatic assignment
- ·Approval workflow design and configuration
- ·Department structure and role-based access control
- ·HRMS - attendance, leave, and employee records
- ·SOP creation for all departments and roles
- ·Team training and system handover