Key takeaways
- Give every product a unit cost and a selling price.
- Record pieces baked per batch, per shift.
- Enter stale returns on the delivery row.
- Settle outlets from OUTLET STATEMENT, not from memory.
A panaderya bakes in the dark and settles accounts in a hurry. Trays leave on two routes, stores pay in loose cash, and stale bread comes back the next morning with nobody sure whose account it belongs to. Panaderya PH puts the batch and the delivery row at the center: pieces baked, pieces delivered, pieces returned, and the amount actually due after stale bread is deducted. By the end of the week the owner can say which product paid for itself and which outlet is behind.
Cost every product once
Each bread, pastry, or loaf is listed once with a unit cost and a selling price, and margin per piece is computed. The owner sees which product carries the counter before a single tray is baked.
Changing the unit cost after a flour price increase updates batch costs and product profit from one place.
Bake by batch, not by guess
A production row records the shift, the product, and the pieces baked. Batch cost comes from the product's unit cost, so the sheet knows what the morning's trays cost to produce.
Pieces sold and pieces returned are pulled back from the delivery rows, and pieces unsold is what is left: baked minus sold minus returned.
Deliver by route and settle the stale bread
A delivery row carries the route, the outlet, the batch, the pieces delivered, and the stale pieces returned. Pieces sold, the stale deduction, and the amount due are computed on the row.
Because the deduction sits on the same row as the delivery, the rider and the store owner are looking at one number when they settle.
Read the statement before you settle
OUTLET STATEMENT totals deliveries, pieces delivered, pieces returned, amount due, payments received, and the balance for each sari-sari store or canteen.
The dashboard shows pieces baked, pieces sold, stale returns, sales after returns, production cost, and outlet balances, which is the whole week in six numbers.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
Panaderya PH Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.
No recipe costing from raw ingredients, expiry or nutrition labelling, sanitary-permit or licence tracking, supplier API links, payroll or tax computation, and no official receipts.
Frequently asked questions
Do returns reduce what the store owes?
Yes. The stale deduction is subtracted on the delivery row, so the amount due is the value of what was actually sold.
Can one batch go to several outlets?
Yes. Delivery rows point back to the batch, and pieces unsold is what that batch never sold and never had returned.
Does it cost the recipe from raw ingredients?
No. You enter a unit cost per product and log ingredient purchases separately; recipe costing is outside its scope.
Does this replace official records?
No. No recipe costing from raw ingredients, expiry or nutrition labelling, sanitary-permit or licence tracking, supplier API links, payroll or tax computation, and no official receipts.
