Dashboard
Welcome to RafsInventory
📅 Date range
💸
Sale Revenue
—
for selected period
🧾
Cost of Sales (COGS)
—
purchase cost of sold units
📋
Expenses
—
period expenses
📈
Gross Profit
—
Revenue − (COGS + Exp)
🤑
Net Profit
—
Gross ÷ 1.18 (after GST)
💡 Sale Price Prediction
Avg buy price of serials sold this month · margin-wise sale price
PRODUCT AVG BUY (Gross)
Net below (÷1.18)		 +3%
Net		 +5%
Net		 +7%
Net		 +10%
Net		 +12%
Net		 +15%
Net		 +18%
Net		 +20%
Net		 +25%
Net
Loading…
New Purchase Entry
Record a new purchase invoice with one or more products
📦

Purchase Invoice

Fill invoice details then add product line items below

Invoice Details
Product Line ItemsAdd one or more products for this invoice
Notes
New Sale Entry
Record a new sale invoice with one or more products
🏷️

Sale Invoice

Fill invoice details then add product line items below

Invoice Details
Product Line ItemsAdd one or more products for this invoice
Notes
📊 Import Purchase via Excel
Download the template, fill it in Excel, upload — done
ℹ️ How to use Excel Import
1️⃣
Download Template
Click the green button above to get the Excel template
2️⃣
Fill in Excel
Fill each row — one serial number per row
3️⃣
Upload File
Drag & drop or click to select your .xlsx file
4️⃣
Preview & Save
Review the data then click Save All
📋 Required Excel Columns (in order):
invoice_no * purchase_date * supplier * product_name * serial_no * category unit_price notes
* Required fields. One row = one serial number. Same invoice_no groups multiple serials under one invoice.
📊

Upload Purchase Excel File

Accepts .xlsx and .xls files

📊
Drop your Excel file here
or click to browse — supports .xlsx .xls
📊 Import Sale via Excel
Download the template, fill it in Excel, upload — done
ℹ️ How to use Excel Import
1️⃣
Download Template
Click the blue button above to get the Excel template
2️⃣
Fill in Excel
Fill each row — one serial number per row
3️⃣
Upload File
Drag & drop or click to select your .xlsx file
4️⃣
Preview & Save
Review the data then click Save All
📋 Required Excel Columns (in order):
invoice_no * sale_date * customer_name * product_name * serial_no * category sale_price warranty rd_validity notes
* Required fields. One row = one serial number. Same invoice_no groups multiple serials under one invoice.
📊

Upload Sale Excel File

Accepts .xlsx and .xls files

📊
Drop your Excel file here
or click to browse — supports .xlsx .xls
📈 Analytics & Reports
Select date range or financial year
📅 Date range
From – To
💡 Profit formula: Profit = (Qty Sold × Avg Sale Price) − (Qty Sold × Avg Buy Price) — calculated on sold serials only
Revenue vs Profit
Revenue (blue bars) · Profit (green line) — hover for details
Revenue and profit trend
🏆 Product Wise Profit
#ProductCategory Qty soldAvg buy ₹Avg sale ₹Avg profit Buy cost (sold)Sale revProfit / lossNet ProfitMargin%
Purchase Cost vs Sale Revenue
Buy cost (orange) vs sale revenue (green) · ₹ values per period
Purchase and sale units
Revenue vs Buy Cost
Sale revenue vs total purchase cost per period
Revenue vs buy cost
📊 Period Breakdown
PeriodUnits SoldSale RevenueCOGS (Cost of Sold)Gross ProfitExpensesActual ProfitNet ProfitMargin%
🏭 Top Suppliers
# Supplier Name Total Invoices Units Total Spent Last Purchase Avg Price
🔍
PRODUCT NAME PURCHASE QTY PURCHASE PRICE AVG PURCHASE SALE QTY SALE PRICE AVG SALE MARGIN ₹ IN STOCK STOCK VALUE STOCK ALERT
📦 Unsold Stock — Serial Numbers
All purchased serials not yet sold
📦
Loading
—
Product
Category
Supplier
Age
Search Serial
Loading unsold serials…
⚠️ Sold Without Purchase Record
Serial numbers that were sold but have no matching purchase entry
⚠️
What does this mean?
These serial numbers appear in your Sales records but have no matching Purchase entry. This usually means the purchase was not recorded in the system, or the serial number was entered differently during purchase vs sale.
You should either add the missing purchase record or correct the serial number in the existing purchase.
⚠️
Loading
—
Loading…
💼 Expense Manager
Track all business expenses — reflected in profit calculations
💼
Total Expenses
—
📅
This Month
—
📂
Categories
—
📋
Entries
—
🔍
Loading…
All Records
View, edit and manage all purchase and sale entries
Loading…
🔍 Serial Number Lookup
Trace any product — see purchase source, sale destination, pricing and full history
Recent:
User Management
Manage system users and access levels
IDUsernameFull NameRoleStatusCreatedActions
Loading…