Home Automating Commissions with Excel & Velixo

Automating Commissions with Excel & Velixo

Jason Potoka
Tips & Tricks
3 min

The Commission Conundrum

Sales commissions are undoubtedly one of the best methods of incentivizing your team to reach and exceed revenue targets. Pizza parties and dress-down days are great, but that extra income at the end of each month or quarter is the true motivation to succeed in a competitive market.

There is a lot of work that goes into correctly calculating commissions and processing payments in a timely manner to keep management and sales happy. There are systems that offer basic commission calculations functionality and even some that offer the ability to manage unique incentives and splits, but those tend to require added cost and, likewise, added complexity.

The worst-kept secret in the world of fancy software and ERP systems is that no platform will ever fully replace Microsoft Excel. We’ve seen countless Excel users who are achieving incredible feats in their workbooks due to its familiarity, powerful functionality, and ease of use. The drawback to using Excel (without Velixo) for commission calculations is that someone needs to export sales data and salesperson information from your ERP to a workbook before performing the necessary calculations and verifying results.

In this post, we highlight how Velixo, our Excel add-in, is the ideal solution for efficiently and accurately managing commissions.

Automate Calculations with Velixo

Velixo allows you to query your ERP data (including customer invoices) right into your spreadsheet, sparing your sales manager or accounting team the burden of the manual export or copy-pasting process. The data will be up-to-date, and you will have the benefit of Excel acting as the user-friendly presentation layer for your ERP data.

In our sample below, Velixo is pulling in the data we need to calculate commissions for March 2019. We can easily choose to pay by invoice date or payment date and use cell F7 to select if calculations should be based on net sales, gross sales, or gross profit. If you have unique incentives or commission splits, just remember that you are still in Excel! All the flexibility you know and love means that you don’t need to pay an ERP developer or ask your IT team to write or update custom reports.

They are called “workbooks” for a reason. Let Excel and Velixo do the heavy lifting!

Push Data to the ERP

Automating commission calculations with live drillable data provides significant time savings and ensures that your figures will be accurate. But the benefits of Velixo do not end there. Our writeback functionality allows users to create and import records to your ERP right from your workbooks. Click here to learn more about the benefits of pushing data from Excel to your ERP with writeback.

So what does this mean for commissions? Once Excel has calculated the proper commission amounts for each salesperson, all you need to do is click “Perform Writeback.” Velixo will create AP bills for each salesperson in your ERP, allowing your team to continue their proper workflow and pay the sales team. This reduction in data entry is why our users report a 250% increase in efficiency with writeback.

See our short video below to learn how you can easily pull and push data right from Excel, saving lots of time and effort each month in commission calculations and payments!

Want to Learn More?

If you are spending a lot of time in Excel managing reporting and calculations alongside your ERP, Velixo can boost your efficiency and streamline your daily tasks. To learn more about how our customers are using Velixo to bring their ERP data to life in Excel, click here to schedule a demo.

This content was prepared by Presales Leader. Our team creates product marketing content including blog posts, videos, and click-through demonstrations that are tailored to your specific vertical market. We also offer subscription-based presales support for the entire presales process. We work closely with your sales team to provide maximum results and support throughout the entire sales cycle. If you would like to explore how we can help your business grow with high-quality product marketing content and/or strong end-to-end presales support, visit our website at Presalesleader.com.


Velixo Newsletter

Subscribe to our newsletter to receive news and announcements.