{"id":15320,"date":"2020-09-28T16:15:36","date_gmt":"2020-09-28T14:15:36","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15320"},"modified":"2026-08-19T20:09:51","modified_gmt":"2026-08-19T18:09:51","slug":"modele-de-bon-de-commande-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/manufacturing-templates\/purchase-order-template-in-google-sheets\/","title":{"rendered":"Mod\u00e8le de bon de commande dans Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|0px|0|0px|false|false” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If you work in a small business, it’s likely that you have an informal system for purchase order management and procurement. Perhaps staff just send a quick message to an administrator asking for materials. Or maybe they pick up the phone to place an order with the supplier directly.<\/p>\n

Inefficiencies and communication problems can lead to incorrect orders, shortages, and supply chain disruption. All of which is bad news for your customers. On top of that, overspending and stockpiles can make a dent in your cash flow.<\/p>\n

Imagine that you place an order with a supplier on the phone. On the day the shipment arrives, a colleague accepts the delivery but the invoice shows a higher price than the original quote. Certain items are missing and some goods arrive damaged. Unless the same person places the order and receives the delivery, there can be a delay before anyone spots mistakes. By that point, the invoice may have already been processed and it’s more difficult to solve the problem with the vendor.<\/p>\n

Did your colleague already place the order? Maybe you ordered “two” boxes on the phone but the person in the office thought you said “ten”. Communication issues can be avoided with a formal purchase control system, but it\u2019s not always easy to design and implement a system from scratch.<\/p>\n

Specialist purchase control and procurement software packages aren’t cheap, and these programs can be overly complex for small businesses. Instead, you can create your own purchase order management solution with the tool you already use: spreadsheets.<\/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” 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

Get the free template and start managing your purchase orders<\/span><\/span><\/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:\/\/docs.google.com\/spreadsheets\/d\/1uO1s0AD12DqQwmvk5qB81lJAwTxoV2a9X6nX1LxXatM\/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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n

Why use Google Sheets to manage purchase orders?<\/h3>\n
    \n
  • Flexible: Spreadsheets allow you to create a system that’s tailored to your business. You can adapt and expand it over time, without IT support.<\/li>\n
  • Accessible: Google Sheets is cloud-based so you can manage your purchase order data from anywhere, at any time.\u00a0 All you need is an internet connection. On top of that, you won\u2019t waste money on expensive and unnecessary software.<\/li>\n
  • Compatible with everything: All other software packages integrate with Google Sheets. This means you can easily import data from other parts of the business and centralize everything in Google Sheets.<\/li>\n
  • Easy to use: Most people use spreadsheets at some point. Therefore, the entire team will be able to use the system without training. As a result, it’s future-proof and easy to maintain.<\/li>\n<\/ul>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/purchase-order-template-suppliers-2.png” alt=”Purchase order template suppliers tab” title_text=”purchase-order-template-suppliers” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    How to get started<\/h3>\n

    Sheetgo\u2019s Purchase order management template is a ready-to-use Google Sheets file for tracking purchase orders from request to delivery. It works for any business, in any sector \u2014 there is nothing to install and nothing to connect. Get your free copy, and start logging orders in minutes.<\/p>\n

    [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    What you get with this template:<\/h3>\n

    When you get the Sheetgo purchase order management template<\/b>, you receive a single Google Sheets file with everything in one place:<\/p>\n

      \n
    • A Suppliers<\/b> register and an Orders<\/b> log where teams record purchase requests.<\/li>\n
    • A Received<\/b> tab to record deliveries as they arrive.<\/li>\n
    • An Open POs<\/b> tab that shows what is still outstanding \u2014 ordered minus received \u2014 for every order line.<\/li>\n<\/ul>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/purchase-order-template-open-pos-2.png” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      How to get the template<\/h3>\n

      Click on the button below to get Sheetgo\u2019s Purchase order management template, then:<\/p>\n

      [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1uO1s0AD12DqQwmvk5qB81lJAwTxoV2a9X6nX1LxXatM\/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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 1: Enter your orders<\/h4>\n

      First, list the companies you buy from in the Suppliers<\/b> tab. Then, in the Orders<\/b> tab, log each order line: order number, date, supplier, item, unit price and quantity.<\/p>\n

      Leave the gray Total<\/strong> column alone \u2014 the template fills it in with a built-in formula. The Read me<\/b> tab explains what goes in each column.<\/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 managing your purchase orders<\/span><\/span><\/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:\/\/docs.google.com\/spreadsheets\/d\/1uO1s0AD12DqQwmvk5qB81lJAwTxoV2a9X6nX1LxXatM\/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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 2: Register deliveries<\/h4>\n

      When new deliveries arrive, log them in the Received<\/b> tab: order number, item, received date and quantity received.<\/p>\n

      The Open POs<\/b> tab then shows what is still outstanding \u2014 ordered minus received \u2014 for every order line.<\/p>\n

      If deliveries are accepted by another colleague or team, you can share the file with them and ask them to fill out this tab.<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/purchase-order-template-orders-2.png” alt=”purchase-order-deliveries-received” title_text=”purchase-order-mgmt-orders-received-8″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row 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” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _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_orientation=”center” 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 managing your purchase orders<\/span><\/span><\/h3>\n

      [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1uO1s0AD12DqQwmvk5qB81lJAwTxoV2a9X6nX1LxXatM\/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”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” theme_builder_area=”post_content”]<\/p>\n

      Frequently asked questions<\/h2>\n

      [\/et_pb_text][difl_faq faq_item_gap=”25px” enable_schema=”on” close_icon_color=”#82afff” close_icon_size=”28px” open_icon_color=”#82afff” faq_anime_duration=”200″ faq_item_wrapper_bg_bgcolor=”#FFFFFF” que_text_margin=”10px|20px|10px|20px|true|true” ans_text_padding=”0px|20px|10px|20px|false|true” _builder_version=”4.27.6″ _module_preset=”default” question_text_font=”|600|||||||” question_text_font_size=”19px” design_answer_text_font=”|300|||||||” design_answer_text_font_size=”16px” design_answer_text_line_height=”1.6em” border_radii_faq_item_wrapper_border=”on|12px|12px|12px|12px” border_color_all_faq_item_wrapper_border=”#deeaf7″ global_colors_info=”{}”][difl_faqitem question=”Is the purchase order template free?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

      Yes. It is a Google Sheets file you copy to your own Drive, with nothing to install.<\/p>\n

      [\/difl_faqitem][difl_faqitem question=”How does it track what is still outstanding?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

      The Open POs tab compares what you ordered against what you have recorded as received, and shows the difference per order line.<\/p>\n

      [\/difl_faqitem][difl_faqitem question=”Can it send the purchase orders for me?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

      No. It is a spreadsheet for logging and tracking orders. Sending orders and chasing suppliers is what Sheetgo’s supply-chain virtual employee does.<\/p>\n

      [\/difl_faqitem][\/difl_faq][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

      If you work in a small business, it’s likely that you have an informal system for purchase order management and procurement. Perhaps staff just send a quick message to an administrator asking for materials. Or maybe they pick up the phone to place an order with the supplier directly. Inefficiencies and communication problems can lead […]<\/p>\n","protected":false},"author":50,"featured_media":27450,"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":[64],"tags":[63],"class_list":["post-15320","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-manufacturing-templates","tag-manufacturing"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=15320"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15320\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27450"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=15320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=15320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=15320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}