Skip to main content
All Systems Operational

Downloading GL & TB from Pronto Xi

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 Pronto Xi, 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 Pronto Xi system.
  • From the side menu, choose your company under the Company Selection folder.
  • Select General Ledger.
  • Open the General Ledger Journal report.

 

Step 2: Set Report Parameters

  • Under Home > Data Grid Export, click Custom.
  • Set the date range for the accounting period you wish to see.
  • Select the relevant company or entity, if applicable.

 

Step 3: Configure Columns

  • Please ensure you select columns that contain the following:
    • Account Name
    • Account Code
    • Transaction Date
    • Transaction Number/Reference
    • Transaction Balance
    • Transaction Description (Optional but recommended)

 

Step 4: Generate and Export the Report

  • Next, 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: Locate the Reporting Section

  • Log in to your Pronto Xi system.
  • From the side menu, choose your company under the Company Selection folder.
  • Select the General Ledger folder.
  • Search for or select 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 needed.
  • Ensure that zero balance accounts are included, if available.
  • Verify the report contains these fields:
    • Account Name
    • Account Code
    • Account Balance

 

Step 3: Generate and Export the Report

  • Next, 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