{"product_id":"materials-order-tracker-excel-template","title":"Materials Order Tracker Excel Template | Orders, Deliveries, Overdue Flags and Spend by Supplier","description":"\u003cp\u003eFor trades and contractors buying materials across several jobs. Orders go missing, deliveries run late and nobody knows what each job has cost in materials. This workbook tracks every order from PO to delivery, flags anything overdue and shows your materials spend by supplier and by job.\u003c\/p\u003e\n\u003ch4\u003eWhat it covers\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eOrder log tracking every purchase from PO to delivery\u003c\/li\u003e\n\u003cli\u003eOverdue flags on late deliveries so you know who to chase\u003c\/li\u003e\n\u003cli\u003eDashboard showing materials spend by supplier\u003c\/li\u003e\n\u003cli\u003eMaterials spend broken down by job\u003c\/li\u003e\n\u003cli\u003eSetup tab for your suppliers and jobs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eWho it is for\u003c\/h4\u003e\n\u003cp\u003eSuits builders, roofers, electricians, plumbers, joiners and small contractors ordering from several suppliers.\u003c\/p\u003e\n\u003ch4\u003eWhat is inside\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eEasy Setup, your lists in one place so every dropdown matches how you work\u003c\/li\u003e\n\u003cli\u003eHow To Use and Quick Start guides, from download to working in ten minutes\u003c\/li\u003e\n\u003cli\u003eDashboard\u003c\/li\u003e\n\u003cli\u003eOrders\u003c\/li\u003e\n\u003cli\u003eNotes and Actions, Log and Diary, Goals and Targets, Weekly Review and Monthly Review tabs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eHow it works\u003c\/h4\u003e\n\u003cp\u003eOpen the file in Microsoft Excel and start on the Easy Setup tab. Swap the sample lists for your own and every dropdown in the workbook updates. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.\u003c\/p\u003e\n\u003ch4\u003eWhat you get\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eOne editable Excel (.xlsx) workbook with 10 tabs\u003c\/li\u003e\n\u003cli\u003eBuilt for Microsoft Excel, no macros and no formulas for you to write\u003c\/li\u003e\n\u003cli\u003eExample rows included so you can see every feature working\u003c\/li\u003e\n\u003cli\u003eCommercial licence, use in your own business, not for resale\u003c\/li\u003e\n\u003cli\u003eInstant digital download, no physical item shipped\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eSmall print\u003c\/h4\u003e\n\u003cp\u003eTemplate only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.\u003c\/p\u003e","brand":"SiteSums","offers":[{"title":"Default Title","offer_id":58622771659096,"sku":null,"price":15.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1005\/9166\/5496\/files\/materials-order-tracker-excel-template-08-macbook-ipad.jpg?v=1790977936","url":"https:\/\/sitesums.co.uk\/products\/materials-order-tracker-excel-template","provider":"SiteSums","version":"1.0","type":"link"}