Introduced Invoice Based Commission Spreadsheet Report

Prev Next

Introduced Invoice Based Commission Spreadsheet Report

 

Overview

The Invoice Based Commission report is a newly introduced spreadsheet in Zenople that enables users to calculate and review person-level commissions for any given period. This report provides a detailed, invoice-level breakdown of commissions, ensuring transparency and accuracy in commission calculations.

Why it matters:
 Accurate commission tracking is critical for performance evaluation and payroll compliance. This feature allows businesses to monitor commissions based on actual invoice data, improving financial accuracy and operational efficiency.

Key Benefits:

  • Efficiency: Quick access to commission details grouped by salesperson.
  • Accuracy: Uses Commission Rate directly from Transaction User Type for precise calculations.
  • Compliance: Ensures correct commission computation based on payment or invoice dates.

Functionality

Report Name

Invoice Based Commission

Display In

RMS

Report Type

Spreadsheet

Report Description

This report provides a detailed view of commissions calculated per invoice, filtered by date range, user, and mode. It groups data by Person with subtotals for Invoice Amount, GP, Commission, and GP For Commission, using Commission Rate directly from the Transaction User Type.

Report Parameters

Field Name

Field Type

Required?
 (Y/N)

Default Value

Date From

Date Picker

Y

-

Date To

Date Picker

Y

Today's Date

User

Multi-Select Dropdown

N

All

Mode

Dropdown

N

-

Report Columns

Column Name

Description

Person

Name of the person (salesperson) associated with the invoice

Role

Role of the person

Customer

Name of the customer

Department

Department associated with the invoice

Invoice#

Invoice number

Invoice Date

Date of the invoice

Invoice Amount

Total amount of the invoice

GP

Gross Profit (Invoice Amount – Cost)

Amount Paid

Amount paid on the invoice

%Paid

Percentage paid ((Amount Paid / Invoice Amount) × 100; 0 if Invoice Amount = 0)

GP For Commission

GP × (%Paid / 100)

Commission Rate

Rate pulled directly from Transaction User Type

Commission

GP For Commission × Commission Rate

Office

Office location

GPP for Commission

GP for Commission /Invoice Amount) * 100

 

Additional Information

  • Date Parameter Logic: 
    • If Mode = Actual, data is based on the organization’s payment date.
    • If Mode = Forecast, data is based on the invoice date.

Disclaimer

This report is intended for informational purposes only. Ensure that commission calculations comply with your organization’s policies and applicable regulations.