🏢 OfficeMG — Office Management & Billing System

OfficeMG is a professional desktop-based Office Management System built using Python, Tkinter, SQLite and ReportLab. It provides complete tools for managing daily business operations—billing, challans, ledger tracking, product inventory, customer management and PDF report generation.

📌 Overview

officeMG is designed for small and medium offices that require fast billing, challan creation, payment tracking and inventory management without complex ERP systems. The application comes with a clean Tkinter UI, lightweight architecture and professional PDF outputs powered by ReportLab.

✨ Features

🔐 Authentication

System configuration
Login system with SQLite
Secure credential validation

🧾 Billing System

Create, update, and manage bills
Auto-calculation of totals
Save to database
Generate PDF bills using ReportLab
Reprint old bills

📦 Challan Management

Create auto challan or custom challan
Generate PDF challan
Maintain challan history

📚 Ledger (Debit / Credit)

Customer-wise ledger tracking
Debit/Credit entry
Outstanding balance summary
PDF ledger report

👥 Customer Management

Add/Edit/Delete customers
Store customer basic info
View billing and ledger history

💰 Collection Modules

Bill collection management
UT collection
Payment history

📦 Product Store Management

Add or update products
Manage stock quantity
Product pricing control

🖨️ PDF Report System

(All reports generated using ReportLab)

PDF Bill, Challan
PDF Statement, Due Balance
PDF Ledger, Products
Clean professional layout

🛠️ Technologies Used

Area	Technology
Language	Python
GUI Framework	Tkinter
Database	SQLite
PDF Generation	ReportLab
File Export	PDF

🧰 Installation

Step 1. Clone the repository

git clone https://github.com/iamx-ariful-islam/OfficeMG.git
cd OfficeMG

Step 2. Install Python Dependencies

The requirements.txt file, lists of all the Python libraries that "OfficeMG" depends on and installs those packages from the file:

pip install -r requirements.txt
# or
sudo pip install -r requirements.txt

Step 3. Run the Application

python main.py

📂 Folder Structure

Here’s the structure of the OfficeMG project:

OfficeMG/
│
├── Screenshots/
├── main.py
├── notes.txt
│── LICENSE
│── README.md
└── requirements.txt

🖼️ Screenshots

Here are some screenshots of the OfficeMG project:

System Configure

Admin Login

Main Window

Bill Payment

Bill-UT Collection

Bill Information

Products Purchase

Customers Information

Settings

Change Password

Bill

Challan

Bill Statement

Due Bill Statement

Products Statement