Today's Sales
₹1,84,200
↑ 6 invoices
Outstanding (All Customers)
₹18,42,600
across 34 running accounts
Commission Payable
₹96,400
12 architects/carpenters
Stock Value (approx)
₹32,10,000
Ply, HDHMR, Hardware
Customers Nearing Full & Final
projects likely closing this month| Customer | Project / Site | Referred By | Billed | Received | Balance |
|---|---|---|---|---|---|
| Mr. Rajeev Sharma | Indirapuram — 3BHK Interior | Ar. Neha Kapoor | ₹4,20,000 | ₹4,45,000 | Excess ₹25,000 |
| Mrs. Suman Gupta | Vaishali — Kitchen | Carp. Mahesh Lal | ₹1,85,000 | ₹1,60,000 | Due ₹25,000 |
| Mr. Ankit Verma | Raj Nagar Ext. — Wardrobe | — Walk-in | ₹96,000 | ₹96,000 | Settled |
| Customer | Phone | Site / Project | Referred By | Since | Balance |
|---|---|---|---|---|---|
| Rajeev Sharma | 98100-xxxxx | Indirapuram — 3BHK | Ar. Neha Kapoor | Mar 2026 | Excess ₹25,000 |
| Suman Gupta | 98111-xxxxx | Vaishali — Kitchen | Carp. Mahesh Lal | Apr 2026 | Due ₹25,000 |
| Ankit Verma | 99530-xxxxx | Raj Nagar Ext. — Wardrobe | Walk-in | May 2026 | Settled |
| Priya Malhotra | 97170-xxxxx | Crossings Republik — Full Home | Ar. Neha Kapoor | Jun 2026 | Due ₹1,10,000 |
Add / Edit Customer — form fields
e.g. Rajeev Sharma
e.g. 98100-XXXXX
e.g. Indirapuram — 3BHK Interior
Dropdown — searchable
₹0.00
Auto-calculated
Balance = Σ Sales − Σ Payments Received
| Name | Type | Phone | Customers Referred | Lifetime Commission | Balance Payable |
|---|---|---|---|---|---|
| Neha Kapoor | Architect | 96500-xxxxx | 7 | ₹1,84,200 | ₹18,900 |
| Mahesh Lal | Carpenter | 95400-xxxxx | 4 | ₹62,300 | ₹16,540 |
| Rohit Bhatia | Architect | 93100-xxxxx | 3 | ₹41,000 | Settled |
Add / Edit — form fields
e.g. Neha Kapoor
Architect / Carpenter
e.g. 96500-XXXXX
UPI ID / Bank A/C
e.g. 3% — staff can change per item
Auto-calculated
Payable = Σ Commission Accrued − Σ Commission Paid
42
Plyboard
28
HDHMR
51
Hinges
27
Handles
| Item | Category | Brand | Unit | Purchase Rate | Std. Sale Rate | Current Stock |
|---|---|---|---|---|---|---|
| 19mm Ply (8x4) | Plyboard | Century | Sheet | ₹2,180 | ₹2,650 | 146 |
| 6mm HDHMR | HDHMR | Greenlam | Sheet | ₹1,180 | ₹1,450 | 64 |
| Soft-close Hinge | Hardware | Hettich | Piece | ₹62 | ₹85 | 890 |
| Cabinet Handle 96mm | Hardware | Godrej | Piece | ₹22 | ₹35 | 640 |
| Supplier | Phone | Supplies | Payable Balance |
|---|---|---|---|
| Sharda Plywood Distributors | 90100-xxxxx | Ply, HDHMR | ₹1,16,000 |
| Hettich India (Distributor) | 98200-xxxxx | Hinges, Fittings | ₹42,300 |
| Godrej Locking Solutions | 99800-xxxxx | Handles, Locks | Settled |
Customer & Reference
Mr. Rajeev Sharma — Indirapuram (Existing · Since Mar 2026)
↳ Purchase history with this customer
19mm Century Ply — last bought 14 Jun 2026, Qty 12, Rate ₹2,650/sheet
Hettich Soft-close Hinges — last bought 02 Jun 2026, Qty 40, Rate ₹85/pc
Hettich Soft-close Hinges — last bought 02 Jun 2026, Qty 40, Rate ₹85/pc
Ar. Neha Kapoor (Architect)
Item Lines
commission overridden per line| Item | Qty | Rate | Amount | Commission (to Neha Kapoor) |
|---|---|---|---|---|
| Century Ply 19mm (8x4) | 10 | ₹2,650 | ₹26,500 | ₹80/sheet · ₹800 |
| Greenlam HDHMR 6mm | 6 | ₹1,450 | ₹8,700 | 3% · ₹261 |
| Hettich Hinges (Soft-close) | 24 | ₹85 | ₹2,040 | No commission |
Invoice Summary
Subtotal₹37,240
Total Commission Accrued₹1,061
Commission = Σ (line rate × line qty)
Invoice Total₹37,240
Payment received now₹20,000 (UPI)
Added to running balance₹17,240
New Balance = Old Balance + Invoice Total − Payment Now
Save & Add to Ledger →
Supplier
Sharda Plywood Distributors, Loni Road
SPD-2291 · 01 Jul 2026
Items Received
| Item | Qty | Rate | Amount | Stock After |
|---|---|---|---|---|
| Century Ply 19mm (8x4) | 50 | ₹2,180 | ₹1,09,000 | 146 sheets |
| Godrej Cabinet Handles | 200 | ₹35 | ₹7,000 | 640 pcs |
Stock After = Previous Stock + Purchase Qty
Voucher Details
Refund to Customer
Rajeev Sharma — Customer Ledger
₹25,000
NEFT
UTR — 26070212345
02 Jul 2026
Voucher Types Supported
| Receipt from Customer | Cash/UPI/NEFT |
| Refund to Customer (F&F excess) | Cash/UPI/NEFT |
| Commission Payout | Cash/UPI/NEFT |
| Payment to Supplier | Cash/UPI/NEFT |
Save Voucher →
Running Account
6 months of scattered invoices — this is where it all lives together📄 Item-wise Statement (PDF)
| Date | Particulars | Mode | Debit (Material) | Credit (Received) | Balance |
|---|---|---|---|---|---|
| 02 Mar | Advance received | NEFT | — | ₹1,50,000 | ₹1,50,000 Cr |
| 18 Mar | INV-0981 — Ply & HDHMR | — | ₹2,10,000 | — | ₹60,000 Cr |
| 05 May | Mid-project payment | UPI | — | ₹1,50,000 | ₹2,10,000 Cr |
| 14 Jun | INV-1015 — Hardware | — | ₹1,10,000 | — | ₹1,00,000 Cr |
| 01 Jul | Final payment | NEFT | — | ₹1,45,000 | ₹2,45,000 Cr |
Running Balance = Previous Balance − Debit + Credit
Full & Final Settlement
Total Billed
₹4,20,000
Total Received
₹4,45,000
Excess to Refund
₹25,000
Excess / Due = Total Received − Total Billed
Commission Ledger
| Date | Customer | Item / Basis | Accrued | Paid | Mode |
|---|---|---|---|---|---|
| 18 Mar | Rajeev Sharma | Ply & HDHMR (INV-0981) | ₹6,300 | — | — |
| 25 Mar | — | Partial payout | — | ₹5,000 | UPI |
| 14 Jun | Rajeev Sharma | Hardware (INV-1015) | ₹1,061 | — | — |
| 20 Jun | Suman Gupta | Kitchen order | ₹16,540 | — | — |
Balance Payable = Σ Accrued − Σ Paid
146
Ply Sheets
64
HDHMR Sheets
890
Hinges (pcs)
640
Handles (pcs)
Low Stock Alerts
reorder threshold breached| Item | Current Stock | Reorder Level | Status |
|---|---|---|---|
| Greenlam HDHMR 6mm | 18 sheets | 25 sheets | Reorder Now |
| Godrej Handles — Matte Black | 40 pcs | 100 pcs | Reorder Now |
Current Stock = Σ Purchases − Σ Sales (running, per item)
Customer Purchase History — Mr. Rajeev Sharma
Date range: 01 Mar – 02 Jul 2026📄 Download PDF
| Date | Item | Qty | Rate | Amount |
|---|---|---|---|---|
| 18 Mar | Century Ply 19mm | 12 | ₹2,650 | ₹31,800 |
| 18 Mar | Greenlam HDHMR 6mm | 8 | ₹1,450 | ₹11,600 |
| 14 Jun | Hettich Hinges | 40 | ₹85 | ₹3,400 |
| 14 Jun | Godrej Handles | 36 | ₹35 | ₹1,260 |
Outstanding Report
All customers, sorted by due amount
Commission Report
Accrued vs paid, per architect/carpenter
Day Book
Cash / UPI / NEFT movement, daily
Staff & Permissions
| Name | Role | Access Level | |
|---|---|---|---|
| Owner (You) | Owner | Full access — all ledgers, vouchers, reports, settings | |
| Rakesh (Accountant) | Accountant | Ledgers, vouchers, reports — no user management | |
| Vikas (Sales Staff) | Sales Staff | Sale invoice, purchase-history lookup, stock view only |
Audit Trail (sample)
| Date/Time | User | Action |
|---|---|---|
| 02 Jul, 11:42 AM | Rakesh | Recorded refund voucher VCH-0562 — ₹25,000 to Rajeev Sharma |
| 02 Jul, 10:15 AM | Vikas | Created invoice INV-1042 for Rajeev Sharma |