Free Yard Check Sheet Template (Printable + Spreadsheet)
A yard check is a walk of every trailer spot, writing down what is actually parked there and comparing it with the yard log. Below: a free sheet to run one (print it, open it in Excel, or import the CSV into Google Sheets, no email), the 8 columns, how often to walk, and the step most yards skip.
If you park trailers in a yard, at some point someone has asked "is trailer 4471 still here?" and nobody could answer without walking outside. A yard check is how you make that question answerable from a desk. Each difference the walk finds falls into one of four kinds: wrong spot, in the yard but not in the log, in the log but not found, or a seal that does not match. The check is done when the log is fixed, not when the walk is.
Download
No email required. The workbook has a Yard Check tab (60 spots, prints on one landscape page), an Exceptions tab, and a How-to tab.01What a yard check is
A yard check is a physical count of the trailers in your yard. Someone walks every spot, writes down what is actually sitting there, and compares the result with what the yard log says should be there. It is the same idea as a cycle count in the warehouse, applied to the parking lot.
The point is not the sheet. The point is the difference between the sheet and the log. Every difference is a trailer that is about to be "lost": it is in the yard, but the office cannot find it because the information about where it is has drifted. A yard check catches that drift before a carrier calls about it.
02How often to run one
- Once per shift if you have more than about 40 spots, run more than one shift, or turn trailers over quickly. Drift compounds every time a trailer is moved and the move is not written down.
- Once a day for smaller yards with steady traffic. First thing in the morning works well, because the night shift is when moves go unrecorded.
- Always before an audit — customs, insurance, a customer's security review — and after any incident such as a broken seal or a trailer that was found in the wrong spot.
The right cadence is the one where the sheet rarely finds a surprise. If every check turns up three or four exceptions, check more often, and look at how moves are being recorded.
03The columns, and why each one is there
| Column | Why it is on the sheet |
|---|---|
| Spot / Location | Pre-printed in walking order. The walker fills in the row for the spot they are standing at, so nothing is skipped. |
| Trailer # | Read off the trailer door, not the log. If the number is unreadable, write what you can and flag it in notes. |
| Carrier / SCAC | Distinguishes two trailers with similar numbers from different fleets, and tells the office who to call. |
| Loaded / Empty | Decides what the trailer is worth and whether it should be sealed. Empties sitting for days are the usual detention surprise. |
| Seal # | For every loaded trailer. A loaded trailer with no seal number is the row you look at first. |
| Time In | From the log, if you have it. It is how the dwell column on the tracking sheet gets its start date. |
| Checked By | Accountability, and the person to ask when a row does not make sense later. |
| Notes | Reefer running, flat tire, door damage, "number partly painted over". Short. |
04The routine, step by step
- Print or open the sheet. Fill in site, date, shift, and who is walking. Rename the spot column to match your yard once; keep the walking order fixed after that.
- Walk every spot in the same order. Do not go to the trailers you expect to find; go to the spots. An empty spot gets the word EMPTY, not a blank row. A blank row is indistinguishable from a skipped one.
- Write what is physically there. Number from the door, carrier from the placard, loaded or empty from the seal and the doors, seal number as written on the seal. Never copy from the log — that is the thing you are checking.
- Compare against the log. Four kinds of difference: trailer in the wrong spot, trailer in the yard but not in the log, trailer in the log but not found, and seal does not match. Each goes on the exceptions list with what you think happened.
- Fix the system the same hour. Correct the log, then fill in "keyed into the system" and the time on the sheet. The check is not finished until the log matches the yard.
Keep the walking order fixed, so the walk gets faster each time. Two people walking from opposite ends and meeting in the middle split the work.
05The failure that makes the sheet useless
The most common failure is not a bad walk. It is a good walk that never makes it back into the log. The sheet is completed, clipped to the board, and the log is left exactly as wrong as it was. Two days later the same trailer is "lost" again and someone asks why the yard check did not catch it. It did. Nobody keyed it in.
That is why the template has a "keyed into the system" line and a time next to it, and why the exceptions tab has a "fixed in system?" column. Treat those two cells as the finish line. If the person walking is not the person who updates the log, the sheet has to change hands before the shift ends, every time. The second most common failure is skipping spots that "are always empty"; the day one is not, that is where the lost trailer is.
06Printable sheet
This is what prints when you press the button above (one landscape page, 24 rows; the Excel version carries 60). Your browser's print dialog can save it as a PDF.
| Spot | Trailer # | Carrier / SCAC | Loaded / Empty | Seal # | Time in | Checked by | Notes |
|---|---|---|---|---|---|---|---|
| A-01 | |||||||
| A-02 | |||||||
| A-03 | |||||||
| A-04 | |||||||
| A-05 | |||||||
| A-06 | |||||||
| A-07 | |||||||
| A-08 | |||||||
| A-09 | |||||||
| A-10 | |||||||
| A-11 | |||||||
| A-12 | |||||||
| B-01 | |||||||
| B-02 | |||||||
| B-03 | |||||||
| B-04 | |||||||
| B-05 | |||||||
| B-06 | |||||||
| B-07 | |||||||
| B-08 | |||||||
| B-09 | |||||||
| B-10 | |||||||
| B-11 | |||||||
| B-12 |
When you outgrow the sheet
A paper yard check works until the yard is busy enough that the walk and the keying-in are two different jobs done by two different people, and one of them gets skipped. In Vantage the walk is the keying-in: at each spot, scan the number with the camera in the iPhone app or type it in, and the app marks it Verified, Wrong location, Missing or Unexpected against the yard list. A wrong spot or an unexpected unit is fixed in the yard list right away, with an undo. If the sheet is working for you, keep using it. If you find yourself doing the same walk twice, that is the signal. (How the app version works, step by step: yard check app for iPhone.)
Yard check without the clipboard.
Vantage is a yard management app that runs on a phone. The guard logs each trailer in and out at the gate, the trailer number is read on the device in the iPhone app (typed in a browser), and every record gets a timestamp, plus a photo whenever the camera is used. The live yard map and door board show which trailer is at which door. No hardware, no installer.
Start on the Free plan: $0 for up to 3 users, 1 yard and 100 gate transactions a month, with 30 days of history. No card, and it never expires. Upgrade only if your yard needs more.
Start free in your browser → Get Vantage on the App Store → Free plan: up to 3 users, 1 yard, 100 gate transactions a month. Keep the sheet as your backup.FAQ
What is a yard check?
A yard check is a physical walk of every trailer spot in the yard, writing down what is actually parked there (trailer number, carrier, loaded or empty, seal) and comparing it against the yard log. It is the inventory count for your trailers.
How often should you do a yard check?
Once per shift for yards with more than about 40 spots or heavy turnover, once a day for smaller yards, and always before a customs, insurance, or customer audit. The right cadence is the one where the sheet rarely finds a surprise. If you are a CTPAT highway carrier, CBP's criteria also ask dock supervisors or warehouse managers to periodically verify the seal numbers on trailers and containers, so a yard check that records seals helps with that.
What columns does a yard check sheet need?
Spot or location, trailer number, carrier or SCAC, loaded/empty, seal number, time in, checked by, and notes. Anything more slows the walk down; anything less leaves a gap you will need later.
Is the template free, and can I edit it?
Yes. The printable sheet, the Excel workbook, and the CSV are free, no email required. Rename the spots to match your yard and add or remove columns as you like.
Does the spreadsheet work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Sheets, or import the CSV. The counts and highlighting use plain formulas that work in both Excel and Sheets.
Should a yard check record seal numbers?
Yes, for every loaded trailer. A loaded trailer with no seal number, or a seal that does not match the paperwork, is the first row to look at. CTPAT's seal check is called VVTT: View the seal and locking parts, Verify the number against the shipping documents, Tug the seal, Twist and turn the bolt seal.
What is the difference between a yard check and a gate log?
A gate log records each trailer as it comes in and goes out. A yard check walks the yard and compares what is parked with that log. The gate log tells you what should be there; the yard check tells you what is. Our gate log template and how to fill it in: trailer check-in log at the gate.