The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
AI-assisted spreadsheet-cleanup demonstration using fictional business data. Eight source rows became six unique records after two duplicates were removed. Business names, website URLs and phone formatting were standardized, while missing information stayed blank. The original data was preserved for comparison.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Challenges
View all
Related posts
Superb
AI Rent & Arrears Follow-Up Automation: Property Management Dashboard
A working demo of an arrears management dashboard for property managers. It detects overdue tenants, ranks who to follow up first, and drafts safe, factual tenant messages from stored data.
Chasing late rent is slow and inconsistent. Managers often don't know whom to contact first, and messages are written from scratch each time. I built a demo system that turns rent and payment data into a clear daily workflow:
Rent data → arrears detection → priority → follow-up message → escalation → resolution
What it does:
Dashboard: total rent due, collected, outstanding, overdue tenants, high-risk accounts and follow-ups due today.
Arrears queue: every overdue tenant with property, amount, days overdue, priority and a suggested action.
AI Arrears Prioritization: automatically ranks who the manager should contact first, based on days overdue, amount owed and past payment behaviour.
Account analysis: shows the amount outstanding, days overdue, payment history, communication log and a recommended next action for any tenant.
Tenant message generation: drafts a polite reminder, follow-up or escalation message matched to the account's stage.
Manual stage control: the manager moves each account through Reminder, Follow-up, Escalation and Resolved.
Tech stack: Python, Flask, SQLite, HTML, CSS, JavaScript, with optional local AI through Ollama and a rule-based fallback. It needs no paid APIs and runs fully offline.
Demo data: 5 properties, 20 units and tenants, six months of payment history and prior follow-up records, so the dashboard looks like a live system.
Honest framing: I'd label it a "working demo" or "prototype" rather than a production system. It uses seeded sample data and has no real SMS or email sending or login yet. Those would be the natural next steps for a client.
Hi! I'm a professional and detail-oriented Data Entry Specialist with strong skills in Microsoft Excel and data management. I provide accurate and reliable Data Entry, Excel formatting, data cleaning, sorting, copy-paste, web research, and PDF to Excel/Word conversion services. I focus on accuracy, quality, confidentiality, and on-time delivery. I carefully follow instructions and ensure every project is clean, organized, and error-free. If you need a reliable and hardworking professional for your data entry or Excel work, I'm ready to help. Let's work together!