LIVE DATABASE SANDBOXYou are viewing the live PostgreSQL sandbox portfolio. Sign in via Resend Magic Link to create your own private portfolio.
Building: Kaunas Oak Residency (4 Doors Tracked in PostgreSQL)Inbound Inbox: kaunas-oak@in.billaily.com
Multi-Apartment Utility PDF Ingestion & Tenant Ledger Workspace
98/100 PDFs auto-assigned via Pass-1 Meter Serial & Pass-2 Door Parser • 2/100 in Constrained Missing-Bill Exception Queue
Live Gemini 2.5 Multimodal AI Ingestion + PostgreSQL 16 Persistence
Drop a Utility Bill PDF/Image or Test Live Gemini 2.5 Extraction
Extracts provider, meter serial, customer code, kWh/m³, and € amount, runs the 3-Pass Matcher, and saves directly to PostgreSQL (utility_bills & tenant_ledger_entries).
Utility PDFs Ingested
100 / 100
SHA-256 deduplicated
Auto-Assigned (Pass 1 & 2)
98 / 100 (98%)
Matched by Meter & Door #
Exception Queue
2 Pending
Filtered to missing doors
Leak & Variance Alerts
2 Active Flags
Vacant Water Leak Detected
1. The 2/100 Constrained Exception Queue (Smart Candidate Filtering)
For the 2% of PDFs missing a door number, Billaily filters the dropdown to only the apartments in that building still missing that utility bill for 2026-10 — and permanently learns the meter serial into PostgreSQL unit_meters.
water • 2026-10€34.90 (7.80 m³)
Kauno Vandenys UAB — Raw Address: “Oak St 14, Kaunas (Bulk Municipal PDF — Missing Door #)”
Meter Serial: MTR-WATER-4B-99201 • Customer Code: KV-882910
🎯 2 of 4 units still missing 2026-10 water bill: Apt 102, Apt 4B
water • 2026-10€22.80 (5.10 m³)
Kauno Vandenys UAB — Raw Address: “Oak St 14 (Scanned Invoice — Unclear Flat)”
Meter Serial: MTR-WATER-102-33180 • Customer Code: KV-441029
🎯 2 of 4 units still missing 2026-10 water bill: Apt 102, Apt 4B
• 98 of 100 October PDFs auto-assigned (Pass-1 Meter Serial @ 1.000 confidence & Pass-2 Door Parser @ 0.950 confidence).
2. Continuous Tenancy Debt, Overpayment Credit & Mid-Month Proration Grid
Try entering €150.00 on an apartment's bill to see running_balance_cents turn into a negative Overpayment Credit in PostgreSQL.
| Door & Status | Tenant & Proration | Prior Debt / Credit | Oct Utilities | Net Balance Due | Anomaly Flags | Payment Status | 1-Click Confirm Payment |
|---|---|---|---|---|---|---|---|
Apt 101 OCCUPIED | Jonas Kazlauskas Open Tenant Link (/t/tok_asta_14) | €0.00 | €112.60 | €112.60 | None | PENDING_CONFIRMATION | |
Apt 102 OCCUPIED | Egle Petrauskiene (Mid-Month Move-In Oct 18) 🔄 Prorated: Oct 1–15 Mantas V. (15/31d); Oct 16–17 Vacant (2/31d); Oct 18–31 Egle P. (14/31d) Open Tenant Link (/t/tok_asta_14) | +€23.12 Debt | €51.20 | €74.32 | None | UNPAID | |
Apt 201 VACANT | Vacant Unit (Landlord Ledger) Open Tenant Link (/t/tok_asta_14) | €0.00 | €61.50 | €61.50 | ⚠️ VACANT_UNIT_USAGE⚠️ HIGH_VARIANCE_SPIKE | UNPAID | |
Apt 4B OCCUPIED | Asta Jankauskaite Open Tenant Link (/t/tok_asta_14) | -€30.00 Credit | €98.00 | €68.00 | None | CONFIRMED_PAID |