Skip to main content
All Systems Operational

Downloading GL & TB from TechnologyOne ERP

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 TechnologyOne ERP, 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.
  • You need access to XLOne, TechnologyOne’s Excel-based reporting tool. If you do not have access to this module, please reach out to your TechnologyOne administrator.

 

How to Extract a General Ledger Report

Step 1: Open XLOne Reporting Tool

  • Log in to TechnologyOne ERP.
  • Navigate to the Financials module.
  • Launch XLOne.

 

Step 2: Select General Ledger Template

  • Search for a General Ledger Detailed report template.
  • If unavailable, create a new report using the General Ledger data source.

 

Step 3: Configure Report Parameters

  • Set the date range for transactions.
  • Include all accounts, including those with zero balances.
  • Optionally include unposted transactions if needed.

 

Step 4: Include Required Fields

Please ensure the report contains the following fields:

  • Account Name
  • Account Code
  • Transaction Date
  • Transaction Number/Reference
  • Transaction Balance
  • Transaction Description (Optional but recommended)

 

Step 5: Export the Report

  • Click Run to generate the report.
  • Ensure the report contains the above required fields.
  • 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: Open XLOne Reporting Tool

  • Log in to TechnologyOne ERP.
  • Navigate to the Financials module.
  • Launch XLOne from the reporting section.

 

Step 2: Locate the Trial Balance Report

  • In XLOne, search for a Trial Balance report template.
  • If no template exists, create a new report using the Trial Balance data source.

 

Step 3: Configure Report Parameters

  • Select the correct company or legal entity.
  • Set the reporting period (e.g., month-end, quarter-end).
  • Choose the accounting basis (accrual or cash).
  • Ensure that zero balance accounts are included, if available.
  • Verify the report contains these fields:
    • Account Name
    • Account Code
    • Account Balance

 

Step 4: Export the Report

  • Click Run to generate the report.
  • 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.

Related to

Related articles