{"id":6851,"date":"2025-10-21T13:00:34","date_gmt":"2025-10-21T11:00:34","guid":{"rendered":"https:\/\/nilaconseil.com\/templates\/?post_type=product&#038;p=6851"},"modified":"2025-10-21T13:16:37","modified_gmt":"2025-10-21T11:16:37","slug":"purchase-dashboard","status":"publish","type":"product","link":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/","title":{"rendered":"Purchase Dashboard"},"content":{"rendered":"<p>Excel template to track purchasing metrics: it covers year-over-year comparisons, budget versus actual performance, and trends. It includes vendor price benchmarking, contract monitoring, and tracks purchase quantities, amounts, and average prices over time.<\/p>\n<p>This ready-to-use procurement dashboard template includes 2 reports:<\/p>\n<h2>Purchase Analytics Report<\/h2>\n<p>This report shows purchase KPIs, by division, by purchase type, and by item:<\/p>\n<ul>\n<li>Actual purchase quantities and purchase amounts<\/li>\n<li>Budget vs. Actual variance analysis<\/li>\n<li>Current Year vs. Prior Year actuals analysis<\/li>\n<li>Monthly Actuals vs Budgets vs Last Year trends<\/li>\n<\/ul>\n<h2>Unit Price Analytics Report<\/h2>\n<p>This report shows items&#8217; unit prices analytics:<\/p>\n<ul>\n<li>Actual unit prices compared to Budget<\/li>\n<li>Current Year unit prices compared to Prior Year<\/li>\n<li>Vendor price comparison<\/li>\n<li>Purchase volume by vendor and contract<\/li>\n<li>Purchase contracts expiration reminder<\/li>\n<li>Monthly evolution of average unit prices, and purchase quantities<\/li>\n<\/ul>\n<p>Using this template is quite easy, you just need to:<\/p>\n<ul>\n<li>Define your settings<\/li>\n<li>Enter purchase budget data<\/li>\n<li>Enter purchase actuals data<\/li>\n<\/ul>\n<p><strong>Video:<\/strong><\/p>\n<p><iframe loading=\"lazy\" title=\"Purchase Dashboard\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/ntIAPsiPOB4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><strong>Template Requirements and How to Use:<\/strong><\/p>\n<ul>\n<li>Works on PC with Windows.<\/li>\n<li><strong>Does not work on MAC.<\/strong><\/li>\n<li>Requires Microsoft\u00a0<strong>Excel 2019 or higher<\/strong><\/li>\n<li>Allow Macros to run (enable content when opening file).<\/li>\n<li>Ready-to-use template, just enter or import your data.<\/li>\n<li>Dashboard ready to be printed.<\/li>\n<li>Instructions on the Excel sheet \u201cUser Guide\u201d.<\/li>\n<\/ul>\n<p><strong>Customizable template: <\/strong><\/p>\n<p>Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.<\/p>\n<p><strong>Included in the download:<\/strong><\/p>\n<ul>\n<li>A template with sample data<\/li>\n<li>An empty template, ready to receive your data.<\/li>\n<li>A user guide<\/li>\n<\/ul>\n<p><strong>Download link:<\/strong><\/p>\n<ul>\n<li>Downloads are available from\u00a0<a href=\"https:\/\/nilaconseil.com\/templates\/my-account\"><u>your account<\/u>\u00a0<\/a>once your payment is confirmed.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><strong>Warning:<\/strong><\/p>\n<blockquote><p>We have put a lot of effort into providing you with a quality work tool at a reasonable price. We kindly ask you to respect the copyright so that we can continue to exist, develop and improve our services. Thank you.<\/p>\n<p>Once purchased, it is prohibited to resell, redistribute, sublicense, assign or transfer this file to anyone in any form. Please read our <a href=\"https:\/\/nilaconseil.com\/templates\/terms\/\" target=\"_blank\" rel=\"noopener\">terms and conditions<\/a> before purchasing this product.<\/p><\/blockquote>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>Excel template to track purchasing metrics: it covers year-over-year comparisons, budget versus actual performance, and trends. It includes vendor price benchmarking, contract monitoring, and tracks purchase quantities, amounts, and average prices over time.<\/p>\n","protected":false},"featured_media":6853,"template":"","meta":[],"product_brand":[],"product_cat":[19,35,24],"product_tag":[51,26,36,37],"class_list":["post-6851","product","type-product","status-publish","has-post-thumbnail","product_cat-finance","product_cat-procurement","product_cat-projects","product_tag-expenses-tracking","product_tag-financial-dashboard","product_tag-procurement-management","product_tag-purchase-management","first","instock","downloadable","sold-individually","shipping-taxable","purchasable","product-type-simple"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"google-site-verification\" content=\"l9fEjutmsnC8wiL4aeARM6D6jkNPAwTVWZ-SAoB2UD8\" \/>\n\t<meta name=\"msvalidate.01\" content=\"B12C51C6FB4B844C2C4C8B5B06DB9850\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"NILACONSEIL - Dashboards, Reporting, Data Analysis\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Purchase Dashboard\" \/>\n\t\t<meta property=\"og:description\" content=\"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-10-21T11:00:34+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-10-21T11:16:37+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/nilaconseil\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Purchase Dashboard\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates#listItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/nilaconseil.com\\\/templates\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/product-category\\\/finance\\\/#listItem\",\"name\":\"Finance\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/product-category\\\/finance\\\/#listItem\",\"position\":2,\"name\":\"Finance\",\"item\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/product-category\\\/finance\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#listItem\",\"name\":\"Purchase Dashboard\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates#listItem\",\"name\":\"Accueil\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#listItem\",\"position\":3,\"name\":\"Purchase Dashboard\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/product-category\\\/finance\\\/#listItem\",\"name\":\"Finance\"}}]},{\"@type\":\"ItemPage\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#itempage\",\"url\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/\",\"name\":\"Purchase Dashboard\",\"description\":\"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#breadcrumblist\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Purchase_kpis.jpg\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#mainImage\",\"width\":1680,\"height\":863,\"caption\":\"Purchase analytics\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#mainImage\"},\"datePublished\":\"2025-10-21T13:00:34+02:00\",\"dateModified\":\"2025-10-21T13:16:37+02:00\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/#organization\",\"name\":\"NILACONSEIL\",\"description\":\"Dashboards, Reporting, Data Analysis\",\"url\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/NL.png\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#organizationLogo\",\"width\":143,\"height\":147,\"caption\":\"NILACONSEIL\"},\"image\":{\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/shop\\\/finance\\\/purchase-dashboard\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/nilaconseil\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCAVy97uLa814zCmpoF-NiUA\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/nisrine-lahreche\\\/\"]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/#website\",\"url\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/\",\"name\":\"NILACONSEIL\",\"description\":\"Dashboards, Reporting, Data Analysis\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/nilaconseil.com\\\/templates\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Purchase Dashboard","description":"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring","canonical_url":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"l9fEjutmsnC8wiL4aeARM6D6jkNPAwTVWZ-SAoB2UD8","msvalidate.01":"B12C51C6FB4B844C2C4C8B5B06DB9850","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates#listItem","position":1,"name":"Accueil","item":"https:\/\/nilaconseil.com\/templates","nextItem":{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates\/product-category\/finance\/#listItem","name":"Finance"}},{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates\/product-category\/finance\/#listItem","position":2,"name":"Finance","item":"https:\/\/nilaconseil.com\/templates\/product-category\/finance\/","nextItem":{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#listItem","name":"Purchase Dashboard"},"previousItem":{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates#listItem","name":"Accueil"}},{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#listItem","position":3,"name":"Purchase Dashboard","previousItem":{"@type":"ListItem","@id":"https:\/\/nilaconseil.com\/templates\/product-category\/finance\/#listItem","name":"Finance"}}]},{"@type":"ItemPage","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#itempage","url":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/","name":"Purchase Dashboard","description":"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/nilaconseil.com\/templates\/#website"},"breadcrumb":{"@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#breadcrumblist"},"image":{"@type":"ImageObject","url":"https:\/\/nilaconseil.com\/templates\/wp-content\/uploads\/2025\/10\/Purchase_kpis.jpg","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#mainImage","width":1680,"height":863,"caption":"Purchase analytics"},"primaryImageOfPage":{"@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#mainImage"},"datePublished":"2025-10-21T13:00:34+02:00","dateModified":"2025-10-21T13:16:37+02:00"},{"@type":"Organization","@id":"https:\/\/nilaconseil.com\/templates\/#organization","name":"NILACONSEIL","description":"Dashboards, Reporting, Data Analysis","url":"https:\/\/nilaconseil.com\/templates\/","logo":{"@type":"ImageObject","url":"https:\/\/nilaconseil.com\/templates\/wp-content\/uploads\/2020\/12\/NL.png","@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#organizationLogo","width":143,"height":147,"caption":"NILACONSEIL"},"image":{"@id":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/nilaconseil","https:\/\/www.youtube.com\/channel\/UCAVy97uLa814zCmpoF-NiUA","https:\/\/www.linkedin.com\/in\/nisrine-lahreche\/"]},{"@type":"WebSite","@id":"https:\/\/nilaconseil.com\/templates\/#website","url":"https:\/\/nilaconseil.com\/templates\/","name":"NILACONSEIL","description":"Dashboards, Reporting, Data Analysis","inLanguage":"en-US","publisher":{"@id":"https:\/\/nilaconseil.com\/templates\/#organization"}}]},"og:locale":"en_US","og:site_name":"NILACONSEIL - Dashboards, Reporting, Data Analysis","og:type":"article","og:title":"Purchase Dashboard","og:description":"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring","og:url":"https:\/\/nilaconseil.com\/templates\/shop\/finance\/purchase-dashboard\/","article:published_time":"2025-10-21T11:00:34+00:00","article:modified_time":"2025-10-21T11:16:37+00:00","article:publisher":"https:\/\/www.facebook.com\/nilaconseil","twitter:card":"summary","twitter:title":"Purchase Dashboard","twitter:description":"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring"},"aioseo_meta_data":{"post_id":"6851","title":"#post_title","description":"Tracks purchase quantities, amounts, average prices over time, budget versus actual variance, vendor price comparison, contract volume and expiration monitoring","keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":37,"analysis":{"keyphraseInTitle":{"score":3,"maxScore":9,"error":1},"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":1},"keyphraseInURL":{"score":1,"maxScore":5,"error":1},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInSubHeadings":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":[],"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"ItemPage","isEnabled":true},"graphs":[]},"schema_type":"none","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"},\"blockGraphs\":[],\"book\":[],\"event\":[],\"jobPosting\":[],\"music\":[],\"person\":[],\"restaurant\":[],\"service\":[],\"video\":[]}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2025-10-21 11:00:34","updated":"2025-10-21 11:26:17","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/product\/6851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/media\/6853"}],"wp:attachment":[{"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/media?parent=6851"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/product_brand?post=6851"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/product_cat?post=6851"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/nilaconseil.com\/templates\/wp-json\/wp\/v2\/product_tag?post=6851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}