Use cases / Bank statement rent reconciliation
Turn bank deposits into a reviewed rent ledger.
Nexus Landlord helps an owner import a bank export, map its columns and match likely rent deposits to tenants before anything is saved.
The problem
Where the current workflow starts to break
Every bank exports a slightly different set of headers, date formats and overview rows.
UPI references and transfer descriptions rarely match the exact tenant name stored in a rent spreadsheet.
Blind automation is risky: a deposit can be a refund, transfer or unrelated payment rather than rent.
A good fit when
- — Most rent reaches one or more Indian bank accounts.
- — You can export the relevant statement as CSV or Excel.
- — You want suggested matches with a review step rather than automatic bookkeeping.
- — You reconcile monthly and want to reuse the same bank-column mapping.
Workflow
A reviewable process, not a black box
- 01
Export the statement
Download the smallest relevant date range from the bank and keep the original file unchanged.
- 02
Map and match
Identify the date, description, debit and credit columns. Nexus applies saved patterns and tenant names to suggest matches.
- 03
Review before saving
Confirm the tenant, amount and rent period. Unrelated or uncertain rows can be skipped instead of forced into the ledger.
Result
What improves
- ✓ Less manual transaction copying
- ✓ Repeatable mappings for recurring bank exports
- ✓ Human review before records change
- ✓ A rent ledger connected to the original payment context
Questions
›Does Nexus Landlord connect directly to my bank?
No. You download a statement and import the file yourself. Nexus Landlord does not receive bank credentials.
›Will every transaction match automatically?
No. The importer suggests matches and learns reusable patterns, but you review rows before saving.
›Which statement formats are supported?
CSV and Excel files are supported. PDF statements should first be exported from the bank in a structured format when possible.
See the workflow before you buy.
The sandbox uses fake data and resets when refreshed. The Windows app stores your real portfolio locally.