Recipe matrix and the Actual-vs-Expected (DRS & Zoho) usage report.

Map cake items to Zoho composite/component items (for Assemble in Zoho), and choose the vendor that cake purchase Bills are created against.

Reads each mapped production cake's current stock-on-hand in the branch's Zoho warehouse — confirm your opening position before a supply run. Read-only, no Zoho changes.

The cake manager's report: production by cake, ingredient / decoration / packaging variances, purchases, supply to stores (Cake + OCAKE), invoiced value, Zoho push status and an auto-written discussion. Weekly = the Monday–Sunday week containing your date, vs the previous week. Daily = the single date you pick, vs the day before.

Recipe engine coefficients, product yields, the selling price list, and the weekly sauce constants.

The (PIE EXPRESS) composite recipes fetched from Zoho — what the Bundles step consumes per unit. Re-fetch after any recipe change in Zoho.

The manager's Monday–Sunday report: production, raw-material variances, sauce kitchen, supply value, consumables, Zoho push status and an auto-written discussion — compared with the previous week. Both weeks' submissions are loaded and hydrated before anything renders.

DRS pie item → Zoho item. Items without a mapping are skipped and reported on every Bills/Close run, so nothing posts wrong — but map them here so they post at all. Editing is admin/audit only.

Recipe-engine coefficients, the two product yields, pack size, ingredient unit costs and the selling price list. The form runs on the built-in workbook defaults until you override them here.

The manager's Monday–Sunday report: average analysis per item with week-over-week movement, production against expected yield, ingredient usage against the recipe, submission coverage, waste and an auto-written discussion. Both weeks are loaded and hydrated before anything renders. Opens print-ready in a new tab.

Compares total Actual Yield from SICS Cooks (all batches + shifts) against Zoho Quantity In for each recipe.

Items in these lists are skipped from accountant picking variance calculations. Use the Global list for items you never want counted (e.g. spoilage promos). Use Per-Branch overrides to deviate from the global policy at a specific branch (either add an extra exclusion or re-include something that's globally excluded).

Audit's weekly cake report, built from the Daily Record, Decoration and Packaging Analysis submissions and costed at the Zoho purchase price. Pick the days and generate — it opens on last week.

Audit's weekly Pie Express sheet, built from the pie dailies and costed at the Zoho purchase price: production against expected yield, egg wash and sample sauce, ingredients used on excess pastries, finished stock movement and the week's purchases. Pick the days and generate — it opens on last week.