Optimization Updated March 2026

Yardi Bank Reconciliation Automation: The Complete Business Case

Most Voyager clients already have access to Automatic Bank Reconciliation but aren't using it. Here's what it does, what it costs, and what to expect.

Yardi's Automatic Bank Reconciliation (ABR) imports a BAI2 file from your bank and auto-clears 60–80% of matching transactions on the reconciliation screen, reducing per-account reconciliation time from hours to minutes. ABR is included in the core Voyager license (with GL Posting Utilities Plug-In 7.2+), requires no additional fees, and most banks provide the necessary files at no charge. For property management companies reconciling dozens or hundreds of bank accounts each month as part of their core Yardi financial workflows, this is one of the highest-ROI features available in Voyager that many clients still aren't using.

Key Takeaways

  • ABR auto-clears 60–80% of transactions from a single BAI2 file import
  • Reconciliation time drops from 2–4 hours to 15–30 minutes per account
  • Included in your Voyager license (requires GL Posting Utilities Plug-In 7.2+)
  • Most banks provide BAI2 files at no cost via portal download or SFTP
  • Setup takes weeks, not months

What Automatic Bank Reconciliation Actually Does

When you reconcile a bank account manually in Voyager (via GL > Banking > Bank Functions > Bank Reconcile), you're working through a three-column screen: GL information on the left, bank statement data on the right, and a difference field that must hit zero before you can post. For each account, you scroll through every cleared check, deposit, and ACH transaction, manually checking each one off against the bank statement. With moderate transaction volume, this takes 2–4 hours per account.

ABR replaces the manual matching step. Your bank generates a BAI2 file (a standardized format from the Bank Administration Institute) containing every posted transaction. When you import that file into Voyager, the ABR engine compares each transaction against your GL records by amount, date, and reference number. Matching items are flagged as cleared on the reconciliation screen automatically. What remains are genuine exceptions: timing differences, bank fees, ACH discrepancies, or coding errors that need a human set of eyes.

A single BAI2 file can cover every account you hold at a given bank. Voyager separates the transactions by account number during import, so you don't need separate files per property or per account. For portfolios running reconciliation across multiple banking relationships, you import one file per bank and the system handles the rest.

This fits directly into the broader reconciliation workflow. ABR doesn't replace the review step or eliminate the need to investigate exceptions. It clears the routine matches so your accounting team can focus where their judgment actually matters. For a deeper look at how the three-column architecture works and the eight most common failures that cause non-balancing reconciliations, see our bank reconciliation troubleshooting guide.

The Numbers: Manual vs. Automated Bank Reconciliation

We've implemented ABR across dozens of client portfolios at BC Solutions. Here's what the performance data looks like in practice:

Metric Manual With ABR
Time per account 2–4 hours 15–30 minutes
Auto-clear rate 0% 60–80%
Data integrity High manual error risk System-verified matching
Month-end impact Major bottleneck Complete by day 3–5
Scalability Linear: more accounts = more hours Near-flat: bulk file covers all accounts

The ROI compounds as portfolios grow. A 50-account portfolio running manual bank rec might spend 100–200 hours per month on reconciliation alone. With ABR configured, that same portfolio needs 12–25 hours. That's roughly a full-time accounting position freed up for financial analysis, owner reporting, or audit preparation.

The remaining 20–40% of transactions that don't auto-clear are the ones worth investigating: stale outstanding checks, bank fees that need GL coding, ACH payments with mismatched reference numbers, or intercompany transfers that require manual verification. These are the reconciliation items where an accountant's attention actually adds value.

When KORE Investments migrated to Yardi Voyager, our team completed the first-month bank reconciliation before go-live, validating financial accuracy across their commercial portfolio from day one. When Pistilli Management moved from MRI to Voyager, bank reconciliation was part of the ongoing support partnership that kept their 23-property portfolio running cleanly through the transition. In both cases, getting bank rec right early laid the groundwork for everything else.

What You Need to Get Started

ABR has three prerequisites:

  1. GL Posting Utilities Plug-In 7.2+ — Check with your Yardi account manager to confirm your plug-in version. This is the only technical gate on the Yardi side.
  2. A BAI2 file from your bank — Contact your treasury or relationship manager. When requesting, confirm:
    • File format: BAI2 specifically (not CSV or PDF statements)
    • Delivery method: Nightly SFTP export is ideal; manual portal download works
    • Multi-account consolidation: One file covering all accounts at that bank
    • Cost: Many banks provide this at no charge; some charge a nominal monthly fee
  3. Clean bank account configuration in Voyager — Each bank account needs proper GL mapping and property associations before ABR can match transactions correctly.

The bank-side setup is usually the longest lead time. Some institutions provision BAI2 files within days; others need 2–4 weeks to configure. The Voyager-side work typically takes a few days.

One consideration for portfolios with trust or escrow accounts: these often require three-way reconciliation (bank statement, GL, and trust ledger). ABR handles the bank-to-GL matching, but the trust ledger verification remains a separate manual step. Factor this into your process design.

At BC Solutions, we've built relationships with banking institutions to help expedite the BAI2 provisioning process, often cutting the typical timeline from weeks to days.

Where Yardi Is Heading: Voyager 8 and Virtuoso

Bank reconciliation is one piece of the month-end close, and Yardi is investing heavily in making that entire cycle faster.

Voyager 8's Period Close Dashboard centralizes month-end workflows into a single view: task assignments, due dates, dependencies, and completion status for every close step, including bank rec. Controllers get real-time visibility into where the close stands across the portfolio. The dashboard also includes improved journal entry processing (large JEs without timeouts, copy/paste from Excel) and automatic report generation at each milestone.

Yardi Virtuoso, launched at YASC 2025, brings AI-powered agents to financial workflows. Early performance data from adopters shows month-end reconciliation and reporting dropping from 20+ hours to under 5 hours per property. While Virtuoso adoption is still in its early stages, it signals where the platform is heading: tighter automation at every step of the financial close.

For teams evaluating ABR today, the trajectory reinforces the case for starting now. ABR captures the immediate wins. Voyager 8's workflow tools and Virtuoso agents add the next layer of automation as your processes mature. And because ABR cleans up how transactions flow through your GL, it makes these downstream tools more effective. Teams that need custom reporting solutions will also benefit from the cleaner data that consistent, automated reconciliation produces.

Frequently Asked Questions

Is ABR included in my Yardi Voyager license?

Yes. BAI2 imports and the automatic reconciliation engine are part of the core Voyager platform. The only prerequisite is GL Posting Utilities Plug-In 7.2 or higher.

What auto-clear rate should we expect?

Most portfolios achieve 60–80% once ABR is properly configured. Default configurations typically start at 50–85% depending on transaction complexity. The remaining items are genuine exceptions (timing differences, bank fees, ACH discrepancies) that require manual review.

Can ABR handle multiple bank accounts at once?

Yes. A single BAI2 file can contain transactions for every account at a given bank. Voyager separates them automatically by account number during import.

How long does setup take?

The Voyager-side configuration takes a few days. Bank-side provisioning of the BAI2 file typically takes 2–4 weeks, though some banks deliver faster.

We're behind on bank rec. Should we set up ABR first or catch up first?

Catch up first. ABR works best when your GL is current and clean. If you're more than a few months behind, our troubleshooting guide covers how to address the backlog and what to prioritize before implementing ABR.

Ready to Set Up Automatic Bank Reconciliation?

Our team has implemented ABR across multifamily, commercial, and mixed portfolios. We'll assess your current process and handle the setup.

Talk to an Expert