Rent-Roll Truth Check
Rebuild reported occupancy from deposits. The rent roll is a claim. Deposits are the verification.
3 sections · about 10 minutes· runs in your browser
What you type starts as Broker-reported. Mark it Verified only when you can point to the source. What the tool computes is Calculated. Missing is named, never zeroed.
(a) Rent roll rows
One row per unit or site. Check POH when the park owns the home, not just the lot.
Unit 1
(b) Trailing monthly deposit totals
Twelve months of bank deposits, most recent first. Blank is fine; blank months are Missing evidence, never zero.
(c) Reported occupancy
What the deposits say
Deposit-derived occupancy
Trailing deposits / gross potential monthly rent, averaged over 0 month(s)
Reported vs derived variance
Reported occupancy minus deposit-derived occupancy
Units over 60 days overdue
Rent roll rows with days overdue above 60
POH rent subtotal (monthly)
Sum of monthly rent on park-owned-home rows
Lot rent subtotal (monthly)
Total monthly rent minus POH rent
Gross potential monthly rent
Sum of monthly rent across all rows
Close the gaps
12 of 12 deposit months are Missing evidence. Name who gets the statements and when.
Outputs are Calculated. Mark each input Verified only when you can point to the source.
Evidence-readiness posture
Pause
The record supports Pause: reported occupancy is Missing evidence. The truth check needs the OM's number to measure the deposits against. Pull it from the broker package.
Calculated from your inputs. Nothing here is verified until you verify it. The human decides.
Advance, Retrade, Pause, and Walk are evidence-readiness labels. They are not recommendations, approvals, or advice.
Keep the record
The tool is free to use. Email is only asked when you save or export. Take the working paper with you. available for your records. Your numbers stay in your browser until you choose to move them.
Questions
The rent roll is a claim written by the seller. Deposits are the verification. This tool rebuilds occupancy from trailing bank deposits and measures the gap between the two.
Trailing monthly deposits are divided by gross potential monthly rent, averaged across the months on the record. Blank months are excluded from the average, never treated as zero.
Deposits trail the reported occupancy by more than 5 points. The record supports Pause. That gap is either a retrade or a walk, and the record does not say which yet.
Then reported occupancy is Missing evidence and the posture is Pause. The tool never asserts a comparison against a number that is not on the record.
The next step
The deposits do not match the OM.
That gap is a retrade or a walk. Running a live deal? The Acquisition Workspace keeps the full record.
Bring my rent roll to the fit call.