Reports must be in the accounting packages' native format, properly structured, include all required fields, and be free of formatting errors that could cause upload issues.
Introduction
- This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from Accounts IQ, 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 Accounts IQ account.
- Go to Reports > Report Manager.
- Under the GL category, select General Ledger Daybook by transaction or period date (alternatively, General Ledger Audit Trail can be used for a fuller audit view).
Step 2: Configure Report
- Set the date range or period, and company/entity if applicable.
- Please ensure your report contains the following fields:
- Account Code
- Account Name
- Transaction/Period Date
- Reference
- Debit / Credit
- Description
Step 3: Generate and Export the Report
- Run the report.
- Check that all expected transactions are included.
- 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 Reporting Section
- Log in to your Accounts IQ account.
- Go to Reports > Report Manager.
- Under the GL > Trial Balance category, select Trial Balance Standard Format (or Trial Balance DR/CR Format if separate debit and credit columns are needed).
Step 2: Configure Report Parameters
- Set the date range or period, and company/entity if applicable.
- Ensure zero balance accounts are included, if available.
- Verify the report contains these fields:
- Account Code
- Account Name
- Debit / Credit (or Balance)
Step 3: Generate and Export the Report
- Run the report.
- 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.
Uploading to Validis
Once both reports are downloaded, upload them through the Validis portal via Upload & Share.