# Distributor Sales Return

### **Sales Return Reports**

#### This section covers reports related to the process of returns or the sending back of goods from customers.

### **Report Module Guide: Distributor Sales Return Report**

#### **Module Location**

#### Sales > Reports > Sales Return Reports > Distributor Sales Return Report

#### **Module Objective**

#### The **Distributor Sales Return Report** module is used to generate an analytical report that calculates the return rate or percentage for a distributor. This report compares the total sales value (turnover) with the total value of returned goods to provide an overview of the distributor's performance and potential product issues in the market.

### **1. Report Parameters (Filter)**

#### The main page of this module is a form containing various parameters to customize the report that will be generated.

![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/m9Nimage.png)

#### Here is an explanation for each parameter:

- #### **Customer**:
    
    
    - #### The primary filter to select the **Distributor** to be analyzed from the dropdown (e.g., A. Karim,Bp-palembang).
- #### **Period**:
    
    
    - #### Specify the **From** and **To** date range to pull sales and return data within that period (e.g., August 1, 2025, to August 31, 2025).
- #### **Item Category**:
    
    
    - #### Use this list box to focus the analysis on specific product categories.

### **2. Steps to Generate the Report**

#### **Step 1: Set Report Parameters**

#### Select the **Customer** (Distributor) you wish to analyze and define the **Period** range.

![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/8usimage.png)

#### **Step 2: Generate the Report**

#### After all parameters are set, click one of the two buttons in the bottom-left section of the page:

- #### **Display Report**: To preview the analysis report directly on your screen. 
    
    #### ![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/TuVimage.png)
- #### **Export To MS Excel**: To download the report data in an Excel file format. 
    
    #### ![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/aQ6image.png)

### **3. Example of the Report View**

#### After you click, the system will generate a summary report like the following.

![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/Dxpimage.png)

#### **Report Explanation**: This report presents a summary of the return rate per **Product Category** for the selected distributor.

#### **Key Columns for Analysis**:

- #### **Total Omset (Total Turnover)**: Shows the total sales value to the distributor in that period.
- #### **Total Return**: Shows the total value of goods returned by the distributor.
- #### **Percentage %**: Shows the return percentage, calculated from **(Total Return / Total Turnover) x 100%**.

### **Tips & Important Notes**

- #### Use this report to **evaluate distributor performance**. A high return rate may indicate problems with sales activities, product handling, or logistics at the distributor level.
- #### This report is an important analysis tool for **Sales Management** to manage distributor relationships and performance.
- #### To get an accurate percentage calculation, ensure all sales and return transactions for that distributor have been recorded correctly in the system.