{"id":4900,"date":"2026-07-13T09:00:00","date_gmt":"2026-07-13T07:00:00","guid":{"rendered":"https:\/\/inventory-one.com\/?p=4900"},"modified":"2026-07-17T08:58:33","modified_gmt":"2026-07-17T06:58:33","slug":"inventory-list-template","status":"publish","type":"post","link":"https:\/\/inventory-one.com\/en\/2026\/07\/13\/inventurliste-vorlage\/","title":{"rendered":"Inventory List: Free Template for Taking Inventory (Excel &amp; PDF)"},"content":{"rendered":"<p>The <strong>Inventory list<\/strong> This is the main worksheet for the physical inventory: It is used to record and compare target and actual inventory levels. Here is a <strong>Free template in Excel and PDF formats<\/strong> \u2013 with predefined columns and automatic calculation of differences.<\/p>\n<div style=\"display:flex;flex-wrap:wrap;gap:12px;margin:24px 0\"><a href=\"https:\/\/inventory-one.com\/wp-content\/uploads\/2026\/07\/Inventurliste-Vorlage.xlsx\" download style=\"display:inline-block;background:#19BEA0;color:#ffffff;font-weight:700;text-decoration:none;padding:14px 24px;border-radius:8px\">\u2b07\ufe0f Inventory List Template (Excel)<\/a><a href=\"https:\/\/inventory-one.com\/wp-content\/uploads\/2026\/07\/Inventurliste-Vorlage.pdf\" download style=\"display:inline-block;background:#ffffff;color:#1C1C42;font-weight:700;text-decoration:none;padding:12px 22px;border:2px solid #1C1C42;border-radius:8px\">\u2b07\ufe0f Inventory List Template (PDF)<\/a><\/div>\n<h2>Key Points at a Glance<\/h2>\n<ul>\n<li>An inventory list is used to physically count items during an inventory.<\/li>\n<li>Our <strong>free template<\/strong> (Excel &amp; PDF) calculates the <strong>Difference<\/strong> and the <strong>Total value<\/strong> automatically.<\/li>\n<li>Important columns: <strong>Target Inventory, Actual Inventory, Difference, Value, and Counter<\/strong>.<\/li>\n<li>For large collections, a <strong>Mobile Inventory App<\/strong> the recording significantly.<\/li>\n<\/ul>\n<h2>What is an inventory list?<\/h2>\n<p>One <strong>Inventory list<\/strong> (also known as a count sheet) is the form used to record the actual inventory during a physical count. It represents the <strong>Target inventory<\/strong> from the accounting records to the counted <strong>Current inventory<\/strong> and documents any discrepancies. The inventory list thus serves as proof that the inventory was conducted properly.<\/p>\n<h2>What should be included in an inventory list?<\/h2>\n<ul>\n<li><strong>Position<\/strong> and <strong>Inventory\/Item Number<\/strong><\/li>\n<li><strong>Name<\/strong> and <strong>Storage location<\/strong><\/li>\n<li><strong>Unit<\/strong> (piece, pair, carton \u2026)<\/li>\n<li><strong>Target inventory<\/strong> (according to the books) and <strong>Current inventory<\/strong> (counted)<\/li>\n<li><strong>Difference<\/strong> \u2013 calculated automatically in the template<\/li>\n<li><strong>Value per unit<\/strong> and <strong>Total value<\/strong><\/li>\n<li><strong>Counted by<\/strong> and <strong>Date<\/strong><\/li>\n<\/ul>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/inventory-one.com\/wp-content\/uploads\/2026\/07\/infografik-inventurliste.png\" alt=\"Principle of the inventory list: Target inventory minus actual inventory equals the difference\" \/><figcaption class=\"wp-element-caption\">The basic principle of the inventory list: The difference is calculated by comparing the target inventory and the actual inventory.<\/figcaption><\/figure>\n<h2>Taking Inventory Using the Inventory List: Here's How<\/h2>\n<ol>\n<li><strong>Prepare the template<\/strong> and enter the target balances (or export them from the system).<\/li>\n<li><strong>Divide into zones<\/strong> and assign counters.<\/li>\n<li><strong>Count the current inventory<\/strong> and enter it directly into the list.<\/li>\n<li><strong>Check for discrepancies<\/strong> \u2013 The template calculates it automatically.<\/li>\n<li><strong>Sign the list<\/strong> and archive it as an inventory record.<\/li>\n<\/ol>\n<p>To learn about the different inventory-taking methods, read our overview of the <a href=\"https:\/\/inventory-one.com\/en\/?p=4822\">Inventory Types<\/a>.<\/p>\n<div style=\"display:flex;flex-wrap:wrap;gap:12px;margin:24px 0\"><a href=\"https:\/\/inventory-one.com\/wp-content\/uploads\/2026\/07\/Inventurliste-Vorlage.xlsx\" download style=\"display:inline-block;background:#19BEA0;color:#ffffff;font-weight:700;text-decoration:none;padding:14px 24px;border-radius:8px\">\u2b07\ufe0f Inventory List Template (Excel)<\/a><a href=\"https:\/\/inventory-one.com\/wp-content\/uploads\/2026\/07\/Inventurliste-Vorlage.pdf\" download style=\"display:inline-block;background:#ffffff;color:#1C1C42;font-weight:700;text-decoration:none;padding:12px 22px;border:2px solid #1C1C42;border-radius:8px\">\u2b07\ufe0f Inventory List Template (PDF)<\/a><\/div>\n<h2>From a List to Digital Inventory Management<\/h2>\n<p>A template is the perfect place to start\u2014but as your inventory grows, Excel reaches its limits: duplicate entries, outdated locations, no history. With <a href=\"https:\/\/inventory-one.com\/en\/inventory-management\/\">Inventory ONE<\/a> Enter each object via <strong>Barcode\/QR Code Scan<\/strong>, view location and history in real time, and manage the <strong>Mobile Inventory Count via App<\/strong>. Learn more on our pages about <a href=\"https:\/\/inventory-one.com\/en\/inventory-management\/\">Inventory Management Software<\/a> and <a href=\"https:\/\/inventory-one.com\/en\/stocktaking-software\/\">Inventory Software<\/a>.<\/p>\n<h2>Frequently Asked Questions About the Inventory List (FAQ)<\/h2>\n<h3>What is an inventory list?<\/h3>\n<p>The physical inventory form, which compares the target and actual inventory levels and documents any discrepancies.<\/p>\n<h3>What is the difference between an inventory list and a stock-taking list?<\/h3>\n<p>The inventory list provides a permanent record of the available inventory. The inventory count sheet is the form used for conducting an inventory count as of a specific date.<\/p>\n<h3>Is there a free inventory list template?<\/h3>\n<p>Yes, above as an Excel file (with automatic calculation of differences) and as a printable PDF.<\/p>\n<h3>How can I conduct inventory counts more efficiently?<\/h3>\n<p>With a mobile inventory app, multiple teams can count items simultaneously by scanning them and enter the data directly into the system\u2014without having to enter it manually.<\/p>\n<h2>Relevant Templates &amp; Guides<\/h2>\n<ul>\n<li><a href=\"https:\/\/inventory-one.com\/en\/?p=4899\">Inventory List Template (Excel &amp; PDF)<\/a><\/li>\n<li><strong>Inventory List Template (Excel &amp; PDF)<\/strong> (this article)<\/li>\n<li><a href=\"https:\/\/inventory-one.com\/en\/?p=4822\">Overview of Inventory Types<\/a><\/li>\n<li><a href=\"https:\/\/inventory-one.com\/en\/?p=4881\">Maintain an asset register<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Free inventory list template in Excel and PDF\u2014with automatic variance calculation. Plus instructions for conducting a physical inventory count.<\/p>","protected":false},"author":6,"featured_media":4970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-4900","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-inventur"],"acf":[],"_links":{"self":[{"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/posts\/4900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/comments?post=4900"}],"version-history":[{"count":7,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/posts\/4900\/revisions"}],"predecessor-version":[{"id":4918,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/posts\/4900\/revisions\/4918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/media\/4970"}],"wp:attachment":[{"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/media?parent=4900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/categories?post=4900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inventory-one.com\/en\/wp-json\/wp\/v2\/tags?post=4900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}