{"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-10-17T09:17:37","modified_gmt":"2026-10-17T09:17:37","slug":"quote-purchase-order-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/fr\/product\/quote-purchase-order-spreadsheet\/","title":{"rendered":"Quote &#038; Purchase Order Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Quote fast, order right<\/span><\/p>\n<h2 id=\"a-quote-and-purchase-order-template-that-numbers-and-fills-itself\">A quote and purchase order template that numbers and fills itself<\/h2>\n<p>The Quote &amp; Purchase Order Pack is for a small business that sends quotes to customers and orders to suppliers and is tired of retyping both. Type your company details once on Settings, with the number prefixes (Q- and PO- to start) and the first numbers, 1001 or wherever your old system stopped. Then fill Products with what you sell and buy, and Suppliers and Customers with who you deal with.<\/p>\n<h3>Two documents, filled from your lists<\/h3>\n<p>On Quote, pick a customer and products: prices, discount, tax, total and a valid-until date (30 days to start) fill in, with an acceptance block. On Purchase Order, pick a supplier and supplies: your costs, ship-to, terms and a deliver-by date of today plus that supplier&rsquo;s lead time fill in, with an authorisation block. Add your logo once, then print or save as PDF; only the document prints.<\/p>\n<h3>What is late, what is waiting<\/h3>\n<p>Each document adds one line to its log and the next number moves on. A delivery past its expected date stays on the Overview until you type the day it arrived, and Suppliers shows each one&rsquo;s on-time rate and a year&rsquo;s spend. Quote Log keeps every quote&rsquo;s status and next step, and Customers shows what each has been quoted and has accepted.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/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":"1","_templacity_faq":[{"q":"Do the documents number themselves?","a":"Yes. Each shows the next number after the last one on its log, with your prefix in front. Carrying on from an older system? Set the first number on Settings."},{"q":"How is the deliver-by date set?","a":"Today plus the supplier's lead time from the Suppliers tab. Type over it for a one-off."},{"q":"Can I add my logo?","a":"Yes. Click the dashed box on the document, then Insert, Pictures, Place over Cells."},{"q":"Does it handle sales tax?","a":"Every new quote starts with the rate on Settings, 0 until you set one, and you can type a different rate on any one quote. The tax line's label is yours to change too."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"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\/fr\/wp-json\/wp\/v2\/product\/13048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/comments?post=13048"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media\/13049"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/media?parent=13048"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/niche?post=13048"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/template_type?post=13048"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/templacity_topic?post=13048"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_brand?post=13048"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_cat?post=13048"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/fr\/wp-json\/wp\/v2\/product_tag?post=13048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}