Bank Reconciliation Book Activity Client Ledgers

Reconciliation in

Designed for SFR, MFR, and Commercial portfolios using Rent Manager Online (RMO) or RMX that want automated month-end packets, fewer reconciliation exceptions, and audit-ready financials.

The Three Checkpoints in

Bank Reconciliation (Bank ↔ Book)

Use Bank Sync (RMX) to automatically match most transactions and speed up the reconciliation process.

Book Activity (GL ↔ Bank Account Activity)

Run the Bank Account Activity or GL Cash Activity report for the same date as your bank statement.

Client Ledgers (Owner/Tenant/Deposit)

Sum owner, tenant, and security deposit ledgers. Rent Manager’s accounting stack is designed to support trust accounting, clean bank recs, and accurate owner reporting.

Step-by-Step

Pre-Checks
Pre-Checks

Go to Banking → Reconcile (or use the Bank Sync panel in RMX). Confirm the statement date and ending balance.

Reconcile
Reconcile

Go to Banking → Reconcile (or use the Bank Sync panel in RMX). Confirm the statement date and ending balance.

Export Reports
Export Reports
  • Bank Reconciliation

  • Bank/GL Activity

  • Owner/Tenant Balance Summary

  • Security Deposit Report

Prove the Three Totals Match
Prove the Three Totals Match

Ensure Bank = Book = Ledger on the same date. Investigate and resolve any differences (see next section).

Report Automation
Report Automation

Create a Report Batch (e.g., “Broker/Audit Packet”) scheduled monthly to your compliance or broker folder, plus owner packet distribution as needed.

Common Mismatches &

⚠️ Duplicate Receipts via Feed

Remove duplicates created by Bank Sync and re-reconcile.

⚠️ Owner Draws Past Cutoff

Re-date or move the transaction to the next period.

⚠️ Security Deposit Refunds from Operating

First transfer funds to the deposit trust, then issue the refund.

Automation

Smart Bills vs. AvidXchange

Choose based on invoice volume and approval complexity. Both strengthen cut-off integrity for your reconciliation process.

AvidPay Integration

Handles payments directly in-platform, reducing stale checks and improving overall cash flow accuracy.

Reference: Rent Manager

Monthly

Signed 3-Way Packet
Exception Log (CSV)
Owner Packet Schedule Confirmations

Book Your Free Rent Manager

Get a hands-on review of your reconciliation process and automate your month-end tie-outs—no surprises, no missing balances.

🎉 Black Friday Mega Offer — Get Up To 10% OFF! Limited Time Only! 🎉 

If You Need to Speak to us about a general query fill in the form below.