Introduction
- This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from Exchequer, 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 Exchequer system.
- Navigate to the Reports section.
- Select General Ledger Based and then General Ledger History.
Step 2: Configure Report
- Set the date range to match your reporting period (e.g., monthly, quarterly, year-end).
- Please ensure your report contains the following columns:
- Account Name
- Account Code
- Transaction Date
- Transaction Number/Reference
- Transaction Balance
- Transaction Description (optional but recommended)
Step 3: Generate and Export the Report
- Click OK to generate the report.
- From the Print Setup Panel, click the Excel tab.
- Under Export Options, uncheck both the Page Header and Report Totals options.
- Check that the Excel file contains the required fields listed above
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Select a location on your machine to save the file securely for upload to Validis.
How to Extract a Trial Balance Report
Step 1: Locate the Reporting Section
- Log in to your Exchequer system.
- Navigate to the Reports section.
- Select General Ledger Based > Trial Balance from the report list.
Step 2: Configure Report Parameters
- 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 the system's capabilities.
Step 3: Generate and Export the Report
- Click OK to generate the report.
- From the Print Setup Panel, click the Excel tab.
- Under Export Options, uncheck both the Page Header and Report Totals options.
- Check that all expected account balances are included.
- Export the report in (.CSV), (.XLSX), or (.XLS) file format.
- Select a location on your machine to save the file securely for upload to Validis.