[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|0px|0|0px|false|false” da_disable_devices=”off|off|off” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Does a department in your company lend items internally? Perhaps you have a library in your school that lends books to students. Or an IT department that lends computer equipment to employees. Maybe you run a hire business where you rent items to customers, such as bicycles, tools, or clothing?<\/p>\n
Whatever type of business, institute, or organization you work in, tracking lent items is an essential task \u2014 but it\u2019s often done manually or using cumbersome IT systems.<\/p>\n
Keeping tabs on exactly what stock you currently have in your inventory, what has been lent out (and to whom) helps you to calculate if you have enough equipment for your business, to recognize if certain items are going unused, and to help you trace missing or overdue items that have not been returned.<\/p>\n
You could purchase specialist lending software, or ask your IT team to build you a tracking system, but you can actually do it yourself using the tool you already know and use: spreadsheets. Here I\u2019ll show you how to create a reliable inventory lending system in Google Sheets, using a ready-to-use template.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1VqXFtL7t47oAx-wa1ONZyYFmsNt1J-2iLR3FeeHQ0iU\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#FFFFFF” button_bg_color=”#2979FF” button_border_width=”0px” button_border_color=”#2979FF” button_border_radius=”6px” button_font=”|600|||||||” button_use_icon=”off” custom_padding=”15px|20px|15px|20px|true|false” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_text_color__hover_enabled=”on|desktop” button_border_color__hover_enabled=”on|hover” button_border_color__hover=”#2666E2″ button_text_color__hover=”#FFFFFF” button_bg_color__hover=”#2666E2″ button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n