A receiving log is the record of what came off the truck: what you ordered, what arrived, what it cost, and what was wrong with it. It takes a few minutes per delivery, and it is your proof when a case is missing or a price went up without a word. Below is a free receiving log for a café, with eight example lines and two formulas. No signup.

Download the receiving log

Download the free café receiving log (CSV) →

It opens in Google Sheets, Excel or Numbers. The eight lines in it are examples that show a short delivery, a price rise and a damaged case. Delete them and start your own.

ColumnWhat goes in it
Date, Supplier, Invoice NoWhich delivery this line belongs to
Item, Order UnitWhat it is, in the unit on the invoice
Ordered, ReceivedWhat you asked for and what you counted off the truck
Short or OverReceived minus ordered
Invoice Price, Last PriceThe price on this invoice and the price on the one before
Price ChangeHow far the price moved
TempThe reading for chilled and frozen items
Condition OKY or N: sealed, in date, not crushed or leaking
Received ByWho checked it in
Follow UpCredit asked for, item re-ordered, rep called

A CSV file cannot carry formulas, so add two and copy them down:

  • Short or Over (H2): =G2-F2
  • Price Change (K2): =IF(J2>0,(I2-J2)/J2,"") then format the column as a percentage

How to check in a delivery

  1. Have the order next to you. You cannot spot a missing case if you do not know what was ordered. Print the order or open your supplier order guide.
  2. Count before you sign. Count each line off the truck and write the number in Received. If the driver cannot wait, write "not counted" on the delivery note before you sign it.
  3. Check cold items first. Take the temperature of chilled and frozen items and write it down. Your local food safety rules set the limit; write that limit at the top of the sheet so nobody has to remember it.
  4. Look at condition and dates. Torn bags, crushed cases, leaking cartons, short dates. Mark N and say why in Follow Up.
  5. Compare the price. Put the invoice price next to the last price. Small rises on every delivery are easy to miss and add up over a year.
  6. Deal with problems the same day. A short or damaged line is easiest to settle while the driver is there or the rep still remembers the order. Write what you did in Follow Up.
  7. Put it away, oldest in front. New stock goes behind what is already on the shelf.

What the log tells you after a month

  • Which supplier shorts you. Filter by supplier and look at the Short or Over column.
  • Which prices moved. Sort by Price Change. Anything that rose is a question for your rep, or a reason to look at your menu price.
  • What you never got credit for. Any line with a shortage and nothing in Follow Up.

If you want to see what a price rise does to one drink, the free menu pricing and food cost calculator shows the cost and margin before and after.

Where a receiving log stops

The sheet only knows what somebody types into it. On a busy morning the delivery gets put away, the invoice goes in a drawer, and the log has a gap.

QuickStok shortens the typing. Photograph the supplier receipt and the items, pack sizes and prices are read from it; you check them and save. Each line shows whether the price is the same as last time or how far it moved, and every price change is kept in one list. You can also mark each line of a delivery as received, partial or missing, and short or missing lines are flagged for reorder.

It does not ask your supplier for a credit and it does not keep photo proof. You still make that call.

It is free for one café, and it does not expire. No credit card.

If the sheet is doing the job, keep it. Use it with the café par sheet and the count sheet template.

Frequently asked questions

What is a receiving log?

A receiving log is the record of each delivery: what was ordered, what arrived, the price on the invoice, the temperature of cold items, the condition, and what was done about any problem.

What should I check when a delivery arrives?

Count each line against the order before you sign, take the temperature of chilled and frozen items, look for damage and short dates, and compare the invoice price with the last price you paid.

What temperature should chilled deliveries be?

Your local food safety rules set the limit for chilled and frozen deliveries. Write that limit at the top of the log so whoever checks the delivery in does not have to remember it.

What do I do when a delivery is short?

Write the shortage on the delivery note before you sign, record it in the log, and ask the supplier for a credit or a re-delivery the same day. Note what was agreed in the Follow Up column.