Rental Property Mortgage and Refinance Bookkeeping: What Your Bookkeeper Should Reconcile

Your rental-property bookkeeper should reconcile each mortgage to the lender's records, separate principal, interest, and escrow, and account for every use of refinance funds. After a refinance, the old debt, new debt, closing charges, escrow balances, and actual bank movement should tell the same story. Ask for that reconciliation alongside your property profit and loss and entity balance sheet; a matched bank withdrawal alone does not establish that the loan is correct.

What documents should your bookkeeper collect?

Collect the monthly loan statement and transaction history, bank statement, escrow activity, and any notices explaining payment changes. For a refinance, add the final signed settlement statement or Closing Disclosure where used, new loan agreement, dated payoff breakdown, disbursement confirmation, and first new-loan statement. A preliminary estimate is not evidence of the completed transaction.

Keep a loan register connecting the borrower, property, lender, account identifier, opening principal, maturity, and payment terms. Identify loans covering multiple properties and debts in an owner's name that are being paid through an entity. Those arrangements need a documented accounting decision; a property address alone does not establish which entity owes the debt.

How should a monthly mortgage payment be reconciled?

Split the actual payment using the lender's breakdown, then reconcile the principal and escrow balances separately. Principal reduces the loan liability; interest is a separate cost subject to the agreed reporting basis. Money deposited into lender-held escrow remains an asset until it is applied or refunded. Intuit's mortgage guidance illustrates these separate loan and escrow accounts, although its linked instructions are for QuickBooks Desktop.

Consider a fictional $2,100 payment: $500 principal, $1,200 interest, and $400 escrow funding. The bank account falls by $2,100, but the loan falls by only $500. If principal started at $180,000 and there were no other principal movements, the ending loan balance should be $179,500. Booking the whole withdrawal to mortgage expense would overstate expense and leave the debt unchanged.

Use actual payment history rather than repeating last month's split. Extra principal, changed rates, lender fees, payment reversals, and amounts held unapplied can make a scheduled amortization figure differ from what the servicer posted. Reconcile as of a common date and list timing differences instead of changing the ledger merely to match a statement total.

How do you reconcile escrow without counting expenses twice?

Reconcile opening escrow plus deposits and documented adjustments, minus disbursements and refunds, to the servicer's ending balance. Escrow funding and a later tax or insurance payment are different events. Check the bill, coverage period, and reporting policy when the servicer pays it.

In the same fictional month, $2,400 opening escrow plus $400 funding minus a $900 property-tax disbursement leaves $1,900. The $900 reduces the escrow asset; it is not another withdrawal from the operating bank. Depending on the books, the other side records the tax cost or clears an amount already accrued. Insurance paid ahead may require a prepaid balance. Avoid recording the expense both when escrow is funded and again when the servicer pays the bill.

An unexplained escrow adjustment belongs on the exception list. Request its explanation and supporting transaction history before classifying it as income, an owner contribution, or a correction. A changed monthly escrow requirement also does not, by itself, establish the month's tax or insurance expense.

Why can a payoff differ from the mortgage balance?

A payoff can include interest through the settlement date and charges beyond outstanding principal. The CFPB specifically distinguishes the payoff amount from the current balance. Your bookkeeper should obtain that breakdown and reconcile it to the ledger before closing the old loan.

Suppose the recorded principal is $179,500 but the confirmed payoff is $180,100, consisting of that principal plus $600 of interest. Only $179,500 clears principal. The $600 belongs to interest expense or an existing interest payable, according to what has already been recorded. Charging the full $180,100 against principal creates an unexplained $600 debit balance. Do not fix that with a plug to equity.

What should a refinance reconciliation look like?

Show the full new borrowing and every documented use of those funds, including amounts the settlement agent paid directly. Then match only the cash that actually reached or left your bank. A cash-out deposit is borrowing proceeds, not rent revenue.

Here is a fictional closing with one borrower, no lender credits, and no owner cash contribution: a $220,000 new loan funds the $180,100 old-loan payoff, $3,000 of new escrow, $2,900 of separately itemized closing charges, and $34,000 paid to the borrower. Those four uses total $220,000. The bank statement should show the $34,000 receipt, not a fabricated $220,000 deposit and invented withdrawals for payments made directly at settlement.

The old principal closes at zero after the supported $179,500 reduction, and the new loan register starts at $220,000. The $2,900 is a reconciliation subtotal, not permission to put every charge in one expense account. Its individual items still require classification. If a settlement clearing account is used, attach the support and reconcile that account to zero once all related entries are complete.

Keep the old $1,900 escrow balance separate until its disposition is confirmed. If the old servicer later refunds exactly $1,900, match the receipt against that asset. If it applies some funds to a bill or payoff instead, follow the documented application. Do not assume the old escrow transferred to the new lender or recognize a refund as fresh rental income.

Which refinance items need a CPA's accounting or tax decision?

Have the CPA or responsible accounting adviser specify the treatment of financing costs, points, prepaid items, remaining old-loan costs, and any change in borrower or ownership. Provide an itemized schedule and post the approved treatment under the agreed reporting basis. A balanced closing entry proves the funds reconcile; it does not prove that every classification or deduction is correct.

IRS Publication 527 describes special rules for rental-loan points, including treatment over time, refinancing with the same lender, and proceeds used outside the rental activity. That is why a blanket instruction to deduct all closing costs immediately, spread every fee evenly, or write off all remaining old costs can be wrong. Track where cash-out proceeds go and give the supporting transfers and invoices to the tax preparer.

A new appraisal does not, by itself, justify rewriting the property's recorded cost. Keep financing reconciliation separate from the fixed-asset schedule and any ownership-transfer analysis. If title or the borrower changes at closing, have the advisers determine the entries for each party before treating the transaction as an ordinary refinance.

What should the monthly reporting package prove?

The package should connect property results to debt and cash. Request the property profit and loss, entity balance sheet, bank reconciliation, loan balance schedule, escrow reconciliation, and a short list of unresolved items with a responsible person and next step. In a refinance month, add the settlement reconciliation and supporting schedules for adviser review.

Profit and cash available to the owner answer different questions. Principal payments consume cash without becoming operating expenses; new borrowing increases cash without creating rental profit. Ask the bookkeeper to explain those movements when discussing reserves or distributions, and keep that explanation separate from a recommendation to borrow, refinance, or distribute money.

What should you ask before hiring a rental-property bookkeeper?

Ask the provider to explain how it would handle the two fictional examples above. A useful answer identifies the documents, accounts, cutoff, unresolved decisions, and reports. Ask whether monthly loan and escrow reconciliation is included, whether a refinance is separately scoped, who requests missing lender records, and who reviews closing-cost classifications.

Daxable can scope monthly rental-property bookkeeping, historical cleanup, loan and escrow reconciliations, property reporting, and organized records for your CPA. Bring the property and entity list, loans, recent statements, and any unsettled closing records to discovery. The proposal should state which books and reconciliations are covered, the reporting calendar, review responsibilities, and any separate cleanup or closing work.

Discuss your rental-property bookkeeping scope