The template
Copy these columns into the first row of a new sheet, in this order. Every column is there because someone, at some point, will ask the question it answers. If a column never gets asked about in your warehouse, delete it: a shorter log that gets filled in beats a long one that doesn't.
| Column | What goes in it | Example |
|---|---|---|
| Date received | The day it came off the truck, not the day you entered it | 2026-11-12 |
| Time | Roughly when the truck was unloaded | 10:40 |
| Received by | The person who signed the delivery receipt | J. Ortiz |
| Carrier | Who delivered it | Regional LTL carrier |
| PRO / BOL number | The carrier's tracking number from the paperwork | PRO 0123456789 |
| Vendor | Who shipped it | Linden & Oak |
| PO number | The purchase order it belongs to | 4471 |
| Customer | Whose goods these are (the client, retailer or brand) | Studio Avery |
| Sidemark | The customer's own reference, often the end client's name | MORRIS / LIVING |
| Pieces expected | From the BOL or packing list | 3 |
| Pieces received | What actually came off the truck | 3 |
| Carton | Which carton of which piece | Sofa, carton 2 of 3 |
| Condition | Pick from a fixed list (see below) | Damaged: corner crushed |
| Noted on delivery receipt? | Was the damage written on the carrier's paperwork before signing | Yes |
| Photos | Taken? Where are they stored? | Yes, shared drive / 4471 |
| Location | Where it went in the warehouse | Rack B-12 |
| Notes | Anything that will matter later | Packaging kept for inspection |
| Customer told | Date the customer was told it arrived | 2026-11-12 |
| Out | Date delivered or picked up, and by whom | 2026-11-20, delivery |
Setting it up in Excel or Google Sheets
- Freeze the header row so the column names stay visible as the list grows (View > Freeze in both programs).
- Use a dropdown for Condition. Data validation with a short fixed list, for example: Good, Damaged, Needs minor repair, Refused. Free text turns into twenty spellings of "damaged" within a month.
- Use a dropdown for Customer too, from a second sheet with your customer list, so one customer doesn't appear under three names.
- Format the date column as a date, not text, so you can sort and filter by it.
- One row per carton, not one row per delivery. A three-box sofa is three rows with "carton 1 of 3", "2 of 3" and "3 of 3". That's the only way to say which box was damaged.
- Never delete rows. When something leaves, fill in the Out column. The history is the point.
Rules that keep it honest
A template is easy. Keeping it filled in at four o'clock on a Friday is the hard part. These rules help:
- Fill it in at the dock, from the paperwork in your hand, not from memory at the end of the day.
- Count pieces before you sign the delivery receipt, and write any shortage or damage on the receipt itself.
- Photograph before anything goes on the rack. A photo taken after it's been moved proves less.
- Record the photo location in the log the same day, or the photos become a camera roll nobody can search.
- One person checks yesterday's rows each morning for blanks: missing condition, missing photos, missing location.
Photos are the weak spot
The log says a carton arrived damaged. The proof is the photo, and in a spreadsheet the photo lives somewhere else: on a phone, in a text thread, in a shared folder with a name like IMG_4471. When a customer asks three weeks later, someone has to find it, and the person who took it may be off that day.
If you stay on a spreadsheet, make a folder per PO or per customer, name the photos with the PO and carton number, and put the folder path in the Photos column. It's slower, but it means the answer exists. Our photo checklist covers which shots to take.
When to outgrow it
A spreadsheet is fine for a handful of deliveries a week, when the person receiving is the person answering the phone. These are the signs it's starting to cost you:
- Customers ask for photos, and finding them takes longer than taking them did.
- More than one person receives, and rows are missing or filled in differently.
- You can't tell who changed a row, or when.
- Customers call to ask whether something arrived, several times a day.
- A carrier wants concealed damage reported within days, and the evidence is scattered. See our concealed damage guide.
When you see those signs, the next step is a receiving log built for the dock: photos stored on the carton they belong to, a fixed condition list, a record of who did what, and a login for each customer so they can check for themselves. That's what CartonLedger is. There's a free plan, no card is needed, and you can keep the spreadsheet running alongside until you're sure. See spreadsheets compared with a receiving log.