{"id":315721,"date":"2026-10-24T09:33:02","date_gmt":"2026-10-24T14:33:02","guid":{"rendered":"https:\/\/yaku.app\/free-spreadsheet-for-tracking-borrowed-drums-and-jugs\/"},"modified":"2026-10-24T09:41:51","modified_gmt":"2026-10-24T14:41:51","slug":"free-spreadsheet-to-track-loaned-water-jugs","status":"publish","type":"page","link":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/","title":{"rendered":"Free spreadsheet for tracking borrowed water jugs"},"content":{"rendered":"<p>If you&#8217;re still keeping track of your containers in a notebook, this free spreadsheet will help you get organized today. It&#8217;s useful for water purification companies, seltzer delivery businesses, and any distributor that lends water jugs, jugs, siphons, or dispensers to its customers. <\/p>\n<p><a class=\"et_pb_button\" href=\"\/wp-content\/uploads\/2026\/09\/planilla-control-envases-yaku.xlsx\" download=\"\">Download the free spreadsheet (Excel)<\/a><\/p>\n<h2>What&#8217;s Included in the Worksheet<\/h2>\n<ul>\n<li><strong>Customers:<\/strong> code, name, address, zone or route, and the number of containers each had at the start.<\/li>\n<li><strong>Transactions:<\/strong> Each delivery includes the full containers you left and the empty ones that were returned to you.<\/li>\n<li><strong>Balances:<\/strong> This is calculated automatically and shows how many containers each customer currently has. Those that exceed the limit you set are highlighted in red. <\/li>\n<li><strong>Equipment Loans:<\/strong> Record of dispensers, pumps, and other equipment loaned out, including the dates of delivery and return.<\/li>\n<\/ul>\n<p>It works in Microsoft Excel and Google Sheets, and doesn&#8217;t require macros.<\/p>\n<h2>How to Use It in 4 Steps<\/h2>\n<ol>\n<li>Enter your customers&#8217; unique codes and the number of packages each one has today.<\/li>\n<li>At the end of each day, record deliveries and returns on the &#8220;Transactions&#8221; sheet.<\/li>\n<li>Check the &#8220;Balances&#8221; sheet once a week and request a refund from the customers marked in red.<\/li>\n<li>Record each dispenser or piece of equipment you&#8217;ve borrowed on the Comodatos sheet.<\/li>\n<\/ol>\n<h2>When a spreadsheet Is No Longer Enough<\/h2>\n<p>The spreadsheet works well as long as only one person updates it. When you have multiple delivery drivers, routes, and customers, the usual problems arise: data that loads slowly, different versions of the file, and balances that don&#8217;t match reality. <\/p>\n<p>At this point, it makes sense to switch to a system where delivery drivers record deliveries, packaging, and payments using their cell phones, and each customer&#8217;s balance is updated instantly. See how it works in the <a href=\"https:\/\/yaku.app\/en\/software-for-water-refill-businesses\/\">software for water refill businesses<\/a> and in the <a href=\"https:\/\/yaku.app\/en\/software-for-seltzer-delivery-businesses\/\">software for seltzer delivery businesses<\/a>. <\/p>\n<p>Want to know how much your non-returnable containers are costing you? Calculate it with our <a href=\"https:\/\/yaku.app\/en\/profitability-calculator-for-water-refill-and-seltzer-delivery-businesses\/\">profitability calculator<\/a>, or <a href=\"https:\/\/app.yaku.app\/registrarme\">try Yaku for free for 7 days<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re still keeping track of your containers in a notebook, this free spreadsheet will help you get organized today. It&#8217;s useful for water purification companies, seltzer delivery businesses, and any distributor that lends water jugs, jugs, siphons, or dispensers to its customers. Download the free spreadsheet (Excel) What&#8217;s Included in the Worksheet Customers: code, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-315721","page","type-page","status-publish","hentry"],"dsm_author":{"name":"Renzo Castillo","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/e49648a01fbdbfc436377326056232651c49f816c32c136dc474d461865b0d1c?s=96&r=g","archive_link":"https:\/\/yaku.app\/en\/author\/renzocastillo\/","biodata":"Cofundador de Yaku.app"},"dsm_categories":[],"dsm_attachment_categories":[],"dsm_featured_image":null,"dsm_comment_count":0,"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Free Spreadsheet for Tracking Water Jugs (Excel)<\/title>\n<meta name=\"description\" content=\"Download the free Excel spreadsheet to track borrowed jugs, jugs, siphons, and dispensers: balance per customer, transactions, and loans.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Free spreadsheet for tracking borrowed water jugs\" \/>\n<meta property=\"og:description\" content=\"If you&#039;re still keeping track of your containers in a notebook, this free spreadsheet will help you get organized today. It&#039;s useful for water\" \/>\n<meta property=\"og:url\" content=\"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/\" \/>\n<meta property=\"og:site_name\" content=\"Yaku\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/yakuapp\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-24T14:41:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/yaku.app\/wp-content\/uploads\/2026\/09\/yaku-og-1200x630-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/free-spreadsheet-to-track-loaned-water-jugs\\\/\",\"url\":\"https:\\\/\\\/yaku.app\\\/en\\\/free-spreadsheet-to-track-loaned-water-jugs\\\/\",\"name\":\"Free Spreadsheet for Tracking Water Jugs (Excel)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#website\"},\"datePublished\":\"2026-10-24T14:33:02+00:00\",\"dateModified\":\"2026-10-24T14:41:51+00:00\",\"description\":\"Download the free Excel spreadsheet to track borrowed jugs, jugs, siphons, and dispensers: balance per customer, transactions, and loans.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/free-spreadsheet-to-track-loaned-water-jugs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/yaku.app\\\/en\\\/free-spreadsheet-to-track-loaned-water-jugs\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/free-spreadsheet-to-track-loaned-water-jugs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/yaku.app\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Free spreadsheet for tracking borrowed water jugs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/yaku.app\\\/en\\\/\",\"name\":\"Yaku\",\"description\":\"Software de gesti\u00f3n para venta y reparto\",\"publisher\":{\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/yaku.app\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#organization\",\"name\":\"Yaku\",\"url\":\"https:\\\/\\\/yaku.app\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/yaku.app\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/logo-yaku-azul-horizontal-letra-blanca-e1712434032961.png\",\"contentUrl\":\"https:\\\/\\\/yaku.app\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/logo-yaku-azul-horizontal-letra-blanca-e1712434032961.png\",\"width\":2880,\"height\":1171,\"caption\":\"Yaku\"},\"image\":{\"@id\":\"https:\\\/\\\/yaku.app\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/yakuapp\\\/\",\"https:\\\/\\\/www.instagram.com\\\/yaku.app\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@yaku.app\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"contactType\":\"customer support\",\"email\":\"soporte@yaku.app\",\"availableLanguage\":[\"Spanish\"],\"areaServed\":[\"MX\",\"AR\",\"PE\"]},\"parentOrganization\":{\"@type\":\"Organization\",\"name\":\"Quaira LLC\",\"sameAs\":[\"https:\\\/\\\/www.youtube.com\\\/@quaira8308\"]}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Free Spreadsheet for Tracking Water Jugs (Excel)","description":"Download the free Excel spreadsheet to track borrowed jugs, jugs, siphons, and dispensers: balance per customer, transactions, and loans.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/","og_locale":"en_US","og_type":"article","og_title":"Free spreadsheet for tracking borrowed water jugs","og_description":"If you're still keeping track of your containers in a notebook, this free spreadsheet will help you get organized today. It's useful for water","og_url":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/","og_site_name":"Yaku","article_publisher":"https:\/\/www.facebook.com\/yakuapp\/","article_modified_time":"2026-10-24T14:41:51+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/yaku.app\/wp-content\/uploads\/2026\/09\/yaku-og-1200x630-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/","url":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/","name":"Free Spreadsheet for Tracking Water Jugs (Excel)","isPartOf":{"@id":"https:\/\/yaku.app\/en\/#website"},"datePublished":"2026-10-24T14:33:02+00:00","dateModified":"2026-10-24T14:41:51+00:00","description":"Download the free Excel spreadsheet to track borrowed jugs, jugs, siphons, and dispensers: balance per customer, transactions, and loans.","breadcrumb":{"@id":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/yaku.app\/en\/free-spreadsheet-to-track-loaned-water-jugs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/yaku.app\/en\/"},{"@type":"ListItem","position":2,"name":"Free spreadsheet for tracking borrowed water jugs"}]},{"@type":"WebSite","@id":"https:\/\/yaku.app\/en\/#website","url":"https:\/\/yaku.app\/en\/","name":"Yaku","description":"Software de gesti\u00f3n para venta y reparto","publisher":{"@id":"https:\/\/yaku.app\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/yaku.app\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/yaku.app\/en\/#organization","name":"Yaku","url":"https:\/\/yaku.app\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/yaku.app\/en\/#\/schema\/logo\/image\/","url":"https:\/\/yaku.app\/wp-content\/uploads\/2021\/06\/logo-yaku-azul-horizontal-letra-blanca-e1712434032961.png","contentUrl":"https:\/\/yaku.app\/wp-content\/uploads\/2021\/06\/logo-yaku-azul-horizontal-letra-blanca-e1712434032961.png","width":2880,"height":1171,"caption":"Yaku"},"image":{"@id":"https:\/\/yaku.app\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/yakuapp\/","https:\/\/www.instagram.com\/yaku.app\/","https:\/\/www.tiktok.com\/@yaku.app"],"contactPoint":{"@type":"ContactPoint","contactType":"customer support","email":"soporte@yaku.app","availableLanguage":["Spanish"],"areaServed":["MX","AR","PE"]},"parentOrganization":{"@type":"Organization","name":"Quaira LLC","sameAs":["https:\/\/www.youtube.com\/@quaira8308"]}}]}},"_links":{"self":[{"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/pages\/315721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/comments?post=315721"}],"version-history":[{"count":1,"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/pages\/315721\/revisions"}],"predecessor-version":[{"id":315814,"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/pages\/315721\/revisions\/315814"}],"wp:attachment":[{"href":"https:\/\/yaku.app\/en\/wp-json\/wp\/v2\/media?parent=315721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}