Skip to main content
All Systems Operational

Downloading GL & TB from MYOB EXO

Introduction

  • This guide will help you download the General Ledger (GL) and Trial Balance (TB) reports from MYOB EXO, 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 MYOB EXO system.
  • From the top menu, go to Reports.
  • Select General Ledger Reports.
  • Choose GL Account Transactions (Detailed)

 

Step 2: Set Report Parameters

  • Set the date range for the period you want to report on (e.g., full financial year or quarter).
  • Leave blank or select all to include every account in the Account Range.
  • Include accounts with zero balances if this option is available.
  • Choose the accounting basis (accrual or cash), if required.

 

Step 3: Generate the Report

  • Click Display or Preview to generate the report.
  • Review the report to ensure it includes:
    • Account Name
    • Account Code
    • Transaction Date
    • Transaction Number/Reference
    • Transaction Balance
    • Transaction Description (Optional but recommended)

 

Step 4: Export the Report

  • Click the Export button.
  • Export the report in (.CSV), (.XLSX), or (.XLS) file format.
  • Save the file securely for upload to the Validis portal.

 

How to Extract a Trial Balance Report

Step 1: Locate the Trial Balance Report

  • Log in to your MYOB EXO system.
  • From the top menu, go to Reports.
  • Navigate to General Ledger Reports.
  • Select Trial Balance from the list of available reports.

 

Step 2: Configure Report Parameters

  • Set the date range for the period you want to report on (e.g., full financial year or quarter).
  • Leave blank or select all to include every account in the Account Range.
  • Choose the accounting basis (accrual or cash), if required.
  • Include accounts with zero balances if this option is available.

 

Step 3: Generate and Export the Report

  • Click Display or Preview to generate the report.
  • Confirm the report includes the following required fields:
    • Account Name
    • Account Code
    • Account Balance
  • 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