Quick answer: A kisan khata (farmer ledger) has one line for every udhaar (money or goods given) and every jama (crop sale or cash received). The running balance shows what the farmer owes. Byaj is simple interest on that balance:
Byaj = balance × days × monthly rate ÷ 30 ÷ 100
It is worked out for each period between two entries, then added up.
Download a free kisan khata with byaj in Excel below. Type the entries; the balance, days, byaj and farmer statement are worked out.
Key takeaways
- Khata sheet for up to 2,000 entries and 50 farmers.
- Running balance per farmer with Dr / Cr.
- Byaj on the daily debit balance at your rate per month (1% in the sample). No byaj is worked out on a credit balance.
- Farmer Khata statement: every entry, days, byaj, principal, byaj to date and total payable.
- Summary of principal, byaj and total for every farmer.

All farmers at a glance

A minus balance means you owe the farmer, for example after a crop sale that has not been fully paid out.
How to use the template
- Farmers: type your firm name, the byaj rate per month, the date to work byaj up to, and your farmers with a code.
- Khata: enter every transaction in date order. Start each farmer with the old balance as an udhaar line called “Opening balance b/f”.
- Farmer Khata: pick a farmer code to see and print the statement.
- Summary: check who owes how much before the next crop payment.
Tips
- Agree the byaj rate in writing and show the statement before you deduct anything.
- Give a printed statement with every crop payment. It avoids arguments over old entries.
- Write what was given. “DAP 10 bags” is clearer than “goods”.
Download the free Kisan Khata with Byaj
There are four sheets: Farmers, Khata, Farmer Khata and Summary. Fill in the yellow cells; everything else is worked out.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Was this template useful?
Related free templates Free Excel files people download with this one
FAQs
Is 1% per month the same as 12% a year?
For simple interest, yes. The template shows the yearly figure next to the rate.
Does it add byaj to the balance (compound)?
No. It works out simple byaj only. If you charge byaj into the khata, enter it as an udhaar line on that date.
Can shopkeepers use it?
Yes. Any udhaar khata with interest works the same way, for example a fertiliser shop or a village store.









Leave a Review