Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This application is a professional Mortgage Audit and Balance Adjustment tool designed for LegalTech professionals. It connects to Supabase for authentication and database management, allowing users to manage and audit mortgage loans comprehensively. The application provides features for calculating loan events, comparing discrepancies, and generating reports based on user-uploaded documents.

## CORE FEATURES
1. **Data Structure and Multi-tenancy**: Set up tables in Supabase for profiles, loans, index rates, and loan events with Row Level Security (RLS) to ensure data privacy for each user.

2. **Calculation Setup Flow**: Users must select a Calculation Base (30/360, Act/360, Act/365) when creating or editing calculations, with interfaces for managing reference index tables.

3. **Event Engine and Amortization Schedule**: Users can add events to loans, such as partial amortizations and changes in interest rates. The system dynamically recalculates the amortization schedule based on these events.

4. **Comparison and Audit Module**: Users can upload documents (PDFs for contracts and CSVs/Excel for bank statements) to generate comparative tables highlighting discrepancies in loan data.

5. **Results Generation**: A section for creating a PDF Expert Report summarizing total excess interest, current capital differences, and a bar chart showing accumulated discrepancies.

6. **User Interface and Navigation**: A clear and minimalist design structure guiding users from the Dashboard to Loan List, Case Details, and Audits.

## DESIGN SPECIFICATIONS
- **Visual Style**: minimalist - Clean, simple design with plenty of white space, minimal color palette, and focus on typography.
- **Color Mode**: Light theme with dark text on light backgrounds.
- **Primary Color**: #1978E5 (accent for buttons, links, highlights).
- **Typography**: Use Inter from Google Fonts for headings, Inter for body text and UI elements.
- **Border Radius**: 8px (moderately rounded) for buttons, cards, and inputs.
- **Layout**: The layout will consist of a sidebar navigation on the left, a main content area displaying data and forms, and a responsive design to ensure usability across devices.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript.
- **Styling**: Tailwind CSS.
- **UI Components**: shadcn/ui.
- **State Management**: Use React Context or Zustand for state management as needed.

## IMPLEMENTATION STEPS
1. **Set up Supabase**: Create the necessary tables (profiles, loans, index rates, loan events) and implement Row Level Security (RLS).
2. **Develop the Authentication System**: Use Supabase Auth for user sign-up and login functionalities.
3. **Create Calculation Setup Interfaces**: Build forms for users to select calculation bases and manage index tables.
4. **Implement the Event Engine**: Develop functionalities for users to add loan events and dynamically recalculate amortization schedules.
5. **Build the Document Upload Feature**: Implement file upload capabilities for PDFs and CSV/Excel documents, and enable data extraction (OCR) for mortgage documents.
6. **Design the Comparison Module**: Create a visual representation of discrepancies in loan data.
7. **Generate PDF Reports**: Integrate a library for creating downloadable PDF reports with summarized data and charts.
8. **Finalize UI/UX Design**: Refine the user interface to ensure a clean, professional look with a focus on user experience.

## USER EXPERIENCE
Users will have a seamless experience navigating from the Dashboard to different sections of the application. They can easily create and manage their loan calculations, upload necessary documents, and view discrepancies in a clear visual format. The application will provide instant feedback on any changes made, ensuring users have a comprehensive understanding of their mortgage audits. The minimalist design will enhance usability and focus on the critical functions of the application.