# Equipment checkout with no record: how to track who has what

> For the full documentation index, see https://250highstreet.com/llms.txt

> Shared laptops, tools and vehicles go missing when nobody writes down who took them. Build an asset list and a checkout log with due dates and overdue flags.

Short answer: equipment goes missing because taking it takes ten seconds and writing it down takes a minute. Keep two lists. One lists every item you own. The other logs every checkout: who, when, due back and condition. Then flag anything past its due date so someone asks about it that day, not next quarter.

## At a glance

| Item | Number | What it means for you |
|----|----|----|
| Items in one list | 30 million | Your asset list and checkout log will not hit this limit. A checkout log grows by one row each time. |
| List view threshold | 5,000 items | A view that shows more than 5,000 items can fail. Filter the Overdue view to keep it small. |
| File attached to a list item | 250 MB | A photo of damage when an item comes back fits easily. |
| Idle flow shut off | 90 days | A flow nobody triggers for 90 days might be turned off. Check your overdue reminder flow. |

## Why shared equipment disappears

Shared equipment looks free to use. A laptop sits in a cabinet. A scanner lives on a shelf. A van key hangs on a hook. Someone needs it, takes it and plans to bring it back. Then a project ends, a person goes on leave, or the item moves to a second team. Nobody wrote anything down, so nobody can say where it is.

There are four common causes:

- No one owns the list. If everyone can take things, no one is asked about them.
- No due date. An item with no return date is never late.
- The record is a paper sign-out sheet or a message in a chat. Both are hard to search and easy to lose.
- No one checks. A count that happens once a year finds the problem far too late.

## Signs this is happening in your team

- You buy a second scanner because you cannot find the first.
- People ask in a group chat, "Does anyone have the blue laptop?"
- A damaged tool goes back on the shelf and the next person finds it broken.
- You cannot say who had a vehicle when something went wrong with it.
- Your count of items does not match what you pay for or insure.

## Step 1. Build the asset list

Start with one list of everything that can be borrowed. One row per item. Keep the columns few:

- Asset name (for example, "Laptop 07"). Use the Title column for this. Every list has a Title column and it is required by default. Rename it to Asset name, or turn Require off, so it holds the main label.
- Type (laptop, tool, vehicle, scanner, other)
- Tag or serial number
- Location when it is home
- Status (Available, Checked out, In repair, Retired). Choice columns sort in list order or alphabetically, so add number prefixes if order matters, such as 1 Available, 2 Checked out, 3 In repair, 4 Retired.

Give each item a short tag number and put a label on the item itself. A tag is the key that ties the item to its record. Without a tag, two similar laptops look the same and the record is useless.

## Step 2. Build the checkout log

Make a second list. Each row is one checkout, not one item. That way the history stays and you can see who had an item last month. One way to start with these columns:

- Title (required by default; rename it to "Checkout" or turn Require off, so it holds the main label)
- Asset (a lookup to the asset list)
- Borrowed by
- Date out
- Due back
- Date returned (blank until it comes back)
- Condition out (Good, Worn, Damaged)
- Condition back (Good, Worn, Damaged)
- Notes

Microsoft documents the column types you need. Its page on lists names Choice, Date and Time, Lookup and Yes/No among the types you can use, and says a lookup column "retrieves (or 'looks up') one or more values from a target list." A lookup is how the log points back to the asset list, so you type the asset once and pick it later.

## Step 3. Make checkout the easy path

A record only works if people use it. One way to start: make the form short enough to finish in under a minute. Pick the asset, pick a due date, press save. Put a link to the form on the shelf, on a printed sign or a QR code, and pin it in your team chat. Do not ask for anything you will not use later.

Set a rule that is easy to remember: if it leaves the room, it gets logged. Say it out loud on day one for each new hire.

## Step 4. Set a due date on every checkout

Pick a default. For example, laptops come back in a week, tools in a day, vehicles the same day. Let people choose a later date when they have a reason. The due date is what makes an overdue return visible. It also gives the borrower a fair reminder of when the item is expected.

## Step 5. Use a view to show what is overdue

Make a view called "Overdue". It shows checkouts where Date returned is blank and Due back is before today. Microsoft says \[Today\] filters cannot be set from a column header, so choose Edit current view, then Filters. For blank filters, we also use the classic view editor. That part is our advice, not a Microsoft rule. Microsoft says list views let you "organize, sort, and filter data in different and specific ways," and that "the contents of the actual list don't change." So an Overdue view is only a saved filter. It does not alter your data.

Make two more views:

1.  Out now: everything currently checked out, grouped by person.
2.  By item: the full history for one asset.

## Step 6. Add a daily reminder

You can have a flow check the log and message each borrower with an overdue item. A scheduled cloud flow runs on a schedule you set. Microsoft says it can run once a day, an hour or a minute, and you set the Interval and Frequency in the Recurrence trigger. For example, Interval = 1 and Frequency = Week runs it once a week. There is also a Time zone field, so you can say whether the start time is local or UTC.

One way to start: run it once each weekday morning. Send one message per person with a list of what they still hold. Many messages get ignored. If an item is a week late, copy the team lead.

## Step 7. Check condition on return

When an item comes back, the person returning it picks the condition. If it says Damaged, set the asset status to In repair so the next person cannot borrow it. This takes one extra field and saves you from handing out broken gear.

## Step 8. Count once in a while

A list can drift from the shelf. One way to start: once a quarter, walk the shelf and compare it to the Available items. Fix any gap that day. If you find an item that is not on the list, add it. If an item is gone for good, mark it Retired and add a note. The goal is a list you trust, not a perfect one.

## Honest limits

A list does not stop someone from walking out with a laptop. It makes the walk visible and gives you a name to ask. If your team has high-value items, or you need a gate, a check-in desk or a scanner at the door, a list is only part of the answer. It is also only as good as the habit of using it. Start with one category, such as laptops, and get that working before you add vehicles and tools.

If you already track assets in a purchasing or finance system, keep that as the book of record for cost and depreciation. This guide is about who holds an item today. For related guides, see "[Who owns this shipment](/guides/who-owns-this-shipment/)" for tracking items in motion and "[Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)" if your sign-out sheet lives in a file today. If your sign-out sheet exists in several copies, see "[Spreadsheet versions out of sync](/guides/spreadsheet-versions-out-of-sync/)".

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

Updated 2026-10-27.

### Do I need one list or two?

Two. One list holds the items you own. The other holds each checkout. If you put both in one list, you lose the history every time you update a row.

### What if people forget to log a checkout?

Make the form very short, put the link where the gear is kept, and ask about unlogged items when you find them. Do not punish the first miss. Fix the path so it is easier next time.

### How long should the default loan be?

It depends on the item. One way to start is a day for tools, a week for laptops, and the same day for vehicles. Adjust after a month of real use.

### Can I do this in Excel instead?

You can, but a shared spreadsheet is easy to overwrite and hard to filter for overdue items. A list gives you views and reminders without extra files.

### Who should own the asset list?

Name one person, and one backup. That person adds new items, retires old ones and runs the quarterly count.

## Sources

- [Microsoft Support, Introduction to lists](https://support.microsoft.com/en-us/sharepoint/lists/get-started-with-sharepoint/introduction-to-lists)
- [Microsoft Learn, Run a cloud flow on a schedule in Power Automate](https://learn.microsoft.com/en-us/power-automate/run-scheduled-tasks)
- [Microsoft Learn, SharePoint limits - Service Descriptions](https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits)
- [Microsoft Learn, The number of items in this list exceeds the list view threshold](https://learn.microsoft.com/en-us/troubleshoot/sharepoint/lists-and-libraries/items-exceeds-list-view-threshold)
- [Microsoft Learn, Limits of automated, scheduled, and instant flows](https://learn.microsoft.com/en-us/power-automate/limits-and-config)

## Related guides

- [A key checkout log in SharePoint](/guides/key-checkout-log-sharepoint/)
- [An equipment maintenance log in SharePoint for a clinic or lab](/guides/equipment-maintenance-log-clinic-lab/)
- [How to set up a training record in SharePoint](/guides/setup-training-record-sharepoint/)

Source: https://250highstreet.com/guides/equipment-checkout-no-record/