
Growth exposed the limits of spreadsheet tracking
A Singapore real-estate agency had grown its sales activity and agent team. Staff managed the sales pipeline and commission calculations in spreadsheets. Manual updates took time, introduced errors and left management waiting for a current view of team performance.
The agency asked Zolution to customise CRM around two connected needs: managing the sales process and calculating commissions. Agents needed to follow the agency’s sales procedures. Finance needed commission information for month-end payment, while managers needed to see the latest business position without waiting for spreadsheet updates.
Sales information through to commission work
- 01Sales progress
Agents follow the agreed sales process
- 02Next steps
Notifications to agents and customers
- 03Forecast
Agents view commission forecasts
- 04Month end
Finance extracts commission data
Sales procedures inside Zoho CRM
Zolution used Zoho CRM’s automation and process engine to support the agency’s standard sales procedures. Notifications reminded agents and customers about the next steps. Staff from different departments could collaborate on deals in the system, and management could access current performance information.
Commission forecasts and month-end extraction
Agents could monitor their commission forecasts in CRM. At the end of the month, the finance department could extract commission data for payment to agents. Pipeline information and commission work therefore formed part of the same CRM implementation.
Bring the commission rules to the workshop
If your agency faces a similar problem, prepare a completed deal and the calculation finance used to pay it. Add one deal that needed an adjustment. Use them to answer the following scoping questions:
- Which event updates the forecast, and which event permits payment?
- How are shared deals or different agent arrangements calculated?
- Who can amend an amount after finance has reviewed it?
- What happens when a transaction is cancelled or a payment arrives late?
Agree those rules with sales and finance before configuring the fields, reminders and month-end output.
