BranchesTags

Repository files navigation

Jewellery ERP System

A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.

The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.

Overview

This project was built to simplify the management of jewellery and gold trading businesses.

The system includes:

  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates

The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.

Features

Entity Management

Manage customers, vendors, and business partners.

Features include:

  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history

Item Management

Manage jewellery item categories and default transaction rules.

Features include:

  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values

Transaction Management

Record gold purchases and sales with automatic balance calculation.

Each transaction supports:

  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment

Automatic Gold Calculations

The system automatically converts transaction details into final gold weight.

Supports:

Profit-Based Calculation

Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation

Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.

Customer Balance Ledger

Each entity maintains a running gold balance.

New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:

  • New transactions
  • Transaction edits
  • Transaction deletion

Cash & RTGS Tracking

The ERP supports cash settlements converted into gold value.

Special transaction types:

  • Cash Gold
  • RTGS Gold

Calculation:

Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:

  • Gold movement
  • Cash movement
  • RTGS movement

Stock Management

Inventory is updated automatically from transaction entries.

Purchase

Stock += Base Weight

Sale

Stock -= Base Weight

Features:

  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation

Transaction Editing

Existing transactions can be modified at any time.

The system automatically:

  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency

Transaction Deletion

Transactions can be removed safely using a soft-delete mechanism.

Deletion automatically:

  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information

Historical Balance Correction

One of the core features of the system is automatic balance correction.

If an old transaction is edited:

Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:

Transaction 2 → Balance 130

The system automatically updates:

Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.

Reporting

The ERP provides multiple business reports.

Gold Report

Displays:

  • Customer gold balances
  • Stock gold value
  • Total gold position

Cash Report

Displays:

  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances

Workflow

Typical business flow:

Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture

The application uses Socket.IO for instant communication between client and server.

Benefits include:

  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience

Technology Stack

Backend

  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication

Frontend

  • HTML
  • CSS
  • JavaScript

Database

  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support

Project Structure

.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation

Clone Repository

git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program

Create Virtual Environment

python -m venv venv

Activate:

Linux / macOS

source venv/bin/activate

Windows

venv\Scripts\activate

Install Dependencies

pip install -r requirements.txt

Run Application

Start the server:

python app.py

Open:

http://localhost:5000

Key Highlights

This project demonstrates:

  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History

Future Improvements

  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups

Author

Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.

About

Notes for Dad

Topics

csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit

Resources

Readme
MIT license
Activity

Stars

1 star

Watchers

0 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { injectUserscript("// Add copy buttons to all 
 blocks\n(function() {\n function addCopyButtons() {\n document.querySelectorAll('pre code').forEach(function(codeBlock) {\n if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;\n codeBlock.parentElement.setAttribute('data-copy-added', 'true');\n \n var btn = document.createElement('button');\n btn.textContent = 'Copy';\n btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';\n btn.onmouseover = function() { this.style.opacity = '1'; };\n btn.onmouseout = function() { this.style.opacity = '0.7'; };\n btn.onclick = function() {\n navigator.clipboard.writeText(codeBlock.textContent).then(function() {\n btn.textContent = 'Copied!';\n setTimeout(function() { btn.textContent = 'Copy'; }, 1500);\n });\n };\n codeBlock.parentElement.style.position = 'relative';\n codeBlock.parentElement.appendChild(btn);\n });\n }\n \n addCopyButtons();\n \n // Re-run on dynamic content\n var observer = new MutationObserver(addCopyButtons);\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Add Copy Buttons to Code Blocks");
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Force GitHub README to respect dark mode\n(function() {\n var style = document.createElement('style');\n style.textContent = '\n .markdown-body {\n color-scheme: dark light;\n }\n .markdown-body pre { background: #161b22 !important; }\n .markdown-body code { background: rgba(110, 118, 129, 0.4) !important; }\n .markdown-body table th, .markdown-body table td { border-color: #30363d !important; }\n .markdown-body img { background: #0d1117; }\n .markdown-body blockquote { border-left-color: #8b949e; }\n .markdown-body hr { border-color: #30363d; }\n ';\n document.head.appendChild(style);\n})();", "GitHub Dark Mode README Fix");
}
} catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Highlight search terms from Google/DuckDuckGo/Bing referrer\n(function() {\n var ref = document.referrer;\n var terms = [];\n \n if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) {\n var url = new URL(ref);\n var q = url.searchParams.get('q') || url.searchParams.get('p');\n if (q) {\n terms = q.split(/\\s+/).filter(function(t) { return t.length > 2; });\n }\n }\n \n if (terms.length === 0) return;\n \n var style = document.createElement('style');\n style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }';\n document.head.appendChild(style);\n \n function highlight(node) {\n if (node.nodeType === 3) { // text node\n var text = node.textContent;\n var found = false;\n terms.forEach(function(term) {\n var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\\]\\\\]/g, '\\\\') + ')', 'gi');\n if (regex.test(text)) {\n found = true;\n var frag = document.createDocumentFragment();\n var parts = text.split(regex);\n parts.forEach(function(part, i) {\n if (i % 2 === 0) {\n frag.appendChild(document.createTextNode(part));\n } else {\n var span = document.createElement('span');\n span.className = 'userscript-highlight';\n span.textContent = part;\n frag.appendChild(span);\n }\n });\n node.parentNode.replaceChild(frag, node);\n }\n });\n } else if (node.nodeType === 1 && node.childNodes) { // element\n var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT'];\n if (!skipTags.includes(node.tagName)) {\n Array.from(node.childNodes).forEach(highlight);\n }\n }\n }\n \n highlight(document.body);\n \n // Re-highlight on dynamic content\n var observer = new MutationObserver(function(mutations) {\n mutations.forEach(function(m) {\n m.addedNodes.forEach(function(node) {\n if (node.nodeType === 1 || node.nodeType === 3) highlight(node);\n });\n });\n });\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Highlight Search Terms");
}
} catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Strip utm_, fbclid, gclid, etc. from all links on page\n(function() {\n var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content',\n 'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid',\n 'ref', 'ref_src', 'source', 'medium', 'campaign'];\n \n function cleanUrl(url) {\n try {\n var u = new URL(url, window.location.origin);\n var changed = false;\n trackingParams.forEach(function(p) {\n if (u.searchParams.has(p)) {\n u.searchParams.delete(p);\n changed = true;\n }\n });\n return changed ? u.toString() : url;\n } catch (e) {\n return url;\n }\n }\n \n function cleanLinks() {\n document.querySelectorAll('a[href]').forEach(function(a) {\n var clean = cleanUrl(a.href);\n if (clean !== a.href) a.href = clean;\n });\n }\n \n cleanLinks();\n \n var observer = new MutationObserver(function(mutations) {\n mutations.forEach(function(m) {\n m.addedNodes.forEach(function(node) {\n if (node.nodeType === 1) {\n if (node.tagName === 'A') cleanLinks();\n node.querySelectorAll('a[href]').forEach(function(a) {\n var clean = cleanUrl(a.href);\n if (clean !== a.href) a.href = clean;\n });\n }\n });\n });\n });\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Remove Tracking Parameters from Links");
}
} catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); }
})();
(function(){
try {
var __m = "youtube.com";
var __re = new RegExp('^' + "youtube\\.com" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Auto-enable theater mode on YouTube\n(function() {\n function tryTheater() {\n var btn = document.querySelector('button[aria-label=\"Theater mode\"], ytd-player #player button[title=\"Theater mode\"]');\n if (btn && !btn.classList.contains('activated')) {\n btn.click();\n }\n }\n \n // Try immediately\n tryTheater();\n \n // Try after navigation (SPA)\n var lastUrl = location.href;\n setInterval(function() {\n if (location.href !== lastUrl) {\n lastUrl = location.href;\n setTimeout(tryTheater, 500);\n }\n }, 1000);\n \n // Also try on player load\n var observer = new MutationObserver(tryTheater);\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "YouTube Theater Mode Default");
}
} catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Remove or un-stick sticky/fixed headers that block content\n(function() {\n function unstick() {\n document.querySelectorAll('header, nav, [role=\"banner\"], .header, .navbar, .sticky, .fixed-top, [style*=\"position: fixed\"], [style*=\"position:sticky\"]').forEach(function(el) {\n if (el.style.position === 'fixed' || el.style.position === 'sticky' || \n getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') {\n el.style.position = 'static';\n el.style.top = 'auto';\n el.style.zIndex = 'auto';\n }\n });\n }\n \n unstick();\n \n var observer = new MutationObserver(unstick);\n observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] });\n})();", "Kill Sticky Headers");
}
} catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Universal Dark Mode - works on any site\n(function() {\n var enabled = true;\n \n function applyDarkMode() {\n if (!enabled) return;\n \n // Create style element if it doesn't exist\n var style = document.getElementById('universal-dark-mode-style');\n if (!style) {\n style = document.createElement('style');\n style.id = 'universal-dark-mode-style';\n document.head.appendChild(style);\n }\n \n // Dark mode CSS - inverts colors but preserves images/video\n style.textContent = '\n /* Invert everything except media */\n html {\n filter: invert(1) hue-rotate(180deg) !important;\n background: #1a1a2e !important;\n }\n \n /* Restore images, videos, iframes, canvas */\n img, video, iframe, canvas, svg, picture, [style*=\"background-image\"] {\n filter: invert(1) hue-rotate(180deg) !important;\n }\n \n /* Preserve specific elements that should not be inverted */\n .no-dark-mode, .no-dark-mode *,\n [data-theme=\"light\"], [data-theme=\"light\"],\n .ace_editor, .ace_editor *,\n .CodeMirror, .CodeMirror *,\n .monaco-editor, .monaco-editor *,\n .markdown-body pre, .markdown-body pre *,\n .highlight, .highlight *,\n pre code, pre code * {\n filter: none !important;\n }\n \n /* Fix common UI elements */\n .modal, .popup, .dropdown-menu, .tooltip, .popover {\n filter: invert(1) hue-rotate(180deg) !important;\n background: #2d2d44 !important;\n border-color: #444 !important;\n }\n \n /* Scrollbars */\n ::-webkit-scrollbar { background: #1a1a2e !important; }\n ::-webkit-scrollbar-thumb { background: #444 !important; }\n ::-webkit-scrollbar-thumb:hover { background: #555 !important; }\n \n /* Selection */\n ::selection { background: #4ecdc4 !important; color: #1a1a2e !important; }\n ::-moz-selection { background: #4ecdc4 !important; color: #1a1a2e !important; }\n ';\n }\n \n function removeDarkMode() {\n var style = document.getElementById('universal-dark-mode-style');\n if (style) style.remove();\n }\n \n // Toggle with Alt+Shift+D\n document.addEventListener('keydown', function(e) {\n if (e.altKey && e.shiftKey && e.key === 'D') {\n e.preventDefault();\n enabled = !enabled;\n if (enabled) {\n applyDarkMode();\n console.log('[Universal Dark Mode] Enabled');\n } else {\n removeDarkMode();\n console.log('[Universal Dark Mode] Disabled');\n }\n }\n });\n \n // Apply on load\n applyDarkMode();\n \n // Re-apply on dynamic content\n var observer = new MutationObserver(function(mutations) {\n if (enabled && !document.getElementById('universal-dark-mode-style')) {\n applyDarkMode();\n }\n });\n observer.observe(document.head, { childList: true });\n \n console.log('[Universal Dark Mode] Loaded - Press Alt+Shift+D to toggle');\n})();", "Universal Dark Mode");
}
} catch(__e) { console.warn('[Userscript:Universal Dark Mode]', __e); }
})();
})();

Skip to content
BranchesTags
Repository files navigation
Jewellery ERP System
A complete Jewellery ERP system designed for managing gold transactions, customer balances, inventory stock, cash settlements, and business reporting.
The application provides a real-time web interface powered by Flask and Socket.IO, allowing users to manage daily gold trading operations, maintain accurate customer ledgers, track stock movement, and generate financial reports.
Overview
This project was built to simplify the management of jewellery and gold trading businesses.
The system includes:
  • Customer & Vendor Management
  • Gold Transaction Processing
  • Inventory Tracking
  • Customer Gold Ledger
  • Cash & RTGS Management
  • Automated Balance Calculation
  • Transaction Editing & Deletion
  • Historical Balance Correction
  • Reporting Dashboard
  • Real-Time Updates
The objective is to maintain accurate gold balances, stock records, and transaction history while reducing manual bookkeeping.
Features
Entity Management
Manage customers, vendors, and business partners.
Features include:
  • Add entities
  • Edit entity details
  • Delete entities
  • Search entities
  • Track running gold balance
  • Maintain transaction history
Item Management
Manage jewellery item categories and default transaction rules.
Features include:
  • Add item types
  • Configure touch percentage
  • Set default profit percentage
  • Set default wastage percentage
  • Auto-fill transaction values
Transaction Management
Record gold purchases and sales with automatic balance calculation.
Each transaction supports:
  • Customer selection
  • Multiple items
  • Weight entry
  • Touch percentage
  • Profit percentage
  • Wastage percentage
  • Stone deduction
  • Quantity tracking
  • Cash adjustment
  • RTGS adjustment
Automatic Gold Calculations
The system automatically converts transaction details into final gold weight.
Supports:
Profit-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (Touch + Profit) / 100

Wastage-Based Calculation
Final Weight =
(Base Weight - Stone Less)
× (100 + Wastage) / 100
× Touch / 100

All calculations are updated instantly while entering data.
Customer Balance Ledger
Each entity maintains a running gold balance.
New Balance =
Old Balance + Transaction Weight

The system automatically updates balances after:
  • New transactions
  • Transaction edits
  • Transaction deletion
Cash & RTGS Tracking
The ERP supports cash settlements converted into gold value.
Special transaction types:
  • Cash Gold
  • RTGS Gold
Calculation:
Gold Weight =
Cash Amount ÷ Gold Rate

This allows simultaneous tracking of:
  • Gold movement
  • Cash movement
  • RTGS movement
Stock Management
Inventory is updated automatically from transaction entries.
Purchase
Stock += Base Weight

Sale
Stock -= Base Weight

Features:
  • Real-time stock updates
  • Item-wise stock balance
  • Touch-based gold valuation
Transaction Editing
Existing transactions can be modified at any time.
The system automatically:
  • Updates transaction records
  • Recalculates stock
  • Recalculates customer balances
  • Preserves historical consistency
Transaction Deletion
Transactions can be removed safely using a soft-delete mechanism.
Deletion automatically:
  • Reverses stock changes
  • Updates customer balances
  • Preserves audit history
  • Stores recovery information
Historical Balance Correction
One of the core features of the system is automatic balance correction.
If an old transaction is edited:
Transaction 1 → Balance 100
Transaction 2 → Balance 120
Transaction 3 → Balance 140

After modifying Transaction 2:
Transaction 2 → Balance 130

The system automatically updates:
Transaction 3 → Balance 150

This ensures ledger consistency across all historical records.
Reporting
The ERP provides multiple business reports.
Gold Report
Displays:
  • Customer gold balances
  • Stock gold value
  • Total gold position
Cash Report
Displays:
  • Cash inflow
  • Cash outflow
  • RTGS inflow
  • RTGS outflow
  • Current balances
Workflow
Typical business flow:
Create Entity
↓
Create Items
↓
Enter Transaction
↓
Update Customer Balance
↓
Update Stock
↓
Generate Reports

Real-Time Architecture
The application uses Socket.IO for instant communication between client and server.
Benefits include:
  • Live transaction updates
  • Immediate balance calculations
  • Real-time stock updates
  • Faster user experience
Technology Stack
Backend
  • Python
  • Flask
  • Flask-SocketIO
  • SQLAlchemy
  • JWT Authentication
Frontend
  • HTML
  • CSS
  • JavaScript
Database
  • SQLAlchemy ORM
  • Postgresql
  • Relational Database Support
Project Structure
.
├── app.py
├── models.py
├── static
│ ├── css
│ │ └── styles.css
│ └── js
│ ├── main.js
│ ├── entity.js
│ ├── item.js
│ ├── transaction.js
│ ├── stock.js
│ ├── cash.js
│ └── report.js
├── templates
│ └── index.html
├── requirements.txt
└── README.md

Installation
Clone Repository
git clone https://github.com/Sachcith/Notes-Program
cd Notes-Program
Create Virtual Environment
python -m venv venv
Activate:
Linux / macOS
source venv/bin/activate
Windows
venv\Scripts\activate
Install Dependencies
pip install -r requirements.txt
Run Application
Start the server:
python app.py
Open:
http://localhost:5000

Key Highlights
This project demonstrates:
  • Real-Time ERP Development
  • Gold Ledger Management
  • Inventory Management
  • Financial Transaction Processing
  • Automated Balance Reconciliation
  • Stock Tracking
  • Socket.IO Communication
  • Business Workflow Automation
  • Audit-Friendly Transaction History
Future Improvements
  • Multi-user roles and permissions
  • Advanced accounting integration
  • GST invoicing
  • Barcode support
  • Multi-branch management
  • Export to Excel/PDF
  • Mobile application support
  • Dashboard analytics
  • Automated backups
Author
Developed as a complete Jewellery ERP solution for managing gold transactions, inventory, customer balances, cash settlements, and business reporting through a unified real-time web application.
About
Notes for Dad
Topics
csserp-applicationflask-postgresflask-socketiohtmljewelryjspostgresqlpythonsafe-edit
Resources
Readme
MIT license
Activity
Stars
1 star
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages