Remix

Make your own version of Kesari LedgerIQ

Edit the prompt below and generate a customized version in seconds.

Original by Prathamesh

Describe your app

Below is a comprehensive master prompt you can paste into Claude within Cursor. It is written as if Claude is the Lead Solution Architect, Product Manager, UI/UX Designer, Database Architect, and Senior Full-Stack Developer responsible for designing and building the entire application.

---

# PROJECT MASTER PROMPT

You are a Senior Product Architect, Chartered Accountant Consultant, SaaS Product Designer, UI/UX Expert, Database Architect, AI Engineer, and Full Stack Developer.

Your task is to design and build a complete cloud-based Project Accounting & Financial Intelligence Platform for my company.

## CLIENT DETAILS

Company Name: **KESARI INFRA BUILD PVT LTD**

The application will be used internally by management, accounts teams, project managers, and directors to manage project-wise finances, revenues, expenses, profitability, cash flow, invoices, and AI-powered financial insights.

The system must have a premium SaaS feel similar to modern products like:

* Notion
* Linear
* Monday.com
* ClickUp
* Stripe Dashboard
* QuickBooks
* Zoho Books
* Xero

The UI should be modern, responsive, minimal, fast, and enterprise-grade.

---

# PRIMARY OBJECTIVE

Create a centralized Project Accounting Platform where every financial transaction is linked to a project.

The system should provide:

* Real-time project profitability
* Project-wise revenue tracking
* Project-wise expense tracking
* Outstanding receivables
* Outstanding payables
* Balance Sheet generation
* Profit & Loss generation
* Cash Flow reporting
* AI-powered financial assistant

The system should become a complete financial intelligence dashboard for project-based businesses.

---

# TECHNOLOGY STACK

Build using:

Frontend:

* Next.js
* TypeScript
* Tailwind CSS
* ShadCN UI

Backend:

* NestJS
* TypeScript

Database:

* PostgreSQL

ORM:

* Prisma

Authentication:

* JWT
* Role Based Access Control

Hosting:

* Azure Cloud

Storage:

* Azure Blob Storage

AI:

* OpenAI API

Charts:

* Recharts

Export:

* PDF
* Excel

Notifications:

* Email
* Dashboard Alerts

---

# USER ROLES

Create role-based access.

## Super Admin

Can:

* Create users
* Edit users
* Delete users
* View all projects
* View all financial data
* Approve transactions
* Generate reports
* Configure AI settings

---

## Director

Can:

* View all projects
* View profitability
* View reports
* View dashboards
* Ask AI questions

Cannot:

* Delete financial records

---

## Accounts Manager

Can:

* Create expenses
* Create revenues
* Upload invoices
* Approve transactions
* Manage vendors
* Manage clients

---

## Project Manager

Can:

* Create project expenses
* View project financials
* Upload project documents

Cannot:

* Access company-wide reports

---

## Employee

Can:

* Submit expense requests
* Upload bills

Cannot:

* Access financial reports

---

# CORE MODULES

---

# MODULE 1 – DASHBOARD

Create a premium dashboard.

Display:

### Company Overview

* Total Revenue
* Total Expenses
* Net Profit
* Total Projects
* Active Projects
* Closed Projects
* Pending Receivables
* Pending Payables

---

### Financial Graphs

Revenue Trend

Expense Trend

Profit Trend

Cash Flow Trend

Monthly Comparison

Yearly Comparison

---

### Project Summary

Top Profitable Projects

Loss-Making Projects

Projects Near Completion

Projects With Outstanding Payments

---

# MODULE 2 – PROJECT MANAGEMENT

Every financial activity must belong to a project.

Project Fields:

* Project Name
* Project Code
* Client Name
* Contract Value
* Start Date
* End Date
* Project Status
* Project Manager
* Description

Project Status:

* Planning
* Active
* On Hold
* Completed
* Closed

---

Project Dashboard should show:

Revenue

Expenses

Profit

Profit %

Outstanding Amount

Invoices Raised

Invoices Received

Payment Status

Cash Flow

Documents

Activity Logs

---

# MODULE 3 – REVENUE MANAGEMENT

Revenue Entry Form

Fields:

* Revenue Number
* Date
* Project
* Client
* Amount
* GST
* Invoice Number
* Invoice Date
* Due Date
* Payment Status
* Payment Date
* Remarks

Status:

* Invoice Not Raised
* Invoice Raised
* Partially Received
* Fully Received
* Overdue

---

Auto calculations:

Revenue

GST

Receivable Amount

Received Amount

Pending Amount

---

# MODULE 4 – EXPENSE MANAGEMENT

Expense Categories:

* Labour
* Material
* Transportation
* Contractor
* Consultancy
* Government Fees
* Site Expenses
* Equipment
* Fuel
* Miscellaneous

---

Expense Fields

* Expense Number
* Date
* Project
* Vendor
* Category
* Amount
* GST
* Payment Status
* Bill Upload
* Remarks

Status:

* Pending
* Approved
* Paid
* Rejected

---

# MODULE 5 – VENDOR MANAGEMENT

Vendor Master

Fields:

* Vendor Name
* GST Number
* PAN
* Contact Person
* Phone
* Email
* Address

Track:

* Total Purchases
* Outstanding Amount
* Payment History

---

# MODULE 6 – CLIENT MANAGEMENT

Client Master

Fields:

* Client Name
* Contact Person
* Mobile
* Email
* Address
* GST Number

Track:

* Total Projects
* Revenue
* Outstanding Receivables

---

# MODULE 7 – INVOICE MANAGEMENT

Sales Invoice

Purchase Invoice

Upload PDF

Generate Invoice PDF

Track:

* Raised
* Sent
* Received
* Paid
* Overdue

Automatic reminders before due dates.

---

# MODULE 8 – DOCUMENT MANAGEMENT

Allow uploads:

* Agreements
* Work Orders
* Invoices
* Bills
* Drawings
* Compliance Documents

Store in Azure Blob Storage.

Tag documents by:

* Project
* Vendor
* Client
* Category

---

# MODULE 9 – ACCOUNTING REPORTS

Generate automatically:

## Profit & Loss

Revenue

Expenses

Net Profit

---

## Balance Sheet

Assets

Liabilities

Equity

---

## Cash Flow

Operating

Investing

Financing

---

## GST Report

Input GST

Output GST

Net GST

---

## Project Profitability Report

Project Wise

Month Wise

Year Wise

---

# MODULE 10 – AI FINANCIAL ASSISTANT

This is a major feature.

Add an AI chatbot accessible from every page.

---

Chat Window Features:

Ask:

"What is the profit of Project A?"

"Show expenses this month."

"Which projects are loss making?"

"How much payment is pending from Client X?"

"Generate project summary."

"Generate board report."

"Compare last month revenue."

"Predict cash flow."

---

AI should understand:

Projects

Clients

Vendors

Revenue

Expenses

Invoices

Outstanding Payments

Financial Reports

---

# AI SYSTEM ARCHITECTURE

OpenAI API should not directly access database.

Build an AI Service Layer.

Flow:

User Query

↓

AI Controller

↓

Data Retrieval Service

↓

SQL Query Generation

↓

Database

↓

Structured JSON

↓

OpenAI

↓

Final Response

---

AI should always work with actual database records.

No hallucinations.

---

# AI FEATURES

1. Natural Language Queries

2. Financial Summaries

3. Project Insights

4. Revenue Analysis

5. Expense Analysis

6. Profitability Analysis

7. Outstanding Payment Tracking

8. Cash Flow Forecasting

9. Executive Summary Generation

10. Board Meeting Report Generation

---

# AUDIT LOGS

Track:

* User
* Action
* Timestamp
* Old Value
* New Value

Maintain complete audit trail.

---

# NOTIFICATIONS

Notify users for:

* Overdue invoices
* Pending approvals
* Upcoming payments
* Document expiry
* Revenue collections

---

# SEARCH SYSTEM

Global Search Bar

Search by:

* Project
* Client
* Vendor
* Invoice
* Expense
* Revenue
* Document

---

# EXPORT SYSTEM

Allow export:

PDF

Excel

CSV

For:

* Reports
* Project Summary
* Financial Statements

---

# DASHBOARD DESIGN REQUIREMENTS

Theme:

Premium SaaS

Modern Enterprise

Clean White Background

Optional Dark Mode

Rounded Cards

Minimal Design

Responsive Layout

Fast Loading

Professional Typography

Animated Charts

Beautiful Tables

Sticky Navigation

Global Search

Command Palette

---

# DATABASE DESIGN

Generate:

1. Complete ER Diagram

2. Complete PostgreSQL Schema

3. Prisma Models

4. Foreign Key Relationships

5. Database Indexes

6. Migration Strategy

---

# DEVELOPMENT PHASES

Phase 1

Authentication

Users

Roles

Projects

Clients

Vendors

---

Phase 2

Revenue

Expenses

Invoices

Documents

---

Phase 3

Financial Reports

Profitability Engine

Dashboard

---

Phase 4

AI Assistant

OpenAI Integration

Insights

Forecasting

---

Phase 5

Testing

Security

Optimization

Azure Deployment

---

# DELIVERABLES EXPECTED FROM YOU

Before coding:

1. Complete System Architecture
2. Complete Database Design
3. Folder Structure
4. API Structure
5. UI Wireframes
6. User Flow Diagrams
7. ER Diagram
8. Security Architecture
9. AI Architecture

Then generate production-ready code module by module.

Do not skip planning.

Act as a senior enterprise SaaS architect and build this application from scratch with best practices, scalability, security, maintainability, and future AI expansion in mind.

Start with:

1. Product Requirement Document (PRD)
2. System Architecture
3. Database Design
4. UI/UX Wireframes
5. Development Roadmap
6. Folder Structure
7. API Design
8. Prisma Schema

Then proceed module by module.

Free to use. No credit card required.