How to export your General Ledger and Trial Balance ready for Upload & Share
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 3.73GB
-
API
- The API accepts multiple files for a single upload, up to 25 for the same report type. For example, four quarterly General Ledger files plus one Trial Balance in the same upload.
- The per-file limit of 3.73GB applies to each file individually, and the whole upload must stay under 4GB.
-
Website
- Uploads through the website take one file per report type (for example one General Ledger and one Trial Balance), up to 3.73GB in total for all the files in one upload.
-
API
- 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:
Once both reports are ready
Follow Upload & Share Journey (GL & TB) to send them to Validis.