Ideaconv: A Full-Stack Investment Management Platform Built to Scale
Project Overview
Ideaconv is a production-grade internal management system built for Ideaconv S.A. de C.V., a private investment firm based in Monterrey, México. The platform centralizes the entire lifecycle of private capital investments — from onboarding new investors and managing active portfolios to calculating monthly interest, generating legally-formatted account statements, and confirming payments — all within a single, branded web application.
Before this system existed, the firm managed hundreds of investors across spreadsheets, manual PDF generation, and scattered email threads. Ideaconv eliminated that entirely. Today, closing a monthly cycle — calculations, PDF generation, and email delivery to every investor — takes minutes instead of days.
The Problem We Solved
Private investment firms operating below institutional scale face a common operational trap: they're too big for manual processes but too specialized for off-the-shelf accounting software. Ideaconv was caught in exactly that gap.
- Interest calculations done manually per investor: Each month, staff had to apply ISR (20%), IVA (16%), and external payment splits by hand for every contract — an error-prone process taking 2–3 days.
- No tranche awareness: When an investor added or withdrew capital mid-period, the old process couldn't pro-rate correctly. Interest was either over or under-calculated.
- PDF statements created one by one: Each branded account statement was assembled manually in Word or a PDF editor, then emailed individually. With 50+ investors, this was unsustainable.
- No single source of truth: Investor records lived in spreadsheets, payment confirmations in email, and contracts in physical folders. Reconciliation was a weekly nightmare.
What We Built
We delivered a fully custom Django application with a REST API backend and a modern JavaScript frontend — no third-party SaaS, no templates, no compromises. Every screen was designed around exactly how the Ideaconv team works.
- Investor CRM: Full investor profiles including personal data, fiscal information (RFC, CURP, tax regime), bank details, and document management. Supports both individuals and corporations.
- Multi-Investment Portfolio Management: Each investor can hold multiple active investment contracts simultaneously, each with independent rates, bases (360/365), billing percentages, start dates, and maturity dates.
- Tranche-Based Interest Engine: Mid-period capital movements (deposits or withdrawals) automatically split the calculation period into pro-rated tranches. Each tranche earns interest only on the actual capital balance for that sub-period.
- Consolidated Monthly Statements: A single account statement per investor consolidates all their active investments for the period — one PDF, one email, regardless of how many contracts they hold.
- Automated PDF Generation & Email Dispatch: One click generates branded PDFs using ReportLab and delivers them via transactional email (Resend/Anymail). Closing an entire monthly cycle for all investors takes under 60 seconds.
- Payment Tracking & Receipts: Every account statement generates a payment record. Staff confirm payments with date, method, and confirmation ID. Printable receipts are generated on demand, split between invoiced and external payment amounts.
- Prospect Pipeline: A Kanban-style prospect board tracks leads from initial contact through to full investor onboarding. One-click conversion promotes a prospect directly into the investor CRM.
Technical Implementation
- Backend: Django 6 + Django REST Framework — custom API endpoints for every resource, no boilerplate generators.
- Frontend: Vanilla JavaScript with a custom design system — no React, no build pipeline. Fast, zero-dependency UI served directly from Django templates.
- PDF Engine: ReportLab Platypus — fully branded multi-page PDFs including a cover summary page and per-investment detail pages with historical payment tables.
- Email: Anymail + Resend for transactional delivery with PDF attachments. Responsive HTML email templates included.
- Database: PostgreSQL in production via dj-database-url. SQLite for local development.
- Security: Honeypot fake admin panel to log and capture brute-force attempts. CSRF protection, session security, and login-required guards on all views.
- Hosting: WhiteNoise for static files, deployable to any WSGI-compatible host (Render, Railway, or VPS).
How the Monthly Cycle Works
What used to take the Ideaconv team 2–3 full working days now happens in under 5 minutes:
- Navigate to the Account Statements module and click "Monthly Close."
- Set the period start and end dates. The system calculates the exact number of days automatically.
- Click "Generate for All" — the engine loops every active investor, consolidates all their investments, applies tranche math for any mid-period movements, and creates one account statement per investor.
- Review the Cut Summary — a detailed breakdown table showing every investor's gross interest, ISR withholding, IVA, external payment, and net payable.
- Click "Send to All" — the system generates a branded PDF for each investor and dispatches it via email. Done.
Business Value
- Operational Time Savings: Monthly close cycle reduced from 2–3 days to under 5 minutes. That's roughly 150+ hours saved per year.
- Calculation Accuracy: The tranche-based engine handles every edge case that manual spreadsheets missed — mid-period deposits, partial withdrawals, mixed billing percentages. Zero rounding errors.
- Professional Investor Experience: Investors receive a polished, branded PDF statement every month — the same quality they'd expect from a bank — reinforcing trust and reducing inbound support calls.
- Growth-Ready Architecture: The system was built to handle hundreds of investors without degradation. Adding a new investor or investment takes seconds. The REST API makes future integrations (accounting software, investor portal) straightforward.
- Full Visibility & Audit Trail: Every payment, movement, and statement is timestamped and linked. The dashboard surfaces expiring contracts, pending payments, and data quality warnings in real time.
- Prospect-to-Investor Conversion: The built-in prospect pipeline gives the sales team a structured way to track and nurture leads. Converting a qualified prospect to a full investor profile is a single button press.
Does your firm run on spreadsheets?
If you manage investors, capital, and monthly interest payments manually, there's a better way. We've built this before — we can build it for you, faster and at a fraction of the cost of off-the-shelf software that doesn't actually fit.
Book a Free Strategy Call