Kisan Khata in Excel with Byaj (Free) – Farmer Ledger with Interest on Daily Balance

Kisan khata in Excel with udhaar, jama, running balance and byaj

Advertisement

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.

↓ Jump to the free download

FOR ARHTIYASJ-form, farmer khata and byaj — settled in minutes.XploreArhat works out arhat, byaj on the daily balance and agency dues for govt and private sales.See XploreArhat — from ₹999 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreArhat

Advertisement
Kisan khata in Excel with udhaar, jama, running balance and byaj
₹45,000 opening for 21 days at 1% a month = ₹315 byaj. After seed, fertiliser and a ₹50,000 cash advance, he owes ₹78,900 plus ₹3,462 byaj.

All farmers at a glance

Farmer ledger summary in Excel with principal, byaj and last entry date
Principal, byaj and total for each farmer, with the date of the last entry.

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

  1. Farmers: type your firm name, the byaj rate per month, the date to work byaj up to, and your farmers with a code.
  2. Khata: enter every transaction in date order. Start each farmer with the old balance as an udhaar line called “Opening balance b/f”.
  3. Farmer Khata: pick a farmer code to see and print the statement.
  4. 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”.
Outgrown the free sheet? Here’s what XploreArhat adds

Free sheetXploreArhat
Arrivals / J-form register—✓
Outstanding with WhatsApp reminders—✓
Dues from agencies & buyers—✓
Printable sale slip—✓
Month-wise income report—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreArhat — from ₹999 →

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?

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.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.