{"id":13048,"date":"2026-09-19T15:08:23","date_gmt":"2026-09-19T15:08:23","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13048"},"modified":"2026-09-27T15:14:02","modified_gmt":"2026-09-27T15:14:02","slug":"quote-purchase-order-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/zh\/product\/quote-purchase-order-spreadsheet\/","title":{"rendered":"Quote &#038; Purchase Order Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p>Quotes out and purchase orders in, from one workbook. Pick a customer or supplier and the products; prices, costs, tax, totals and the next number fill in.<\/p>\n<ul>\n<li><strong>Overview<\/strong>: what is on order, late deliveries, quotes waiting, win rate and each supplier&#8217;s on-time rate.<\/li>\n<li><strong>Quote<\/strong>: the quote you send, with discount, tax, valid-until and an acceptance block.<\/li>\n<li><strong>Purchase Order<\/strong>: the PO you send, with ship-to, deliver-by, terms and an authorisation block.<\/li>\n<li><strong>PO Log and Quote Log<\/strong>: status, dates, days late and next steps.<\/li>\n<li><strong>Suppliers, Customers and Products<\/strong>: the lists behind both documents, with margins.<\/li>\n<li><strong>Settings<\/strong>: company details, number prefixes, tax, validity and terms.<\/li>\n<\/ul>\n<p><strong>What you get:<\/strong> a one-page PDF with two buttons. One makes a blank copy of the Google Sheet in your own Drive, the other a copy filled with an example so you can see every tab working first. The same workbook comes as two Excel files, blank and example, checked in Excel with every formula recalculated. No year is printed anywhere, so it starts the day you do.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Numbered quotes and purchase orders that fill themselves from your customer, supplier and product lists, with logs that flag late deliveries and quotes waiting.<\/p>\n","protected":false},"featured_media":13049,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Purchase Order and Quote Template for Sheets and Excel | Templacity","rank_math_description":"A purchase order and quote template for Google Sheets and Excel: auto-numbered documents, PO and quote logs, supplier on-time rates and margins.","rank_math_seo_score":"9","_templacity_copy_live":"","_templacity_faq":[]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13048","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product\/13048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/comments?post=13048"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media\/13049"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media?parent=13048"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/niche?post=13048"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/template_type?post=13048"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/templacity_topic?post=13048"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_brand?post=13048"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_cat?post=13048"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_tag?post=13048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}