To reconcile a bank account for a rental business, compare the bank's statement to your ledger for the same period: bring in the statement lines, match each one to the ledger entry it represents, explain any difference you accept, then lock the reconciliation so the month stops moving. The work is monthly, and it takes one sitting when the books are current.
Here is the morning this guide is for. It is the 14th, your accountant has asked for last month, and you have the bank's site open in one tab and the ledger in the other. A deposit reads $4,180 in one and $4,205 in the other. Somewhere in that $25 is a bank fee, a short-paid rent, or a typo from the 3rd, and you will find it. That is the problem. You will find it every month.
What a bank reconciliation actually proves
A bank reconciliation is a comparison of two independent records of the same money: what the bank says moved through an account in a period, and what your ledger says moved. When the two agree, line by line, the account is reconciled. The exercise looks clerical, and its purpose is not.
Until an account is reconciled, every number that depends on it is an assertion. The owner statement you sent says the building collected a certain amount. The income statement says the portfolio earned it. The rent roll says a resident is current. Each of those is your ledger repeating itself, and a ledger repeating itself is not evidence. The bank is the outside party that can confirm or contradict it, which is why the reconciliation is the last step in a monthly close rather than an optional tidy-up. The close is not done until the bank agrees.
What it catches is ordinary, and expensive when it is late: the deposit that was recorded but never landed, the vendor paid twice, the resident's payment that bounced three weeks ago, the transposed amount that has been quietly wrong since the 3rd. None of these announce themselves. They surface when two records are held against each other, or they surface at year end, when the trail has gone cold and the resident has moved out.
Why property managers reconcile more than most small businesses
Property management carries a reconciliation burden that a comparable business its size does not, for four structural reasons.
First, the account count. Most operators run more than one bank account by design: an operating account, a separate account for security deposits, and in many portfolios one per owner or per building. Every account is its own monthly reconciliation, so the work scales with the portfolio rather than with revenue.
Second, deposits arrive bundled. A single bank line for $18,400 on the 3rd is not one payment; it is eleven rent payments a bank teller or a lockbox combined into one deposit. The ledger holds eleven records and the bank holds one, so matching is rarely one-to-one.
Third, much of the money is not yours. Security deposits and owner funds sit in your accounts on someone else's behalf, which changes what an error means. A mistake in your own operating account is an accounting problem. A mistake in an account holding other people's money is a different category of problem, and it is the reason regulators take an interest in how often these accounts get reconciled.
Fourth, the transactions are small, numerous, and repetitive. Rent, fees, a plumber, a hardware run, a utility, monthly, across every unit. Volume is the whole difficulty. Nothing here is hard, and there is a great deal of it.
How to reconcile a bank account, step by step
The procedure is the same in any system, on paper or in software. Run it once a month, per account.
- Pick the account and the statement period. One bank account, one statement, one date range. Do not reconcile two accounts together, and do not span two statements.
- Record the opening balance. The first reconciliation on an account needs a starting cash balance that matches the bank, or every month after it inherits a difference that has nothing to do with this month's activity.
- Bring in the statement lines. Enter them by hand from the PDF, or import the CSV your bank exports. Either way, the statement is the bank's record and it is not edited to fit the ledger.
- Match each line to its ledger entry. Work down the statement, pairing each bank line with the entry that represents it. Most lines match one to one and go quickly.
- Attach the bundles. Where one bank line covers several ledger entries, such as a deposit holding a batch of rent payments, attach all of them to that line so the total ties out.
- Post what the bank knew and the ledger did not. Service charges, interest, and returned payments usually appear on the statement first. They are not variances; they are entries you owe the ledger. Book them.
- Explain what is left. Anything still unmatched is a timing difference, a duplicate, an omission, or an error. Identify which, and record the reason for any difference you accept rather than resolve.
- Confirm the balance and lock it. When the cleared ledger total agrees with the statement, mark the reconciliation complete so the period cannot drift afterward.
When the statement and the ledger disagree
A difference between the bank and the ledger is normal, not a sign that something is broken. Almost every difference is one of six things, and naming which one it is turns a hunt into a lookup. Two of the six have formal names worth knowing. A deposit in transit is money you recorded and the bank has not yet credited. An outstanding check is a payment you recorded and the recipient has not yet cashed. Both are timing, not error, and both clear themselves next month.
| What you are looking at | What it is | What to do |
|---|---|---|
| Deposit in transit | Recorded in the ledger, not yet credited by the bank | Leave it uncleared; expect it on next month's statement |
| Outstanding check | Issued and recorded, not yet cashed | Leave it uncleared; chase anything still open after 60 days |
| Bank fee or interest | The bank knew first; the ledger has no entry | Post the entry, then match it |
| Returned or NSF payment | A payment reversed after you recorded it as received | Reverse the receipt, restore the balance owed, apply any fee |
| Duplicate or missing entry | The same transaction recorded twice, or never | Correct the ledger; the bank is right about what moved |
| Wrong amount | A transposed or mistyped figure on one side | Trace to the source document and correct the ledger |
Work them in that order, cheapest first: timing differences cost nothing to identify, bank-only items are a single entry each, and errors are the only category that requires real investigation. A reconciliation that will not balance after all six have been worked is telling you something specific, and it is usually that the opening balance was never right.
Locking the reconciliation, and why the lock is the point
Locking a completed reconciliation is what converts it from a task you performed into a fact you can rely on. An unlocked month is not finished, because anything posted into it afterward silently changes a number you already reported. The owner statement you sent in April should still be true in July, and the only way to guarantee that is to make late edits impossible rather than merely discouraged.
Locking also has to be reversible, because legitimate corrections do arrive late. The working rule is that a reopen is allowed, requires a stated reason, and is recorded. That combination keeps the history honest: the month can be corrected, and nobody can correct it quietly. The same logic governs the monthly period close described in Property Management Accounting: The Complete Operational Guide, and the two locks work together. Reconcile the bank, then close the period.
How the reconciliation workspace works in Scaalr
Scaalr runs bank reconciliation as a guided workspace rather than a spreadsheet you maintain beside the ledger. You start one by picking a cash account, a statement date, and the opening and closing balances; duplicate reconciliations for the same account and date are blocked. Each one carries a status, Draft, Reconciled, or Reopened, so the state of every account is visible without opening it.
Statement lines arrive one of two ways: typed in, or imported from a CSV file up to 5 MB. The import previews and maps before it commits, handles any column order, accepts either a single signed amount or separate debit and credit columns, and reports the rows it skipped instead of dropping them silently. There is no live bank connection, which is a deliberate boundary worth stating plainly: you reconcile against the statement your bank issued, not against a feed that interprets it.
Matching is drag and drop. Pull a statement line onto its ledger entry, or attach several entries to one line where a single deposit covers a batch of rent receipts. When the amounts do not agree exactly, the match requires a recorded variance reason before it will complete, so a forced tie-out always leaves an explanation behind it. A running panel shows the opening balance, the closing balance, the statement change, and the cleared ledger total, with a plain Balanced or Out-of-balance indicator, and lines carry a Matched, Cleared, or Unmatched flag beside a panel of ledger activity that has not been reconciled yet.
Marking the reconciliation complete locks it against edits. Reopening requires both the unpost permission and a reason, and every action is logged. For a new account, you can seed the opening cash balance so the first reconciliation does not begin with a variance that predates the system. Two reports sit alongside the workspace: the Subledger Reconciliation ties the receivables, payables, and cash control accounts to their subledger totals as of a date, with a variance and a balanced flag, and the cash flow statement reconciles back to the cash ledger.
The volume of matching drops when entries post themselves. Rent, invoices, payments, refunds, and cancellations write their own balanced entries as the work happens, and a card payment collected through Invoicing for Property Management: Residents, Owners, and Contractors posts its entry, marks the invoice paid, and records the Stripe reference with no manual step. What reaches the reconciliation is then mostly confirmation rather than data entry. The division of labor is the one argued in Automation vs Augmentation in Multifamily Operations: the system carries the matching, and you keep the judgment about what a difference means. Bank reconciliation is part of every plan, including Starter.
One more piece of the loop is the part that notices you have stopped. The dashboard's attention strip carries a tile for books behind on bank reconciliation, alongside overdue rent and aging work orders, and it opens the worklist behind it. Falling behind is the failure mode this work actually has, and the tile is what surfaces it.
The same morning, current
Back to the 14th. Last month's statements came in on the 2nd, each account reconciled in one sitting, and each reconciliation is locked. The $25 was a bank service charge, posted during the reconciliation and matched in the same pass. Your accountant's request is a report you run rather than a week you schedule, and the answer to whether the money is really there is on the record instead of in your memory.
That is the honest promise here. Not a smaller job, a finished one, every month, on a date you choose rather than the date something goes wrong.
Key questions
How often should I reconcile my bank accounts?
Monthly, on every account, as soon as the statement is available. Monthly is the cadence most operators can actually sustain, and it is what state regulators expect from brokers holding client money: the Oregon Real Estate Agency, for example, requires each clients' trust account and security deposit account to be reconciled monthly. Reconciling more often is fine. Reconciling less often means errors age past the point where anyone remembers them.
What if the bank statement and the ledger do not match?
A difference is normal, and it usually falls into four categories: timing (a deposit or check that has not cleared yet), items only the bank knew about (fees, interest, a returned payment), items only the ledger knew about (an entry keyed twice or never keyed at all), and plain errors (a transposed amount). Work through them in that order. Whatever is left after those four is the number worth investigating.
What is a three-way reconciliation, and do I need one?
A three-way reconciliation compares three balances instead of two: the bank statement, the cash record or check register, and the sum of every individual owner or resident ledger the account holds. State real estate regulators commonly require it for accounts holding client money, and the Oregon Real Estate Agency, for example, requires that comparison monthly. Scaalr reconciles the bank against the ledger and separately ties control accounts to their subledgers, and it does not produce a signed trust-account worksheet.
What do I do if I have not reconciled a bank account in months?
Reconcile forward from the last month you trust, one month at a time, and lock each one before starting the next. Do not try to reconcile the whole gap as a single period: a twelve-month variance tells you nothing about which month broke. If the account has never been reconciled, seed its opening balance first so the earliest month does not open with a false difference.
Which Scaalr plan includes bank reconciliation?
All of them, including Starter. The reconciliation workspace, the double-entry ledger, and the financial report suite are part of every plan; Starter is free for the first 5 units, then $0.99 a unit a month. Growth, at $99 a month for the first 50 units and then $1.49 per additional unit, adds invoicing with online card payment, whose payments post and match themselves.