Sales and Inventory Management Software(👉 “Inventory + Billing + GST Invoice System (Excel VBA)”)

1. Automated Inventory Management System

• Products Add/Edit

• Auto stock update

• Low-stock alerts

• Purchase/Sale report
  

📌 2. GST Invoice Generator (Auto PDF Export)

• User form से customer details

• Button click में invoice बनाना

• GST calculate

• Auto PDF में save और WhatsApp/email

Reports

✔ Sales Report
✔ Purchase Report
✔ GST Report
✔ Stock Report
✔ Customer-wise report
✔ Date filter + Today/This Month filter
✔ Export to PDF
✔ Export to Excel
✔ Print-ready format

✔ 1. Sales Report

·         Invoice-wise record

·         Date range filter

·         Customer filter

·         Product filter

·         GST-wise breakdown

·         Total Qty, Total Amount, Total GST summary

✔ 2. Purchase Report

·         Supplier-wise

·         Product-wise

·         Date-wise

·         GST breakdown

✔ 3. Stock Report

·         Opening stock

·         Purchase qty

·         Sales qty

·         Closing stock auto-calculated

✔ 4. GST Report

·         CGST, SGST, IGST breakup

·         Month-wise/Date-wise filter

·         Sale GST

·         Purchase GST

·         Net payable GST (Sale - Purchase)

✔ 5. Customer Ledger Report

·         Sales

·         Payments

·         Outstanding balance

✔ 6. Export Options

·         Export to PDF

·         Export to Excel

·         Print-ready format

✔ 7. Search + Filters

·         Date Range

·         Customer Name

·         Product Name

·         Invoice No