spotlightonspend is an innovative online platform that seeks to deliver meaningful visibility of public sector spending on goods & services. To that end significant effort is required to improve the raw financial data such that it is accessible, relevant and of value to the general public. The work to effect the data improvement is undertaken by Spikes Cavell – a private sector organization that transforms and analyzes spend and related data for more than 1,000 public sector bodies worldwide to help them save money, address important policy related questions and, as a bi-product of those efforts, facilitate the delivery of transparency.
The functionality on this and related pages enables the download of multiple datasets where each dataset contains the transactions above $500 in value for a single public body before any cleansing, enrichment, aggregation or other data improvement has been made by Spikes Cavell other than;
- the identification and redaction of payments made to individuals,
- standardization of the file format (including column headings and positions).
The copyright in the raw financial data is owned by the public body that provided the raw data (the "Data Provider"). The Data Provider has elected to make the raw financial data freely-reusable by the general public.
Some users may experience a known Microsoft Excel bug when trying to 'Open' data files (http://support.microsoft.com/kb/213983 - the bug causes certain files not to be found). If you experience this problem, click the file and choose 'Save', rather than 'Open' and save a copy of the file to your desktop. You will then be able to open the file using Excel from your saved copy.
Reconciling £values in the Raw Data Download file to the External Spend with suppliers included in spotlightonspend
The External Spend in spotlightonspend (see Buying Entity -> Spend in Summary) shows Total Payments to Suppliers of Goods & Services where aggregated period spend is greater than $1,000.
The Raw Data Download files list all payments over $500 made in the period shown.
The total value of payments in the Raw Data Download file will usually be greater than the External Spend in spotlightonspend because the Raw Data Download file follows the Transparency Guidelines and additionally includes:
- Individual Payments to Suppliers over $500, but where the aggregate period spend with the supplier is less than $1,000.
- Redacted Payments
- Non-Trade items such as grants or payments to other Public Sector Bodies (where not classified as external trade/payments for goods & services).