How to Audit a DFW Turnkey SFR Rent Roll: Stated Rent vs Actual Collections and Concession Red Flags

How do you audit a DFW turnkey SFR rent roll for stated rent vs actual collections?

You audit a rent roll by reconciling every line of stated rent against actual collections, then stress-testing concessions, credits, and arrears until the cash that hit the operating account matches what the seller is asking you to underwrite—not the face rent on a PDF.

If you buy turnkey single-family rentals in Dallas–Fort Worth without living nearby, the rent roll is often the first document that looks “done.” It is also the document that quietly embeds the largest underwriting errors. Stated rent is a marketing number until collections, concessions, and timing prove otherwise. The practical way to audit rent roll turnkey DFW single family rental actual collections is to treat the roll as a claims list, then rebuild trailing cash from bank deposits, owner statements, and lease exhibits before you accept any pro forma.

What should a clean DFW turnkey SFR rent roll actually contain?

A usable rent roll is not a one-column list of addresses and monthly rents. For a DFW single-family rental being sold as turnkey, insist on a line-level file that includes: unit/property ID, lease start and end, current monthly contract rent, other recurring charges (pet rent, garage, storage if any), security deposit held, concession or free-rent balance remaining, prepaid rent, current balance due, last payment date, payment method pattern, and notice status if any.

Ask for the same data in two formats: the broker/PM export and the trailing twelve owner statements. If those two sources disagree on contract rent by even $25–$50 on a $2,100 house in a Fort Worth or southern Dallas suburb, stop and reconcile before you model debt service. Clean rolls also flag month-to-month status explicitly. “Lease ends 08/31” with no renewal executed is not the same as a firm twelve-month term, and your collections risk is different.

How do you separate stated rent from actual collections in underwriting?

Stated rent is the contractual face amount. Actual collections are what cleared into the property account after NSFs, partials, fee waivers, and owner credits. Build a simple three-column worksheet for the last 12 months:

1. Contract rent billed
2. Cash collected (rent only, not late fees)
3. Variance and reason code

Then compute two ratios. Collections-to-billed = cash rent collected ÷ contract rent billed. Economic occupancy proxy = cash rent collected ÷ market rent you would use if the unit were vacant and re-leased today. On a $2,050 stated rent house, twelve months of billed rent is $24,600. If owner statements show $23,100 of rent cash after two months of half-payments and one $400 concession amortization, collections-to-billed is about 93.9%. That is not a catastrophe, but it is not $2,050 either. Underwrite the cash, then decide whether the gap is temporary (lease-up, one-time credit) or structural (weak tenant, soft submarket, chronic discounting).

Which concession structures are normal in DFW—and which are red flags?

Concessions are common in competitive DFW zip codes when inventory of similar 3/2 homes is high or when a property sat vacant. A one-time $500 move-in credit or half-month free on a twelve-month lease can be rational if the alternative was 45–60 days vacant. Red flags look different: recurring “owner credit” lines every month, “rent reduced for maintenance inconvenience” with no work-order closeout, free rent still running in month 10 of a 12-month term, or a concession that was never written into the lease but appears only on the ledgers.

Work a concrete test. Lease says $1,995. Rent roll shows $1,995. Owner statement shows $1,795 for four consecutive months with memo “promo.” Annualize that incorrectly at $1,995 and you overstate income by $2,400 before vacancy and bad debt. Prefer concessions that are front-loaded, fully disclosed, and already burned off before closing. Discount or re-trade when the effective rent only equals stated rent if you assume the next tenant pays full freight with zero friction.

How do you verify trailing collections without relying on the seller’s PDF alone?

Do not stop at the rent roll export. Request: (1) trailing 12 months of owner draws/statements, (2) rent ledger by tenant with payment dates, (3) bank deposit detail or PM trust account reports if available, (4) the executed lease plus all addenda, and (5) a current tenant ledger through the most recent open period. Then pick three months at random—one peak summer month, one winter month, and the most recent full month—and tie cash rent from ledger → statement → deposit total.

Mini step-by-step many out-of-state buyers skip:

1. Total contract rent on the roll for Month X.
2. Sum rent-only receipts on the tenant ledger for Month X.
3. Confirm the owner statement rent line matches within a few dollars.
4. Explain every variance over $100 with a document (NSF reverse, concession, partial, eviction filing, owner-hold).
5. Repeat for two more months. If you cannot tie two of three months, treat the roll as unverified.

For international buyers, this paper trail matters more than a polished photo set. You are underwriting a cash machine you will not walk weekly.

What late-fee, partial-payment, and arrears patterns should change your bid?

A tenant who pays $2,100 on the 1st is not the same credit as a tenant who pays $700 weekly and extinguishes balance on the 20th after two late-fee waivers. Look at the last six payment events, not the balance today. Patterns that deserve a tighter bid or escrow holdback: repeated partials, balances that clear only after “payment plan” notes, NSF followed by money order, and arrears that reset every quarter without a formal repayment addendum.

Numbers help. Suppose stated rent is $1,875 and the ledger shows on-time full pay in 3 of last 6 months, with the other three months collecting between day 12 and day 24. Your default underwriting should not use 100% of $1,875 as stabilized month-one cash. Use a collections haircut (for example, model 95–97% of contract rent until a clean six-month streak exists), or require estoppel plus confirmation that no side agreement exists. Arrears cured in the last 30 days before listing deserve special skepticism—sometimes they are real catch-up, sometimes they are seller-funded cosmetics.

How should month-to-month, early termination, and renewal timing affect the audit?

DFW SFR leases often end in summer. A rent roll stamped in February with three homes rolling in June–August is a different risk stack than a laddered book with expirations every other month. Month-to-month after a fixed term can be fine with a strong payer and clear notice terms; it is not fine if the roll still displays the old fixed rent while the market has moved, or if the tenant has already given notice that is missing from the summary tab.

Audit questions to force into the file: Has renewal been offered in writing? At what rent? Was any renewal concession discussed? Is there a notice to vacate? If a lease expires 45 days after your target close, your underwriting should include a vacant-ready budget path (make-ready, days vacant, reletting fee) even if the current tenant “plans to stay.” Plans are not cash. For turnkey marketplaces aimed at passive and foreign investors, the honest move is to show both paths: stay-at-current-rent and turnover-at-market, with collections history attached to the stay case.

What is a practical due-diligence checklist before you accept the seller’s income line?

Use this as a close-ready gate, not a vibe check:

• Lease PDF matches rent roll fields: rent, term, deposits, pet rent, who pays which utilities.
• Last 12 months collections tied for at least three sample months.
• Concessions scheduled and remaining balance disclosed to the day.
• Security deposit liability listed and matches lease.
• No undocumented side deals (cash side payments, “owner will handle lawn,” temporary rent cuts).
• Estoppel certificate requested from tenant confirming rent, deposit, and no promises.
• PM transition terms clear if you are keeping or replacing management.
• Income model uses actual collections first, stated rent second, market rent third.

If you are comparing multiple DFW turnkey options, standardize the worksheet so every asset is scored on the same collections-to-billed and concession-adjusted rent. That is how you avoid buying the prettiest pro forma instead of the best verified cash history.

How do out-of-state and international investors operationalize this without a local team on day one?

You do not need to live in Arlington or McKinney to run this audit, but you do need document discipline and a single accountable manager. Require a virtual data room with naming conventions, not a text-thread of screenshots. Have your CPA or bookkeeper reconcile the T12 once; you are looking for pattern recognition, not doing monthly bookkeeping yourself. On calls with the listing PM, ask them to screen-share the live ledger, not a static roll from last week.

For foreign investors, add time-zone and banking realities: confirm how rent is collected (ACH, portal, check), how owner distributions are sent, and whether any tenant concessions were used to mask slow lease-up after a prior sale fell through. Passive does not mean unverified. Passive means the verification is front-loaded into underwriting so day-one cash flow is based on money that already behaved, not on a headline rent that never fully collected.

Frequently asked questions

Is stated rent on a DFW rent roll ever safe to underwrite at 100%?

Only after you have tied recent actual collections and confirmed concessions are gone. Even then, many careful buyers still apply a small ongoing vacancy/credit loss factor because single-family books are lumpy. Treat 100% of stated rent as a ceiling for discussion, not a default assumption for closing.

What collections-to-billed ratio should concern me on a turnkey SFR?

Context matters, but sustained results materially below the mid-90s without a clear, documented cause deserve a slower bid or a price adjustment. One bad month after a job loss is different from three quarters of partials and credits. Ask for the story, then demand the ledger that proves the story ended.

Do free rent and owner credits need to be added back when I model resale or refinance later?

Lenders and future buyers will care about durable contract rent and recent cash, not a temporary promo. Do not annualize a post-concession spike until you have clean months at the new face rent. Keep a bridge schedule that shows effective rent by month so nobody confuses a burned-off discount with sudden market appreciation.

Should I walk away if the seller will only send a one-page rent roll?

Usually yes, or at least pause hard. A one-pager without ledgers, leases, and T12 statements is a brochure. Turnkey is a delivery method for an operating asset; if the operating history cannot be audited, you are not buying turnkey income—you are buying a narrative.

Can I complete this audit entirely remote before creating a purchase path?

Yes. Remote buyers do this every week with shared data rooms, video ledger reviews, and third-party lease/estoppel checks. Create a free account on platforms that show pricing and underwriting detail up front so you spend diligence hours on assets that already clear a basic numbers screen.

If you want to practice this audit on live DFW inventory with visible pricing and underwriting detail, create a free account and review current tenanted listings at https://liquidsfr.com/investment-properties?utm_source=x&utm_medium=post&utm_campaign=buyerlist.

Educational content only. Not legal, tax, or investment advice.