{"id":15320,"date":"2020-09-28T16:15:36","date_gmt":"2020-09-28T14:15:36","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15320"},"modified":"2025-07-08T22:30:23","modified_gmt":"2025-07-08T20:30:23","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

Sign up for Sheetgo and start automating 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:\/\/app.sheetgo.com\/templates\/purchase-order” 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.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?<\/b><\/h3>\n