Cash flow and balance sheet for each public body included in the whole of government accounts.

Waiting for an internal review by Her Majesty’s Treasury of their handling of this request.

Dear Her Majesty’s Treasury,

I was pleased to see the audited Whole of Government Accounts published on Tuesday:

http://www.hm-treasury.gov.uk/psr_govern...

I would like to request the balance sheet and cash flow statement for each body included in the report, in spreadsheet format.

Yours faithfully,

Lisa Evans

Enquiries, CEU - HMT, Her Majesty’s Treasury

Dear Ms Evans

Thank you for your Freedom of Information request. I write to confirm receipt of your request and to let you know that it is receiving attention. If you have any enquiries regarding your request do not hesitate to contact us.

Regards

Sian

show quoted sections

responses, FOI - HMT, Her Majesty’s Treasury

1 Attachment

Ms Evans,

Please find attached our reply to your recent FOI request.

Regards

Information Rights Unit

show quoted sections

Dear responses, FOI - HMT,

Thank you for your reply to my Freedom of Information Request.

You replied to say that the information I requested would be available in the next COINS release on the data.gov.uk website.

The COINS data containing the WGA is now available at:

https://s3-eu-west-1.amazonaws.com/ukhmg...

and

https://s3-eu-west-1.amazonaws.com/ukhmg...

However the guidance provided to the COINS data here:

http://www.hm-treasury.gov.uk/d/coins_gu...

is insufficient to extract the cash flow, balance sheet and profit and loss statement for each of the 1,500 public bodies included in the WGA.

Could you either:

1) update the guidance so it includes a section on how to extract the cash flow, balance sheet and profit and loss statement for each of the 1,500 public bodies included in the WGA

or

2) add the cash flow, balance sheet and profit and loss statement for each of the 1,500 public bodies included in the WGA to the COINS page of data.gov.uk

Many thanks

Yours sincerely,

Lisa Evans

Enquiries, CEU - HMT, Her Majesty’s Treasury

Dear Ms Evans,

Thank you for your e-mail dated 3 January.

I am writing to confirm receipt and to inform you that your enquiry is receiving attention.  We aim to reply to all correspondence within 15 working days of receipt.

Regards,

Sian

show quoted sections

Hughes, Jim - HMT, Her Majesty’s Treasury

Lisa,

 

I have been asked to consider your request of 3 January to provide
guidance on extracting data for the above.

 

We recognise the recent data release contains a huge amount of data. 
Before formally respond to you, I feel it may be useful to get together in
advance to discuss your requirements and for us to explain in more detail
what is contained in the release, the limitations of the data
(particularly if you are considering trying to ‘recreate’ the 2009-10
Whole of Government Account), and what options are available to extract
the data you need.  Please let me know if you would find this useful and,
if so, let me have some dates / times for such a meeting.

Regards,

Jim

Jim Hughes
HMT Whole of Government Accounts | Financial Management and Reporting
Group
1 Horse Guards Road, London, SW1A 2HQ
Tel: 020 7270 5748 | [mobile number] | E-mail:
[email address]

 

show quoted sections

Dear Hughes, Jim - HMT,

I'm not trying to recreate the WGA - I'm asking how to extract the financial statements for any of the 1,500 authorities included in WGA as I've clearly stated.

I don't think I can be any more clear than I have been about my requirements but I would be willing to meet if you need further clarfication.

Yours sincerely,

Lisa Evans

Hughes, Jim - HMT, Her Majesty’s Treasury

Lisa,

Apologies for not coming back to before now.

I do understand your request. Nonetheless, and as you will appreciate, we use the reporting capabilities of COINS to extract and analyse the relevant data we need to construct WGA in the format we require. We do not have a specific tool to extract the data from www.data.gov.

We have a number of Excel tools that may be of some use. These extract data from COINS reports converted to an Excel format. I not sure, however, whether, as developed, these will provide the level of detail you require. For example, our balance sheet and cash flow statement are at a fairly high level - is this the level of detail you want?

I am very happy to run through these tools with you at any time.

Regards,
Jim
Jim Hughes
HMT Whole of Government Accounts | Financial Management and Reporting Group
1 Horse Guards Road, London, SW1A 2HQ
Tel: 020 7270 5748 | [mobile number] | E-mail: [email address]

show quoted sections

Dear Hughes, Jim - HMT,

Thank you for your reply. It is fine that the data is high level.

I'd like to take you up on the kind offer to show me how you can extract individual sets of acounts from COINS.

Let me know a good time.

Yours sincerely,

Lisa Evans

Hughes, Jim - HMT, Her Majesty’s Treasury

Lisa,

Some suitable dates for us would be:

Wednesday, 18th January (PM)
Thursday, 19th January (AM)
Tuesday, 24th January (PM)
Wednesday 25th January (AM/PM)

Please let me know if any of these times suit.

Regards,
Jim
Jim Hughes
HMT Whole of Government Accounts | Financial Management and Reporting Group
1 Horse Guards Road, London, SW1A 2HQ
Tel: 020 7270 5748 | [mobile number] | E-mail: [email address]

show quoted sections

Dear Hughes, Jim - HMT,

Wednesday 25th AM is good for me, ideally at 9:00 or thereabouts.

Many thanks,

Yours sincerely,

Lisa Evans

Hughes, Jim - HMT, Her Majesty’s Treasury

Lisa,

Wednesday, 9.00 should be fine. Please come to the reception at Horse Guards Road and ask for me.

Regards,
Jim
Jim Hughes
HMT Whole of Government Accounts | Financial Management and Reporting Group
1 Horse Guards Road, London, SW1A 2HQ
Tel: 020 7270 5748 | [mobile number] | E-mail: [email address]

show quoted sections

Dear Hughes, Jim - HMT,

Thank you I'll see you then.

Yours sincerely,

Lisa Evans

Lisa Evans left an annotation ()

At 9am on Wednesday 25th Jan 2012 I met six people from HM Treasury on their invitation. I took with me a lecturer in accountancy from the University of Birmingham.

The outcome of the meeting was that the people from HM Treasury agreed to:

- releaese a spreadsheet tool to analyse the COINS balance sheet data. This would be published on the COINS page of Data.gov.uk

- release the cash flow statments of all the UK local authorities (as it turns out they are not in the COINS release).

Since the meeting the FOI has been delayed by HM Treasury with no explanation in over a month.

I have emailed the WGA department twice in the past 4 weeks for an update but no reply.

Therefore I'm requesting an internal review.

Dear Her Majesty’s Treasury,

Please pass this on to the person who conducts Freedom of Information reviews.

I am writing to request an internal review of Her Majesty’s Treasury's handling of my FOI request 'Cash flow and balance sheet for each public body included in the whole of government accounts.'.

On Wednesday 25th Jan 2012 I met six people from HM Treasury on their invitation. I took with me a lecturer in accountancy from the University of Birmingham.

The outcome of the meeting was that the people from HM Treasury agreed to:

- release a spreadsheet tool to analyse the COINS balance sheet data. This would be published on the COINS page of Data.gov.uk

- release the cash flow statments of all the UK local authorities as they are not included in the latest COINS release HM Treasury refered me to in an earlier reply to this Freedom of Information Request.

Since the meeting on the 25th of Jan the FOI has been delayed by HM Treasury with no explanation in over a month.

I have emailed the WGA department twice in the past 4 weeks for an update but no reply.

Therefore I'm requesting an internal review.

A full history of my FOI request and all correspondence is available on the Internet at this address:
http://www.whatdotheyknow.com/request/ca...

Yours faithfully,

Lisa Evans

Looking for an EU Authority?

You can request documents directly from EU Institutions at our sister site AskTheEU.org . Find out more .

AskTheEU.org