How to export your General Ledger and Trial Balance ready for Upload & Share
Introduction
This guide explains how to export the General Ledger and Trial Balance reports from Accounts IQ in a format Validis can process, ready to upload through Upload & Share.
Export the reports in the format Accounts IQ produces natively. They need to be properly structured, contain all the required fields, and be free of the formatting errors that stop a file being read.
Before you begin, note the following:
- Reports should be exported as .CSV, .XLSX, or .XLS.
- File size must not exceed 100 MB.
- Reports must already contain the required fields, without any manual manipulation after export.
How to extract a General Ledger report
Step 1
Locate the General Ledger report
Sign in to Accounts IQ and go to Reports > Report Manager.
Under the GL category, select General Ledger Daybook by transaction or period date. If you need a fuller audit view, General Ledger Audit Trail can be used instead.
Step 2
Configure the report
Set the date range or period, and the company or entity if that applies to you.
Check that the report contains the following:
- Account Code
- Account Name
- Transaction or Period Date
- Reference
- Debit and Credit
- Description
Step 3
Generate and export the report
Run the report and check that every transaction you expect to see is there. Export it as .CSV, .XLSX, or .XLS, and save it somewhere secure ready to upload.
How to extract a Trial Balance report
Step 1
Locate the Trial Balance report
Sign in to Accounts IQ and go to Reports > Report Manager.
Under GL > Trial Balance, select Trial Balance Standard Format. If you need separate debit and credit columns, select Trial Balance DR/CR Format instead.
Step 2
Set the report parameters
Set the date range or period, and the company or entity if that applies. Include zero balance accounts if the option is available.
Check that the report contains the following:
- Account Code
- Account Name
- Debit and Credit, or Balance
Step 3
Generate and export the report
Run the report and check that every account balance you expect to see is there. Export it as .CSV, .XLSX, or .XLS, and save it alongside your General Ledger export.
Uploading to Validis
With both reports exported, upload them through the portal by following Upload & Share Journey (GL & TB). Do not open and edit the files first, as changes made after export can stop them being read.