Free · CSV & Google Sheets

The costing templates we use inside COG.

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.

Specialty café

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.

Google Sheets · CSV · en-AU Copy to Sheets
Ceramics & small-batch

Kiln-share batch costing

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.

Google Sheets · CSV · en-AU Copy to Sheets
Shopify & marketplace

Landed cost + contribution margin

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.

Google Sheets · CSV · en-AU Copy to Sheets
BAS & bookkeeping

Supplier price watch · BAS-ready log

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.

Google Sheets · CSV · en-AU Copy to Sheets
Prefer to skip the sheet? The calculator does most of what these templates do, one SKU at a time. The templates earn their keep when you're pricing a whole menu or a whole shop.