Build your first MRI Software reports around four checks: the trial balance, aged receivables, aged payables and the bank reconciliation. Those MRI software reports tie out the general ledger before owners see a number. This guide gives the build order, custom report steps and a month-end schedule for property management accountants.
By REA Team, Property Management Experts

What are the essential MRI software reports for month-end close?
An MRI report is a saved query inside MRI Software that pulls ledgers, tenants, leases or vendor data into a formatted summary. Property management professionals usually sort them by who reads them. Complexity grows with every property you add, so the sorting matters.
Six report groups cover most closes, whether you run one building or a portfolio of commercial properties:
| Report | What it proves | Main reader | |---|---|---| | Trial balance | Debits equal credits in every ledger | Controller | | Aged receivables | What tenants owe, by age | Property accountant | | Aged payables | Which vendor invoices are unpaid | AP lead | | Bank reconciliation | Book cash matches the bank | Accountant | | Lease report | Active leases, tenants, renewals and billing charges | Asset manager | | Income and expense summary | Actual versus budget by property | Owner |
The first four prove the numbers are right. The last two explain them to owners through lease detail and income summaries, which feed the financials owners actually read. REA is an independent accounting firm and is not affiliated with MRI Software.
Which MRI software reports should accountants build first?
Build the reports that catch errors before the ones that explain results:
1. Trial balance by property. Run it first, because out-of-balance ledgers poison every report after them. 2. Bank reconciliation report. Confirm each bank balance matches the ledger. Skip it and cash looks healthy until a vendor check bounces. 3. Aged receivables. List tenant balances by age bucket. Skip it and delinquent rent hides inside total incomes. 4. Aged payables. Show every unpaid vendor invoice by due date. Skip it and late fees reach the owner's financials. 5. Lease report. List active leases, tenants and charges, including upcoming renewals. Skip it and billing errors survive from one month to the next. This matters most for commercial properties, where leases drive the charges. 6. Budget versus actual summary. Compare incomes and expenses to budget, which also feeds budgeting for the next year. Skip it and owners ask questions you cannot answer on the same call.
Build these MRI software reports in one sitting, then save them in a shared folder and pin the summaries to owner dashboards. If your team would rather not build the set alone, REA's Real Estate Accounting professionals support 130,000+ residential units and 30M+ commercial square feet.
How do you build custom MRI software reports without IT help?
Most MRI products include a report writer, much like other property management software, though what you see depends on your security role, version and licensed modules. Ask your MRI administrator once to grant report design rights. After that, a custom report takes a few clicks and no IT ticket. The MRI accounting features you can use vary by product.
1. Copy the closest standard report. Edit the copy, never the original. The standard version is already tested. 2. Choose columns and filters. Use the report grids to pick property, account range and period. Make the period a prompt, not a fixed date. 3. Name it with a convention. Use a pattern such as ME_TrialBalance_Property so any teammate finds it fast. 4. Test against a known total. Compare the result to the standard trial balance or aged receivables total. Every extra filter adds complexity, so test again after each change. 5. Share it with a version note. Put it in the team folder with one line on what changed.

Which MRI reports reconcile the general ledger, AR and AP at month-end?
Three tie-outs prove the ledgers are clean and support compliance reviews. Each compares a subledger report with a control account on the general ledger:
- Aged receivables total to the AR control account. The two should match to the cent. A gap usually means a payment, credit or billing run posted outside the tenant ledgers.
- Aged payables total to the AP control account. A gap usually means an invoice entered without a vendor or a manual journal entry.
- Bank reconciliation ending balance to the cash account. Unreconciled items older than one month are the first thing to clear.
Run them in that order after posting stops, and write down every difference with an owner and a date. Clean tie-outs also keep owner dashboards and financials from repeating an error across the portfolio. Teams that tie out monthly carry fewer open items into year-end close preparation.
How do you schedule and automate MRI software reports each month?
Schedule the reports that need no judgment and review the ones that do. If your management software supports scheduled runs, set it up this way:
1. Fix a close calendar. Set a posting cut-off, such as business day three, and run the tie-out reports right after it. 2. Schedule recurring runs. Send the trial balance, aged reports and lease reports to a shared folder as PDF or Excel files. Setup takes only a few clicks. 3. Assign one owner per report. A named person signs off each one, which also leaves a compliance trail. Unowned reports get skipped. 4. Feed summaries into dashboards. Pin budget summaries and KPI figures, such as days to close and delinquency, so owners see the same month-end reports you do. Dashboards fed from locked periods stay consistent. 5. Lock the period after sign-off. Locking stops late postings from changing financials you already sent, and it supports compliance.
What mistakes make MRI software reports unreliable at close?
Most bad reports trace back to a few habits that experienced professionals learn to avoid:
- Running reports before posting is finished. Late invoice entries change totals after you sent them, and the owner financials no longer match.
- Hard-coding dates. A copied report still points at last month.
- Mixing cash and accrual basis. Two reports that look alike will not tie, and incomes land in the wrong month.
- Editing exports by hand. A spreadsheet that drifts from the source report makes the next audit harder and weakens trust accounting compliance.
Frequently Asked Questions
What reports does MRI software have for accountants?
Depending on your product and licensed modules, MRI Software typically offers general ledger reports such as the trial balance, receivables and payables aging, bank reconciliation, lease reports and budget comparisons. Names vary by version, so ask your MRI administrator.
Does MRI software have a report writer for custom reports?
Most MRI products include a report writer or designer. You copy a standard report, change the columns and filters, and save the result.
Can MRI software reports be exported to Excel?
In most cases, yes. Like most management software, MRI reports can usually be exported to Excel or PDF, depending on your product and configuration.
What is the difference between standard and custom MRI reports?
Standard reports ship with the software and are already tested, which makes them the safest base for tie-outs. Custom reports are copies you adjust with your own columns, filters and groupings, which helps when commercial properties need different groupings than residential ones.
How long should month-end reporting take in MRI?
There is no single benchmark, because timing depends on portfolio size, complexity and how clean the books are. Set a fixed posting cut-off and track days to close as a KPI.
Get Your MRI Month-End Reports Built Right
Talk through your MRI setup and close calendar with the REA team, and decide which reports to build first for your residential and commercial properties. Schedule a consultation to get started.
Want this handled for you?
Schedule a Call





