Home

PeliKalc Broker Commission Calculation & Reporting System

PeliKalc™ provides food manufacturers the tools needed to easily calculate and report accurate payments to their brokers.   Detailed commission statements provide each broker the line item detail necessary to confirm the accuracy of their payments, including invoice detail, allowable deductions, credit memos and marketing payments.

PeliKalc™ was written by Greg Helland,  a food company COO, that also owns/operates a software company.  He originally wrote this system to solve the age old problem of accurately calculating and reporting broker commissions.

Advantages of PeliKalc™ incudes:

  • $$ Savings from processing detailed deductions such as:
    • Damage
    • Billbacks
    • Off invoice
    • Cash payment deductions
    • Marketing programs including deductions for coupons, etc.
  • No Reentry of Data: Uses existing data from your accounting system
  • Commission Savings: Average hard dollar savings of 5% on commissions due to accuracy of detailed tracking
  • Clerical Time Savings: Reduction in clerical time calculating and producing broker statements
    • Eliminates a myriad of spreadsheets that are maintained to calculate brokerage
    • Eliminates errors due to re-entry of or lack of visibility to data
  • Accuracy of Broker Payments increased
  • Gives higher visibility to this important expense category
  • Provides the financial tools needed to efficiently manage the broker network
  • Maintains all business rules and exceptions for each customer, item, broker and buying group
  • Maintains relationships between customers, brokers and master brokers
  • Handles exceptions to standard broker commissions
  • Flexibility: Processes broker commissions based upon invoice date or date paid
  • Handles broker commissions for re-distributer networks such as DOT
  • Reporting:
    • Audit reports for review before producing broker statements
    • Broker statements by broker
    • Broker statements by groups
    • PDF’s that can be attached to Accounts Payable entries for backup
    • Customer, broker and master broker relationship reports

Set up an online demo today for yourself or one of your team to see how PeliKalc™ can benefit your company.  Click Here to contact us.

 

More Information

Why Use PeliKalc™?

Food manufacturing and sales is a complex business. The many layers of distribution, redistribution, brokers, buying groups and sales people create a challenging environment when tracking the percentage that each layer demands.   The cost associated to brokerage in the food industry has traditionally been difficult and time consuming to calculate and audit.  Most food companies have very little visibility to this all important cost.

While sales teams are faithfully managing brokers and buying groups, the accounting team is trying to keep up with the minutia required to properly track and pay the brokers. This is further complicated when a re-distributor such as DOT Foods is inserted into the equation.  The re-distributor model adds more layers of payments, deductions, marketing programs and buying groups thereby complicating the brokerage cost accounting tasks.

Depending upon the size of the company tens of thousands to hundreds of thousands of dollars are lost annually to this seemingly benign function. Some companies calculate their brokerage costs on an item and invoice basis, daily dedicating people and spreadsheets to this function.  Other companies rely upon the brokers and buying groups to invoice them each month and do not regularly audit these charges.

Virtually every accounting system available today tracks one sales person to a customer and does not have the ability to add additional layers for brokerage commissions or buying group commissions. This is not a deficiency in these systems but rather a complex problem that accounting systems do not wish to address.

This has created an opportunity for a new application that aggregates data from other systems through a simple Excel spreadsheet import in order to calculate and monitor broker and buying group costs. The Brokerage Application affords the food company a system that can reduce their costs dramatically and increase accuracy and performance metrics.  Instead of maintaining brokerage percentages in a myriad of spreadsheets, the Brokerage Application maintains all of their business rules and exceptions for each customer, item, broker and buying group that will accurately maintain and calculate costs while giving high visibility to this important expense category.

Further, this visibility to the multiple layers and percentages that brokerage and buying groups cost the company gives management the tools to more intelligently negotiate brokerage contracts.

The first company that used this software went from two dedicated staff working in this arena down to one person spending about an hour a month to import and maintain brokerage calculations and produce a detailed brokerage and buying group statement for each entity involved. These statements were then used to enter accounts payable items into the accounting system.

Set up an online demo today for yourself or one of your team in order to see how PeliKalc™ can benefit your company.  Click Here to contact us.

Pictures

Pelikalc™ Application Views
click on images for full view

Main Window
Admin Menu
Reports Menu

Set up an online demo today for yourself or one of your team to see how PeliKalc™ can benefit your company.  Click Here to contact us.