# Consolidated Document Report

### **Module Guide: Consolidated Document Report**

#### Module Location

#### Settings > Accounting Settings > Consolidated Document Report

#### Module Purpose

#### The **Consolidated Document Report** module serves as a reporting tool that can combine and display a list of document transactions from multiple companies within a group. Unlike financial consolidation, this module focuses on merging lists of documents (such as Sales Invoices, Purchase Orders, etc.) for the purpose of cross-company review, auditing, and control within a specific period.​

#### 1. Main View (Report Filter Page)

#### The main page is a filter interface where the user can define the criteria for the report they wish to generate.

### View Explanation

- #### **Report Filter**:
    
    
    - #### **Document Type**: A dropdown to select the specific type of document you want to display (e.g., Purchase Invoice, Sales Return).
    - #### **Company**: A dropdown to select one, several, or all companies whose data will be combined in the report.
    - #### **Start Date**: The beginning date of the report's period range.
    - #### **To Date**: The ending date of the report's period range.
- #### **Action Buttons**:
    
    
    - #### **Search**: A button to execute and generate the report based on the selected filters.
- #### **Results Table**: An area at the bottom that will display the list of documents after the search is performed. If no data matches, this area will show a message like "...No Data...".

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

- #### Access the **Consolidated Document Report** module.
- #### Select the relevant **Document Type** from the dropdown.
- #### Choose the **Company(s)** you want to include in the report.
- #### Define the date range by filling in the **Start Date** and **To Date**.
- #### Click the **Search** button.
- #### The system will display a combined list of all documents that match your criteria from all selected companies.

### **3. Integrated Workflow & Business Process**

- #### **Audit and Control Tool**: This module is not used for transactions but is purely for reporting. It provides management or audit teams with a "helicopter view" of the volume and list of specific transactions across the entire corporate group.​
- #### **Intercompany Reconciliation**: It can be used as an initial step to identify intercompany transactions by displaying all related documents (e.g., all sales and purchase invoices) on a single screen for further analysis.
- #### **Centralized Visibility**: It makes it easier for the head office to monitor operational activities in subsidiary companies without having to log into each company's database separately.​

### **4. Tips & Important Notes**

- #### Ensure you select the filters, especially **Document Type** and **Company**, correctly to get a relevant report.
- #### Use a specific date range to speed up the report generation time, especially if the transaction volume is very large.
- #### This report is very useful for internal and external audit teams when performing sampling or transaction verification at the group level.
- #### Access to this module is typically given to users at the corporate or management level who have the authority to view data from multiple companies.