Function #6: Calculate Commissions for paid invoices

Zoho Books helps you automate the process of calculating and recording commissions paid to sales persons using custom functions. We've written a script that computes the commission amount based on the percentage of commission you enter and creates an expense correspondingly.

Prerequisites:

Add a new custom field of type Percent with the name "Commission Percent" for the Invoices module. In this field, you will enter the percentage of commission you ought to give the salesperson.

Custom Function:

Now, head to Settings -> Automation -> Custom Functions -> +New Custom Function and add the function script. You can find the script in this GitHub link.

As you'll notice, we have entered "Petty Cash" as the Paid Through account for the expense in the script. If you wish to track it using a different account, replace Petty Cash by the appropriate account name.

Also, don't forget to create the Connection. Without it, the function won't execute. Here's how to create a connection in Zoho Books:

Workflow Rule:

Go to Settings -> Automation -> Workflow Rules -> +New Workflow Rule and configure the rule as follows to animate the custom function on the right occasion.

Once you choose the appropriate custom function at the end, save the workflow.

This will streamline the process of tracking commissions and increase efficiency by hampering the possibility of any human errors and saving you time.

Some of you might want to record the commission amount as bill or have other additional requirements in this workflow. In such a case, I recommend you to contact us for a customized function.

Regards,

Divya R

Zoho Books

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Sticky Posts
[Webinar] Understanding the New Invoice Management Systems
Join industry expert CA Pritam Mahure as he discusses the importance of the new Invoice Management System (IMS) and its impact on taxpayers. Topics Covered: - Concept of IMS and pre-requisites - Applicability and Restrictions on Invoices/Records for IMS
Latest Updates of the 53rd GST Council Meeting & Its Business Implications
Join industry expert CA Venugopal Gella as he discusses the importance of 53rd GST Council Meeting, the latest notifications and changes introduced by the Finance Act 2024. Register Now: https://zoho.to/GST_Webinar
Best practices for financial year-end closing with Zoho Books | Free Webinar
Ready to close your year-end finances like a pro? Join our free webinar and learn how Zoho Books helps you maintain clean accounts, carry forward balances, and get geared up for the new financial year. Register now - https://zoho.to/9f1
Zoho Books will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100
Master the art of budgeting with Zoho Books | Free Webinar | 4th & 5th March 2024
We're thrilled to launch the Zoho Books monthly webinar series! Don't wait to conquer your finances in 2024! Budgeting can be easy with Zoho Books. Join our FREE webinar and learn how to set and track goals, master budgeting, and unlock insights to make