# Company Loan Report

### **Report Module Guide: Company Loan Report**

#### **Module Location**

#### Finance > Reports > Company Loan Report

#### **Module Objective**

#### The **Company Loan Report** module is used to generate a detailed report of all loan activities received by the company. This report can be used to view a list of new loans received as well as the details of installment payments that have been made, making it important for tracking and managing total loan liabilities.

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

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

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

- #### **Based on**:
    
    
    - #### This is the primary filter to select the type of report you want to see:
    - #### **Loan Receipt**: To display a list of new loans received by the company in a period.
    - #### **Loan Installment**: To display a list of loan installment payments that have been made.
- #### **Status**:
    
    
    - #### Filter loans by their status, for example, **Fully Paid** or those still outstanding/active.
- #### **Date**:
    
    
    - #### Specify the **From** and **To** date range to define the report's period.

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

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

#### Define the parameters you need, especially selecting the report type in the **Based on** filter and specifying its date range.

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

#### After all parameters are set, click one of the two buttons at the bottom:

- #### **\[Display Report\]**: To preview the loan report directly on your screen.
- #### **\[Export to MS Excel\]**: To download the report data in an Excel file format.

### **3. Reading the Report (Report Content)**

#### The generated report will be a list of loan transactions according to the filters you have selected.

#### This report displays important details such as:

- #### Lender
- #### Initial loan amount
- #### Details of Installments that have been paid
- #### Remaining loan balance
- #### Loan status

### **Tips & Important Notes**

- #### Use this report to monitor the company's total loan debt and to track its payment schedule.
- #### This report is a recapitulation of the data created in the **Loan Receipt** module and its installment payment module.
- #### This is a crucial report for **Finance Management** to manage liabilities and plan for cash outflows.