PROBLEM IT SOLVES:
Most Kienyeji farmers in Kenya don't know if they make profit or loss. They forget eggs collected, feed used, chicks died, vaccine costs, money from selling birds. Without records, you can't know if your farm grows or dies. This 8-sheet PRO record book solves that.
WHO SHOULD USE IT:
- Kienyeji chicken farmers (10 to 500 birds)
- Beginners who never kept records before
- Farmers using phone, no laptop needed
- Farmers in Kenya, Uganda, Tanzania who sell eggs at 20 KES and birds at 800-1500 KES
WHAT YOU RECEIVE AFTER PAYMENT (Instant Download):
Excel File - 8 Sheets - 100 Rows Empty Template (Works on Phone + Laptop) - No example data, you start fresh:
- INSTRUCTIONS: How to open with WPS Office FREE, how to use yellow/green color code, list of 8 sheets, works offline
- EGG COLLECTION: Date, Total Eggs, Broken, Good Eggs (auto), Sold, Price per egg, Money (auto), Note/Customer
- FEEDS RECORD: Date, Feed Type (Chick Mash/Growers/Layers), KG Bought, Price per KG, Total Cost (auto), KG Fed Today, Stock Left (auto), Supplier
- EXPENSES: Date, Item (Vaccine/Transport/Labor/Chicks), Cost KES, Paid To, Receipt No, Category
- VACCINATION RECORD: Date, Vaccine Name, Age of Birds, No. Vaccinated, Cost (KES), Next Due Date (auto), Vet/Agrovet
- MORTALITY: Date, Birds Added (chicks bought), Birds Died, Birds Sold or Culled, Flock Now (auto), Note
- OTHER INCOME: Date, Item (Birds/Manure/Eggs), Quantity, Price Each (KES), Total (auto), Note - Tracks money from selling birds
- PROFIT SUMMARY: Total Egg Money, Total Feeds Cost, Total Other Expenses, Other Income, TOTAL PROFIT/LOSS (auto), Total Good Eggs, Total Sold, Total Broken, Flock Size, Average per Day
PRACTICAL EXAMPLE - HOW IT WORKS:
Mama John has 20 hens. This is how she uses 8 sheets:
Day 1:
- Egg Collection: 18 eggs, 1 broken = 17 good, sells 15 @ 20 KES = 300 KES (Money auto = 300)
- Feeds Record: Chick Mash 10kg @ 80 KES = 800 KES total auto, feeds 2kg, stock left 8kg auto
- Expenses: Vaccine 500 KES, Transport 200 KES
Day 2:
- Mortality: 1 chick died, Flock Now auto = 19
- Other Income: Sells 2 old hens @ 1000 KES each = 2000 KES total auto
After 30 days: Egg Money 9,000 + Other Income 2,000 = 11,000 income. Feeds 4,800 + Expenses 1,000 = 5,800 cost. Profit = 11,000 - 5,800 = 5,200 KES. Profit Summary shows auto. Now she KNOWS real profit, not guessing.
HOW TO DOWNLOAD, OPEN, AND USE (Beginner Guide - Phone Only):
File Format: .xlsx (Excel) - 8 sheets inside
Size: ∼25KB (small, downloads fast even with poor internet)
Required App: WPS Office FREE (Play Store, App Store) or Microsoft Excel or Google Sheets
Works Offline: Yes, after download, no internet needed. Works on Android, iPhone, Laptop.
Step 1: After payment on Selar or Vezill, click Download, save to phone Downloads folder.
Step 2: If ZIP, install ZArchiver FREE from Play Store, open Files, Downloads, tap ZIP, Extract Here.
Step 3: Install WPS Office FREE from Play Store.
Step 4: Open WPS Office, open Excel file, you will see 8 sheets at bottom - tap each sheet name to switch.
Step 5: Every evening 2 minutes: Fill Egg Collection, Feeds, Mortality, Expenses.
Step 6: Every time you vaccinate: Fill Vaccination Record.
Step 7: Every Sunday: Check Profit Summary sheet - it auto tells you profit/loss, flock size, total eggs.
HOW IT HELPS YOU MAKE BETTER DECISIONS:
- Reduces mistakes: No more forgetting eggs or feed theft - you track stock left auto
- Monitors flock: Mortality sheet shows if many birds dying - you act fast
- Tracks all income: Other Income shows money from selling birds, not just eggs
- Monitors expenses: See where money goes - vaccine, transport, labor, chicks
- Understands profitability: Profit Summary auto shows daily, weekly, monthly profit/loss with Other Income included
- Makes better decisions: If feeds cost too high, switch supplier. If broken eggs many, fix nest. If mortality high, call vet. If profit low, increase price.
- Saves time: 2 minutes per day, no complex bookkeeping
- Works for 1 year: 100 rows = 100 days per sheet, then copy sheet for next 100 days
VERIFIED FUNCTIONALITY
- All formulas tested with realistic Kienyeji farming data (20-50 eggs per day, 2-5kg feed per day, 20 KES per egg, 1000 KES per bird)
- Tested on WPS Office Android, Microsoft Excel Windows, Google Sheets
- Empty template - no example data - farmer starts fresh - green blanks = auto calculates when you type yellow
- Yellow cells = you type, Green cells = auto calculates, don't delete green cells
Comments