How to Track and Forecast Your Sales Commissions

Why Commission Tracking Matters

As a commission based agent, your income is variable. Without accurate tracking, you do not know where you stand financially. Without forecasting, you cannot plan for the future. Both are essential for professional and personal financial management.

Track Every Commission Source

If you represent multiple agencies or sell multiple products, each has its own commission structure, payment schedule, and reporting format. Centralise this information so you have a single view of your total income. Spreadsheets work initially, but as complexity grows, dedicated tools become necessary.

Zepys provides a centralised dashboard for agents to track commissions across all their agency relationships, eliminating the need to log into multiple portals and reconcile different reports.

Understand Your Commission Structures

For each product you sell, document the commission percentage, whether it is one time or recurring, the clawback period, any performance bonuses or accelerators, and the payment timeline. This information is the foundation of accurate forecasting.

Calculate Your Run Rate

Your run rate is your current annualised income based on recent performance. Take your last three months of commission income, average it, and multiply by four. This gives you a rough projection of where you are tracking for the year.

Update this monthly to catch trends early, both positive and negative.

Forecast Recurring Revenue

For trailing commissions, forecast future income based on your current book of business and historical retention rates. If you have 100 recurring accounts averaging $50 per month in commission and your annual retention rate is 90 percent, you can project approximately $54,000 in trailing commissions over the next year.

Pipeline Weighted Forecast

For new business, apply a probability to each deal in your pipeline based on its stage. An early stage opportunity might have a 10 percent probability while a verbal commitment has a 90 percent probability. Multiply each deal's commission value by its probability and sum them up for a weighted forecast.

Reconcile Monthly

Compare your actual commission payments against what you expected. Discrepancies happen more often than you might think, due to data entry errors, clawbacks, or miscalculated rates. Monthly reconciliation catches issues early and ensures you are paid what you are owed.

Plan Around Variability

Commission income fluctuates. Build a financial buffer of at least two to three months of expenses to smooth out the peaks and valleys. Knowing your tracking and forecast numbers makes it easier to build and maintain this buffer because you can anticipate lean periods before they hit.