Skip to main content
All Systems Operational

Downloading GL & TB from Yardi (Voyager)

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 Yardi (Voyager) and ensure 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

  • From the Reports menu, go to GL Reports or search for General Ledger - Detailed.
  • Select the GL Detail Report or equivalent.

 

Step 2: Set Report Parameters

  • Choose the correct Entity or Property.
  • Enter the Date Range for the transactions.
  • Select filters such as Account, Department, or Transaction Type if needed.
  • Ensure the report includes Posted Transactions and optionally Unposted Transactions.
  • Enable the option to Include Zero Balance Accounts (if available).

 

Step 3: Generate and Export the Report

  • Run the report and verify it includes the following fields:
    • Account Name
    • Account Code
    • Transaction Date
    • Transaction Number/Reference
    • Transaction Balance
    • (Optional but recommended): Transaction Description
  • Export the report in .CSV, .XLSX, or .XLS format.
  • 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 Yardi Voyager system.
  • Navigate to the Reports menu.
  • Select Financial Reports or search for Trial Balance.

 

Step 2: Configure Report Parameters

  • Choose the appropriate Entity or Property.
  • Set the Date Range for the reporting period.
  • Select the Accounting Basis (Accrual or Cash).
  • Ensure the option to Include Zero Balance Accounts is selected (if available).

 

Step 3: Generate and Export the Report

  • Click Run Report or Submit.
  • Review the report to ensure it includes:
    • Account Name
    • Account Code
    • Account Balance
  • Export the report in .CSV, .XLSX, or .XLS format.
  • Save the file securely for upload to Validis.

Related to

Related articles