A comprehensive business ledger management system for product-selling companies with real-time data synchronization, overdue management, and intelligent credit limit handling.

🚀 Live Demo • 📖 Documentation • 🐛 Report Bug • 💡 Request Feature

🌟 Overview

The Product Ledger Management System is a full-stack web application designed for product-selling companies to efficiently manage their financial transactions, customer relationships, and inventory. Built with modern technologies, it provides real-time data synchronization, intelligent overdue management, and automated credit limit adjustments.

✨ Key Highlights

• 🔄 Real-time Data Sync - IndexedDB + MongoDB integration
• 💰 Smart Credit Management - Dynamic credit limit adjustments
• 📊 Comprehensive Reporting - Revenue, product, and overdue analytics
• 🔔 Automated Overdue Tracking - Intelligent interest and fine calculations
• 📱 Responsive Design - Works seamlessly across all devices
• 🔐 Secure Authentication - NextAuth.js with multiple providers
• 📧 Email Integration - Automated notifications and password reset

🏗️ System Architecture

graph TB
    subgraph "Frontend Layer"
        A["Next.js 14 App Router"]
        B["React Components"]
        C["Tailwind CSS"]
        D["shadcn/ui"]
    end
    
    subgraph "Authentication"
        E["NextAuth.js"]
        F["Google OAuth"]
        G["Email Provider"]
    end
    
    subgraph "API Layer"
        H["REST API Routes"]
        I["Server Actions"]
        J["Middleware"]
    end
    
    subgraph "Data Layer"
        K["MongoDB Atlas"]
        L["IndexedDB"]
        M["Real-time Sync"]
    end
    
    subgraph "External Services"
        N["Email Service"]
        O["Cron Jobs"]
        P["PDF Generation"]
    end
    
    A --> B
    B --> C
    B --> D
    A --> E
    E --> F
    E --> G
    A --> H
    H --> I
    H --> J
    H --> K
    K --> L
    L --> M
    H --> N
    O --> K
    H --> P

📋 Features

• Customer Management: Add, update, and track customer details with credit limits and transaction history.
• Transaction Ledger: Record sales, payments, and adjustments with real-time updates.
• Overdue Alerts: Automated notifications for overdue payments with customizable interest rates.
• Inventory Tracking: Monitor stock levels and integrate with sales data.
• Analytics Dashboard: Visualize revenue trends, product performance, and overdue accounts.
• PDF Reports: Generate professional invoices and account statements.
• Multi-user Support: Role-based access control for team collaboration.

🛠️ Installation

Prerequisites

• Node.js 18.x or higher
• MongoDB Atlas account
• Google OAuth credentials (for authentication)
• Email service provider (e.g., SendGrid, Nodemailer)

Steps

1. Clone the Repository

   git clone https://github.com/your-repo/product-ledger.git
   cd product-ledger

2. Install Dependencies

   npm install

3. Set Up Environment Variables Create a .env.local file in the root directory and add the following:

   MONGODB_URI=MONGODB CONNECTION URI
   MONGODB_DB=Database name
   NEXTAUTH_SECRET=secret key
   NEXTAUTH_URL=https://product-ledger.vercel.app/
   EMAIL_SERVER_HOST=smtp.gmail.com
   EMAIL_SERVER_PORT=587
   EMAIL_SERVER_USER=user mail-id
   EMAIL_SERVER_PASSWORD=google generated password 
   EMAIL_FROM=From mail-id

4. Run the Application

   npm run dev

   Open http://localhost:3000 in your browser.

🖥️ Usage

1. Sign Up/Login: Use Google OAuth or email-based authentication to access the system.
2. Dashboard: View key metrics like total revenue, overdue accounts, and inventory status.
3. Add Customers: Input customer details and set credit limits.
4. Record Transactions: Log sales, payments, or adjustments in the ledger.
5. Generate Reports: Export invoices or account statements as PDFs.
6. Monitor Overdues: Receive automated alerts for overdue payments and apply interest/fines.

🧪 Development

Tech Stack

• Frontend: Next.js 14 (App Router), React, TypeScript, Tailwind CSS, shadcn/ui
• Backend: Next.js API Routes, Server Actions, MongoDB Atlas
• Authentication: NextAuth.js (Google OAuth, Email)
• Database: MongoDB with IndexedDB for offline sync
• External Services: Email notifications, PDF generation, cron jobs for scheduled tasks

Project Structure

product-ledger/
├── app/                    # Next.js App Router
├── components/             # React components
├── lib/                    # Utility functions and configurations
├── models/                 # MongoDB schemas
├── public/                 # Static assets
├── styles/                 # Tailwind CSS and global styles
├── .env.local              # Environment variables
├── next.config.js          # Next.js configuration
├── tsconfig.json           # TypeScript configuration

🐳 Deployment

Deploy to Vercel

1. Push your repository to GitHub.
2. Connect your repository to Vercel.
3. Configure environment variables in Vercel’s dashboard.
4. Deploy the application with a single click.

Deploy to Other Platforms

• Use Docker for containerized deployment.
• Configure MongoDB Atlas for production-grade database hosting.
• Set up cron jobs for scheduled tasks (e.g., overdue notifications).

🤝 Contributing

Contributions are welcome! Please follow these steps:

1. Fork the repository.
2. Create a new branch (git checkout -b feature/your-feature).
3. Commit your changes (git commit -m 'Add your feature').
4. Push to the branch (git push origin feature/your-feature).
5. Open a pull request.

📜 License

This project is licensed under the MIT License. See the LICENSE file for details.

📞 Contact

For questions or support, reach out to:

• Email: [email protected]
• GitHub Issues: Report a Bug
• Feature Requests: Request a Feature

🙏 Acknowledgments

• Next.js for the robust framework
• MongoDB Atlas for scalable database solutions
• Tailwind CSS for rapid UI development
• shadcn/ui for accessible UI components
• NextAuth.js for secure authentication