Commission

Commission structures in ERPNext reveal a fundamental design decision: the system tracks commission calculations separately from accounting entries. While Sales Orders, Delivery Notes, and Sales Invoices can all display commission amounts, these calculations exist purely for reporting purposes without creating any General Ledger impact. This separation between operational tracking and financial recording requires bookkeepers to understand both what ERPNext calculates automatically and what must be recorded manually.

Calculations

ERPNext's commission functionality calculates and tracks commission amounts across sales documents but deliberately avoids creating accounting entries. The system maintains fixed commission percentages, calculates amounts based on transaction values, and can split commissions among multiple parties. However, every commission-related General Ledger entry must be created manually through Journal Entries or Payment Entries.

This separation serves important control purposes. Commission calculations often require review and approval before becoming financial obligations. Sales may be subject to returns, payment collection requirements, or performance thresholds that affect final commission amounts. By keeping commission tracking separate from accounting, organizations maintain flexibility in recognition timing and payment terms.

Example: Chelsea Fruit Company processes a $10,000 wholesale order. ERPNext automatically calculates the 5% commission ($500) and displays it on the Sales Invoice, but no accounting entries are created. The bookkeeper separately determines when and how to record the commission obligation.

The commission tracking system provides several reports that become source documents for manual accounting entries. The Sales Person Commission Summary shows internal team commissions, while the Sales Partner Commission Report tracks external partner amounts. Sales Analytics can include commission columns, and territory-wise commission analysis helps evaluate regional performance. These reports support accounting decisions but do not constitute accounting records themselves.

Internal Sales Team Commission

Internal sales team commission typically flows through payroll systems rather than accounts payable. ERPNext allows commission allocation to multiple team members with configurable percentage splits, tracking these amounts without creating financial obligations until payroll processing.

Commission Tracking Structure

Sales Team entries cascade through the sales cycle, starting from the Customer master where default commission structures can be defined. These defaults flow to Sales Orders when created, then inherit to Delivery Notes and finally Sales Invoices. The commission can be calculated on either gross transaction value or net total after discounts, depending on your commission agreement structures.

Example: Chelsea Fruit Company's sales structure for a $50,000 equipment sale:

ERPNext displays these calculations on the Sales Invoice but creates no journal entries. The amounts exist only in the sales tracking system and require manual extraction for payroll processing.

Payroll Integration

Since ERPNext does not automatically flow commission data to payroll, bookkeepers typically extract commission data from reports and incorporate it into payroll calculations. This process varies by organization, with some processing commission monthly while others use quarterly or annual cycles.

Monthly Payroll Entry (including commissions for multiple employees):

Organizations often maintain spreadsheets reconciling ERPNext commission reports to payroll records, though this reconciliation could also be built within ERPNext using custom reports or doctypes.

Period-Close Accruals

Organizations that recognize commission expense when earned rather than when paid may choose to record period-close accruals. This approach matches commission expense to the period of sale, though some organizations find the timing difference immaterial and skip this step.

Period-Close Accrual Entry:

Following Period Reversal:

Sales Partner Commission

Sales Partners represent external parties selling your inventory, requiring different accounting treatment than internal sales teams. Partner commissions create accounts payable obligations that flow through the standard vendor payment process.

Sales Partner as Supplier

ERPNext's design requires Sales Partners to also exist as Suppliers for payment processing. This structure enables standard accounts payable workflows, provides tax compliance capabilities such as 1099 reporting for US organizations, and leverages existing purchase approval processes.

The setup process involves creating a Sales Partner record with the appropriate commission rate, then creating a corresponding Supplier record. Many organizations create a dedicated "Sales Partner" supplier group to distinguish these vendors from regular suppliers. The Sales Partner field on the Customer record links specific customers to their sales channel, ensuring commission calculations flow through all related transactions.

Basic Commission Recognition

The standard workflow uses the Sales Partner Commission Report to determine payment amounts, then creates manual accounting entries:

Example: FreshMart sells $75,000 of Chelsea Fruit products in October, with 12% commission rate set on the Sales Partner record.

The Sales Invoices to end customers show commission calculations but create standard revenue entries:

At period-close, the bookkeeper reviews the Sales Partner Commission Report showing $9,000 commission and creates a Journal Entry:

When paying the commission through Payment Entry:

E-Commerce and Marketplace Commission

E-commerce and marketplace sales represent a notable exception to traditional commission workflows. In these scenarios, the marketplace typically deducts commission at the point of sale and remits the net amount to the seller. This creates different accounting requirements since the commission is effectively paid through reduction of receipts rather than as a separate payment.

Example: Chelsea Fruit Company sells $5,000 of products through GreenGrocer.com marketplace, which charges 12% commission.

When the marketplace remits payment, they send $4,400 (sales less commission). The accounting entry reflects both the gross sale and the commission.

This pattern differs from traditional commission because the commission amount is known precisely at the transaction level and is immediately settled through the reduced payment. Many organizations integrate their e-commerce platforms with ERPNext through customization, automatically creating Sales Invoices with the appropriate commission calculations. The precision of per-transaction commission data makes this an excellent candidate for automation through custom development, including the reconciliation process.

For organizations with multiple marketplace channels, tracking commission by platform helps evaluate channel profitability.

Consignment Sales Accounting

Consignment arrangements involve selling suppliers' inventory for a commission, creating complex accounting scenarios where inventory ownership, valuation, and commission recognition intersect. Unlike standard sales where you own inventory until sale, consignment items remain the supplier's property until the final customer purchase.

Standard Consignment Flow

The consignment cycle requires careful tracking, which can be managed within ERPNext using standard features creatively or through customization:

Example: Tropical Growers Ltd. consigns 500 boxes of exotic fruit to Chelsea Fruit Company with a 25% commission arrangement. The fruit will retail for $30 per box.

Step 1: Receive Consignment Inventory

Organizations typically track consigned inventory using a Stock Entry with appropriate valuation:

Using 75% of retail (selling price less commission) maintains proper inventory valuation and margin reporting, though organizations may choose different valuation approaches based on their agreements.

Step 2: Sale to End Customer

Selling 50 boxes at $30 each using standard sales process:

Sales Invoice:

Delivery Note (automatic with stock update):

Step 3: Settlement with Supplier

Creating purchase documentation for consignment sold:

Purchase Invoice (net of commission):

The $375 difference between sales revenue ($1,500) and supplier payment ($1,125) represents the 25% commission retained, appearing in gross margin rather than as a separate commission expense.

Consignment Reconciliation

Regular reconciliation between physical inventory, consignment liability, and supplier statements helps maintain accuracy. While this reconciliation can be built within ERPNext using custom reports or tracked externally in spreadsheets, the key information includes beginning balances, receipts, sales, returns, ending balances, commission earned, and amounts due to suppliers.

Commission Scenarios Requiring Customization

Many commission structures common in business require customization or external tracking as ERPNext does not support them natively. Understanding these limitations helps identify when custom development may be beneficial.

Unsupported Commission Features

ERPNext's commission functionality is limited to flat percentage rates applied uniformly across transactions. More complex structures require additional development or manual tracking:

Tiered Commission Rates involve progressive rates based on volume, such as 10% on first $10,000 and 12% on amounts above. Since ERPNext only supports single percentage rates, organizations track cumulative sales separately and calculate tier-based adjustments manually or through customization.

Minimum Guarantees ensure partners receive specified minimum commission regardless of sales volume. Organizations tracking guarantees compare actual commission from ERPNext reports to guaranteed amounts and create adjustment entries for any shortfall.

Commission on Collections calculates commission based on payments received rather than invoiced amounts. Since ERPNext calculates commission on invoice value, organizations wanting collection-based commission track payment applications separately and calculate commission outside the system or through custom development.

Product-Specific Rates vary commission by item or category within transactions. While ERPNext supports different rates by Sales Partner or Sales Person, varying rates by product requires customization or manual calculation.

Using Sales Taxes and Charges for Commission

Some organizations attempt to use the Sales Taxes and Charges table to automatically create commission expenses on each invoice. While this approach can create immediate expense recognition, it has significant limitations. The commission expense posts to the General Ledger but does not link to the Supplier/Sales Partner for payment processing. This method also complicates sales tax calculations if not configured carefully and may not properly handle returns or adjustments. It is appropriate in an ecommerce context where the same transaction structure will be reused many times.