Template
Ingredient purchase and cost log
Track invoice dates, supplier item codes, pack contents, and purchase prices behind recipe costs in a blank printable or downloadable log.
A purchase-cost log preserves the invoice facts behind a recipe calculation. It records supplier identity, date, pack structure, inner quantity, unit/state, price, credits, and conversion notes. The blank worksheet does not calculate unit costs, update recipes, compare suppliers, or retrieve live prices. Keep each dated purchase specification so a later result can be reconstructed without overwriting the basis used earlier.
How to record an ingredient purchase
- Start a dated record. Identify the kitchen or location, review period, recorder, and currency or price-basis notes.
- Copy the supplier specification. Record the ingredient name, supplier or product code, invoice date/reference, and pack exactly as invoiced.
- Expand the pack structure. Enter inner units per pack and quantity per inner unit separately. State the unit and food form, including net or drained basis when relevant.
- Preserve price adjustments. Record pack price and any credit, exception, or conversion basis. Keep prior dates instead of silently replacing an old price.
- Calculate in a matching unit. Use the purchase-unit or ingredient-line calculator with compatible quantities. The log retains the facts but does not create a calculated total.
Your worksheet
Fill in your own records, then print or download them. Fields are optional. No costs, quantities, percentages, or totals are calculated. Entries stay in this page and are not saved by this site. Keep a downloaded or printed copy if you need the record later.
Ingredient purchase and cost log
- Kitchen / location
- ________________
- Review period
- ________________
- Recorded by
- ________________
- Currency / price-basis notes
- ________________
Entry 1
- Internal ingredient name
- ________________
- Supplier / product code
- ________________
- Invoice date / reference
- ________________
- Pack as invoiced
- ________________
- Inner units per pack
- ________________
- Quantity per inner unit
- ________________
- Quantity unit and state
- ________________
- Pack purchase price (USD)
- ________________
- Credits / exceptions / conversion basis
- ________________
From invoice to a reusable unit-cost basis
- Capture Invoice
Supplier, item code, date, pack price.
- Normalize Comparable unit
Use the verified quantity and any documented credit.
- Apply Recipe calculation
Calculate unit cost or the amount used in a recipe.
Separate purchase facts from calculated values
The worksheet preserves source records. Use a separate calculation for derived prices so invoice facts remain visible.
| Record field group | What it preserves | Related calculation |
|---|---|---|
| Product and supplier | Internal name, supplier code, invoice reference | Identifies the item; it does not calculate a price. |
| Pack structure | Inner count, quantity per inner, unit, and food state | Can establish a comparable total quantity when the pack definition is verified. |
| Price history | Pack price, date, currency, credit, and exception notes | Supports a dated unit-cost calculation. |
| Recipe link | Cost basis and conversion notes | Connects the purchase record to an ingredient-line calculation. |
Record the purchase as invoiced
Create a new dated entry when the price, pack, supplier item, or product form changes. Keep earlier entries so previous recipe costs can be reconstructed.
- Match the invoice item to a specific internal ingredient and usable state.
- Distinguish a case price from an inner-pack price. Record which one the price represents.
- Record stated quantities from the invoice and label. Do not guess missing pack counts or treat a trade can size as a fixed net weight.
Keep the price basis consistent
Record the food purchase price and any credits or exceptions used in the calculation. This log does not select an accounting policy or allocate overhead.
Map an invoice to the worksheet fields
An invoice lists two 5 lb bags in a $40 case. A recipe uses 1.5 lb from that purchase basis.
Inputs
- Inner bags per case
- 2
- Quantity per bag
- 5 lb
- Case price
- $40.00
- Recipe amount used
- 1.5 lb
- Total case quantity = 2 × 5 lb = 10 lb.
- Purchase-unit cost = $40.00 ÷ 10 lb = $4.00 per lb.
- Recipe line cost = $4.00 per lb × 1.5 lb = $6.00.
- Pack expansion: 2 bags × 5 lb/bag = 10 lb
Result: $6.00 for 1.5 lb used
Keep full precision through the unit-cost multiplication; display the final dollar amount to cents. All quantities use the same weight basis.
Preserve the invoice basis
A dated log makes the purchase price and pack quantity traceable. Keep the supplier specification, unit, state, and adjustments together, then use a separate calculator to derive unit and recipe costs. If the pack or price changes, create a new dated record and recost the affected recipes.