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.
Discover our comprehensive Three way trust reconciliation expertise and how we help streamline your property accounting
Read MoreAutomation
💡
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.