Reconciliation & the Monthly Close — Because a Balanced Month Can Still Be Missing Rent

Entering a transaction records what you think happened. Reconciling confirms it against what actually happened. That is the division of labor this domain runs on, picked up from the stage before: recording decomposes each cash event into its true parts, and reconciliation proves you decomposed it completely — by checking your books against source records that are independent of your own entries.

The control is not that the bank is truth. The control is: don't verify the books using only the books.

Skip it and the failure is quiet, which is what makes it dangerous. It is easy to record all month and never reconcile — the books look done, so the gap stays invisible while small errors compound. A miscategorized charge, a fee never recorded, a duplicated entry. Then a lender asks for a clean profit-and-loss statement, or the tax preparer opens the file, and nothing ties out. Reconciliation is what keeps "looks done" and "is done" from drifting apart.

(Educational, not legal or tax advice. Deductibility and tax-line questions are your tax professional's.)

Two jobs both called reconciliation. They are not the same operation and confusing them is common.

Account reconciliation matches a balance-sheet account — a bank or credit card — to its external statement, with the difference resolved to zero. This is the formal "reconcile" function in bookkeeping software, and it transfers to a rental unchanged.

Source-to-books reconciliation proves that what you recorded reconstructs what a third party reported and what actually settled. It is not a button. You are checking that your entries add back to someone else's account of the same events.

And here the long-term rental diverges from every other rental business, because of what its second source is.

A short-term operator reconciles to a platform report: gross bookings, fees, taxes, refunds, then the payout that settled. A landlord has no platform. What a landlord has is a lease that says what should have arrived — and, if the property is managed, a statement from someone else who collected it.

That difference matters more than it sounds, because of an asymmetry in what a bank feed can see. A bank feed records what happened. It cannot record what didn't. If rent arrives late, short, or never, there is no transaction to categorize, no line to reconcile, nothing to flag. Every account can reconcile to the penny while a tenant is two months behind, because the absence of a payment is invisible to a process built on payments.

So the landlord's source-to-books check runs against the rent roll: what each tenancy was contractually due this month, against what was actually collected, against what actually landed in the account. Three columns, and the gaps between them are the ones that carry information. An unexplained gap between rent owed and rent collected is delinquency — though not every gap is one, since a concession, an agreed credit, a prorated first month or an approved adjustment all produce differences that should be identifiable as themselves. Rent collected but not landed is money held by the manager, in transit, or in the wrong account — or, where a manager collects, amounts they netted out before disbursing, which are decomposed from the statement rather than chased as missing cash. Neither shows up in a bank reconciliation, and both are things you want to learn in month one rather than month four.

If a property manager collects for you, their statement is the third-party record your entries have to reconstruct — gross rent, the management fee, repairs they paid, the disbursement that reached you. Actually reading that statement, and what to do when it does not agree with the property, has its own guide in this domain. What belongs here is that it is a source-to-books job rather than an account reconciliation, and that it belongs in the monthly routine rather than in the pile of things you will look at eventually.

The one balance-sheet tie worth doing every month. Your security-deposit liability — what you owe tenants back — should reconcile to the funds supporting that obligation, wherever they are appropriately held. Often that is your own deposit account; where a property manager holds tenant deposits it may be funds held by them. If your books say you owe $4,800 and the funds supporting it come to $3,200, something specific has happened: money was spent, a deposit was never recorded, or a move-out was settled in the ledger and not in the cash. A difference can be legitimate — an ordinary timing item, or funds sitting with a manager — but it must be identifiable and supported. An unexplained difference is the problem, and in a jurisdiction with segregation rules it may be a compliance matter rather than a bookkeeping one.

This tie is the reason the separation stage and the recording stage have to agree, made into something you can actually check. A boundary you cannot test once a month is a boundary you are trusting rather than maintaining.

No unexplained balance survives the close. Some accounts should be empty and are not, legitimately: rent received on the 30th that lands on the 2nd is genuinely in transit at the cutoff. So the rule is not "always zero." A residual you can explain is a reconciling item you carry forward with a note. A residual you cannot explain is the error signal, and the close is where you chase it, while it is one month old and still has a cause you can remember.

The close, in five steps. Same order, every month.

1 · Reconcile. Every material bank and card account to its statement. Then the source-to-books pass: the rent roll against collections and deposits, and the manager's statement if you have one. Clearing balances land at zero after settlement, or at a supported in-transit figure you can name.

2 · Review. Scan the profit-and-loss statement and balance sheet for figures that are plausible but wrong — the uncategorized transaction, the cost in the wrong bucket, the balance that should not be sitting there. In a long-term rental the recurring suspects are specific: a deposit liability for a tenant who moved out three months ago, a "repairs" figure that quietly contains a capital improvement, a turnover whose costs are scattered across four accounts, and an escrow balance that stopped making sense after the servicer's annual analysis changed the payment.

3 · Adjust. Post supported corrections and the entries a bank feed will never show you: expenses you paid personally, depreciation from the schedule, and — if you are on an accrual basis — the accruals and prepaids that make the period honest. Corrections are posted, not overwritten; you want the trail.

4 · Lock. Set the closing date. This is a control, not a seal — it warns on, restricts, or requires authorization for later edits to a closed period; it does not make the past immutable. What it buys you is that a number you called final stops drifting silently. If a closed period genuinely must change, you change it deliberately and write down why.

5 · Report. Produce the statements for the period and, if you hold more than one property, per property. Reading them — what a P&L is actually telling you about a rental, and what it is not — is the next guide in this domain. The close's job is to make sure the numbers in them are ones you can defend.

Cadence beats thoroughness. A modest close done every month beats an exhaustive one done twice a year, because the errors you are hunting are cheapest to find while you still remember the transaction. Skip three months and you are no longer reconciling; you are investigating.