BitCapro - Smart Investment Request Automation

🚀 What Inspired Us

Many organizations manage critical investment requests through a mix of spreadsheets, emails, and manual workflows. While these methods may get the job done, they often result in delays, miscommunication, limited visibility, and challenges in compliance tracking.

We observed that processes for Capital Expenditure (CapEx) and Operational Expenditure (OpEx) requests were often inconsistent across departments such as Finance, Operations, and ESG. This fragmentation led to inefficiencies, approval bottlenecks, and missed opportunities for strategic investments.

This inspired us to build BitCapro — Intelligent investment request platform that unifies and streamlines the entire request lifecycle, from initiation to approval and compliance management.

Our mission is to empower enterprises with a secure, AI-driven, and scalable solution that accelerates decision-making, improves transparency, and supports governance at every stage.


💡 What It Does

BitCapro provides a smart and centralized investment request automation system that enables:

  • Smart Forms: Replace spreadsheets with guided forms for CapEx and OpEx.
  • 🤖 AI Insights: Optimize business cases, predict delays, and simulate ROI impact.
  • 🧾 Multi-Level Approvals: Route requests based on configurable rules to relevant stakeholders (Manager → Director → CFO → CEO).
  • 📊 Real-Time Dashboards: Visualize the full investment portfolio, pending actions, and KPIs.
  • 🌱 ESG Compliance Tracking: Assess and monitor environmental and social impact.
  • 📱 Mobile-First Access: Designed for use on any device, ensuring convenience and real-time interaction.

🔧 How We Built It

✨ Frontend Stack

  • Framework: React 18 with TypeScript – Ensures type safety and component reusability.
  • Bundler: Vite – Super-fast development and optimized builds.
  • Styling: Tailwind CSS – Rapid UI development with responsive design.
  • Routing: React Router DOM – Smooth client-side navigation.
  • Icons: Lucide React – Clean and consistent SVG-based icons.
  • Charts: Recharts – Interactive visual dashboards.

🧠 Backend & Authentication

  • Supabase (PostgreSQL + Auth) – Real-time backend with built-in authentication.
  • Row Level Security (RLS) – Access control enforced at the database level.
  • Supabase Auth – Handles:
    • Role-based access: Admin, Submitter, Approvers (L1–L4)
    • Department mapping
    • Session management with auto-logout
  • Secure File Uploads – Using Supabase storage with access restrictions.

🧱 Database Architecture

Table Description
investment_requests Holds project data, business case, financials (CapEx, OpEx), ESG impact
user_profiles Stores user identity, department, and roles
approval_matrix Configurable approval routes and levels
approval_logs Maintains an audit trail for approvals
kpis Stores ROI metrics: IRR, NPV, Payback Period, etc.
notifications Manages real-time alerts and reminders

⚙️ Developer Tools

  • ESLint for code linting
  • TypeScript for type safety
  • PostCSS + Autoprefixer for CSS optimization
  • Hosted and deployed using Netlify

🧩 Challenges We Faced

🔄 Dynamic Multi-Level Approval Matrix

  • The approval matrix supports:
    • Routing by amount, department, business case
    • Role-based escalation
    • Audit trail for each level
  • It was challenging to model this logic cleanly in the database using Supabase with role checks and conditions.

📉 ROI Simulation & Financial Modeling

  • Implementing predictive models for ROI impact due to delays
  • Accurate calculations for:
    • IRR (Internal Rate of Return)
    • NPV (Net Present Value)
    • Payback Period
  • Data integrity and financial validation required careful attention to business rules.

🔔 Real-Time Notifications

  • Live alerts needed to be:
    • Instant
    • Role-targeted
    • Persisted in the database
  • Implemented using Supabase subscriptions and notification logic.

📐 Data Validation & Compliance

  • Ensured:
    • Auto-validation of required fields
    • ESG checklist adherence
    • Budget overrun alerts
  • This demanded a strong mix of UI validation, backend logic, and schema-level constraints.

🏆 Accomplishments We're Proud Of

  • Full-Stack Platform: Functional React + TypeScript frontend, Supabase backend with secure access control
  • 🔐 Robust Security: Role-based permissions, RLS, session auto-logout
  • 📊 Analytics Dashboards: Dynamic charts, risk analysis, ESG impact tracking
  • 🧠 AI-Powered Recommendations: Risk prediction, missing docs detection, weak KPI alerts
  • 🧾 Approval Workflow Engine: Multi-step routing with full traceability
  • 📱 Responsive UI/UX: Works beautifully across devices with collapsible sidebar, error states
  • 📂 PDF Generation: Submit request details exportable as PDFs (in progress)

📚 What We Learned

  • 🏗️ How to architect scalable role-based workflows
  • 🧠 How to integrate AI for decision support tools
  • 🎯 How to align business logic with user experience
  • 💼 Importance of ESG compliance and auditability in enterprise systems

🔮 What’s Next for BitCapro

✅ High Priority

  • Configure .env.local for:

    • Supabase keys
    • OpenAI API
    • Slack Webhook
    • Email services (SendGrid / Mailgun)
  • Set up:

    • Supabase migrations
    • RLS policies
    • File storage bucket (investment-documents)

🧪 Medium Priority

  • Full integration testing of:

    • OpenAI-powered optimization
    • Real-time notifications
    • File uploads
    • Full approval cycle
  • Production Deployment:

    • Netlify setup with custom domain
    • Analytics and performance monitoring

✅ Task List

  • Role-based access setup
  • Investment request form with validation
  • Approval matrix logic & audit logs
  • Realtime dashboards & notifications
  • ESG and ROI simulations
  • PDF generation for request summary
  • Finalize production deployment

🔗 Links


📝 Footnote

BitCapro is a step forward in reshaping enterprise investment decisions through intelligence, speed, and transparency.
Developed during a high-impact AI hackathon, with a focus on real-world enterprise challenges.

Built With

Share this project:

Updates