This template keeps track of shared equipment such as laptops, cameras and projectors. The Equipment tab lists each item with its condition and usual location. The Checkouts tab is the loan log, with the borrower, team, out date, due date and a tick box for when the item comes back.

Each loan shows as Out, Overdue or Returned, and overdue rows turn red. The Dashboard shows how many items are out now, how many are overdue and how often each item and team borrows.

It comes with sample data. Make a copy, then replace the sample rows with your own equipment and loans. Formulas, dropdowns and highlights update on their own.