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.
Applicability
If you do not have estimated commissions, there is no financial liability, since there are no "earned" or "potential" commissions. Please reach out to our team if you would like to establish estimated commissions.
Also, we only support liability reporting when actual commissions and estimated commissions are issued on the same records. If, for example, estimated commissions are issued over sales records, but actual commissions are issued over payment records, the liability report will not work and will always show 100% liability. Our team is working to improve liability reporting for this type of scenario. Withholdings shown on incentive dashboards however will reflect liability correctly for this scenario.
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.
- Also apply date range to actuals
- By default, estimated commissions from the selected period, are compared to all actual commissions (regardless of period). This option makes it possible to also restrict actual commissions to the same specified period. For example, if you selected "This Quarter", when this option is checked, we will compared estimated commissions from this quarter vs. actual commissions from this quarter. Without this option checked, we will compared estimated commissions from this quarter vs. actual commissions from <any period>.
- 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 ...