What Are Commission Formulas For?
If you are using spreadsheets to calculate commissions, you are probably:
- Use messy nested conditions
- Reference cells by name or position
- Have multiple sheets with v-tables, etc.
If someone shifts cells, adds a column, or includes hidden rows of data, the output may be incorrect, or you may get errors such as "#NUM!", etc.
In addition, you may need to split master calculation spreadsheets into individual statements. This creates further potential for error as references may break, the wrong data may be copied, etc.
Sales Cookie lets you use formulas to control every aspect of commission calculations. Those formulas can be filtering formulas, crediting formulas, reward formulas, etc. Formulas are only required when you want to override Sales Cookie's default behavior.
Sales Cookie formulas naturally operate on a per-transaction and/or per-payee basis. For example, if you have 1,000 transactions across 100 payees, the same formulas can be used to calculate commissions per-transaction and per-payee, using the same data processing logic. There is no need for you to split your master spreadsheet into individual ones.
Using formulas, you can create clean data processing scripts which are not subject to all the limitations of a spreadsheet. In the example below, we are calculating a per-transaction commission amount. This logic will automatically run for each credited transaction. We can assign variables and re-use them in our calculations. We also have an early exit condition (IFEX statement), as well as a flow-control using WHEN statements.
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 Debug Formulas?
You can use debug mode to understand how formulas are applied to a sample transaction or sample payee. You will see how each formula statement was evaluated against your sample transaction or user (payee). Debugging Formulas - Sample Transaction To ...How Can I Adjust An Individual Transaction's Commission
This article only applies to per-transaction rewards. Many commissions are paid in aggregate (ex: $1000 payout for reaching a milestone), and so there isn't a per-transaction commission amount. The same applies is you use the portion method to ...Error - Your Plan Contains Advanced Formulas Which Must Be Approved By Us
Applicability This error applies to the following situation: A plan was configured by our technical team You altered formulas within the plan Some of those formulas contain {{...}} expressions Your calculation is failing with this error Impact This ...How Can I Claw Back Commissions?
Sometimes, you may incur cancellations, non-payment, etc. There are 3 primary ways you can claw back previously paid commissions. In this article, we describe some pros and cons of each approach. Add a Negative Transaction Setup a Claw Back Formula ...