Menu pour-cost workbook (60 PLUs)
Dose in grams, milk in millilitres, cup & lid, oat/almond surcharge, card fee. Gives you pour cost, gross profit % and $ per drink, and a daypart summary from a Square or Lightspeed CSV.
These are the same ledger sheets we build on top of — pour-cost menus, kiln-share batch costing, landed-cost per SKU, and a BAS-ready cost of sales workbook. Copy any of them to your Drive, or export a CSV to bring straight into Xero or MYOB.
Dose in grams, milk in millilitres, cup & lid, oat/almond surcharge, card fee. Gives you pour cost, gross profit % and $ per drink, and a daypart summary from a Square or Lightspeed CSV.
Roll clay body, glaze batch, kiln kWh at your NSW retail electricity rate, element wear and wheel/trim/glaze minutes across the pieces a bisque or cone 6 firing produced. Seconds column feeds a separate seconds SKU.
For Shopify, Etsy and TikTok Shop sellers. FOB goods, inbound freight, duty by HS code, 10% GST at the border (low-value imported goods scheme handles anything under AUD $1,000), AusPost satchel size by cubic weight, 3PL pick-and-pack, Shopify Payments and Afterpay fees. Outputs contribution margin % per SKU.
A simple change-log for supplier prices in ex-GST terms, with % delta and a flag for anything above 5%. Feeds directly into a margin re-cost, and matches the tax invoice figures your bookkeeper is reconciling in Xero or MYOB for the quarterly BAS.