How Can I Analyze Liabilities?
Definition
A liability is the difference between an estimated and actual commissions.
Example:
- An estimated of $100 was issued to rep "John Doe" on deal #123
- Only $20 has been paid to "John Doe" on this deal so far
- As a result, there is a liability of $80
Alternative definitions exist:
- Actual commissions can also be called "paid commissions"
- Estimated commissions can also be called "earned commissions", "expected commissions", "on-payment commissions", etc.
- Liabilities can also be called "holds", "withheld commissions", "pending commissions", etc.
Why Analyze Liabilities?
Analyzing liabilities:
- Helps you forecast potential commission costs (budgeting)
- Helps you identify deals which haven't fully converted
- Helps you answer questions from reps about "missing" commissions
Please note that not all estimated commissions may be paid - for example:
- You issue estimated commissions when invoices are open
- An invoice is open and an estimated commission was issued
- However, this invoice was never paid by the client, so no actual commission was issued
- Or the invoice was partially paid by the client, so the actual commission was less than estimated
- No additional payment is expected on this invoice
Sales Cookie provides you with options to choose which liabilities are meaningful and which should be ignored.
Liability Report
To analyze liabilities:
- Navigate to Reports > Get Report
- Select "Liabilities Report"
In this example:
- We are analyzing liabilities for all payees
- We are only interested in liabilities from estimated commissions issued in the last 6 months
- We want to group liabilities by customer, without any further grouping
- We want to see the full list of transactions with a liability
- We can click on tiles to expand or contract them
- We can click on transactions to see more details
Advanced Options
The following describes advanced options:
- Exclude deactivated user commissions
- When users are terminated, estimated commissions may never be paid. You may choose to ignore liabilities associated with terminated users.
- Include negative commission liabilities
- This option includes liabilities from deals with negative estimated commissions. For example, if an estimated commission was -$100, but only -$10 was issued in actual commissions, a liability of -$90 remains.
- Exclude partially paid commissions
- Sometimes, an actual commission was issued, but is less than estimated. For example, a rep received an actual commission of $90 instead of $100 estimated because a discount was given to the customer. This option allows you to focus on deals without any actual commission paid.
- Only show partially paid commissions
- Sometimes, an actual commission was issued, but is less than estimated. For example, a rep received an actual commission of $90 instead of $100 estimated because a discount was given to the customer. This option allows you to focus on deals with some actual commission paid.
- Use latest commission estimate
- Check this option if your plans are repeatedly re-estimating commissions, and so multiple estimates are issued on the same deal. We will lookup the latest estimates instead of normally calculating the sum of estimated commissions. This is uncommon.
- Ignore liabilities lower than <value>
- Sometimes, the actual commission may differ from the estimated commissions by a few cents due to rounding errors, exchange rate conversion, etc. This option allows you to ignore small liabilities which may be distracting.
- Plans
- This option lets you narrow down your analysis to a specific set of plans. Make sure to select both plans issuing estimated commissions AND actual commissions. This could be 2 or more plans, or the same plan.
Applicability
The liability report only works when the estimated and actual commissions are issued on the same transaction.
For example, it will not work if you have this configuration:
- Estimated commissions are issued on "closed won" SalesForce opportunities
- Actual commissions are issued on paid QuickBooks Online invoices.
Reach out to support for assistance.
Helping Reps Track Liabilities
Sales Cookie has the ability to show withheld commissions to your reps - learn more
here.
Related Articles
Commission Software Checklist
Don't be fooled by slick demos. Can other providers really handle your data and your commission structure? Ask the right questions. Choosing Commission Software At Sales Cookie, we want you to make an informed decision. The reality is that many of ...
How Can I Enable Revenue Analytics For My Reps?
Why Enable Revenue Analytics? Revenue Analytics provide a unique understanding of your organization's revenue and sales performance. Revenue Analytics help identify your best and worst customers. Using Revenue Analytics, you can identify top ...
How Do Advanced SQL Statements Work?
What Are Advanced SQL Statements? Our technical team may configure advanced SQL statements which operate directly against the database. This is done a/ for performance reasons, b/ to perform complex queries spanning multiple entities, or c/ to ...