Determine whether reported operating income is supported by cash collections.
An operating statement, rent ledger, and bank account can each be correct while reporting different income totals. They answer different questions: what was recognized, what was billed, and what cash arrived. Before asking a lender to accept a property’s income, reconcile those questions for the same entities and dates. An unexplained difference is an evidence problem; it is not automatically fraud, bad debt, or additional income.
A specific public example shows why the distinction matters. Kimco Realty’s first-quarter 2026 lease disclosure explains that straight-line recognition can differ from contractual rent timing. This is one issuer’s accounting policy, not a rule requiring a lender to finance uncollected accounting income. The workflow below is an original cash reconciliation for a fictional property.
Set the perimeter before subtracting anything
Write the legal owner, property, bank accounts, and twelve-month period at the top of the reconciliation. A manager’s portfolio bank account may contain receipts for several properties. A December operating statement may include an invoice posted in January. A rent-roll snapshot may annualize leases that started only last month. None can substitute for a matching historical period without adjustments.
Request the general ledger, monthly tenant charges and credits, opening and closing tenant receivables, bank deposit detail, and the schedule of prepaid rents and refundable deposits. Preserve the original files before adding annotations. Record whether amounts are gross or already net of concessions, write-offs, payment-processing fees, or recoveries.
Choose one starting line. If it is recognized rental revenue, isolate noncash recognition first. If it is billed rent, do not subtract straight-line rent again. If it is bank deposits, first remove money that did not arise from the income being tested.
Work from recognition to billing to collection
Assume a fictional property reports $1,260,000 of rental revenue. Of that amount, $60,000 is straight-line revenue recognized before contractual billing. Current-period rent billed is therefore $1,200,000. Tenant accounts receivable begin at $90,000 and end at $150,000. There are no write-offs, credit memos, transfers, or other receivable adjustments in this simplified example.
The receivable identity is opening balance plus billings minus collections equals ending balance. Rearranging it produces $1,140,000 of tenant collections. That includes collections of prior-period receivables and excludes current bills still outstanding; it does not claim that every dollar collected was earned this year.
| Reconciliation line | Amount | Evidence |
|---|---|---|
| Recognized rental revenue | $1,260,000 | General ledger and statement |
| Remove noncash straight-line component | −$60,000 | Lease accounting schedule |
| Current-period billings | $1,200,000 | Charge-level tenant ledger |
| Add opening receivables | $90,000 | Prior closing balance |
| Subtract closing receivables | −$150,000 | Current aging report |
| Tenant collections | $1,140,000 | Cash application detail |
| Add next-period prepaid rent received | $20,000 | Prepayment ledger |
| Add refundable security deposits received | $30,000 | Deposit liability ledger |
| Modeled bank receipts | $1,190,000 | Reconciled deposits |
The $70,000 difference between recognized revenue and bank receipts is not the full income adjustment. The bank includes $50,000 assigned to prepayments and refundable deposits. The difference between recognized revenue and the modeled tenant collections is $120,000: $60,000 of straight-line recognition plus a $60,000 increase in receivables.
Add the real-world items back into the identity
Actual ledgers often contain write-offs and credits. A $10,000 write-off reduces receivables without bringing in cash. In the identity, subtract it along with other noncash reductions before solving for collections. Otherwise the worksheet would invent a $10,000 deposit. A tenant credit applied against a disputed charge needs the same attention, although its accounting treatment may differ.
Bank deposits can contain owner contributions, refinancing proceeds, sale proceeds, transfers between accounts, and insurance recoveries. Tag these by source and purpose. Do not infer rent from a deposit description containing a tenant’s name if it actually includes a refundable security deposit or construction reimbursement.
Payment timing also matters. A tenant may pay on December 31 while the processor settles in January. Reconcile deposits in transit instead of shifting income opportunistically between periods. Have the property accountant resolve accounting entries; the financing reconciliation should preserve the explanation rather than rewrite the books to produce a preferred ratio.
Historical collection is not the entire forecast
After the historical bridge ties, build a separate forward schedule. Suppose next year’s contractual billings are $1,320,000, but executed concessions reduce amounts due by $60,000. If a separately identified collection-loss assumption is $20,000, modeled collections are $1,240,000. This is a new forecast with stated assumptions, not an annualization of the latest deposit.
Identify which leases support the increase, when payment starts, whether occupants have possession, and which balances are disputed. Ask the lender what history, annualization method, and deductions its program requires. Do not assume a recent collection cure erases an underlying tenant-credit concern or that removing straight-line income means all current billed rent will be accepted.
Deliver a reconciliation someone else can reproduce
The final package should include a one-page bridge, the underlying schedules, and an exceptions log. For each exception record amount, account, period, explanation, source document, and reviewer responsible for resolving it. Tie the sum of property-level receipts to the bank reconciliation without exposing unrelated tenant or account information in a public document.
A useful acceptance test is simple: a second analyst should be able to start with the original statement, reproduce each adjustment, and reach the same collections total. Unresolved differences remain visible. Once that evidence is stable, proceed to lender-specific income normalization and debt sizing; a mathematical DSCR calculation cannot repair an unreconciled numerator.
Sources and evidence
- Kimco Realty — 2026 first-quarter lease accounting disclosureLeases; Straight-Line Rents · Checked 2026-10-21 · One public issuer’s accounting policy illustrates timing differences; it is not a lender underwriting rule or a statement about the reader’s accounts.
Source dates and applicability matter. Report an error or a changed source.