Open Data / Information
Spending / Invoices over £500
We are now publishing details of items that we spend over £500 to improve openness and transparency in public spending.
The data is taken directly from the Council's financial management system, and is presented in a raw 'CSV' format. You can open this file type using various software packages including Microsoft Excel. This format therefore allows the data to be interrogated easily.
There are some items of expenditure that are excluded from the reports. These are:
Where a payment is to an individual or a sole trader, the name of the individual has been removed as this information is protected under the Data Protection Act 1998. Approval for publication of their names has been sought and may be released at a later date should they agree.
We will publish data monthly and have backdated our publication of data to 1 April 2010.
The data is taken directly from the Council's financial management system, and is presented in a raw 'CSV' format. You can open this file type using various software packages including Microsoft Excel. This format therefore allows the data to be interrogated easily.
The reports show several items of information for each entry.
The information contained for each entry (along with the 'key') is shown below:
| Field name within file
|
Field description
|
|---|---|
| Service_Area_Categorisation
|
Service to which the spend has been allocated
|
| Service_Division_Categorisation
|
General service area to which this service fits within the Council's provision
|
| Responsible_Unit |
The management area responsible for that service
|
| Expenses_Type
|
General expenditure type
|
| Detailed_Expenses_Type
|
Type of expenditure that this spend has been allocated to.
|
| Expense_Code
|
Code used by the Council to depict the Expenditure type
|
| Narrative
|
A description of spend
|
| Date
|
Date of payment
|
| Transaction_Number
|
Reference used by the Council to identify this spend
|
| SumOfAmount_Inc_VAT
|
Amount allocated to that service and expenditure type including VAT
|
| SumOfAmount_Exc_VAT
|
Amount allocated to that service and expenditure type excluding VAT
|
| Capital_Revenue
|
Reference as to whether the spend is on the Revenue Account, Balance Sheet or a Capital Scheme
|
| Supplier_Name
|
Name of the supplier who the Council procured the goods / service from
|
| Supplier_ID
|
Reference within the Financial Management System for the Supplier
|
| Contract_ID
|
Link to any current contracts (currently N/A)
|
There are some items of expenditure that are excluded from the reports. These are:
- Payments of less than £500
- Banking investments
- Payroll Information
- Severance Payments
- Settlement and Compensation Payments
Where a payment is to an individual or a sole trader, the name of the individual has been removed as this information is protected under the Data Protection Act 1998. Approval for publication of their names has been sought and may be released at a later date should they agree.
Where payments under £500 appear in a report, this will be either because once the VAT element is included the total is more than £500, or because an invoice for more than £500 has been broken down across different areas of expenditure.
This data is freely re-usable under the same terms as data.gov.uk recommend.
The 'CSV' format uses a standard column width and not all entries may be completely visible. To view all the data, you will need to expand the columns. You can do this by selecting all the cells in the file (the grey box beside column A and above row 1), and then clicking on Format > Column > AutoFitSelection.
Any requests for more details about these items will be dealt with under freedom of information requests.
Using our data
All data on this site is subject to the Open Government Data Licence, details of which can be found at http://www.nationalarchives.gov.uk/doc/open-government-licence.
