Inventory Sign In and Out Sheet Template
Track borrowed and returned inventory items with borrower information, item details, and location logging.
This template enables organizations to systematically record inventory movements, specifically tracking items that are signed out and returned. It includes a main sign-in/sign-out sheet for logging borrower details (name, contact information), item information (name, ID number), and transaction dates, paired with a separate item list that maintains a master catalog of all available inventory items with descriptions. The template uses formulas to validate and cross-reference item data, making it ideal for managing equipment, tools, or supplies in warehouses, offices, or rental facilities.
What's inside
- Borrower information capture (name, contact)
- Item identification (name, ID number)
- Location tracking (warehouse/branch logging)
- Transaction date recording
- Master item list with descriptions
- VLOOKUP for item validation
- Item count calculations with COUNTA
- Conditional logic for tracking status
Download this template
.xlsx · 2 sheets · included with lifetime access
More in Inventory & Operations
Inventory & OperationsAdministration Fixed Asset Register Template
Track and manage company fixed assets with depreciation calculations and current valuations.
- Depreciation calculation (Straight-Line and Declining Balance methods)
- Asset status tracking (In Use, Under Maintenance, Disposed)
- Multiple asset type categories
Inventory & OperationsAdministration IT Equipment Tracking Template
Comprehensive IT equipment inventory management system with tracking of assets, warranty dates, assignment details, and equipment status.
- Overview dashboard with equipment count summary
- Automated equipment numbering with formula-based IDs
- Warranty expiry date tracking
Inventory & OperationsAdministration Procurement Project Tracking Template
A comprehensive procurement management system that tracks vendors, projects, and company information for streamlined administration and procurement oversight.
- Vendor database with contact information
- Project status tracking (Completed, In Progress)
- Company information management
Inventory & OperationsAdministration Supplier Audit Schedule Template
A comprehensive supplier audit scheduling template to manage supplier evaluations, track audit types, and maintain supplier contact information.
- Multi-sheet organization for schedules, supplier lists, and audit definitions
- Supplier contact database with responsible person tracking
- Audit frequency and type tracking