# Bank Product Report

### **Report Module Guide: Bank Product Report (Aging Report)**

#### **Module Location**

#### Finance > Reports > Bank Product Report

#### **Module Objective**

#### The **Bank Product Report** module is used to generate an **aging report** for various banking products or instruments, such as a **Bank Guarantee**. This report helps management monitor how long these financial instruments have been outstanding or active.

### **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 parameter:

- #### **1. As of**:
    
    
    - #### Specify the reference date ("as of" date) for the calculation of the bank product's age.
- #### **2. Aging Method**:
    
    
    - #### Select the basis to be used for calculating the age, for example, **"Calculate Number of Days Since Bank Product Date"**.
- #### **3. Aging Period**:
    
    
    - #### Set the time range for each aging bucket in the report, for example, the first 30 days, the second 60 days, and the third 90 days.

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

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

#### Define the parameters you need, especially the reference date and the aging ranges you wish to analyze.

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

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

- #### **\[Display Report\]**: To preview the bank product aging 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 banking products classified by their age.

#### This report displays details such as the **Bank Product Number, Bank Product Date,** and **Amount**. The **Amount** value of each product will be placed in one of the aging columns on the right (e.g., 0 - 30, 31 - 60, etc.) according to the result of its age calculation.

### **Tips & Important Notes**

- #### Use this report to monitor financial instruments that have been outstanding for a long time and may require attention or follow-up.
- #### This report is a recapitulation of the data managed in the **Banking Product** module.
- #### This is an important monitoring report for the **Treasury team** to manage the company's portfolio of banking instruments.