# Debtor Ledger

### **Report Module Guide: Debtors Ledger**

#### **Module Location**

#### Accounts Receivable > Report > Debtor Ledger

#### **Module Objective**

#### The **Debtor Ledger** report module is used to generate the **Accounts Receivable Subsidiary Ledger**. This report presents a detailed list of all transactions (such as invoices, payments, and credit/debit notes) for each customer or all customers within a specific time period. It is a fundamental report for managing and reconciling customer receivable accounts.

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

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

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

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

- #### **Customers**:
    
    
    - #### Select **All** to display the debtors ledger for all customers.
    - #### Select **Selected** to display the debtors ledger for one specific customer.
- #### **Date**:
    
    
    - #### Specify the **Start Date** and **To Date** range to define the report's period (e.g., August 1, 2025, to August 31, 2025).
- #### **Status**:
    
    
    - #### Use this dropdown to filter transactions by their status.
- #### **Currency**:
    
    
    - #### Choose how currency values will be displayed, either in **Respective Currency** (original transaction currency) or **Base Currency** (company's base currency).

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

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

#### Select all the parameters you need, especially defining the **Date** range and the scope of **Customers** you wish to see.  
![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/2rjimage.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 debtors ledger report directly on your screen. ![image.png](https://manual.kokola.co/uploads/images/gallery/2025-08/scaled-1680-/uZ4image.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-/Tooimage.png)

### **Tips & Important Notes**

- #### The Debtors Ledger report is one of the most important reports in the **Accounts Receivable** module. Use it to see the complete transaction history per customer.
- #### This report is the basis for **reconciling the receivable balance** with the customer's records.
- #### Use the **Selected Customer** filter to focus on one customer when handling inquiries or billing disputes.