{"id":39025,"date":"2022-03-17T15:15:27","date_gmt":"2022-03-17T14:15:27","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=39025"},"modified":"2025-11-18T19:51:30","modified_gmt":"2025-11-18T18:51:30","slug":"prestar-plantilla-de-inventario-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/inventory-templates\/lend-out-inventory-template-excel\/","title":{"rendered":"Plantilla de inventario en Excel"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>Is there a part of your company that lends out equipment or supplies to employees? Maybe you\u2019re a company lending items to customers, such as sports equipment or cars? Keeping track of which objects are in stock is essential, whether you\u2019re lending internally or externally. Having an automated system to manage your lend-out inventory is the best way to keep track of operations. It avoids the risks associated with manual work, such as human error or outdated information.<\/p>\n<p>Purchasing lending software is one option, but this is extremely expensive and requires extra training. The most practical solution is to create a custom solution using the program you already use daily &#8211; Microsoft Excel. This article will explain how you can implement an automated, easy-to-use inventory lending system using Microsoft Excel in your business.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; text_font_size=&#8221;30px&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p><strong>Start tracking your <span style=\"background-color: rgba(41,121,255,0.2);\">inventory<\/span><\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1UB2fFOLRDUtbHk91FyP7wweFIvmuvGUi&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Why choose Microsoft Excel to manage inventory lending?<\/h2>\n<p>Microsoft Excel is known for its ability to store and manage large amounts of data easily. Here are just some of the reasons why Excel is a great tool to use to help manage your inventory lending:<\/p>\n<ul>\n<li><b>Flexibility:<\/b> Excel allows you to build an inventory system from the ground up. When working in a Sheetgo Lend-out inventory template with excel, you do not need other software or coding knowledge.<\/li>\n<li><b>Accessibility: <\/b>In Excel, you can collaborate with all your team members; they simply need a link to the file and a stable Wifi connection.<\/li>\n<li><b>Compatibility:<\/b> You can easily integrate other software or tools already used in your business in Excel. This allows you to incorporate data from other departments in your lend-out workflow.<\/li>\n<li><b>Ease of use:<\/b> Every corporate employee has a basic knowledge of Excel. As a result, there is no need to teach your employees how to navigate the tool. The lend-out system is straightforward and clear to use.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>What you get with this template<\/h2>\n<p>The Lend-out inventory template by Sheetgo consists of:<\/p>\n<ul>\n<li><strong>Items database (input)<\/strong>: Where you record the items you\u2019re managing, to be later checked in and out.<\/li>\n<li><strong>Check-in<\/strong>: Where you log items that have been returned.<\/li>\n<li><strong>Check-out<\/strong>: Where you record items that are being lent out.<\/li>\n<li><strong>Current inventory list<\/strong>: A live overview of your inventory, showing items in, items out, and availability percentage.<\/li>\n<li><strong>Item out matrix<\/strong>: A table displaying which items are currently out and who has them.<\/li>\n<li><strong>Dashboard<\/strong>: A visual summary of your inventory, with charts to help you quickly understand its status.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>How to get the Lend out inventory template<\/h2>\n<p>Click the button below to download Sheetgo&#8217;s Inventory lending template for Excel.<\/p>\n<p>[\/et_pb_text][et_pb_button url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|20px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1UB2fFOLRDUtbHk91FyP7wweFIvmuvGUi&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Interested in other Excel inventory templates?<\/h2>\n<p>Sheetgo offers a wide range of templates to choose from. Take a look at this <a href=\"https:\/\/www.sheetgo.com\/blog\/inventory-templates\/inventory-system-with-barcode-scanner\/\">Inventory barcode scanner system for Google Sheets<\/a> to find out how you can easily scan items in and out of your stock.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is there a part of your company that lends out equipment or supplies to employees? Maybe you\u2019re a company lending items to customers, such as sports equipment or cars? Keeping track of which objects are in stock is essential, whether you\u2019re lending internally or externally. Having an automated system to manage your lend-out inventory is [&hellip;]<\/p>\n","protected":false},"author":50,"featured_media":39049,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[69],"tags":[58],"class_list":["post-39025","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-inventory-templates","tag-inventory"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/39025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=39025"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/39025\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/39049"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=39025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=39025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=39025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}