Arhtiya Commission 2026-27: Wheat ₹50.75, Paddy ₹50.61 per Quintal – Free Arhat & Byaj Calculator (Excel)

arhtiya commission calculator 2026 27
Ads loading…

Advertisement

Quick answer: From the 2026-27 season, the Centre has raised the arhtiya commission (arhat) on government wheat and paddy procurement in Punjab and Haryana:

  • Wheat: ₹50.75 per quintal (was ₹46.00)
  • Paddy: ₹50.61 per quintal (was ₹45.88)

The agency pays this commission. It is not deducted from the farmer, who gets the full MSP directly in his bank account (DBT). For example, 100 quintals of wheat at the MSP of ₹2,585 is ₹2,58,500 to the farmer and ₹5,075 arhat to the arhtiya. Download the free calculator below. It also has a byaj (interest) calculator for farmer advances.

Key takeaways

  • Arhat on government purchase is a fixed ₹ per quintal, paid by the procuring agency.
  • On private sales (basmati, maize, mustard), arhat is usually a % of the sale value and is deducted from the farmer, along with labour.
  • The free Excel file works out the arhat, the farmer’s amount and who pays what, and calculates byaj on advances by days.
  • Every rate can be edited, because rates change each season.

↓ Jump to the free download

Arhtiya commission calculator 2026-27 in Excel for wheat and paddy
100 quintals of wheat to a govt agency: the farmer gets ₹2,58,500 by DBT, and the arhat of ₹5,075 is paid by the agency.

Arhtiya commission rates 2026-27

Crop (govt procurement)MSP 2026-27Arhat – oldArhat – from 2026-27Arhat on 100 qtl
Wheat (Punjab, Haryana)₹2,585 / qtl₹46.00 / qtl₹50.75 / qtl₹5,075
Paddy – common₹2,441 / qtl₹45.88 / qtl₹50.61 / qtl₹5,061

The commission paid to procurement societies and co-operatives was also raised: wheat from ₹27.00 to ₹29.79 per quintal and paddy from ₹32.00 to ₹35.30. Rajasthan’s wheat arhat went from ₹41.40 to ₹45.67.

Govt purchase vs private sale – who pays the arhat?

Govt agency (MSP)Private buyer
Farmer is paid byAgency, directly to his bank (DBT)Arhtiya, after receiving from the buyer
ArhatFixed ₹ per quintal, paid by the agencyUsually a % of the sale value, deducted from the farmer
Labour / handlingAs per agency ratesOften deducted from the farmer at ₹ per quintal

Example of a private sale: 129.19 qtl of basmati at ₹4,050 = ₹5,23,219.50. Less 2.5% arhat (₹13,080) and labour at ₹12/qtl (₹1,550), the farmer gets ₹5,08,589. The arhat % and labour vary by mandi, so enter your own.

Ads loading…

Byaj (interest) on farmer advances

Byaj calculator in Excel for farmer advances by days
Interest is worked out by days from each entry’s date. Money received gives the farmer interest credit from that date.

Many arhtiyas give farmers advances and inputs (seed, fertiliser, diesel) and recover them after harvest. The byaj sheet works out simple interest at your rate per month (for example 1%), counting each entry by days with a month taken as 30 days. It then shows the principal outstanding, the interest and the total due. Charge interest only as allowed by law and your written agreement with the farmer.

Run an arhat shop? XploreArhat – Arhtiya (Commission Agent) Accounts in Excel covers up to 200 farmers. It keeps an arrivals / J-form register for govt (DBT) and private sales and a farmer khata with every sale, advance and payment. Byaj is worked out each month on the daily balance. It shows who owes you and whom you owe, with WhatsApp reminders, plus agency and buyer dues and a month-wise and crop-wise income report.

Download the free Arhtiya Commission & Byaj Calculator

There are two sheets: Arhat Calculator and Byaj Calculator. Fill in the yellow cells. It works in Excel, Excel for Mac and Google Sheets.

FAQs

Is arhat deducted from the farmer’s MSP payment?

No. In government procurement the farmer receives the full MSP in his bank account, and the agency pays the arhtiya’s commission separately.

From when do the new rates apply?

From the Rabi Marketing Season 2026-27 onwards, as announced by the Ministry of Consumer Affairs, Food & Public Distribution in March 2026. Check your agency’s latest instructions.

What is the arhat on private sales?

It depends on the mandi and the crop, and is usually agreed as a percentage. Enter your rate. The 2.5% in the file is only an example.

Ads loading…

Does it work on mobile?

Yes. Open it in the Excel or Google Sheets app.

More free templates

Ads loading…

Advertisement

Amanpreet Kaur Bharaj
Welcome to my profile! My name is Amanpreet Kaur, and I am a Freelance Microsoft Excel Specialist with an extensive background in data management and analysis. I offer top-tier Excel services, helping businesses optimize their processes, make informed decisions, and improve overall efficiency.Over the years, I have honed my skills in Excel to provide solutions tailored to each client's unique needs. I specialize in creating and maintaining complex Excel spreadsheets, utilizing advanced functions and formulas for optimal data processing, and designing macros to automate repetitive tasks.My expertise extends to crafting custom Excel VBA scripts, which allows me to cater to specific project requirements. Additionally, I am adept at building and managing pivot tables for robust data analysis and visualization. I also offer data cleaning services to ensure data integrity and reliability.With a keen eye for detail and a strong commitment to accuracy, I provide Excel-related technical support and training, always ensuring the highest quality in the work I deliver. My strong analytical and problem-solving skills, combined with excellent communication abilities, enable me to understand and fulfill your data requirements effectively.As a freelancer, I understand the value of meeting deadlines and deliver high-quality output within the agreed timeframe. I can work independently on projects, offering turnkey solutions that drive successful results. Staying updated with the latest developments and features in Microsoft Excel is a commitment I take seriously, always aiming to provide the most current and efficient solutions to my clients.Having worked with various industries, I have a broad outlook that allows me to adapt quickly to new environments and data structures. Whether it's a small business looking to streamline their data management or a large corporation in need of complex data analysis, I take pride in delivering the best possible results.I'm passionate about helping organizations make sense of their data and uncover insights that can propel their growth. So, if you're looking for a reliable, efficient, and professional Microsoft Excel expert, you've come to the right place.Thank you for visiting my profile. I look forward to the opportunity of working together and leveraging the power of data to drive your business forward!