Free Excel managed-spend policy and exclusions register with synthetic examples, editable inputs, live formulas and clear review states.
Free Excel workbook, no sign-up. The formulas are live, and sample rows show how it fills in: replace them with your own.
Download managed-spend-classification-register.xlsx
| Rule ID | Category | Addressable? | Broad policy test | Strict policy test | Evidence reference | Owner | Policy version | Agreed date | Policy status |
|---|---|---|---|---|---|---|---|---|---|
| MS-01 | IT | Yes | Contract or approved supplier | Contract and approved route | POL-IT | Owner A | 1.0 | 10/1/2026 | Complete |
| MS-02 | Payroll | No | Excluded | Excluded | POL-PAY | Owner B | 1.0 | 10/1/2026 | Complete |
| MS-03 | Marketing | Unknown | Contract or approved supplier | Contract and approved route | POL-MKT | Owner C | 1.0 | 10/1/2026 | Unresolved scope |
| MS-04 | Facilities | Yes | Contract or approved supplier | Contract and approved route | POL-FAC | Owner A | 1.0 | Awaiting agreement |
This managed-spend policy and exclusions register records the definition a procurement report will apply. It separates whether a category is addressable from what counts as managed under a broad or strict test. The workbook is an agreement artifact with live completeness counts. The companion spend-under-management workbook performs invoice calculations; this register keeps the selected policy defensible.
Each rule has a category, addressability decision, broad and strict tests, evidence reference, owner, version and agreement date. The sample broad test accepts a contract or approved supplier. The strict test requires a contract and approved route. These are clearly defined example policies, not external benchmark definitions. Record different tests if that is what your organization agrees, and carry the resulting version into the later report.
Keep the amber inputs separate from the pale blue calculation columns. The worksheet has 20 prefilled detail rows, from 13 through 32. If you need more records, extend every affected formula and summary range together, then check a first, middle and final row. Save a dated working copy before replacing the sample.
The sample agrees that IT is addressable and payroll is excluded under version 1.0. Marketing’s scope is Unknown and facilities lacks an agreement date. The summary therefore has one agreed addressable category, one agreed excluded category and two unresolved rules. Giving marketing an evidence reference alone cannot settle its addressability decision.
Policy status checks the addressability decision, both test descriptions, evidence, owner and version before testing agreement. An Unknown scope remains Unresolved scope. Counts use only Complete records for agreed addressable or excluded categories. These formulas measure specification completeness and do not classify invoice amounts or automatically treat approved suppliers as contracted suppliers.
A recorded policy can differ from a published benchmark or another organization’s definition. Comparisons require the same numerator, denominator and time basis. This artifact does not determine which categories procurement should influence, validate contract coverage or establish savings. When the policy changes, explain the reclassification separately from a real change in purchasing. Keep the previous version and its effective date in your reporting records.
For the underlying method, read spend under management. what is a good spend under management covers the adjacent question. If you want to review the required fields and one reporting output, discuss your setup. Views depend on your records and agreed definitions.
No. Every identifier, amount and policy choice in the sample is synthetic. Replace the sample before using the workbook for your own review.
Edit the amber input cells. Keep the pale blue calculated columns and summary formulas. The prefilled detail area supports rows 13 through 32; extend formulas and summary ranges together for a larger file.
No. It is a manual Excel workbook. If you want to discuss recurring reporting, bring one question and the relevant file structure to Covirage.