Budget 2014 -15 and Portfolio Budget Statements (PBS) - Tables and Data

The 2014 15 Budget is officially available at [budget.gov.au](http://budget.gov.au "budget.gov.au") as the authoritative source of Budget Papers (BPs) and Portfolio Budget Statement (PBS) documents. This dataset is a collection of data sources from the 2014 15 Budget, including:

* Selected Tables from the Budget Papers – Available after Budget Papers published on budget.gov.au (~7.30pm Budget night).
* Machine Readable Tables from Budget Papers – Available after Budget Papers published on budget.gov.au (~7.30pm Budget night).
* The Portfolio Budget Statement Excel spreadsheets – Available after PBSs tabled in the Senate (~8.30pm Budget night).
* A Machine Readable CSV of all PBS Excel Spreadsheet Line Items – Available after PBSs tabled in the Senate and translated (~8.30pm Budget night). First version published with 10 portfolios ~8:50pm Budget night. Work due to be competed by midday 14 May 2014.

Data from the 2014-15 Budget are provided to assist those who wish to analyse, visualise and programmatically access the 2014-15 Budget. It is the first time this has been done as per [our announcement blog post] (http://www.finance.gov.au/blog/2014/04/24/budget-2014-in-data-form "Budget 2014 in data form blog post"). We intend to move further down the digital by default route to make the 2015-16 Budget more accessible and reusable in data form. We welcome your feedback and comments below.  Data users should refer to footnotes and memoranda in the original files as these are not usually captured in machine readable CSVs.

This dataset was prepared by the Department of Finance and the Department of the Treasury. 

Information about the PBS Excel files and CSV
--------------------------------------------------------
The PBS Excel files published should include the following financial tables with headings and footnotes. Only the line item data (table 2.2) is available in CSV at this stage as we thought this would be the most useful PBS data to extract. Much of the other data is also available in the Budget Papers 1 and 4 in aggregate form:

* Table 1.1: Agency Resource Statement;
* Table 1.2: Agency 2014-15 Budget Measures;
* Table 2.1: Budgeted Expenses for Outcome X;
* Table 2.2: Programme Expenses and Programme Components.
* Table 3.1.1: Movement of Administered Funds Between Years;
* Table 3.1.2: Estimates of Special Account Flows and Balances;
* Table 3.1.3: Australian Government Indigenous Expenditure (AGIE);
* Tables 3.2.1 to 3.2.6: Departmental Budgeted Financial Statements; and
* Tables 3.2.7 to 3.2.11: Administered Budgeted Financial Statements.

Please note, total expenses reported in the csv file ‘2014-15 PBS line items dataset’ was prepared from individual agency programme expense tables. Totalling these figures does not produce the total expense figure in ‘Table1: estimates of general government expenses’ (Statement 6, Budget Paper 1).  Differences relate to:

1.      Intra agency charging for services which are eliminated for the reporting of general government financial statements; 

2.      Agency expenses that involve revaluation of assets and liabilities are reported as other economic flows in general government financial statements; and

3.       Additional  agencies’ expenses are included in general government sector expenses (e.g. Australian Strategic Policy Institute Limited and other entities) noting that only agencies that are directly government funded are required to prepare a PBS.

At this stage, the following Portfolios have contributed their PBS Excel files and are included in the line item CSV: 1.1 Agriculture Portfolio; 1.2 Attorney-General’s Portfolio; 1.3 Communications Portfolio; 1.4A Defence Portfolio; 1.4B Defence Portfolio (Department of Veterans’ Affairs); 1.5 Education Portfolio; 1.6 Employment Portfolio; 1.7 Environment Portfolio; 1.8 Finance Portfolio; 1.9 Foreign Affairs and Trade Portfolio; 1.10 Health Portfolio; 1.11 Immigration and Border Protection Portfolio; 1.12 Industry Portfolio; 1.13 Infrastructure and Regional Development Portfolio; 1.14 Prime Minister and Cabinet Portfolio; 1.15A Social Services Portfolio; 1.15B Social Services Portfolio (Department of Human Services); 1.16 Treasury Portfolio; 1.17A Department of the House of Representatives; 1.17B Department of the Senate; 1.17C Department of Parliamentary Services; and 1.17D Department of the Parliamentary Budget Office.

The original PBS Excel files and published documents include sub-totals and totals by agency and appropriation type which are not included in the line item CSV as these can be calculated programmatically. Where modifications are identified they will be updated as required. If a corrigendum to an agencies PBS is issued after budget night, tables will be updated as necessary. 

Below is the CSV structure of the line item CSV. The data transformation is expected to be complete by midday 14 May, so we have put up the incomplete CSV which will be updated as additional PBSs are transformed into data form. Please keep refreshing for now.

Portfolio, Department/Agency, Outcome, Program, Expense type, Appropriation type, Description, 2012-13, 2013-14, 2014-15, 2015-16, 2016-17, Source document, Source table, URL

Budget Paper Tables
--------------------------
We have made a number of data tables from Budget Papers 1 and 4 available in their original format as Excel or XML files. We have transformed a number of these into machine readable format (as prioritised by several users of budget data) which will be published here as they are ready. Below is the list of the tables published and whether we’ve translated them into CSV form this year: 

* Budget Paper 1 Overview Appendix C Major Intiatives (XLSX, CSV)
* Budget Paper 1 Overview Appendix D Major Savings (XLSX, CSV)
* Budget Paper 1 Statement 3 Table 5 Reconciliation of underlying cash balance estimates (XLSX, no CSV due to complexity)
* Budget Paper 1 Statement 5 Table 1 Australian Government general government receipts (XLSX, CSV)
* Budget Paper 1 Statement 5 Table 8 Australian Government general government (cash) receipts (XLSX, CSV)
* Budget Paper 1 Statement 5 (online tables) Australian Government (accrual) revenue (XLSX, CSV)
* Budget Paper 1 Statement 5 Table 11 Reconciliation of 2015-15 general government (accrual) revenue (XLSX, CSV)
* Budget Paper 1 Statement 6 Appendix A Table A1 Estimates of expenses by function and sub-function (XLSX, CSV)
* Budget Paper 1 Statement 10 Table 1 Australian Government general government sector receipts payments net Future Fund earnings and underlying cash balance (XLSX, CSV)
* Budget Paper 1 Statement 10 Table 4 Australian Government general government sector taxation receipts non taxation receipts and total receipts (XLSX, CSV)
* Budget Paper 1 Statement 10 Table 5 Australian Government general government sector net debt and net interest payments (XLSX, CSV)
* Budget Paper 4 Table 1.1 Agency Resourcing (xls, CSV coming)
* Budget Paper 4 Table 1.2 Special Appropriations (xlsx, CSV coming)
* Budget Paper 4 Table 1.3 Special Accounts (xlsx, CSV)
* Budget Paper 4 Table 2.2 Average Staffing Table  (xlsx, CSV coming)
* Budget Paper 4 Table 3.1 Departmental Expenses (xlsx, CSV coming)
* Budget Paper 4 Table 3.2 Net Capital Investment (xlsx, CSV coming)

Tags: budget, economy
Organization: Department of Finance