Skip to main content
All Systems Operational

Downloading GL & TB from MRI Financials

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 MRI Financials, 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 MRI Software
  • Navigate to Other > Export Data
  • Choose Excel under the Export to option

 

Step 2: Set Report Parameters

  • Select Owner/Property or Tenant under the Merge with option
  • Type of Letter – Leave this as General (default value)
  • Contact – Leave this as Primary (default value)

 

Step 3: Configure Columns

  • Selection – Choose from either All, Range, or select the required information
  • 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

  • Select Excel as the output
  • Enter your file name under the Output File Name
  • Click on Start
  • 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 MRI Software system.
  • Navigate to Other > Export Data
  • Choose Excel under the Export to option

 

Step 2: Configure Report Parameters

  • Select Owner/Property or Tenant under the Merge with option
  • Type of Letter – Leave this as General (default value)
  • Contact – Leave this as Primary (default value)
  • Verify the report contains these fields:
    • Account Name
    • Account Code
    • Account Balance

 

Step 3: Generate and Export the Report

  • Select Excel as the output
  • Enter your file name under the Output File Name
  • Click on Start
  • Export the report in (.CSV), (.XLSX), or (.XLS) file format.
  • Save the report securely for upload to the Validis portal.

 

Below is an example of how the export of the GL report should look, where possible its best to avoid transaction details across multiple rows:

Related articles