{"id":33552,"date":"2021-06-04T13:49:01","date_gmt":"2021-06-04T11:49:01","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=33552"},"modified":"2025-11-18T21:43:15","modified_gmt":"2025-11-18T20:43:15","slug":"modelo-de-pedido-de-compra-em-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/manufacturing-templates\/purchase-order-template-excel\/","title":{"rendered":"Modelo de pedido de compra no Excel"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; da_disable_devices=&#8221;off|off|off&#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;][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.24.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Small businesses typically have an informal system in place to manage their purchase orders and procurement. Perhaps employees simply send a brief message to their manager requesting specific materials. In other cases, they may place orders directly with a supplier without needing authorization. Informal systems might seem adequate for companies at first. However, they can cause communication issues that result in wrong orders and inefficiencies throughout the supply chain. Additionally, missing an essential item in stock reflects poorly on an organization&#8217;s reputation among its customers. Moreover, it causes problems with the cash flow.<\/p>\n<p>When different employees manage the same orders, mistakes accumulate quickly. While one employee places the order, another accepts it and fails to notice items missing. Organizations that delegate these tasks properly have a more efficient ordering process. Managers do this by implementing a formal purchase control system.<\/p>\n<p>At this point, companies might think they need specialist software with a hefty price tag. In many cases, these tools are complex and too overwhelming for a business&#8217;s specific needs. Instead of going through that trouble, firms can simply create their own purchase order management system with a familiar tool: spreadsheets. Sheetgo&#8217;s Purchase order template enables companies to automate their purchase order processes in an online template easily.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>How to get started<\/h2>\n<p>The Sheetgo purchase order template in Excel is specifically designed to automate purchase order management and can be used by any organization, in any sector.<\/p>\n<p>Firms that require a reliable way to handle order requests benefit from havig these processes automated.<\/p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1197uPX8BcHNt4SlR_ikt93UGjxq0QPjJ&#8221; 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|30px|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; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#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;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>What you get with the Purchase Order template in Excel<\/h2>\n<p>When you download the Sheetgo Purchase Order template, you&#8217;ll have a template with:<\/p>\n<ul>\n<li>Two <b> Order request <\/b>sheets. Make copies if you have additional departments or teams to add. Each team uses its copies to submit requests for materials and supplies.<\/li>\n<li>One <strong>Supplier&#8217;s register <\/strong>sheet.<\/li>\n<li>One <strong>Orders received\u00a0<\/strong>sheet.<\/li>\n<li>One <strong>Dashboard<\/strong> for top-view metrics.<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>How to use the Purchase Order template<\/h2>\n<ol>\n<li>Register all your suppliers in the Suppliers register (Input) tab.<\/li>\n<li>Place all approved orders.<\/li>\n<li>Register all orders received in the Orders received (Input) tab of this sheet.<\/li>\n<li>Monitor all purchases in your Dashboard.<\/li>\n<\/ol>[\/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;]<h2>That\u2019s it!<\/h2>\n<p>Congratulations on setting up Sheetgo&#8217;s Purchase order template in Excel! Are you looking for more Excel templates? Have a look at Sheetgo&#8217;s Cash flow template<a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/cash-flow-template-in-excel\/\" target=\"_blank\" rel=\"noopener\"> here<\/a>.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row 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; locked=&#8221;off&#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.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; text_font_size=&#8221;30px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; 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;]<p><strong>Start <span style=\"background-color: rgba(41,121,255,0.2);\">tracking<\/span> your suppliers and collecting order requests<\/strong><\/p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1197uPX8BcHNt4SlR_ikt93UGjxq0QPjJ&#8221; 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;25px|0px|0px|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; 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;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>Small businesses typically have an informal system in place to manage their purchase orders and procurement. Perhaps employees simply send a brief message to their manager requesting specific materials. In other cases, they may place orders directly with a supplier without needing authorization. Informal systems might seem adequate for companies at first. However, they can [&hellip;]<\/p>\n","protected":false},"author":50,"featured_media":33553,"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-33552","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-manufacturing-templates","tag-manufacturing"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/33552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=33552"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/33552\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/33553"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=33552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=33552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=33552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}