Introduction
- This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from Sage Evolution, 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: Open the Transactional Export Utility
- Launch Sage Evolution.
- Log in to your company database.
- Navigate to General Ledger > Transactions > Transactional Export Utility.
Step 2: Configure Export Filters
- In the export utility window
- Select the date range for the transactions you want to export.
- Choose the GL accounts or leave blank to include all.
- Ensure the export type is set to Detailed (not Summary).
- Verify that zero balance accounts are included (if available).
Step 3: Select Required Fields
Make sure the following fields are included in the export. These fields are typically pre-selected in the utility, but double-check before exporting:
- Account Name
- Account Code
- Transaction Date
- Transaction Number/Reference
- Transaction Balance
- Transaction Description (Optional but recommended)
Step 4: Export the Report
- Click Export.
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Save the report securely for upload to the Validis portal.
How to Extract a Trial Balance Report
Step 1: Locate the Trial Balance Report
- Open Sage Evolution and log in to your company database.
- Navigate to General Ledger > Reports > Trial Balance.
Step 2: Configure Report Parameters
- In the Trial Balance report window
- Select the report type: choose XLS Trial Balance – Detail if available.
- Set the date range to match your reporting period (e.g., month-end, quarter-end).
- Choose the accounting basis (accrual or cash), if applicable.
- Ensure that zero balance accounts are included (if available).
Step 3: Generate and Export the Report
- Click Preview or Run to generate the report.
- Once the report is displayed, click Export to Excel.
- Check that all expected account balances are included.
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Save the report securely for upload to the Validis portal.