Introduction
- This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from Oracle PeopleSoft, ensuring the data meets Validis' upload requirements.
- Reports should be exported in (.CSV), (.XLSX), or (.XLS) file format.
- File size must not exceed 100 MB.
- Reports must already contain the required fields without manual manipulation.
How to Extract a General Ledger Report
Step 1: Locate the General Ledger Report
- Log in to your Oracle PeopleSoft system.
- From the main menu, go to General Ledger > General Reports > Journal Entry Detail Report (for detailed transactions).
Step 2: Set Report Parameters
- Choose the Business Unit and Ledger you want to report on.
- Set the Date Range for the transactions (e.g., fiscal year, quarter, or custom period).
- Select the Detail Level as Detail to ensure transaction-level data is included.
- Ensure the following fields are selected or included in the output:
- Account Name
- Account Code
- Transaction Date
- Transaction Number/Reference
- Transaction Balance
- Transaction Description (Optional but recommended)
- If available, enable the option to Include Zero Balance Accounts.
Step 4: Generate and Export the Report
- Click Run to generate the report.
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Once the report is processed, go to the Report Manager to view the output.
- Save the report securely for upload to the Validis portal.
How to Extract a Trial Balance Report
Step 1: Locate the Reporting Section
- Log in to your Oracle PeopleSoft system.
- Navigate to General Ledger > General Reports > Trial Balance.
Step 2: Configure Report Parameters
- Select the appropriate Business Unit and Ledger.
- Set the Accounting Period or Date Range for the report.
- Choose the Accounting Basis (e.g., Accrual or Cash), if applicable.
- Ensure the following fields are included in the report output:
- Account Name
- Account Code
- Account Balance
- If available, enable the option to Include Zero Balance Accounts.
Step 3: Generate and Export the Report
- Click Run to generate the report.
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Access the Report Manager to retrieve the output.
- Check that all expected account balances are included.
- Save the report securely for upload to the Validis portal.