Introduction
- This guide helps you download the General Ledger and Trial Balance reports from SAP S/4 HANA for Validis.
- 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 SAP S/4 HANA system.
- Navigate to the General Ledger section.
- Click on "Display Line Items in General Ledger".
Step 2: Set Report Parameters
- Select the appropriate ledger for your accounting method from the Ledger drop-down menu (Default 0L).
- Select "All Items" from the Status drop-down.
- Select "Date Range" from the Posting Date drop-down and enter the appropriate date range for the accounting period you wish to see.
Step 3: Configure Columns
- Click the Settings cog icon on the right-hand side of the screen.
- In the Columns tab, select the following columns by clicking the tick box next to each:
- G/L Account
- G/L Account Long Name
- Journal Entry
- Journal Entry Date
- Journal Entry Item Text
- Journal Entry Type
- Journal Entry Created By
- Posting Date
- Amount in Company Code Currency
Step 4: Generate and Export the Report
- Click the "Go" button to run the report.
- Once the report has run, click the "Export to Spreadsheet" button on the right of the screen.
How to Extract a Trial Balance Report
Step 1: Locate the Reporting Section
- Log in to your SAP S/4 HANA system.
- Navigate to the "Reports" or "Financial Reports" section.
- Search for or select "Trial Balance" from the report list.
Step 2: Configure Report Parameters
- Select the relevant company or legal entity, if applicable.
- Set the date range to match your reporting period (e.g., monthly, quarterly, year-end).
- Choose the accounting basis (accrual or cash), if required.
- Apply filters such as departments or dimensions, depending on system capabilities.
Step 3: Generate and Export the Report
- Click "Run" or "Generate" to view the report.
- Check that all expected account balances are included.
- Export the report in .CSV, .XLSX, or .XLS file format.