Bookstore Inventory Spreadsheet
For independent bookstores tracking new titles by ISBN alongside sidelines like bookmarks and journals. Logs section, quantity and distributor so you can see what to reorder and what to return.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| 9780000000017 | The Lighthouse Keeper's Daughter (pb) | Fiction | Fiction A-F | each | 3 | 1 | 10.2 | auto | auto | Riverside Book Distributors |
| 9780000000024 | Beginner's Guide to Sourdough (hc) | Cooking | Cookbooks Bay | each | 2 | 1 | 16.8 | auto | auto | Riverside Book Distributors |
| SL-BKM-0040 | Leather Bookmark, Assorted | Sidelines | Register Counter | each | 35 | 15 | 1.6 | auto | auto | Inkwell Gift Wholesale |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Use the ISBN-13 as the SKU; it is printed on every book and avoids duplicate entries for the same title.
- Flag returnable stock and note the return-by window so slow titles go back for credit instead of sitting on the shelf.
- Keep one copy as the reorder point for backlist staff picks, and two or three for anything on a current book-club list.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplatePet Store Inventory TemplateFlorist Inventory TemplateJewelry Store Inventory Spreadsheet