Council Expenditure or Payment to Suppliers
Nikhil Prabhu made this Freedom of Information request to Pembrokeshire County Council
This request has been closed to new correspondence. Contact us if you think it should be reopened.
Dear Pembrokeshire Council,
I'd like to make a request under the Freedom of Information act for all transactions over £500 from 1st April 2017 to 31st December 2018 (if December 2018 is not available, then, November 2018). Please provide the data in a machine readable format (preferably csv). As a minimum, please make sure to include the date, value and recipient of each transaction. Please also provide details on the procurement category of each transaction if you have it.
For the avoidance of doubt, I am making this request under the Freedom of Information Act. I await your response within 20 working days.
Yours faithfully,
Nikhil Prabhu
If you have received this email in error, please notify us by telephone on
01437 764551 and delete it from your computer immediately. Os ydych chi
wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod
inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith
oddi ar eich cyfrifiadur.
Thank you for contacting Pembrokeshire County Council. We acknowledge
receipt of your request for information.
Depending upon the nature of your request it will be processed under the
Freedom of Information Act 2000, or the Environmental Information
Regulations 2004.
In either case a response will be issued no later than 06/02/2019, which
is the 20 working day statutory timescale. If we require additional time
we will inform you in accordance with the legislation.
Responses to requests for information are routinely published on the
Council’s website: [1]disclosure log. If you find the information you
have requested is already available on our website please contact us to
cancel your request.
The Freedom of Information Team’s Fair Processing Notice, is available on
our website:
[2]https://www.pembrokeshire.gov.uk/privacy...
Kind regards,
[3]cid:image001.jpg@01D41443.6BD4F5B0Jodie Aylward
Administrative Assistant, The FOI Team
Cynorthwyydd Gweinyddol, Y Tîm RhG
Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
Tel / Ffon: 01437 775272
Email / E-bost: [4][email address]
Publication Scheme: [5]https://www.pembrokeshire.gov.uk/publica...
Cynllun Cyhoeddi: [6]https://www.sir-benfro.gov.uk/cynllun-cy...
Disclosure Log:
[7]https://www.pembrokeshire.gov.uk/freedom...
Cofnod Datgeliadau:
[8]https://www.sir-benfro.gov.uk/rhyddid-gw...
P Think Green – Please consider the environment when printing this email.
Fynd yn Ecolegol - Os gwelwch yn dda ystyriwch yr amgylchedd cyn
argraffu’r e-bost hwn.
Dim ond y sawl y mae'r ddogfen hon wedi'i chyfeirio atynt ddylai ei
darllen, a'i defnyddio ganddynt ar gyfer ei dibenion bwriadedig; ac ni
ddylid fel arall ei hatgynhyrchu, copio, lledaenu, datgelu, addasu,
dosbarthu, cyhoeddi na'i rhoi ar waith chwaith. Os ydych chi wedi derbyn
yr e-bost hwn trwy gamgymeriad, byddwch cystal a rhoi gwybod i ni ar
unwaith trwy ffonio 01437 764551 a'i ddileu oddi ar eich cyfrifiadur ar
unwaith. Ni ddylid rhoi'r cyfeiriad e-bost i unrhyw drydydd parti na'i
ddefnyddio ar gyfer unrhyw ddiben arall chwaith.
Gwefan Cyngor Sir Penfro - [11]http://www.sir-benfro.gov.uk
Sylwer: Mae negeseuon e-bost sy’n cael eu hanfon a’u derbyn yn cael eu
monitro’n rheolaidd ar gyfer cydymffurfio â’n Diogelwch TG, a’n Polisi
E-bost/Rhyngrwyd.
Mae'r llofnod hwn hefyd yn cadarnhau bod y neges e-bost hon wedi cael ei
harchwilio am fodolaeth firysau cyfrifiadurol a chod maleisus.
Cyngor Sir Penfro
Rhif ffôn 01437 764551
E-bost [12][email address]
Rydym yn croesawu gohebiaeth yn Gymraeg a Saesneg a byddwn yn ymateb cyn
pen 15 diwrnod gwaith fan bellaf. Byddwn yn ymateb yn yr un iaith â’r
ohebiaeth a dderbyniwyd (oni bai eich bod yn gofyn i ni wneud yn wahanol).
Os am gopi mewn print mawr, fformat hawdd ei ddarllen, Braille, sain neu
mewn iaith arall, cysylltwch â’r person a anfonodd yr e-bost hwn.
***************************************************************************************************************
References
Visible links
1. https://www.pembrokeshire.gov.uk/freedom...
2. https://www.pembrokeshire.gov.uk/privacy...
4. mailto:[email address]
5. https://www.pembrokeshire.gov.uk/publica...
6. https://www.sir-benfro.gov.uk/cynllun-cy...
7. https://www.pembrokeshire.gov.uk/freedom...
8. https://www.sir-benfro.gov.uk/rhyddid-gw...
9. http://www.pembrokeshire.gov.uk/
10. mailto:[email address]
11. http://www.sir-benfro.gov.uk/
12. mailto:[email address]
If you have received this email in error, please notify us by telephone on
01437 764551 and delete it from your computer immediately. Os ydych chi
wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod
inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith
oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
This is to inform you that your request has been considered and our
response is provided in the attached document. We trust this information
meets your requirements at this time and we believe this request is
complete and now closed. Should any further information be requested
regarding this topic, a separate request will need to be submitted.
If you believe you have not been provided with the information you
requested, you have the right to request an internal review. Internal
review requests should be submitted within two months of the date of
receipt of the response to your original request, and should be addressed
to:
Katy Holman
Information Governance & Freedom of Information Officer
Pembrokeshire County Council
County Hall
Haverfordwest
SA61 1TP
[1][Pembrokeshire County Council request email]
If you are not satisfied following the outcome of a review, you can make
an appeal to the Information Commissioner, who is the statutory regulator.
The Information Commissioner can be contacted at:
Information Commissioner’s Office
2^nd Floor,
Churchill House
Churchill Way
Cardiff
CF10 2HH
[2]www.informationcommissioner.gov.uk
Kind regards,
The FOI Team
Pembrokeshire County
Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
Tel / Ffon: 01437 77 5272 /
5380
Email / E-bost:
[3][Pembrokeshire County Council request email]
Publication Scheme: [4]https://www.pembrokeshire.gov.uk/publica...
Cynllun Cyhoeddi: [5]https://www.sir-benfro.gov.uk/cynllun-cy...
Disclosure Log:
[6]https://www.pembrokeshire.gov.uk/freedom...
Cofnod Datgeliadau:
[7]https://www.sir-benfro.gov.uk/rhyddid-gw...
Dear Freedom Of Information, Ms. Katy Holman,
Thank you for your response of 29 January 2019.
However, I noticed that your file "Pembrokeshire Council Response Supplier Payments via Creditors.xls" contains duplicate sheets 2017-18 and Apr-Dec18. Could you please check and revert?
Also, we require the monthly breakups of the Supplier Spend data for the Creditors file (instead Spend data for the entire year 2017-18 and Apr-Dec18 was sent). You supplied the monthly data in your other Purchase Card payments file. Could you please re-send the Creditors data with the monthly transactions? Hope it should not be too much of a bother with the accounting software! I sincerely appreciate your help in this matter.
Yours faithfully,
nikhil prabhu
Dear Nikhil Prabhu,
Thank you for your email. You are indeed correct, somehow the data has been duplicated on the Creditors spreadsheet. The correct spreadsheet is attached.
We can only provide the data for the year, not every transaction, as we do not have this facility. We do have the Public Inspection of Accounts during the month of June every year. During that month members of the public can see all transactions (non-personal) that have been made to suppliers throughout the previous year.
Kind regards,
Katy
Katy Holman
Information Governance & Freedom of Information Officer /
Swyddog Llywodraethu Gwybodaeth a Rhyddid Gwybodaeth
Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
Tel / Ffon: 01437 775380
Email / E-bost: [email address]
Publication Scheme: https://www.pembrokeshire.gov.uk/publica...
Cynllun Cyhoeddi: https://www.sir-benfro.gov.uk/cynllun-cy...
Disclosure Log: https://www.pembrokeshire.gov.uk/freedom...
Cofnod Datgeliadau: https://www.sir-benfro.gov.uk/rhyddid-gw...
Dear Freedom Of Information, Ms. Holman, Katy,
Thank you for your response of February 4th, unfortunately, it seems you have sent the same file over again (with duplicate sheets for 2017-2018 and Apr-Dec 2018. Could you please revert with the correct file. My apologies, I seemed to have missed this the first time around. i.e., "Response Supplier Payments via Creditors 2.xls" is the same as "Response Supplier Payments via Creditors.xls".
Also, if at all possible, please do provide the monthly breakups of the data as well, otherwise we cannot categorize the data accurately.
Yours sincerely,
nikhil prabhu
Dear Freedom Of Information,
Could you please acknowledge my previous message.
Thank you,
sincerely,
nikhil prabhu
If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
Apologies for the delay in responding to your email. To clarify I have sent your request to the contact officer who was dealing with your request, and once I receive a response I will forward this onto you.
Kind Regards,
Jodie Aylward
Administrative Assistant, The FOI Team
Cynorthwyydd Gweinyddol, Y Tîm RhG
C:Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
: 01437 775272 : [email address]
Publication Scheme: https://www.pembrokeshire.gov.uk/publica... / Disclosure Log: https://www.pembrokeshire.gov.uk/freedom...
Cynllun Cyhoeddi: https://www.sir-benfro.gov.uk/cynllun-cy... / Cofnod Datgeliadau: https://www.sir-benfro.gov.uk/rhyddid-gw...
Think Green – Please consider the environment when printing this email.
Fynd yn Ecolegol - Os gwelwch yn dda ystyriwch yr amgylchedd cyn argraffu’r e-bost hwn.
If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
Apologies for the delay, please see below the contact officers response:
'I don't think the spreadsheet is duplicated. The spreadsheet 17-18 relates to financial year 2017-18 (ie April 2017 - March 2018) and then the second spreadsheet is April -Dec 2018. His request was for April 2017 - December 2018.
I am unable to provide a monthly transaction break down for Creditor Payments.'
Kind Regards,
Jodie Aylward
Administrative Assistant, The FOI Team
Cynorthwyydd Gweinyddol, Y Tîm RhG
C:Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
: 01437 775272 : [email address]
Publication Scheme: https://www.pembrokeshire.gov.uk/publica... / Disclosure Log: https://www.pembrokeshire.gov.uk/freedom...
Cynllun Cyhoeddi: https://www.sir-benfro.gov.uk/cynllun-cy... / Cofnod Datgeliadau: https://www.sir-benfro.gov.uk/rhyddid-gw...
Think Green – Please consider the environment when printing this email.
Fynd yn Ecolegol - Os gwelwch yn dda ystyriwch yr amgylchedd cyn argraffu’r e-bost hwn.
Dear Freedom Of Information, Ms. Jodie Aylward, Sir/Ma'am,
Thank you for your response last week. The spreadsheet is indeed not duplicated and we do sincerely apologize for that oversight and any inconvenience caused. However, we are disappointed in your response w.r.t. the data without corresponding transaction dates.
The Data appears to have been transferred from the accounting system onto a pivot table. The pivot shows the supplier name - number of transactions and total amount paid in that period. What we want is to break the number of transactions into their date and their component spend. The pivot table should be able to do this.
We need this as we are a research organisation who are trying to create data analytics and then create AI in Health and Social Care in the UK. Without this information we are unable to create this vision.
As an accountant myself, this job should take no more than 5 minutes and would appreciate your assistance in this matter.
Yours Faithfully,
Nikhil Prabhu
Thank you for contacting Pembrokeshire County Council. We acknowledge
receipt of your request for information.
Depending upon the nature of your request it will be processed under the
Freedom of Information Act 2000, or the Environmental Information
Regulations 2004.
In either case a response will be issued no later than 08/05/2019, which
is the 20 working day statutory timescale. If we require additional time
we will inform you in accordance with the legislation.
Responses to requests for information are routinely published on the
Council’s website: [1]disclosure log. If you find the information you
have requested is already available on our website please contact us to
cancel your request.
The Freedom of Information Team’s Fair Processing Notice, is available on
our website:
[2]https://www.pembrokeshire.gov.uk/privacy...
Kind regards,
[3]cid:image001.jpg@01D41443.6BD4F5B0Jodie Aylward
Administrative Assistant, The FOI Team
Cynorthwyydd Gweinyddol, Y Tîm RhG
+:Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
': 01437 775272 ;: [4][email address]
Publication Scheme: [5]https://www.pembrokeshire.gov.uk/publica... /
Disclosure Log:
[6]https://www.pembrokeshire.gov.uk/freedom...
Cynllun Cyhoeddi: [7]https://www.sir-benfro.gov.uk/cynllun-cy... / Cofnod
Datgeliadau:
[8]https://www.sir-benfro.gov.uk/rhyddid-gw...
P Think Green – Please consider the environment when printing this email.
Fynd yn Ecolegol - Os gwelwch yn dda ystyriwch yr amgylchedd cyn
argraffu’r e-bost hwn.
Dear Freedom Of Information, Ms. Holman Katy, Ms. Jodie Aylward, Sir/Ma'am,
Do you perchance have an update for me?
As per my previous message, it should be but a simple use of the pivot table Excel function.
Thanking you,
Yours sincerely,
nikhil prabhu
If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
Thank you for your email, your request for information will be issued no later than 08/05/2019, which is the 20 working day statutory timescale. If we require additional time we will inform you in accordance with the legislation.
Kind Regards,
Jodie Aylward
If you have received this email in error, please notify us by telephone on
01437 764551 and delete it from your computer immediately. Os ydych chi
wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod
inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith
oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
We apologise for the delay in responding to your request for information,
and for any inconvenience this may have caused you.
This is to inform you that your request has been considered and our
response is provided in the attached document. We trust this information
meets your requirements at this time and we believe this request is
complete and now closed. Should any further information be requested
regarding this topic, a separate request will need to be submitted.
If you believe you have not been provided with the information you
requested, you have the right to request an internal review. Internal
review requests should be submitted within two months of the date of
receipt of the response to your original request, and should be addressed
to:
Katy Holman
Information Governance & Freedom of Information Officer
Pembrokeshire County Council
County Hall
Haverfordwest
SA61 1TP
[1][Pembrokeshire County Council request email]
If you are not satisfied following the outcome of a review, you can make
an appeal to the Information Commissioner, who is the statutory regulator.
The Information Commissioner can be contacted at:
Information Commissioner’s Office
2^nd Floor,
Churchill House
Churchill Way
Cardiff
CF10 2HH
[2]www.informationcommissioner.gov.uk
Kind regards,
[3]cid:image001.jpg@01D4C869.7501CAC0 The FOI Team
Pembrokeshire County
Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
Tel / Ffon: 01437 77 5272 /
5380
Email / E-bost:
[4][Pembrokeshire County Council request email]
Publication Scheme: [5]https://www.pembrokeshire.gov.uk/publica...
Cynllun Cyhoeddi: [6]https://www.sir-benfro.gov.uk/cynllun-cy...
Disclosure Log:
[7]https://www.pembrokeshire.gov.uk/freedom...
Cofnod Datgeliadau:
[8]https://www.sir-benfro.gov.uk/rhyddid-gw...
Dear Freedom Of Information, Ms. Katy Holman,
Thank you for your response of 10 May, with the data sheet.
Would it be possible for your to please re-send the data in a CSV file format ?
I am unable to open the Excel sheet format you have sent over "FOI Response 9554.xlsx".
Yours sincerely,
nikhil prabhu
Dear Nikhil Prabhu,
Thank you for your email. Just to let you know, I have contacted the contact officer regarding your request, and once I have received a response I will contact you further.
Kind Regards,
Jodie Aylward
Administrative Assistant, The FOI Team
Cynorthwyydd Gweinyddol, Y Tîm RhG
C:Pembrokeshire County Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
: 01437 775272 : [email address]
Publication Scheme: https://www.pembrokeshire.gov.uk/publica... / Disclosure Log: https://www.pembrokeshire.gov.uk/freedom...
Cynllun Cyhoeddi: https://www.sir-benfro.gov.uk/cynllun-cy... / Cofnod Datgeliadau: https://www.sir-benfro.gov.uk/rhyddid-gw...
Think Green – Please consider the environment when printing this email.
Fynd yn Ecolegol - Os gwelwch yn dda ystyriwch yr amgylchedd cyn argraffu’r e-bost hwn.
Dear Nikhil Prabhu,
Apologies for the delay, I have spoken with both the contact officer, who had dealt with your request and with my senior officer, and unfortunately we are unable to provide you the data in a CSV file format. We are only able to provide the response in excel or PDF.
Kind Regards,
The FOI Team
[Pembrokeshire County Council request email]
Dear Freedom Of Information,
I see. Ok. Would you please send the response in PDF format over then?
Thank you!
Yours sincerely,
nikhil prabhu
Dear Freedom Of Information,
Would you please re-send the file in PDF format?
Yours sincerely,
nikhil prabhu
Dear Freedom Of Information,
We would appreciate it if you would please send the PDF file version through, as we are unable to open the Excel sheet.
Thank you,
Yours sincerely,
nikhil prabhu
Dear Freedom Of Information,
Did you receive my previous message?
Yours sincerely,
nikhil prabhu
Dear Freedom Of Information,
May I please request an update (file in PDF format)?
Thank you!
Yours sincerely,
nikhil prabhu
If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.
Dear Nikhil Prabhu,
Your response to your request for information has been responded to on 4 different occasions now. Please check your emails dated the 17/05/19, 22/05/19, 28/05/19 and the 04/06/19. If you have any issues opening these please let us know.
Kind Regards,
Jodie
Dear Freedom Of Information, Ms. Jodie,
I understand that you have provided me with a response earlier, with Excel data, however, I have replied saying we are unable to open that file and hence requested you to please provide the same response in CSV or PDF format.
Sir/Ma'am: The Excel file seems to be corrupted. Hence, please do provide the same in CSV or PDF format.
Thank you and apologies for the misunderstanding and any inconvenience caused.
Yours sincerely,
Nikhil Prabhu
Dear Freedom Of Information,
May I please request an update?
Thank you!
Yours sincerely,
nikhil prabhu
Dear Nikhil Prahbu,
Attached is the response to your request. These were sent to you on four
separate occasions 17/05/19, 22/05/19, 28/05/19 and the 04/06/19. If you
have any problems opening the documents please do not hesitate to get in
touch with us
Kind Regards,
Caitlin Jennings
[1]cid:image001.jpg@01D4C869.7501CAC0 The FOI Team
Pembrokeshire County
Council / Cyngor Sir Benfro
County Hall / Neuadd y Sir
Haverfordwest / Hwlffordd
SA61 1TP
Tel / Ffon: 01437 77 5272 /
5380
Email / E-bost:
[2][Pembrokeshire County Council request email]
Publication Scheme: [3]https://www.pembrokeshire.gov.uk/publica...
Cynllun Cyhoeddi: [4]https://www.sir-benfro.gov.uk/cynllun-cy...
Disclosure Log:
[5]https://www.pembrokeshire.gov.uk/freedom...
Cofnod Datgeliadau:
[6]https://www.sir-benfro.gov.uk/rhyddid-gw...
Dear Freedom Of Information,
Thank you so much for this! We were now able to open the (PDF) file attached.
For some reason we did not receive this attachment in your previous replies, for that please accept my sincerest apologies and for any misunderstanding/miscommunication.
Yours sincerely,
nikhil prabhu
We work to defend the right to FOI for everyone
Help us protect your right to hold public authorities to account. Donate and support our work.
Donate Now