# Cash Book Request Aging Report

### **Report Module Guide: Cash Book Request Aging (CBR Aging)**

#### **Module Location**

#### Finance > Reports > Cash Book Request Aging Report

#### **Module Objective**

#### The **Cash Book Request Aging** report module is used to generate an aging report of all **Cash Book Requests** that are still outstanding (unresolved). This report is crucial for monitoring cash advances given to employees and for identifying which requests have passed the deadline for submitting an accountability report (SPJ).

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

- #### **Request For**:
    
    
    - #### Select **All** to display all requestors, or **Select** to choose a specific requestor.
- #### **As of**:
    
    
    - #### Specify the reference date ("as of" date) for the calculation of the request's age.
- #### **Aging Period**:
    
    
    - #### Set the time range for each aging bucket in the report, for example, 1-30 days, 31-60 days, 61-90 days, and so on.
- #### **Type**:
    
    
    - #### Select **Summary** to see totals per requestor, or **Detail** to see the breakdown per request document.

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

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

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

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

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

- #### **\[Display Report\]**: To preview the cash request 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 outstanding cash requests, classified by their age since the request date.

#### This report displays:

- #### The **Requestor's Name** (labeled as Customer Name in the example).
- #### The **total amount** of outstanding requests (labeled as Invoice Amount in the example).
- #### A breakdown of that total amount into the **aging columns**, such as **1 - 30, 31 - 60, 61 - 90,** and **>90** (more than 90 days).

### **Tips & Important Notes**

- #### Use this report to **follow up with employees** who have not yet submitted their accountability report (SPJ) for the cash advance they received.
- #### This report is a crucial **internal control tool** for Finance Management to manage cash that is outstanding outside of the cashier/bank.
- #### This report's data comes from the **Cash Book Request** module for requests whose status has not yet been closed by the **Cash Book Request Declaration** module.