---
title: "Introduced Invoice Based Commission Spreadsheet Report"
slug: "introduced-invoice-based-commission-spreadsheet-report"
updated: 2025-12-31T12:15:13Z
published: 2025-12-31T12:15:13Z
canonical: "zenoplesupport.aqore.com/introduced-invoice-based-commission-spreadsheet-report"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://zenoplesupport.aqore.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduced Invoice Based Commission Spreadsheet Report

## 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.