Unpaid Income Tracking for Real Estate Investors and Landlords in New York City
Aging the rent roll so you know what you are really owed
The foundation of unpaid income tracking is an aging schedule, a report that takes every tenant’s outstanding balance and sorts it by how long it has gone unpaid, current, thirty days, sixty, ninety, and beyond. For a New York City landlord with more than a couple of units, this is the single report that tells you the truth about your income, because collected rent and billed rent are two different numbers and the gap between them is what an aging schedule measures. A tenant a few days late is noise. A tenant ninety days behind is a decision point, and the aging is what surfaces it before it becomes a five-figure hole. The report also drives everything downstream, the choice to start a nonpayment case, the negotiation of a payment plan, and, at year end, the honest picture of what income actually arrived. Consider a twelve-unit building in Washington Heights where average rent is $2,300. If the rent roll says you billed $331,200 for the year but the aging shows $28,000 sitting unpaid across four tenants, then you collected about $303,200, and only the collected figure belongs on a cash-basis return. Without the aging you might assume the full billed amount and either overstate income or lose track of which tenants owe what. We maintain the aging tenant by tenant and tie it to your bookkeeping, so at any moment you can see the whole unpaid picture rather than discovering it in April, and so the number you report is the number you actually received.
Timing versus loss: what unpaid rent means on a cash-basis return
The reason tracking unpaid income matters for tax, and not just for management, is that on the cash basis unpaid rent is not yet income, so how you track it directly controls what lands on your return. Most individual New York City landlords report on the cash basis, meaning rent is taxable when received, not when it is due. So a balance sitting in your aging schedule is a receivable, not taxable income, until the cash actually arrives, which is a genuine benefit because you are not taxed on money you have not collected. But it only works if the tracking is right, because the aging has to feed the return so that the income you report matches the cash you received, not the rent you billed. Get this wrong and you either overstate income, paying New York’s stacked federal, state, and city tax on phantom rent, or you lose track of a balance and misstate the year. There is a flip side that tracking also clarifies. Because you never report the unpaid rent as income on the cash basis, you generally get no bad-debt deduction when a balance proves uncollectible, since there is nothing to write off that was never counted. What you can deduct are the real costs of the delinquency, the legal fees and the turnover expenses, which the tracking keeps separate. Say your aging shows a tenant $19,000 behind at year end. On the cash basis none of that $19,000 is income this year, so it stays off the return, and if the tenant later vanishes owing it, you take no bad-debt deduction for the rent but you do deduct the $5,200 you spent in housing court and repairs. We keep the aging and the tax treatment aligned through your tax strategy consulting so the unpaid balances are handled correctly at every step.
Tracking recoveries, partial payments, and the year they hit
Unpaid income does not just sit still, it moves, and tracking those movements is where the discipline earns its keep for a New York landlord. A delinquent tenant makes a partial payment, a payment plan brings in some of the arrears, a housing court judgment gets paid in installments, or a collection agency recovers part of an old balance net of its fee. Each of those events changes the unpaid number and, because you are on the cash basis, creates taxable income in the year the cash arrives, even if the rent it pays off was owed in a prior year. If the tracking does not record which payments are applied to which arrears and when, you cannot tell current rent from recovered back rent, and you cannot see the taxable event coming. This matters in New York because a recovery can land in a single year and spike your income at the top combined rate, and if it is large enough it can throw off your quarterly estimated payments and trigger an underpayment penalty on top. It also matters that recoveries through an agency are recorded gross, the full amount recovered as income and the agency fee as a separate deductible expense, rather than just booking the net check, which understates both sides. Picture an aging schedule showing a tenant $14,000 in arrears who agrees to a plan and pays $700 a month. Each $700 is taxable rental income in the month it arrives, and tracking it that way lets us see the income build through the year and plan the estimates around it. We record every partial payment and recovery against the right balance and the right year, keeping it reconciled through your financial reconciliation so a recovery never surprises you.
Deposits, credit balances, and the parts of the ledger that flip to income
A landlord’s ledger holds more than unpaid rent, and good tracking watches the items that can quietly turn into taxable income, because in New York City getting the timing wrong on any of them means paying the stacked tax in the wrong year. Security deposits are the main one. A deposit you hold is not income, it is the tenant’s money you expect to return, and New York requires many deposits to sit in a separate account, so the tracking has to keep deposits distinct from rent from the day a tenant moves in. But the moment you retain part of a deposit, for unpaid rent or for damage beyond normal wear when a tenant leaves, that retained amount becomes income in that year, and tracking is what catches the conversion so it is picked up correctly. Prepaid rent is the mirror image, a tenant who pays next month early creates income now on the cash basis, even though it relates to a future period, so the tracking has to flag it. Tenant credit balances, last-month rent held at signing, and application of a deposit to a final month all sit in this category of items that flip from a liability to income at a specific moment. Take a tenant who leaves owing $2,100 in rent and $900 of damage, against a $3,000 deposit you hold. You keep the full $3,000, and tracking shows that $3,000 becomes income this year, offset by the $900 repair you deduct and matched against the $2,100 of rent you were owed, so the return reflects the real economics rather than a guess. We track deposits, prepayments, and credit balances separately from rent and pick up each conversion in the right year, keeping the whole ledger straight so nothing lands on the wrong return, and we keep it reconciled through your financial reconciliation.
Related Services from The Reed Corporation
Helpful Guides You Might Also Like
Sources & References
Frequently Asked Questions
What does unpaid income tracking mean for a real estate investor CPA in New York City?
Unpaid income tracking is the discipline of measuring, precisely and continuously, all the rent your tenants owe you but have not paid, and a real estate investor CPA in New York City treats it as the measurement system the whole rental business runs on, separate from the work of actually collecting the money. Collecting is chasing a debt. Tracking is knowing the debt cold, exactly who owes what, how long it has been outstanding, and whether it is likely to become cash or a write-off. In a high-tax city with a slow eviction process, that knowledge is what keeps your management decisions sound and your tax return accurate.
The core tool is an aging schedule, which lists every tenant’s unpaid balance sorted by how overdue it is. This single report tells you the difference between the rent you billed and the rent you actually collected, and that difference is exactly what a landlord needs to see, because the two numbers diverge whenever a tenant falls behind. The aging drives your decisions about which delinquencies to pursue, and it feeds the tax return so that the income you report reflects what you received rather than what you were owed.
The tax reason this matters so much in New York is the cash basis. Most individual landlords report rent as income when it is received, so an unpaid balance is not yet taxable. If your tracking is sloppy and you report billed rent instead of collected rent, you pay New York’s stacked federal, state, and city tax on money you never got. If you lose track of a balance entirely, you misstate the year. Accurate tracking is what keeps the reported number honest in both directions.
There is a defensive dimension as well. When you take a tenant to housing court, the amount you claim has to be exact and supportable, and a clean aging ledger is what your attorney attaches to the filing. A vague record weakens the case.
Tracking also feeds decisions that are not about tax at all but shape your returns just as much. Whether to renew a marginal tenant, whether a building’s real collected yield justifies holding it, and how much cash you can safely pull for the next acquisition all depend on knowing your true collected income rather than the optimistic billed figure. Owners who run on billed rent tend to overestimate what a building actually produces and get caught short, while an owner who watches the aging knows the real number and plans against it.
Here is a concrete case. A ten-unit building in the Bronx bills $276,000 of rent for the year, but the aging schedule shows $22,000 unpaid across three tenants at year end. That means you collected $254,000, and only the $254,000 belongs on your cash-basis Schedule E, keeping $22,000 of phantom rent off the return and out of New York’s tax net for now. Without the tracking, you might have reported the full billed figure and overpaid. We maintain the aging and tie it to your bookkeeping. The rental reporting rules are in IRS Publication 527, and the cash method is explained in IRS Publication 538.
How does a real estate investor CPA build an aging schedule for my New York City rentals?
An aging schedule is the central deliverable of unpaid income tracking, and a real estate investor CPA builds it so a New York City landlord can see the whole unpaid picture on one report rather than piecing it together from memory and bank statements. At its simplest, an aging schedule lists each tenant, the total they owe, and how that balance breaks down by how long it has been outstanding, typically in buckets of current, one to thirty days past due, thirty-one to sixty, sixty-one to ninety, and over ninety. The buckets matter because the older a balance gets, the less likely it is to be collected, so the aging is really a risk map of your income.
To build it, we start from the rent roll, the record of what each unit is supposed to pay, and match it against the payments actually received, applying each payment to the right tenant and the right period. The difference is the unpaid balance, and sorting each balance by its age produces the schedule. Keeping it accurate requires applying payments correctly, especially partial payments and payment-plan installments, because a payment applied to the wrong month makes the aging lie. For a landlord with several buildings, we keep the aging by property and in total, so you can see both a single problem building and the whole portfolio.
The schedule is only useful if it is current, so we update it as payments come in rather than once a year, which means at any point you can look and know exactly where you stand. That currency is what lets the aging drive real decisions, when a balance crosses into the ninety-day bucket, it is time to decide on a nonpayment case, and the aging is what flags the moment.
The aging also feeds two other things directly. It feeds the tax return, because the collected-versus-billed distinction it captures is what keeps cash-basis income accurate. And it feeds any housing court filing, because the exact, dated balance it shows is the number your attorney claims.
A well-built aging schedule also carries the supporting detail behind each balance, the lease rent, the dates of the payments received, and any partial applications, so that the number is not just a total but a defensible record. That backup is what makes the difference when a tenant disputes the amount owed, because you can show exactly how the balance was built month by month rather than asserting a lump sum, and it is the same detail that supports the deductions for legal and turnover costs when a delinquency ends in court.
Here is a worked example. Across two Brooklyn buildings you have fifteen tenants. The aging shows eleven current, two tenants thirty days behind at $2,400 and $2,600, one tenant sixty days behind at $5,000, and one tenant over ninety days behind at $11,400. In one glance you see about $21,400 of total arrears, and more importantly you see that the $11,400 tenant is the real problem headed for court while the thirty-day tenants are likely just late. That clarity is what the schedule buys you. We build and maintain it against your bookkeeping and use it to drive the recovery work in receivables and collections. The recordkeeping standard is in IRS Publication 527, and the state tax that rides on the collected rent is run by the New York State Department of Taxation and Finance.
Why does unpaid income tracking keep my New York City tax return accurate?
Unpaid income tracking keeps a New York City landlord’s return accurate because on the cash basis the return is supposed to report the rent you collected, not the rent you billed, and the only way to know the collected number precisely is to track the unpaid part. A real estate investor CPA leans on this because the difference between billed and collected rent is exactly the amount your tracking measures, and in a city stacking federal, state, and city tax, reporting the wrong one is expensive either way.
Here is why the cash basis makes tracking indispensable. Under the cash method, which most individual landlords use, rent becomes taxable income when you actually receive it, not when the lease says it is due. So if a tenant owes you rent at year end that they have not paid, that unpaid rent is not income yet, and it should not appear on your return. If your records only show what you billed, you would overstate income and pay tax on rent you never received, at a combined marginal rate that for many New York owners exceeds 40 percent. Tracking the unpaid balances is what lets you subtract them and report only the cash that came in.
The tracking also prevents the opposite error. When a tenant who was behind finally pays, that recovered rent is income in the year you receive it, and if you were not tracking the arrears you might miss the income or misdate it. So accurate tracking keeps both the current-year collected rent and any recovered back rent landing in the correct year, which is what an accurate cash-basis return requires.
It matters for consistency across years too. New York’s returns start from the federal numbers, so an error in what you report federally flows straight to the state and city returns, and an inconsistency between years, income appearing and disappearing without explanation, is the kind of thing that invites a notice. Clean tracking gives you a coherent multi-year story.
There is also a substantiation angle if a return is ever examined. If New York questions why your reported rental income is lower than the leases on file would suggest, the aging schedule is the answer, showing exactly which tenants were behind and by how much at year end, so the gap between billed and collected rent is documented rather than looking like unreported income. Without that record, a perfectly correct cash-basis return can be hard to defend, because the examiner sees leases totaling one number and a return showing a lower one and has nothing to bridge them.
Here is a worked example. Your rent roll bills $180,000 for the year. During the year two tenants fell behind, and your aging schedule shows $15,000 unpaid at December 31. It also shows that a formerly delinquent tenant paid off $6,000 of last year’s arrears during this year. Your correct cash-basis rental income is the $180,000 billed, minus the $15,000 still unpaid this year, plus the $6,000 recovered from last year, which is $171,000, not the $180,000 the rent roll alone suggests. Reporting $180,000 would have meant paying tax on $9,000 of net phantom rent. We keep the tracking feeding the return so the number is right, and coordinate the timing through your tax strategy consulting. The cash method is explained in IRS Publication 538, and the rental reporting rules are in IRS Publication 527.
How does a real estate investor CPA track recovered back rent for a New York City landlord?
Tracking recovered back rent is a specific part of unpaid income tracking, and a real estate investor CPA handles it carefully for a New York City landlord because a recovery creates taxable income in the year the cash arrives, and it has to be recorded against the right balance and with the right character so the return and the estimated payments stay correct. Recovered back rent is money you finally collect on a debt that was outstanding, whether through a payment plan, a housing court judgment, or a collection agency, and the tracking has to capture when it arrives and how much of it is truly yours.
The governing rule is the cash basis. Rent is taxable when received, regardless of the year it was owed, so a payment that clears an old arrears is income now, not retroactively in the year the rent was originally due, and no amended prior-year return is needed. The tracking job is to apply each incoming payment to the correct tenant and the correct old balance, so you can distinguish current rent from recovered arrears, and so the aging schedule shrinks correctly as recoveries come in.
Character matters when a third party is involved. If a collection agency recovers an old balance and remits it net of its fee, the full amount recovered is your income and the fee is a separate deductible expense, so the tracking must record the recovery gross rather than just booking the smaller net check. Recording only the net understates both your income and your deductions, which can create a mismatch that draws attention even when the bottom line is unchanged.
Timing is the planning piece. Because a recovery can be large and lands in one year, it can spike your income at New York’s top combined rate and, if big enough, leave your quarterly estimated payments short, triggering an underpayment penalty. Seeing the recovery coming in the tracking lets us adjust the estimates so it does not surprise you.
There is a further wrinkle when a recovery arrives as a lump-sum settlement for less than the full balance. If a tenant owed $12,000 and settles for $7,000, only the $7,000 you actually receive is income, because on the cash basis the $5,000 forgiven was never counted as income and simply never becomes taxable, and there is no separate deduction for the shortfall. Tracking has to record the $7,000 as the income and close out the remaining $5,000 as uncollected rather than as a bad-debt write-off, which keeps the treatment correct and avoids claiming a deduction that a cash-basis landlord is not entitled to.
Here is a worked example. Your aging shows a former tenant owed $12,000 that you placed with a collection agency. The agency recovers $8,000 and keeps a 25 percent fee, sending you $6,000. For tax, you record $8,000 of recovered rental income and deduct the $2,000 agency fee, netting to the $6,000 you banked, and all of it falls in this year. If the recovery had instead come as a $500-a-month payment plan, the tracking would record $500 of income each month as it arrived. Either way the tracking places the income in the right year and preserves the gross-versus-net detail. We reconcile these through your financial reconciliation and plan the tax around them. The reporting rules are in IRS Publication 527, and the state tax is administered by the New York State Department of Taxation and Finance.
Does unpaid income tracking include security deposits for a real estate investor CPA client in New York City?
Yes, security deposits belong in a landlord’s tracking even though they are not unpaid rent, because they are items on the ledger that can flip into taxable income at a specific moment, and a real estate investor CPA in New York City watches them closely so that conversion is caught in the right year. The starting point is that a security deposit you receive is not income, it is the tenant’s money you are holding and expect to return, and New York law requires many landlords to keep deposits in a separate account, so the tracking has to hold deposits apart from rent from the day the tenant moves in.
The tracking earns its value at the moments a deposit changes character. If a tenant moves out and you keep part or all of the deposit to cover unpaid rent, the amount you retain becomes rental income to you in that year, because it is now paying you rent you were owed. If you keep part to repair damage beyond normal wear and tear, the retained amount is income, though the repair cost is a deductible expense that often roughly offsets it. And if at the end of a lease you and the tenant apply the deposit to the last month’s rent, it becomes rent then. Each of these is a taxable event that tracking catches and that a landlord not watching the deposit ledger can easily miss or misdate.
Related items sit in the same category. Prepaid rent, a tenant paying a future month early, is income now on the cash basis even though it covers a later period, so the tracking flags it. Last-month rent collected at signing and tenant credit balances also have to be watched for when they convert. The common thread is that these are liabilities on your books until a specific event turns them into income, and only careful tracking places that income in the correct year.
Getting the year wrong cuts both ways in New York. Reporting a deposit as income too early means paying the stacked tax on money you are only holding and may return. Failing to report a retained deposit as income when you keep it understates income and can surface in an examination with penalty and interest.
New York adds a compliance layer that makes the deposit tracking matter beyond tax. State law limits how large a residential deposit can be, requires that it be held in a segregated account for many landlords, and requires prompt return with an itemized statement of any deductions after a tenant leaves. If your tracking does not cleanly separate each tenant’s deposit and document what you withheld and why, you risk not only a tax error but a dispute under the deposit law, where a landlord who cannot substantiate the deductions can be ordered to return the full amount. So tracking deposits carefully protects you on both fronts at once, the tax year of any retained amount and the legal duty to account for the deposit.
Here is a worked example. A tenant paid a $3,300 deposit and moves out owing $2,000 in rent and leaving $800 of damage beyond normal wear. You keep $2,800 of the deposit and return $500. Your tracking records that the $2,800 you retained becomes income this year, matched against the $2,000 of rent you were owed and offset by the $800 repair you deduct, so the net taxable effect is correct rather than overstated or missed. We track deposits, prepaid rent, and credit balances separately from rent and pick up each conversion in the right year, keeping the ledger straight against your bookkeeping. New York’s deposit rules are summarized by the New York Attorney General, and the federal income treatment is in IRS Publication 527.