[\/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:\/\/app.sheetgo.com\/templates\/inventory” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” 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
Why choose Google Sheets for inventory management?<\/h2>\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
- \n
- Flexible: Google Sheets enables you to create a tailor-made inventory control system that you can change and adapt yourself, without any specialist software.<\/li>\n
- Accessible: As it\u2019s cloud-based, Google Sheets can be accessed by any member of the team at any time, as long as they have an internet connection.<\/li>\n
- Compatible with everything: All other software packages integrate with Google Sheets so you can easily merge data from multiple departments or processes, such as sales, order, or e-commerce software.<\/li>\n
- Easy to use: There\u2019s no need to train your team as they will already be familiar with spreadsheets. Maintenance is straightforward and there\u2019s no need for technical or IT support.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Sheetgo\u2019s Inventory management template<\/h2>\n
Sheetgo\u2019s Inventory template<\/a> is a pre-built system in Google Sheets for automated inventory tracking that can be used by companies handling any kind of product, from kitchen ingredients to clothing.<\/p>\n
The template gives managers a reliable way to track inventory and stock levels while providing warehouse or office staff with a simple method to log which items have entered or left the company.<\/p>\n
The spreadsheet contains pre-built tables, charts, layouts, and formulas.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/Inventory-template-Sheetgo-Dashboard-1.png” alt=”Inventory template Sheetgo Dashboard” title_text=”Inventory template Sheetgo Dashboard 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to get the Inventory template<\/h3>\n
Click on the button below to get your free copy of the Inventory management template in Google Sheets by Sheetgo.<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/inventory” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|20px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The single spreadsheet file contains a couple of different tabs where you can work in:<\/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
- \n
- A Check-in<\/b> sheet where the individual or team responsible records which items enter the company. This data might include new deliveries or returned items, for example.<\/li>\n
- A Check-out<\/b> sheet where the individual or team responsible registers items leaving the inventory. This might include items sold, materials used in manufacturing, or products sent to other departments.<\/li>\n
- A Current inventory list<\/b> that automatically updates with the status of your inventory. Here you have an overview of your available stock per item.<\/li>\n
- An Inventory management<\/b> master sheet for the manager. This tab contains automated dashboards with an overview of current stock levels. Data flows into this file from the check-in and check-out sheets via pre-built formulas.<\/li>\n<\/ol>\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
You can always read through the Instructions<\/b> tab to remember how to use the template best.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/Inventory-template-Sheetgo-Instructions-1.png” alt=”Inventory template Sheetgo Instructions” title_text=”Inventory template Sheetgo Instructions 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Or visualize a simpler version of the Inventory management template by Sheetgo here<\/a>.<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Get started<\/h3>\n
Step 1: Remove sample data<\/h4>\n
Inside the Check-in and Check-out tabs, there is some sample data provided for you to better understand how the template works.<\/p>\n
Simply remove all data from within the white cells to get started with your own.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/Inventory-template-Sheetgo-Check-in-1.png” alt=”Inventory template Sheetgo Check-in” title_text=”Inventory template Sheetgo Check-in 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Fill out your check-in and check-out<\/h4>\n
Once you\u2019ve removed all the sample data from the Check-in and Check-out tabs, you\u2019ll notice that the Current inventory list<\/b> and Dashboard<\/b> tabs are empty.<\/p>\n
To be able to track your own inventory in the template and its dashboard, start filling out your stock levels. The Check-in sheet is where you log all of the items you currently have in stock. Use the Check-out sheet to log every sale (or simply every time an item leaves your inventory).<\/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
Start tracking your inventory<\/span><\/span> automatically<\/h4>\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:\/\/app.sheetgo.com\/templates\/inventory” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” 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
Step 3: The Current inventory list automatically updates<\/h4>\n
Now you\u2019ll notice that the template automatically calculates how many items you have in your current inventory, by deducting the Check-out from the Check-in using Google Sheets formulas.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/Inventory-template-Sheetgo-Current-inventory-list-1.png” alt=”Inventory template Sheetgo Current Inventory list” title_text=”Inventory template Sheetgo Current inventory list 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Monitor stock in the pre-built dashboard<\/h4>\n
Finally, in the Dashboard<\/b> tab, you will be able to see your key inventory metrics in a visually appealing way. Monitor the following:<\/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
- \n
- Total items in stock<\/li>\n
- Top selling items<\/li>\n
- Sold out items<\/li>\n
- Average check-out items per weekday<\/li>\n
- Volume of items per day<\/li>\n
- Oversold items<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/08\/Inventory-template-Sheetgo-Dashboard-1.png” alt=”Inventory template Sheetgo Dashboard” title_text=”Inventory template Sheetgo Dashboard 1″ align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
That\u2019s it. That\u2019s how you use our simple, easy to implement Inventory management template in Google Sheets.<\/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
Start tracking your inventory<\/span><\/span> automatically<\/h4>\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:\/\/app.sheetgo.com\/templates\/inventory” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” 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
Inventory management in Google Sheets<\/h3>\n
This is how you easily monitor stock levels using the tools you\u2019re already familiar with: spreadsheets. No need to buy any expensive inventory software if you have these amazing templates and features.<\/p>\n
- A Check-out<\/b> sheet where the individual or team responsible registers items leaving the inventory. This might include items sold, materials used in manufacturing, or products sent to other departments.<\/li>\n
- A Check-in<\/b> sheet where the individual or team responsible records which items enter the company. This data might include new deliveries or returned items, for example.<\/li>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2016\/12\/white-and-green_sheetgo.png\")
<\/a><\/p>\n