How to Automate Mandi Commission (Patti) Calculation — Step-by-Step Guide

If you are still calculating mandi commission manually — by hand, on a calculator, or in Excel — you are losing 2–4 hours every single day. Worse, you are almost certainly making calculation errors that cost you money with every patti you generate.

This step-by-step guide shows you exactly how modern commission agents at Azadpur Mandi (Delhi), Vashi APMC (Mumbai), Bowenpally (Hyderabad), and thousands of mandis across India have automated the entire patti calculation process — reducing their daily reconciliation time from hours to minutes.

What Exactly Is a Mandi Patti? (And Why Getting It Wrong Costs You Money)

A mandi Patti (also called Bikri, Sale Memo, or Farmer Settlement) is the financial settlement document given to a farmer after their produce is sold at the mandi. It is both a legal document and the primary trust signal between an arhtiya and their farmer network.

Getting a Patti calculation wrong costs you in 3 ways:

1. Direct financial loss: If you underpay yourself (miscalculate commission or miss a deduction), you absorb the cost. If you overpay, the farmer disputes it later.
2. Dispute and relationship damage: Farmers who cannot verify deductions on an English Patti often assume they are being shortchanged. This damages trust and farmer loyalty.
3. APMC compliance risk: Incorrectly computed APMC Cess creates discrepancies in your 6R/J-Form reports that trigger audits.

The Complete Mandi Patti Formula (With Real Numbers)

Here is the standard formula used across Indian mandis, with a worked example:

Now imagine repeating this calculation 60–150 times per day, with different rates for different farmers, different commission structures per party, and APMC Cess varying by commodity. This is why manual calculation fails at scale.

The 7 Components of a Mandi Patti (Every Arhtiya Must Know)

How to Automate Patti Calculation in MandiGrow (Step-by-Step)

Step 1: Configure Commission Rates Per Party

In MandiGrow's Party Master, set the Arhat % for each farmer relationship. Some farmers may have a 5% commission, others 6%. These rates auto-apply to every sale — no manual input per transaction.

Step 2: Set APMC Cess for Your State

Go to Settings → Mandi Configuration → APMC Cess. Enter your state's market fee rate (e.g., 1% for Telangana, 0.8% for Maharashtra, 1.5% for UP). This auto-applies to every transaction in your mandi.

Step 3: Configure Hamali & Tulai Rates

Set standard rates per bag, per crate, or per quintal. MandiGrow allows different rates per commodity type — for example, ₹5/bag for tomatoes but ₹3/bag for onions — reflecting the actual labour cost differential.

Step 4: Record the Sale (Under 30 Seconds)

During the morning auction, the munim opens the POS, selects the lot (by scanning QR code or typing 6-digit code), enters the sale rate and buyer name, and presses Confirm. The entire Patti is instantly calculated — zero manual math.

Step 5: Print or WhatsApp the Patti

The Patti is ready. Print it on a 3-inch thermal printer (Bluetooth, under 2 seconds) or tap WhatsApp to send it directly to the farmer before they leave the mandi premises. The farmer's Khata is updated simultaneously.

What Happens to Farmer Advances (Peshgi)?

Commission agents frequently advance money to farmers before harvest. These advances must be recovered from future sales. MandiGrow maintains a running Peshgi ledger per farmer. When a sale is processed, MandiGrow automatically shows the outstanding advance and lets you deduct it partially or fully from the Patti — with full transparency to the farmer on the printed slip.

APMC Cess Rates by State (2026 Reference Table)

Note: Rates are indicative based on publicly available state APMC notifications. Verify with your local Mandi Samiti for the latest applicable rates.

Frequently Asked Questions

Stop doing manual patti calculations. Start your 14-day free trial and generate your first automated Patti in under 5 minutes.