Punch a dish
Or paste a batch
One dish per line, price first — 150 Pork Dish 4/5, 150, Pork Dish, 4/5 or 150, Pork Dish, 4, 5. Every line needs a price above ₱0 (no thousands commas — ₱1200, not ₱1,200). If any line is unreadable or has no price, nothing in the batch gets added.
The full slip
Click a date to expand or collapse its entries. Chips: Expand ALL · Last 3 Days Detail · Daily Summary · By Workweek · Monthly Summary. Red box = the name doesn't exactly match the menu. not in menu = no menu dish has this name (the sale keeps its price) — click it to link or add the dish. new price = this sale changed the dish's price — hover for old → new. no price set only appears on older sales saved without a price.
| Dish | Sold | Available | Sell-through | Price | Revenue | Lost | |
|---|---|---|---|---|---|---|---|
|
No dishes punched in yet Add one above, or paste a batch to get started. |
|||||||
Today, this week & beyond
| Period | Revenue | Sold / Available | Sell-through |
|---|
Top by category
| Category | Dishes | Revenue | Avg. sell-through |
|---|---|---|---|
| No sales yet. | |||
Top performers
| Dish | Category | Servings sold | Sell-through | Revenue |
|---|---|---|---|---|
| No sales yet. | ||||
Needs attention
| Dish | Category | Sell-through | Unsold | Lost revenue |
|---|---|---|---|---|
| No sales yet. | ||||
Add a dish
Or paste a batch
One dish per line — label, price, label, price, YYYY-MM-DD, or label, price, YYYY-MM-DD, dish category. Every line needs a price above ₱0. Existing labels (matched regardless of case) get a new price record if the price changed. If any line is unreadable or has no price, nothing in the batch gets added.
Rename or delete a category
Renaming updates every dish currently in that category automatically — nothing to edit dish by dish. Deleting a category moves its dishes to Uncategorized, so no dish is ever left pointing at a category that no longer exists.
Menu & prices
Chips show dish categories ranked by how many dishes they hold — click one to show just that category, or Categories to fold everything down to its headers. The pencil edits a dish's name, price or dish category right on its card. Deleting a dish removes it from this list only — every past sale already has its own recorded price locked in, so historical figures are never affected. Renaming a dish updates its label on already-logged sales automatically.
No dishes yet
Add your first dish above to start tracking prices.
Market & raw material expenses
Log an expense
Or paste a batch
One item per line — item [weight/volume] [count] price, with commas or spaces: ampalaya 2kg 8pcs 220, egg 30pcs 240, LPG 11kg 1tank 1050. The price is the last plain number. If any line is unreadable, nothing in the batch gets added. Each item is auto-matched against your materials catalog; an unmatched line is still added, flagged in the log below. A line linked to a material but with no quantity is flagged "no qty".
This catalog defines the ingredient types you can link to when logging an expense on the "Log expense" tab — no cost or date here, since a material gets bought many times at different prices. Record the actual purchase (its date and cost) on Log expense, then link it to a material below.
Add a material
Or paste a batch
One material per line — name, unit, name, unit, category, or name, unit, category, type (type is "perishable" or "consumable"; defaults to perishable). A name matching an existing material updates it instead of adding a duplicate. If any line is unreadable, nothing in the batch gets added.
Material list
| Name | Material category | Unit | Type | |
|---|---|---|---|---|
| No materials added yet. | ||||
Material cost tracking
Ranked by weekly spend, independent of the sales Pareto in the Charts tab — materials above the 80% line are worth logging with quantity and date; the rest can stay a plain lump expense.
| Material | Week's spend | Cumulative | |
|---|---|---|---|
| Log some market expenses with a material link to see this. | |||
Market expense log
Click a date, week, or month to expand or collapse it. Chips: Expand all · Daily · Week · Month.
| Item | Material | Amount | |
|---|---|---|---|
| No market expenses logged yet. | |||
Monthly fixed expenses (rent, utilities, etc.)
Log a monthly expense
Or paste a batch
One item per line — category, amount (uses the month field) or category, amount, YYYY-MM. If any line is unreadable, nothing in the batch gets added.
Monthly expense log
| Month | Category | Amount | Daily rate | |
|---|---|---|---|---|
| No monthly expenses logged yet. | ||||
What the kitchen actually used each day — quantities only, never pesos, and never linked to market purchases. A line with no unit is in that ingredient's usual unit, set in section 26.
Log an ingredient used
Or paste a batch
One ingredient per line — qty [unit] ingredient: 3 bawang, 1/4 bihon, 1 tali sitaw, 1 pcs.patatas. The unit is optional (the usual unit is used). If any line is unreadable, nothing in the batch gets added.
Kitchen ingredient list / unit selection
Each ingredient's usual unit — what a plain number means in the log — grouped by category. Pick a unit from the menu or choose "Custom…" to type your own. This list is the kitchen's own, separate from the Materials catalog in Expenses.
Ingredients used log
Red box + not in list = the name isn't in section 26 yet — click it to fix the name or add it. unit differs = a different unit than usual — a typo, or a smaller unit.
| Ingredient | Qty used | Unit |
|---|
Weekly usage
How much of each ingredient the kitchen used, Mon–Sat. Darker cells = more used that day. Per day = week total ÷ 6 working days (÷ working days so far, for the current week). The last column compares with the week before — handy when planning the next weekly market buy. A line in a different unit gets its own row; nothing is ever converted.
Vital signs
vs the period before · hover a card for whyI2Menu matrix
popularity × marginI5Market price watch
price per unit · last 4 weeks vs 4 beforeI6Did the price change work?
4 weeks before vs after each changeI7Prep guide
typical sold (big) · usual prep (small) · last 6 of each weekdayI8How it judges
adjustable thresholdsI9Profit ladder
Gross profit = sales − food bought (weekly market share + daily store buys). Net profit = gross − bulk consumables share − monthly fixed share. Only Mon–Sat carry costs; a period still in progress counts up to today. Click ▸ show math on any line to see each purchase behind it.
By period
One row per week — click a row to open it in the ladder above.
| Period | Revenue | Weekly market | Daily store | Gross | Bulk cons. | Monthly fixed | Net |
|---|---|---|---|---|---|---|---|
| Log some sales and expenses to see net profit here. | |||||||
Material cost by dish (current week, perishable ingredients only)
Estimated from each dish's recipe times this week's weighted-average material cost. Consumables like LPG aren't attributed here — they're pooled into the market expense total above instead. Only dishes with a recipe defined in Menu & Prices appear.
| Dish | Sold | Material cost | Margin |
|---|---|---|---|
| Add a recipe to a dish in Menu & Prices to see this. | |||
Cumulative net profit
Running total across periods, oldest to newest — shows whether the business is net-positive overall, not just period to period.
| Period | Net profit | Cumulative |
|---|---|---|
| Log some sales and expenses to see this. | ||
Sales revenue
Daily totals
Unique dishes served
Daily count of distinct dishes with sales
Lost sales
Daily lost revenue from unsold servings
Sell-through
Daily sell-through — servings sold ÷ servings available
Revenue by top dishes category
Dish categories by revenue, most recent week
Expenses — monthly vs weekly allocation
Sales vs expenses by month, with each month's weekly average shown as a dashed marker
Top material costs
Material categories by weekly spend, independent of the revenue Pareto above — see the Expenses tab for the live, day-by-day version.
Dish price history
A step line — the price holds flat, then jumps on the day it changed; the last price runs on to today. Pick a dish category, then a dish, or just type in the search. Dishes with the most price changes come first.
Date range for sales & expense exports
Leave blank to export everything. Menu, backup, and restore aren't affected by this range.
CSV exports
Each opens directly in Excel, Google Sheets, or Numbers.
Load data from a file
Import a CSV previously exported from this app (Sales, Expenses, Menu, or Materials — auto-detected) to add those rows to what's already here. Restoring a JSON backup replaces everything instead.
Local file sync (PC, Chrome/Edge)
This browser doesn't support direct folder access — use the CSV/JSON export and import above instead (works everywhere, including phones). On a computer with Chrome or Edge, this section lets the app read and write straight to a synced folder, e.g. one watched by your pCloud desktop app.
Not connected to a folder.
Save writes two files: a fixed sarap-d2-current.json (always the latest) and a dated sarap-d2_YYYY-MM-DD.json — one per day, only rewritten if something actually changed that day.
Save tabs as PDF (screenshot)
Captures each selected tab exactly as it currently looks — full length, including anything scrolled off-screen — as a picture, not a data export. Collapsed sections stay collapsed; expanded sections capture in full. Pick one or more tabs below.