| Item | Amount | Meaning |
|---|
Supporting schedules: Purchases and closing stock are shown for management control, but they are not added directly into Nett Profit. COGS is based on actual OUT_STOCK usage.
Cost of Goods Sold โ Stock Used
| Stock Name | Total Used | UOM | Total Cost |
|---|
Purchased โ Stock In
| Stock Name | Total Purchased | UOM | Total Cost |
|---|
Expenses
| Description | Category | Amount |
|---|
Closing Stock Balance โ Asset
| Stock Name | Balance Qty | UOM | Stock Value |
|---|
View Management Analysis
Performance Diagnosis
Expense Breakdown
Product Performance
Cost & Wastage Control
Inventory Value Movement
| Statement Item | Amount | Explanation |
|---|
Value by Category
| Category | Opening | Stock In | Stock Out | Adjustment | Closing |
|---|
View Raw Material Inventory Details
| Raw Material | Category | Opening Qty | Stock In Qty | Stock Out Qty | Closing Qty | Opening Value | Closing Value |
|---|
Monthly Sales Trend
P&L Breakdown
Top Product Sales
Top Wastage Cost
Month Comparison
| Month | Sales | Gross Profit | Nett Profit | Sales Growth | Wastage Cost |
|---|
SKU Growth
1. Enter Forecast Quantity by Product
Enter how many units or Combo sets you expect to sell. Sales amount, cost and GP update automatically.
2. Consolidated Raw Material Preparation List
The same RAW_LIST ID is combined into one line. Employee Prepare / Buy is the final recommended quantity after current stock and safety stock.
Bulk upload: CSV or Excel (.xlsx/.xls). Required columns are Products ID, Products Name, and UOM. Optional Opening Balance creates one opening IN_STOCK record for newly added IDs only.
Grouped by category for easier checking.
Stock In Form
For staff to record received stock. Date, time and staff name are saved automatically.
Historical Stock In is allowed: CSV or Excel (.xlsx / .xls). Required columns: Date, Product ID, Qty. Optional: Unit Price, PIC, Reference, Invoice Number, Time. Supported dates include 2025-07-30, 30/07/2025, 7/30/25 and normal Excel date cells. Add new records only keeps existing records and reports matches as โAlready in systemโ. Initial setup: replace all Stock In is Boss-only and rebuilds the Stock In ledger from the uploaded file after making a safety backup.
Stock Out Form
For staff to record production use, wastage, expired stock, damage or adjustment.
For new wastage/expired records, upload proof photo when required.
CSV / Excel format: Date, Product ID, Qty, Out Type. Optional: Unit Cost, PIC, Remark, Time. Historical dates are accepted.
First-time history: Boss may choose Initial history: import all valid rows. It accepts past OUT_STOCK even when the opening/IN_STOCK history is not complete yet. Re-uploading the same file keeps existing transactions and adds only the previously missing valid rows. Normal staff and manual entries still block negative stock.
First-time history: Boss may choose Initial history: import all valid rows. It accepts past OUT_STOCK even when the opening/IN_STOCK history is not complete yet. Re-uploading the same file keeps existing transactions and adds only the previously missing valid rows. Normal staff and manual entries still block negative stock.
Staff workflow: Weigh the finished mix and record its completion date/time. Record actual consumption by weight; mix still inside a machine or container remains part of the batch. At 120 hours, every remaining gram becomes wastage and the batch cannot be used. If it smells bad, discard the entire remaining batch immediately.
ๅๅทฅๆต็จ๏ผๅถไฝๅฎๆๅ่ฎฐๅฝๆฅๆใๆถ้ดใ่ด่ดฃไบบๅ้้๏ผ่ฎฐๅฝๅฎ้ ๆถ่้้๏ผๅ่ฟๆบๅจไธ็ฎๅทฒๆถ่๏ผๆปก 5 ๅคฉๆๅบ็ฐๅผๅณ๏ผๅฎนๅจๅๆบๅจๅ ๅฉไฝ mix ๅฟ ้กปๆฅๅบใ
ๅๅทฅๆต็จ๏ผๅถไฝๅฎๆๅ่ฎฐๅฝๆฅๆใๆถ้ดใ่ด่ดฃไบบๅ้้๏ผ่ฎฐๅฝๅฎ้ ๆถ่้้๏ผๅ่ฟๆบๅจไธ็ฎๅทฒๆถ่๏ผๆปก 5 ๅคฉๆๅบ็ฐๅผๅณ๏ผๅฎนๅจๅๆบๅจๅ ๅฉไฝ mix ๅฟ ้กปๆฅๅบใ
Mix Batch History
Production, actual usage, expiry and off-odor disposal remain traceable.
| Time | Mix / Batch | Action | Weight | Reason | Responsible Person | Note |
|---|
Wastage Ranking
Sales Excel template: it now lists active Combo products first, followed by ordinary products. Fill Qty with the month's total. Keep Combo Discount at 0; its price is controlled in Combo Builder. Importing updates monthly sales and expected Recipe usage onlyโit does not create OUT_STOCK.
Monthly Product & Combo Sales Units
Enter all monthly sales units here. Combo products appear at the top of the same table.
Product
Units
Discount / Adjust
Price
Final Cost
Sales
Gross Profit
Margin
Expected vs Actual Raw Material Usage
Recipe ร recorded sales is the expected usage. Only staff-entered OUT_STOCK is actual usage and affects stock balance. A difference is a warning to investigate, not automatic proof of misuse.
Expenses CSV / Excel: Date, Category, Description, Amount. Optional: PIC, Payment Method, Reference. Historical dates are accepted.
Product Forecast Entry
Same product list as SALES_IN: Active Combo products and ordinary Recipe products are forecast together. Projection estimates sales, cost and raw-material demand only; it never changes actual stock.
Product
Forecast Qty
Price
Final Cost
Sales
GP
Margin
Recipe
Raw Material Prepare List โ Linked With Inventory
If the linked raw material is wrong, change the Raw Material ID or factor directly in the row. Factor means recipe amount ร factor = inventory UOM.
Correct workflow: Combo Builder only defines the combination and price. Enter monthly Combo units in SALES_IN. Actual inventory changes only when staff submits IN_STOCK or OUT_STOCK.
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Correct cash formula: Closing Cash + Cash Out โ Opening Cash = Cash Sales Received. Cash Out is added back because that money left the drawer after it was received. Customer refunds already deducted by the POS should not be entered as Cash Out here.
Checking automatic backup setup...
Retention30 days
Daily automationChecking
Available points0
Free-plan boundary: These incremental restore points protect against mistakes inside this system. They do not survive deletion of the entire Supabase project.
Loading restore points...
Supabase User Accounts
Create, reset or disable login accounts in Supabase โ Authentication โ Users.
Set Boss/Staff role, status and permissions in Table Editor โ profiles.
The first registered user becomes the Boss automatically.
Attendance Store Location & GPS Range
Boss setup only. Stand inside the Alpacco outlet and capture the store position once. When enabled, Staff must share live GPS and remain inside the allowed radius for both Check In and Check Out.
Store location is not configured yet.
Recommended: 150 m radius and 100 m maximum GPS error. The browser will request location permission. After capture, click Save Settings.
Time & Daily Stock Count
Operation Rules
These settings are saved row by row in Supabase with your inventory data.
Category & Payment Method Dropdown Choices
Boss only. These choices control the dropdown lists in Add / Edit Raw Material. Enter one choice per line, then click Save Settings.
Blank lines and duplicate choices are removed automatically.
Removing a choice does not erase it from old records. It only stops it being selected for new records.
Price & Raw Cost Effective Dates
Boss only. Schedule a selling-price or raw-material-cost change without rewriting earlier sales months.
Monthly accuracy rule: SALES_IN is stored by month, not by individual sale date. Choose the first day of a month (for example 2026-08-01). The impact preview recalculates recorded sales from that month onward.