Explore the Library
Home Financial Library About Contact

Long-Term RentalsBookkeeping & Reporting · Concept

Reconciliation & the Monthly Close for Rental Owners

Reconciling proves your books match something outside them: you match them to an independent record (bank, card, platform or manager statement) until they agree or every difference is explained. But a bank feed can only show you what happened, and the most expensive thing in a long-term rental is often what didn't — a tenant who paid late, paid short, or didn't pay at all leaves no transaction behind. A close that only balances the bank will balance perfectly while the rent roll (your record of what each tenancy is due) drifts.

Matt NunnMatt NunnFounder, Builders Finance10 min read
On this page6 sections
  1. Reconciliation is the trust layer
  2. Two jobs both called reconciliation
  3. The landlord's second source is the lease
  4. The one balance-sheet tie worth doing every month
  5. No unexplained balance survives the close
  6. The close in five steps
  7. Your action plan
  8. The bottom line

Key takeaways

  • Recording decomposes; reconciliation proves the decomposition is complete. Decomposing a transaction means breaking it into its separate parts. The control is not "the bank is truth" — it is don't verify the books using only the books.
  • The monthly close, where you check and finalize each month's books, is a five-step routine: reconcile, review, adjust, lock, report. Same order every month; a checklist beats memory.
  • There are two reconciliations, not one. Account reconciliation matches a bank or card balance to its statement and drives the difference to zero. Source-to-books reconciliation proves that your entries add back up to what a third party reported and to the cash that actually settled.
  • The landlord's second source is the lease, not a platform. Besides the bank, the lease is the independent record of what should have arrived. Rent charged versus rent collected is the check the bank cannot perform, because a missing payment produces no line to reconcile.
  • Reconcile the deposit tie every month: your security-deposit liability (money you owe tenants back) should reconcile to the funds supporting that obligation, wherever they are appropriately held — including by a property manager. A difference may be legitimate, but it has to be identifiable and supported.
  • No unexplained balance survives the close. The rule is not "always zero"; a supported, explained balance is a reconciling item, which you note and carry forward. An unexplained one is an error signal.
  • "Lock" is a control, not a seal. Setting a closing date stops a closed number drifting quietly, though it doesn't make the period impossible to change. If a closed period must change, you document why.

Reconciliation is the trust layer

Entering a transaction records what you think happened. Reconciling confirms it against what actually happened. That is the division of labor between Recording Rental Income & Expenses and this page: 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 (agrees with the outside records). Reconciliation is what keeps "looks done" and "is done" from drifting apart.

(This is educational, not legal or tax advice. Whether something is deductible, and which line of your tax return it belongs on, are questions for your tax professional.)

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. The balance sheet shows what you own and what you owe at one point in time. Account reconciliation 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 click. You are checking that your entries add back up to someone else's account of the same events.

The landlord's second source is the lease

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. On a cash basis, income counts when received and expenses when paid. On an accrual basis, income counts when earned and expenses when incurred, regardless of when the cash moves. On cash-basis books, rent that was owed and not paid is not in the ledger at all, which is why the rent roll is checked beside the books; on accrual books it sits as a receivable (an amount owed to you), and the rent roll is what proves the receivable is right.

An unexplained gap between rent owed and rent collected is delinquency, rent that is late or unpaid. Not every gap is one, though: 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 kind of gap 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, is the subject of Reading & Reconciling a Property Manager Statement. What matters for the close 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. The tie works the same on cash or accrual books, because the deposit is a balance-sheet liability either way. 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 (rules on keeping tenant deposits apart from your own money) 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

Sometimes an account that should be empty legitimately holds a balance: rent received on the 30th that lands on the 2nd is genuinely in transit at the cutoff. Whichever basis you keep, the amount sits in an in-transit (clearing) account from the day it is recorded until it lands. A clearing account is a holding account that money passes through and that should come back to zero once a payout or transfer settles; The Rental Chart of Accounts sets that account up. When the rent counts as income is a separate, recording question. 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 (P&L) 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 usual suspects are: a deposit liability for a tenant who moved out three months ago, a "repairs" figure that quietly contains a capital improvement (one you may need to capitalize: record the purchase as an asset, recovered over time through depreciation, instead of as an expense this year), 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 put each amount in its period. 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. It stops a number you called final from drifting silently. If a closed period genuinely must change, 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. What a P&L is telling you about a rental, and what it is not, is the subject of Reading Your Rental's Financials. The close makes 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 errors are cheapest to find while you still remember the transaction. Skip three months and you are no longer reconciling; you are investigating.

BOOKKEEPING & REPORTING · RECONCILIATION & THE MONTHLY CLOSE The bank reconciles what happened. Only the lease knows what should have. Every account can tie to the penny while a tenant is two months behind. 1 · ACCOUNT RECONCILIATION bank / card balance ↔ the statement difference driven to ZERO · transfers to a rental unchanged 2 · SOURCE-TO-BOOKS your entries ↔ a third party’s account of the same events. NOT a button. For a landlord the sources are: THE RENT ROLL what was OWED the manager’s STATEMENT gross rent, fee, repairs paid, what was disbursed RENT OWED RENT COLLECTED CASH LANDED delinquency — IF UNEXPLAINED a concession, a credit, a proration or an approved adjustment is a difference, not delinquency (INVISIBLE to a bank feed either way) held by the manager · in transit · wrong account · or NETTED OUT before disbursement manager-netted amounts are DECOMPOSED from the statement, not chased as missing cash A BANK FEED RECORDS WHAT HAPPENED. IT CANNOT RECORD WHAT DIDN’T. Every account can reconcile to the penny while a tenant is two months behind. THE MONTHLY TIE deposit LIABILITY ↔ THE FUNDS SUPPORTING IT wherever appropriately held — yours, or a manager’s a difference MAY BE LEGITIMATE (timing, manager-held) — if it is identifiable and supported an UNEXPLAINED difference is the problem THE ROUTINE RECONCILE → REVIEW → ADJUST → LOCK → REPORT No UNEXPLAINED balance survives the close. Explained is fine. · LOCK is a control, not a seal. TAKEAWAY Recording decomposes. Reconciliation proves it is complete — and looks for the thing that never arrived. Statement timing, escrow analysis mechanics and deposit segregation rules are servicer- and jurisdiction-specific. Educational only — not legal, tax or accounting advice.
Figure Recording decomposes. Reconciliation proves the decomposition is complete — and looks for the thing that never arrived.
The common mistake

✕ "Everything reconciled, so the month is clean." Everything that happened reconciled. A reconciliation built on transactions cannot see an absence, and in a long-term rental the absence is the expensive part — the rent that did not arrive, the deposit that was never recorded, the manager's disbursement that quietly netted a repair you never saw. The close is where you compare the books to what the lease said should occur, not only to what the bank says did. A second version is treating "reconcile the property manager" as if it were a bank reconciliation: it is a source-to-books check, and clicking reconcile on the deposit that arrived proves only that it arrived.

Your action plan

  1. Put the close on the calendar as a repeating monthly task, and run the same five steps in the same order: reconcile, review, adjust, lock, report.
  2. Reconcile every material bank and card account to its statement, difference to zero.
  3. Run the rent roll as its own pass — owed, collected, landed — and treat every gap as something to explain rather than something to note.
  4. Reconcile the manager's statement source-to-books, not as a bank reconciliation: gross rent, fee, repairs paid and disbursement should reconstruct what arrived.
  5. Reconcile the deposit liability to the funds supporting it every month, wherever those are appropriately held. Name any legitimate difference; chase any you cannot.
  6. Chase every unexplained balance while it is one month old. Explained residuals get a note and carry forward; unexplained ones get resolved.
  7. Lock the period when the work is done, and if a closed month later has to change, record why.

The bottom line

Reconciliation is the trust layer: it proves your books agree with records that did not come from you. For a rental that means the ordinary account reconciliation every business does — and a second pass a landlord cannot skip, because the bank can only confirm what happened. Rent that was owed and never arrived leaves no trace, so the rent roll is the source that has to be checked against collections and cash. Reconcile the deposit liability to the funds supporting it while you are there, chase anything unexplained before it is a quarter old, then lock the period and report it. Do the close monthly and the year-end handoff is a formality; skip it and the year-end handoff is an investigation.

Matt Nunn writes Builders Finance.

About the author →

This resource provides general educational information about rental bookkeeping practice, and is not individualized legal, tax or accounting advice. Whether a cost is deductible, how depreciation is calculated and which accounting method applies to you are decisions for your own qualified tax professional. Security-deposit segregation and handling requirements are state- and often city-specific.

The Profitable Real Estate Operator, by Builders Finance

A letter for people who run property as a business. One idea at a time on the financial side of ownership — what changed, what it means, and what an operator should do about it. Written for short-term and long-term rental owners alike.

Free. No spam. Unsubscribe anytime.