Ghar ka budget track karna, kitchen ka kharcha dekhna, grocery planning karna — yeh sab spreadsheet se bahut aasan ho jaata hai. Google Sheets free hai, mobile aur desktop dono par kaam karta hai, aur family ke saath share bhi ho sakta hai.
Is guide mein hum ek practical kitchen log aur expense tracker banayenge — koi technical knowledge required nahi.
Google Sheets mein ek kitchen/expense tracker 20 minute mein ban sakta hai. Basic structure: Date, Item, Category, Amount, Paid By columns — aur ek summary sheet with SUM formulas. Ya Google ka free “Monthly Budget” template directly use karein (sheets.new → Template Gallery).
Google Sheets Kaise Kholein
sheets.google.com par jaayein ya Google Drive mein “New → Google Sheets” click karein. Mobile par Google Sheets app install karein (Android/iOS, free).
Pehli baar use kar rahe hain? Ek naya blank spreadsheet create karein. Hum step by step banayenge.
Kitchen Log / Expense Tracker Structure
Sheet 1: Daily Expenses
Row 1 mein yeh headers banayein (ek ek column mein):
- A1: Date
- B1: Item / Description
- C1: Category
- D1: Amount (₹)
- E1: Paid By
- F1: Notes
Row 1 ko bold karein aur background color dein taaki headers alag dikhein. Ab row 2 se data bharna shuru karein.
Categories Decide Karein
Common household categories:
- Sabzi/Fruits, Grocery (Atta/Dal/Rice etc.), Dairy (Milk/Dahi), Non-Veg
- Electricity/Water/Gas Bills, Phone/Internet, Rent
- Medicine/Health, School/Education
- Transport, Entertainment, Clothing
- Miscellaneous
Category column mein bar bar type karna mushkil hai — drop-down list banayein: C2 se C1000 select karein → Data menu → Data Validation → Criteria: “List of items” → apni categories comma separated likhein → Save. Ab har row mein C column click karne par drop-down menu aayega.
Sheet 2: Monthly Summary Banana
Sheet 1 ke tab ke paas “+” click karein — “Sheet2” banaayein, name change karein “Summary”.
Summary sheet mein:
- A column: Month names (January, February…)
- B column: Total Expenses uss month ki
- C column: Kitchen specifically
- D column: Bills
SUMIF formula use karein category-wise total ke liye:
=SUMIF(Sheet1!C:C,"Grocery",Sheet1!D:D)
Yeh formula Sheet1 ke C column mein “Grocery” dhundhega aur D column se totals add karega.
Kitchen Mein Specifically Useful Features
Weekly Grocery List Template
Ek alag sheet “Grocery List” banayein:
- Column A: Item name (Atta, Dal, Chawal, Dahi…)
- Column B: Quantity Needed
- Column C: Estimated Price
- Column D: Checkbox (✓ aur ✗ for bought/pending)
Checkboxes Insert kaise karein: D column select karein → Insert menu → Checkbox
Recipe Log
Ek sheet “Recipes” banayein — apni family ki favourite recipes, ingredients aur quantities. Ek baar enter karne ke baad hamesha refer kar sakte hain.
Monthly Kitchen Budget Track
Ek cell mein monthly kitchen budget set karein (jaise ₹15,000). Dusre cell mein actual spending ka running total. Teen cell mein remaining budget:
=B1-SUMIF(Sheet1!C:C,"Grocery",Sheet1!D:D)-SUMIF(Sheet1!C:C,"Sabzi",Sheet1!D:D)
Family ke Saath Share Karein
Google Sheets ka sabse bada advantage hai real-time collaboration — poori family ek hi sheet mein data enter kar sakti hai:
- Share button click karein (top right)
- Family members ke Gmail add karein
- “Editor” access dein taaki woh bhi data enter kar sakein
Ab jab bhi koi kharcha hota hai, koi bhi family member seedha sheet mein enter kar sakta hai apne phone se.
Spreadsheet tracker tabhi kaam karta hai jab regularly update kiya jaaye. Ek habit banayein: raat ko dinner ke baad 5 minute mein din ke kharche enter karein. Agar ek hafte chhod diya toh catch up karna mushkil ho jaata hai. Mobile app se on-the-spot entry kaafi easier hoti hai.
Ready-Made Templates Use Karein
Scratch se banana nahi chahte? Google Sheets ke free templates use karein:
- sheets.new open karein
- “Template Gallery” click karein
- “Personal” section mein: “Monthly Budget”, “Annual Budget” templates milenge
- Template click karein → “Use Template” → apna copy mil jaayega
Yeh templates already formulas aur structure ke saath aate hain — sirf apna data daalo.
□ Google Sheets account ready hai
□ Sheet1 mein headers banaye (Date, Item, Category, Amount, Paid By)
□ Category drop-down list set ki
□ Summary sheet mein SUMIF formulas add kiye
□ Grocery list sheet banaya
□ Family members ke saath share kiya
□ Mobile app install kiya for on-the-go entry
Conclusion
Google Sheets ek powerful free tool hai jo kitchen log se lekkar poore ghar ka budget track karne tak kaam aa sakta hai. Ek simple structure setup karne mein 20-30 minute lagte hain — uske baad sirf daily data entry ki zaroorat hai. Family ke saath share karne se sab aware rehte hain kharche ke baare mein — yeh financial awareness long term mein bahut helpful hoti hai.