Annual Procurement Log and Threshold Tracker

Log every procurement in the year with its entity, vendor, method, value, funding source and award date, and the workbook checks each one against the threshold band in force on its award date, flags methods that look inconsistent with that band, scores file documentation completeness for its method and computes a retain-until date with a legal-hold flag. Consultants can track several entities in one file and roll counts, values and completeness up per entity, with a method × funding source cross-tabulation and a year-at-a-glance Summary. Thresholds and retention rules are not built into the formulas. They sit in dated reference rows, each with its citation, and you confirm every row against its cited source and your own policy before you rely on it. Every flag, percentage and date is computed from those rows and your entries.