Business SystemBusy every day, but how much profit is left at month end?
Recipes, food cost, stock, purchase orders, bills and P&L
For: Restaurants, cafés, noodle and rice shops · Shops selling both dine-in and delivery · Owners who want to control food cost and stock themselves
฿1,290
ExcelGoogle Sheets
Q&A with real numbers from the sample file
What were October sales?Sample data: 405,200 baht from 1,660 bills
What is the food cost?38.9%, and dishes above target are flagged "high cost" on the menu tab
What is left after all costs?Net profit 36,164 baht, shown month by month in the 12-month P&L
FAQ about this system
Does it work in Excel and Google Sheets?Both. Open it in Excel 2016 or later / Microsoft 365, or upload it to Google Drive and open it with Google Sheets
Do I need to be good at Excel?No. Fill in the white cells only; dark cells are formulas, and a 5-step guide is inside the file
Can I change the business name and address on the forms?Yes. Edit them once in Settings and every form updates
How do I clear the sample data?Delete only the white cells on the data tabs; formulas and forms stay in place
How much data can it hold?Up to 9,000 sales lines, tested with full tables and no formula errors
Can I print or save the forms as PDF?Yes. Forms are set up for A4; pick the document number and print or save as PDF
What happens if I type the wrong kind of value?Number and date cells are validated and show a message, and formulas are guarded against error values
How is stock deducted?Enter each recipe once; every sale multiplies the ingredient quantities and deducts them from stock
How does the purchase order fill itself?Ingredients below their reorder point appear with a suggested quantity and value
Can it handle delivery-app commission (GP)?Yes. Set the commission per sales channel in Settings and filter the dashboard by channel
Can it hold a full year?Tested with 9,000 sales lines with every formula calculating correctly
ระบบสมาชิกฟิตเนสและเช็กอิน
เทมเพลตรายรับรายจ่าย ครอบครัว
เทมเพลตครู คะแนน เกรด เช็คชื่อ ตารางสอน
เทมเพลตสต๊อกสินค้าและยอดขาย
ทะเบียนลูกค้าประกันและเตือนต่ออายุกรมธรรม์
ทรัพย์ในมือและลูกค้านายหน้าอสังหาฯ