REPORTS
HISAB Reports
Reports reproduce the workbook SUMIF and DARA logic.
Total Orders2
Total Business₹695,011.80
Total Received₹500,000.00
Total Balance₹195,011.80
BRAN TOTAL₹594,118.80
Weight166.700
DARA3,564.0000
Orders1
CHILKA TOTAL₹100,893.00
Weight199.000
DARA507.0000
Orders1
Distributor Outstanding
Balance = Total Order Amount − Total Payment Received.
| Distributor | City | Business | Received | Balance |
|---|---|---|---|---|
| AMOLAK | - | ₹100,893.00 | ₹0.00 | ₹100,893.00 |
| BABBU | - | ₹0.00 | ₹0.00 | ₹0.00 |
| CHUGH E/P | - | ₹0.00 | ₹0.00 | ₹0.00 |
| Demo | ludiana | ₹594,118.80 | ₹500,000.00 | ₹94,118.80 |
| GURU KIRPA ASSO | - | ₹0.00 | ₹0.00 | ₹0.00 |
| KC SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| KISSAN SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| KISSAN SOLVEX JBD | - | ₹0.00 | ₹0.00 | ₹0.00 |
| MANTRI | - | ₹0.00 | ₹0.00 | ₹0.00 |
| NARESH CHAWLA | - | ₹0.00 | ₹0.00 | ₹0.00 |
| NASA AGRO | - | ₹0.00 | ₹0.00 | ₹0.00 |
| NASA SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| PARAMJEET | - | ₹0.00 | ₹0.00 | ₹0.00 |
| PARAMJIT | - | ₹0.00 | ₹0.00 | ₹0.00 |
| PUNJAB AGRO | - | ₹0.00 | ₹0.00 | ₹0.00 |
| S S SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SACHIN | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SAJAN SHARMA | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SHRI RAM SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SS SOLVEX | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SUBHASH JBD | - | ₹0.00 | ₹0.00 | ₹0.00 |
| SUMIT&SHIVAM | - | ₹0.00 | ₹0.00 | ₹0.00 |
| TIRVANI RICE | - | ₹0.00 | ₹0.00 | ₹0.00 |
| VIKAS SETIA | - | ₹0.00 | ₹0.00 | ₹0.00 |
| VOHRA | - | ₹0.00 | ₹0.00 | ₹0.00 |
TOTAL CHILKA
Weight uses WEIGHT (Excel column D). DARA = Amount ÷ Weight.
| S.No. | Broker | City | Weight | Amount | DARA | Orders |
|---|---|---|---|---|---|---|
| 1 | AMOLAK | - | 199.000 | ₹100,893.00 | 507.0000 | 1 |
TOTAL PHUCK
Weight uses WEIGHT (Excel column D). DARA = Amount ÷ Weight.
| S.No. | Broker | City | Weight | Amount | DARA | Orders |
|---|
TOTAL BRAN
Weight uses NET WEIGHT (Excel column G). DARA = Amount ÷ Weight.
| S.No. | Party Name | City | Weight | Amount | DARA | Orders |
|---|---|---|---|---|---|---|
| 1 | Demo | ludiana | 166.700 | ₹594,118.80 | 3,564.0000 | 1 |
| Gatepass | Date | Distributor | Item | Bag | Weight | Bardana | Net Wt. | Rate | Oil% | Net Oil | Amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| GP-000002 | 10 Oct 2026 | Demo | BRAN | 350.00 | 170.200 | 3.500 | 166.700 | 216.0000 | 19.000 | 16.500 | ₹594,118.80 |
| GP-000001 | 10 Oct 2026 | AMOLAK | CHILKA | 0.00 | 199.000 | 0.000 | 199.000 | 507.0000 | 0.000 | 0.000 | ₹100,893.00 |
| Date | Distributor | City | Mode | Payment |
|---|---|---|---|---|
| 10 Oct 2026 | Demo | ludiana | UPI | ₹500,000.00 |