Gated Rentals — Revenue dashboard (corrected per ADR-0012)

Generated 2026-05-15 03:04. Window: last 30 days. Read-only against prod Dataverse, both tenants.

Bug magnitude: the existing Crosbyprodinternal revrec dashboard books $18,450.00 of deposit intakes as revenue across both tenants in this window. Per ADR-0012, deposit intakes are liabilities (we owe them back). This replica corrects the categorization.

Portfolio totals

$199,193.14Corrected revenue (V2)
$184,740.00Period-spread revenue
$13,797.78Instant revenue
$655.36Forfeits → revenue
$18,450.00Deposit intakes (liability ↑)
$2,242.34Deposit refunds (liability ↓)
$0.00Contra-revenue refunds

Per-tenant rollup

TenantCorrected revenueDeposits intakeDeposits refundForfeitsContra-revenueLines
Crosby Heights GRFIS1 $82,723.83 $11,850.00 $1,001.96 $0.00 $0.00 406
Willis Lakes GRFIS2 $116,469.31 $6,600.00 $1,240.38 $655.36 $0.00 561

Revenue — by tenant + daily breakdown

Crosby Heights

$82,723.83Corrected revenue
$77,115.00Revenue (period-spread)
$5,608.83Revenue (instant)
$0.00Revenue (forfeit)

Daily — most recent 30

DatePeriod revInstant revForfeitContra-revNet
2026-05-14$3,350.00$0.00$0.00$0.00$3,350.00
2026-05-13$2,875.00$77.00$0.00$0.00$2,952.00
2026-05-12$1,100.00$27.00$0.00$0.00$1,127.00
2026-05-11$3,000.00$112.00$0.00$0.00$3,112.00
2026-05-09$3,480.00$0.00$0.00$0.00$3,480.00
2026-05-08$5,825.00$52.00$0.00$0.00$5,877.00
2026-05-07$0.00$60.00$0.00$0.00$60.00
2026-05-06$1,775.00$23.50$0.00$0.00$1,798.50
2026-05-05$2,145.00$216.00$0.00$0.00$2,361.00
2026-05-04$1,745.00$1,629.00$0.00$0.00$3,374.00
2026-05-02$3,990.00$74.00$0.00$0.00$4,064.00
2026-05-01$3,560.00$2,521.90$0.00$0.00$6,081.90
2026-04-30$4,465.00$0.00$0.00$0.00$4,465.00
2026-04-29$3,895.00$52.00$0.00$0.00$3,947.00
2026-04-28$5,530.00$54.50$0.00$0.00$5,584.50
2026-04-27$4,490.00$148.00$0.00$0.00$4,638.00
2026-04-25$3,580.00$0.00$0.00$0.00$3,580.00
2026-04-24$3,715.00$114.00$0.00$0.00$3,829.00
2026-04-23$2,570.00$0.00$0.00$0.00$2,570.00
2026-04-22$2,185.00$0.00$0.00$0.00$2,185.00
2026-04-21$1,970.00$54.00$0.00$0.00$2,024.00
2026-04-20$1,520.00$52.00$0.00$0.00$1,572.00
2026-04-18$2,960.00$87.00$0.00$0.00$3,047.00
2026-04-17$3,010.00$62.00$0.00$0.00$3,072.00
2026-04-16$1,890.00$0.00$0.00$0.00$1,890.00
2026-04-15$1,695.00$0.00$0.00$0.00$1,695.00
2026-04-06$0.00$192.93$0.00$0.00$192.93
2026-04-02$795.00$0.00$0.00$0.00$795.00

Willis Lakes

$116,469.31Corrected revenue
$107,625.00Revenue (period-spread)
$8,188.95Revenue (instant)
$655.36Revenue (forfeit)

Daily — most recent 30

DatePeriod revInstant revForfeitContra-revNet
2026-05-15$0.00$50.00$0.00$0.00$50.00
2026-05-14$7,815.00$216.00$0.00$0.00$8,031.00
2026-05-13$235.00$52.00$0.00$0.00$287.00
2026-05-12$1,265.00$0.00$0.00$0.00$1,265.00
2026-05-11$4,095.00$25.00$0.00$0.00$4,120.00
2026-05-09$1,375.00$27.50$0.00$0.00$1,402.50
2026-05-08$4,430.00$52.00$0.00$0.00$4,482.00
2026-05-07$4,565.00$25.00$0.00$0.00$4,590.00
2026-05-06$7,360.00$52.00$0.00$0.00$7,412.00
2026-05-05$5,405.00$2,421.14$655.36$0.00$8,481.50
2026-05-04$12,135.00$79.50$0.00$0.00$12,214.50
2026-05-02$1,925.00$55.00$0.00$0.00$1,980.00
2026-05-01$5,085.00$3,845.31$0.00$0.00$8,930.31
2026-04-30$5,660.00$106.00$0.00$0.00$5,766.00
2026-04-29$1,620.00$0.00$0.00$0.00$1,620.00
2026-04-28$1,050.00$104.00$0.00$0.00$1,154.00
2026-04-27$9,850.00$77.00$0.00$0.00$9,927.00
2026-04-24$4,220.00$132.00$0.00$0.00$4,352.00
2026-04-23$9,110.00$207.00$0.00$0.00$9,317.00
2026-04-22$2,335.00$55.00$0.00$0.00$2,390.00
2026-04-20$3,740.00$111.00$0.00$0.00$3,851.00
2026-04-18$1,805.00$0.00$0.00$0.00$1,805.00
2026-04-17$6,270.00$52.00$0.00$0.00$6,322.00
2026-04-16$4,760.00$129.00$0.00$0.00$4,889.00
2026-04-15$1,245.00$135.00$0.00$0.00$1,380.00
2026-04-14$80.00$78.50$0.00$0.00$158.50
2026-04-13$0.00$55.00$0.00$0.00$55.00
2026-04-10$0.00$23.50$0.00$0.00$23.50
2026-04-08$0.00$23.50$0.00$0.00$23.50
2026-04-02$190.00$0.00$0.00$0.00$190.00

Deposits — liability ledger

Deposit intakes raise the liability we owe back to residents. Refunds and forfeits reduce that liability. None of these movements is revenue, with the exception of forfeit (which moves liability → revenue at the decision moment).

Crosby Heights

$11,850.00Intakes (window)
$1,001.96Refunds (window)
$0.00Forfeits → revenue
$10,848.04Net liability change (window)

Recent intakes (top 30)

DateInvoiceProductAmountStatus
2026-04-28Crosby-INV-0639Security Deposit$500.00Paid
2026-04-29Crosby-INV-0642Security Deposit$500.00Paid
2026-04-29Crosby-INV-0645Pet Deposit (Per Pet)$500.00Paid
2026-04-28Crosby-INV-0627Security Deposit$500.00Paid
2026-04-24Crosby-INV-0586Security Deposit$500.00Paid
2026-04-24Crosby-INV-0595Security Deposit$500.00Paid
2026-04-24Crosby-INV-0588Security Deposit$500.00Paid
2026-04-16Crosby-INV-0522Security Deposit$500.00Paid
2026-04-16Crosby-INV-0527Pet Deposit (Per Pet)$500.00Paid
2026-04-21Crosby-INV-0561Security Deposit$500.00Paid
2026-05-08Crosby-INV-0820Security Deposit$500.00Paid
2026-05-14Crosby-INV-0868Security Deposit$500.00Paid
2026-04-30Crosby-INV-0664Security Deposit$500.00Paid
2026-04-30Crosby-INV-0667Security Deposit$500.00Paid
2026-05-05Crosby-INV-0775Security Deposit$500.00Paid
2026-05-05Crosby-INV-0777Security Deposit$500.00Active
2026-05-05Crosby-INV-0780Security Deposit$500.00Paid
2026-05-05Crosby-INV-0780Pet Deposit (Per Pet)$500.00Paid
2026-05-13Crosby-INV-0861Security Deposit$500.00Paid
2026-05-13Crosby-INV-0861Pet Deposit (Per Pet)$500.00Paid
2026-05-01Crosby-INV-0741Security Deposit$500.00Paid
2026-05-05Crosby-INV-0789Security Deposit$500.00Paid
2026-05-05Crosby-INV-0789Pet Deposit (Per Pet)$500.00Paid
2026-05-11Crosby-INV-0840Security Deposit$500.00Paid
2026-04-27Crosby-INV-0621Security Deposit$500.00Paid
2026-04-27Crosby-INV-0623Security Deposit$500.00Paid
2026-05-14Crosby-INV-0873Fob Deposit$100.00Paid
2026-04-24Crosby-INV-0596Fob Deposit$50.00Paid
2026-04-23Crosby-INV-0573Fob Deposit$50.00Paid
2026-04-25Crosby-INV-0609Fob Deposit$50.00Paid

Willis Lakes

$6,600.00Intakes (window)
$1,240.38Refunds (window)
$655.36Forfeits → revenue
$4,704.26Net liability change (window)

Recent intakes (top 30)

DateInvoiceProductAmountStatus
2026-04-28Willis-INV-2701Security Deposit $500$500.00Canceled
2026-04-15Willis-INV-2545Security Deposit $500$500.00Paid
2026-05-01Willis-INV-2825Security Deposit $500$500.00Paid
2026-05-01Willis-INV-2826Security Deposit $500$500.00Paid
2026-05-01Willis-INV-2827Security Deposit $500$500.00Paid
2026-04-20Willis-INV-2601Security Deposit $500$500.00Paid
2026-04-22Willis-INV-2608Security Deposit $500$500.00Paid
2026-04-27Willis-INV-2669Security Deposit $500$500.00Paid
2026-04-27Willis-INV-2695Security Deposit $500$500.00Canceled
2026-05-02Willis-INV-2839Security Deposit $500$500.00Paid
2026-05-05Willis-INV-2881Pet Deposit (Per Pet)$500.00Paid
2026-05-05Willis-INV-2881Security Deposit $500$500.00Paid
2026-05-06Willis-INV-2899Security Deposit $500$500.00Paid
2026-05-06Willis-INV-2913Security Deposit $500$500.00Paid
2026-04-24Willis-INV-2660Security Deposit $500$500.00Paid
2026-04-17Willis-INV-2567Pet Deposit (Per Pet)$500.00Paid
2026-05-12Willis-INV-2968Security Deposit $500$500.00Paid
2026-04-30Willis-INV-2712FOB Deposit$50.00Paid
2026-04-17Willis-INV-2566FOB Deposit$50.00Paid
2026-05-05Willis-INV-2894Security Deposit $500$-500.00Paid
2026-05-05Willis-INV-2895Security Deposit $500$-500.00Paid
2026-05-05Willis-INV-2895Pet Deposit (Per Pet)$-500.00Paid
2026-05-05Willis-INV-2896Security Deposit $500$-500.00Paid

Outstanding deposit liability across all residents (cumulative, not just last 30d) requires summing all-time deposit intakes minus refunds minus forfeits per resident. The portal V2 schema's refund table (kind enum) is the canonical place for this once it's deployed; until then, see tools/refunds-tracker/ (queued).

Refunds tracker

Two distinct refund kinds:

  • Deposit refunds (security / pet / FOB / electrical deposits returned to customer) — balance-sheet only, reduces liability. NOT a revenue movement.
  • Contra-revenue refunds (application-fee refund, rent refund, pet-fee refund, propane refund, transaction-fee refund) — these DO reduce revenue, recognized at the moment of refund.

Crosby Heights

$1,001.96Deposit refunds
$0.00Contra-revenue refunds
4Refund lines

Recent refunds (top 50)

DateKindInvoiceProductAmount
2026-05-11deposit_refund (balance-sheet)Crosby-INV-0848Security Deposit (Return to Customer)$50.00
2026-05-05deposit_refund (balance-sheet)Crosby-INV-0786Security Deposit (Return to Customer)$0.00
2026-04-30deposit_refund (balance-sheet)Crosby-INV-0659Security Deposit (Return to Customer)$487.69
2026-04-23deposit_refund (balance-sheet)Crosby-INV-0575Security Deposit (Return to Customer)$464.27

Willis Lakes

$1,240.38Deposit refunds
$0.00Contra-revenue refunds
2Refund lines

Recent refunds (top 50)

DateKindInvoiceProductAmount
2026-05-05deposit_refund (balance-sheet)Willis-INV-2895Security Deposit (Return to Customer)$777.49
2026-05-05deposit_refund (balance-sheet)Willis-INV-2896Security Deposit (Return to Customer)$462.89

By product — per tenant

Crosby Heights

ProductCategoryLinesTotal
Weekly Rent 275Revenue (period-spread)105$40,115.00
Rent -Weekly (Non Lake View)-$235Revenue (period-spread)74$19,495.00
Rent Weekly $265Revenue (period-spread)28$10,080.00
Security DepositDeposit intake (LIABILITY)24$9,000.00
$225 Rent -Weekly (Non Lake View)-Opening discount-First responder/teacherRevenue (period-spread)28$7,425.00
Pet Deposit (Per Pet)Deposit intake (LIABILITY)5$2,500.00
Electrical ChargeRevenue (instant)67$2,280.90
LaundryRevenue (instant)1$1,629.00
Security Deposit (Return to Customer)Deposit refund (LIAB. reduction)4$1,001.96
Application FeeRevenue (instant)17$759.00
Propane- NewRevenue (instant)7$422.00
Late FeeRevenue (instant)7$409.93
Fob DepositDeposit intake (LIABILITY)8$350.00
Pet Fee (Per Pet)Unknown (needs review)27$320.00
Propane SwapRevenue (instant)4$108.00

Willis Lakes

ProductCategoryLinesTotal
Rent -Weekly (Non Lake View) $275Revenue (period-spread)276$89,660.00
Rent -Weekly (Non Lake View)-$235Revenue (period-spread)57$17,295.00
Security Deposit $500Deposit intake (LIABILITY)18$6,000.00
ElectricityRevenue (instant)97$3,845.31
LaundryRevenue (instant)1$2,240.64
Security Deposit (Return to Customer)Deposit refund (LIAB. reduction)2$1,240.38
Single Applicant $52Revenue (instant)19$980.00
Late FeeRevenue (instant)26$691.00
Day RateRevenue (period-spread)7$670.00
Pet Fee (Per Pet)Unknown (needs review)41$610.00
Security Deposit forfeitRevenue (forfeit)2$505.36
Pet Deposit (Per Pet)Deposit intake (LIABILITY)3$500.00
Propane no TankRevenue (instant)5$230.00
Pet Deposit ForfeitureRevenue (forfeit)1$150.00
FOB DepositDeposit intake (LIABILITY)2$100.00
Co-Applicant $77Revenue (instant)1$77.00
Co-Applicant Fee $75Revenue (instant)1$75.00
Propane RefillRevenue (instant)2$50.00

Unknown classifications — staff review

Lines whose product name didn't match any canonical category. Each should be (a) added to packages/product-catalog/catalog.v2.json, (b) mapped to an existing canonical key via upstream.dataverse_product_id, or (c) flagged for deactivation if obsolete.

Crosby Heights — 27 rows

DateInvoiceProductAmount
2026-05-14Crosby-INV-0878Pet Fee (Per Pet)$10.00
2026-05-13Crosby-INV-0853Pet Fee (Per Pet)$10.00
2026-05-13Crosby-INV-0858Pet Fee (Per Pet)$10.00
2026-05-11Crosby-INV-0838Pet Fee (Per Pet)$10.00
2026-05-09Crosby-INV-0826Pet Fee (Per Pet)$10.00
2026-05-08Crosby-INV-0809Pet Fee (Per Pet)$20.00
2026-05-06Crosby-INV-0794Pet Fee (Per Pet)$10.00
2026-05-06Crosby-INV-0795Pet Fee (Per Pet)$10.00
2026-05-06Crosby-INV-0801Pet Fee (Per Pet)$10.00
2026-05-05Crosby-INV-0781Pet Fee (Per Pet)$10.00
2026-05-05Crosby-INV-0783Pet Fee (Per Pet)$10.00
2026-05-05Crosby-INV-0791Pet Fee (Per Pet)$10.00
2026-05-04Crosby-INV-0766Pet Fee (Per Pet)$10.00
2026-05-02Crosby-INV-0760Pet Fee (Per Pet)$20.00
2026-04-29Crosby-INV-0655Pet Fee (Per Pet)$10.00
2026-04-28Crosby-INV-0631Pet Fee (Per Pet)$20.00
2026-04-28Crosby-INV-0633Pet Fee (Per Pet)$10.00
2026-04-27Crosby-INV-0613Pet Fee (Per Pet)$10.00
2026-04-25Crosby-INV-0601Pet Fee (Per Pet)$10.00
2026-04-24Crosby-INV-0583Pet Fee (Per Pet)$20.00
2026-04-22Crosby-INV-0570Pet Fee (Per Pet)$10.00
2026-04-22Crosby-INV-0571Pet Fee (Per Pet)$20.00
2026-04-20Crosby-INV-0550Pet Fee (Per Pet)$10.00
2026-04-18Crosby-INV-0541Pet Fee (Per Pet)$10.00
2026-04-15Crosby-INV-0514Pet Fee (Per Pet)$10.00
2026-04-15Crosby-INV-0516Pet Fee (Per Pet)$10.00
2026-04-02Crosby-INV-0402Pet Fee (Per Pet)$10.00

Willis Lakes — 41 rows

DateInvoiceProductAmount
2026-05-14Willis-INV-2994Pet Fee (Per Pet)$10.00
2026-05-14Willis-INV-2997Pet Fee (Per Pet)$10.00
2026-05-14Willis-INV-3003Pet Fee (Per Pet)$10.00
2026-05-12Willis-INV-2967Pet Fee (Per Pet)$10.00
2026-05-12Willis-INV-2965Pet Fee (Per Pet)$10.00
2026-05-11Willis-INV-2952Pet Fee (Per Pet)$30.00
2026-05-08Willis-INV-2931Pet Fee (Per Pet)$10.00
2026-05-08Willis-INV-2936Pet Fee (Per Pet)$10.00
2026-05-07Willis-INV-2917Pet Fee (Per Pet)$10.00
2026-05-07Willis-INV-2920Pet Fee (Per Pet)$10.00
2026-05-07Willis-INV-2922Pet Fee (Per Pet)$10.00
2026-05-07Willis-INV-2923Pet Fee (Per Pet)$10.00
2026-05-05Willis-INV-2880Pet Fee (Per Pet)$20.00
2026-05-05Willis-INV-2877Pet Fee (Per Pet)$10.00
2026-05-05Willis-INV-2882Pet Fee (Per Pet)$50.00
2026-05-04Willis-INV-2845Pet Fee (Per Pet)$10.00
2026-05-04Willis-INV-2851Pet Fee (Per Pet)$40.00
2026-05-04Willis-INV-2855Pet Fee (Per Pet)$30.00
2026-05-04Willis-INV-2860Pet Fee (Per Pet)$10.00
2026-05-04Willis-INV-2869Pet Fee (Per Pet)$10.00
2026-05-01Willis-INV-2836Pet Fee (Per Pet)$10.00
2026-05-01Willis-INV-2828Pet Fee (Per Pet)$10.00
2026-05-01Willis-INV-2833Pet Fee (Per Pet)$10.00
2026-04-27Willis-INV-2681Pet Fee (Per Pet)$30.00
2026-04-27Willis-INV-2684Pet Fee (Per Pet)$10.00
2026-04-27Willis-INV-2686Pet Fee (Per Pet)$10.00
2026-04-27Willis-INV-2693Pet Fee (Per Pet)$10.00
2026-04-24Willis-INV-2658Pet Fee (Per Pet)$10.00
2026-04-24Willis-INV-2653Pet Fee (Per Pet)$10.00
2026-04-24Willis-INV-2662Pet Fee (Per Pet)$20.00
2026-04-23Willis-INV-2642Pet Fee (Per Pet)$10.00
2026-04-23Willis-INV-2648Pet Fee (Per Pet)$10.00
2026-04-20Willis-INV-2600Pet Fee (Per Pet)$10.00
2026-04-20Willis-INV-2604Pet Fee (Per Pet)$10.00
2026-04-20Willis-INV-2606Pet Fee (Per Pet)$10.00
2026-04-18Willis-INV-2594Pet Fee (Per Pet)$30.00
2026-04-17Willis-INV-2570Pet Fee (Per Pet)$30.00
2026-04-17Willis-INV-2576Pet Fee (Per Pet)$10.00
2026-04-17Willis-INV-2567Pet Fee (Per Pet)$20.00
2026-04-16Willis-INV-2561Pet Fee (Per Pet)$10.00