Budget 2017-18 and Portfolio Budget Statements (PBS) - Tables and Data

The 2017-18 Budget is officially available at 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 2017-18 Budget, including:

• PBS Excel spreadsheets (including Table 2.X.1 Budgeted Expenses for OutcomeX in machine readable format) – available after PBSs are tabled in the Senate (~8.30pm Budget night); and
• Selected tables from Budget Paper No. 4 (including in machine readable format) – available after the BPs are published on budget.gov.au (~7.30 pm Budget night).

Data from the 2017-18 Budget is provided to assist those who wish to analyse and visualise key elements of the 2017-18 Budget.

Data users should refer to footnotes and memoranda in the original files as these are not usually captured in machine readable CSVs.

We welcome your feedback and comments below.

This dataset was prepared by the Department of Finance.

Information about the PBS Excel files and CSV

The PBS Excel files published should include the following financial tables with headings and footnotes, which are also are available in CSV. Much of the other data is also available in Budget Papers Nos. 1 and 4 in aggregate form:

• Table 1.1: Entity Resource Statement;
• Table 1.2: Entity 2017-18 Budget Measures;
• Table 2.X.1: Budgeted Expenses for OutcomeX;
• Table 2.X.2: Program Component Expenses;
• Table 3.1.1 to 3.6: Departmental Budgeted Financial Statements; and
• Tables 3.7 to 3.11: Administered Budgeted Financial Statements.

Please note, total expenses reported in the CSV file ‘2017-18 PBS line items dataset’ were prepared from individual entity program 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 entity charging for services which are eliminated for the reporting of general government financial statements;
2. Entity expenses that involve revaluation of assets and liabilities are reported as other economic flows in general government financial statements; and
3. Additional entities’ expenses are included in general government sector expenses (e.g. Australian Strategic Policy Institute Limited and other entities) noting that only entities that receive funding (either directly or via portfolio department through the annual appropriation acts.

The original PBS Excel files and published documents include sub-totals and totals by entity and appropriation type which are not included in the line item CSV. These can be calculated programmatically. Where modifications are identified they will be updated as required.

If a corrigendum to an entity’s PBS is issued after budget night, tables will be updated as necessary.

The structure of the line item CSV is:

• Portfolio
• Department/Entity
• Outcome
• Program
• Expense type
• Appropriation type
• Description
• 2016-17
• 2017-18
• 2018-19
• 2019-20
• 2020-2021
• Source document
• Source table
• URL

The following Portfolios are included in the line item CSV:

• Agriculture and Water Resources
• Attorney-General's
• Communication and the Arts
• Defence
• Education and Training
• Employment
• Environment and Energy
• Finance
• Foreign Affairs and Trade
• Health
• Human Services
• Immigration and Border Protection
• Industry, Innovation and Science
• Infrastructure and Regional Development
• Prime Minister and Cabinet
• Social Services
• Human Services
• Treasury
• Veterans' Affairs
• Department of the House of Representatives
• Department of the Senate
• Department of Parliamentary Services
• Parliamentary Budget Office

Budget Paper Tables

The list below shows the data tables from the Budget Papers which are available in Excel and CSV formats.

• Budget Paper 4 Table 1.1 – Agency Resourcing
• Budget Paper 4 Table 1.2 – Special Appropriations
• Budget Paper 4 Table 1.3 – Special Accounts
• Budget Paper 4 Table 2.2 – Staffing Tables
• Budget Paper 4 Table 3.1 – Departmental Expenses
• Budget Paper 4 Table 3.2 – Net Capital Investment

Change Log

1. 09:30 15/05/2017 Updated machine-readable CSV file for Program Expenditure Components where applicable. Agencies updated were Australian Taxation Office, Department of Education, Department of Foreign Affairs and Trade, Department of Industry, Innovation and Science, Department of Infrastructure and Regional Development, Department of Prime Minister & Cabinet, Department of Social Services, Department of the Treasury and Department of Veterans’ Affairs