Skip to main content
Guidance

How to analyse budgeting data and download reports

Updated 10 November 2026

There are several ways that users can review the overall position for control totals within budgeting. This guidance focuses on data that is in the live budgeting system (e.g. the last five available outturn years and five plans years).

There are methods to review data from snapshots e.g. to see data as at a certain publication time (for Estimates) or to review older outturn data no longer in the live system. More information is available about this here.

This page focusses on the following:

  • Downloading the ‘Extract - DAR Daily’ report
  • Reviewing data within the Data Input ‘Control Totals’ tab
  • Reviewing data within the Data Input ‘Control Totals Adjustment Tracker’ tab
  • Downloading Estimates reports

Downloading the ‘Extract - DAR Daily’ report

1) When logged onto OSCAR, click ‘Enter Data’, following by ‘Reports and Analysis’:

2) Click Budgets & Estimates, followed by Budgeting Homepage’

When on the homepage, click ‘Open Reporting’:

3) On the reporting Homepage, users can see a number of different reports to r un:

Under ‘Budgeting Reporting’ there are reports which will provide underlying data to capture what has been loaded to OSCAR budgeting.

  • Control Total Summary: This tab has the function to show the overall control totals for departments, plus their unallocated control totals.
  • Control Total Adjustment Tracker: Shows a date ordered, individual breakdown for single adjustments that have been loaded to the budgeting system.
  • Budgeting Data Extract: Also known as the ‘DAR’ (data analysis report), a report containing all underlying data and the main fields for analysis on OSCAR.
  • Submission Deadlines: Shows the latest updated submission deadlines for Main Estimates, Supplementary Estimates and Vote on Account. These should align to the dates given within the PES paper for each round.
  • Data Structures Report: A report for reviewing the latest structures on OSCAR.
  • Data Structures Report (Excel Book): The same as above, but can be downloaded for all tabs within excel.

Under ‘Publication Reports’: there are reports which can be run for Estimates, Vote on Account (VoA) and Common Core Tables.

Control Total Summary

The Control Total Summary report is designed to give departmental users a quick glance of their overall control totals (e.g. Resource DEL Admin or Capital DEL General Capital). It is also a tool to be able to see unallocated control totals. If there are unallocated control totals in confirmed status, it means that departmental users are required to disaggregate data by loading a disaggregation adjustment. For example, if a department receives a Reserve Claim for Resource DEL Prog, Non-ringfenced, this is loaded against ‘central codes’. It is for the department to disaggregate it against their specific account and sub-segment codes to specify where the budget will sit.

As an example, the below view shows the Total, Confirmed Control Totals for HM Treasury. This includes both disaggregated and unallocated data:

Users can select different filters to select data shown in different statuses (such as locked and submitted), as well as look at the unallocated totals. If there are no totals shown in the Unallocated Totals selection, in confirmed status, that means that there is nothing for the department to disaggregate. If there is data shown in the unallocated data filter (in confirmed status), this means that at least one disaggregation adjustment is required. For further analysis on what adjustment needs to be disaggregated, users can:

  • Refer to the disaggregation guidance on the How to Load Adjustments page.
  • Review the unallocated control totals in the Budgeting Data Extract Report
  • Review the Control Total Adjustments Tracker report to see the latest unallocated amounts received

Budgeting Data Extract Report

The Budgeting Data Extract Report (Also known as a ‘DAR’ or Data Analysis Report) gives users a cut of the underlying data and the most relevant, associated data fields to analyse their budgeting data.

To download a Budgeting Data Extract Report, navigate to the Reporting Homepage and select ‘Budgeting Data Extract Report’:

When the report loads, users can select their department, and choose an option for status (e.g. Confirmed) and the Version. It is recommended for users to run their reports for the Live version, unless they are looking up data for a historic plans year that has since been rolled over to an outturn year. Similarly, users might find it preferable to run a report for all statuses and filter accordingly when their report has been exported to Excel.

Users can either select one year, multi select 2 or more years, or run the report for all live years on system (the last five outturn years plus all five plans years). To improve report download times it is recommended for users to only download the years that are required. To make year selections, simply tick the relevant boxes followed by ‘Apply’. When you have selected the years and the organisation/status/version options, press the ‘Populate Data Extract View’ button. It is important these steps are followed each time the report filters are changed so that the report refreshes and updates to those selections. When ready to download the report, click anywhere in the report to make the ‘Export’ button at the top of the screen appear as shown in the screenshot below. Click ‘Export to spreadsheet’ followed by ‘Export’. A pop up box will appear to indicate that the report is running, which will disappear once complete. When complete, a download should appear in your browser.

4) Once you have downloaded the report, you can then create a PivotTable to review your data. If you are unfamiliar with PivotTables you can follow these steps. If you are familiar with creating and using PivotTables, you can skip to Step 7:

Click enable editing, and then click anywhere within the data (from row 6 down). Then press ctrl + A to select the entire table. The click on the ‘insert’ tab and click on the ‘PivotTable’ button (not the arrow, just the button itself):

A box should appear, which is showing you the data it has selected for the PivotTable (which was previously selected by pressing ctrl + A). Just click ‘ok’. 5) Once you have created a PivotTable, this will create a new tab. With the PivotTable field box showing on the right hand side, drag and drop the following fields into the following boxes (for ‘Sum of Amount’, just drag in the ‘Amount’ field to the values):

This should result in your PivotTable populating with some data, similar to the above screenshot. 6) To make your PivotTable more readable, you can take the following steps.

  • Right click on the pivot table, and click on ‘PivotTable Options’:

In the Display tab, click on the box for the Classic PivotTable layout, and then click ‘ok’.

  • If you click on the PivotTable a ‘Design’ tab should appear, which has lots of options for customisation.

Here, the following steps would be recommended:

  • Subtotals: Do Not show Subtotals
  • Grand Totals: On for Columns only
  • Report Layout: Repeat all item labels

7) In the Rows field for the PivotTable options, drag and drop the following fields:

  • Economic Budget Code
  • Control Budget Code
  • Control Budget Detail Code
  • Economic Ringfence Code

This will populate the pivot table with the main control totals:

Note: this view has been updated by moving the order of the resource/capital rows, and adding subtotals for the control budget code by right clicking and adding the option.

8) Next, drag and drop the status field into the column field, under year:

This will show you the status fields appear separately. Filter for just Confirmed and Submitted (although you can also do this for locked data if you wish to view before submitting). As shown above, right click on the year, and click ‘Subtotal Year’.

This then allows you to see the overall totals in the submitted status added to the confirmed adjustments, and review what the overall impact of the submitted adjustment would be:

There are also lots of other fields within the DAR that you can drag in to view lower-level fields within the data, such as account code, sub-segments, economic categories, etc.

Reviewing data within the ‘Control Total Adjustments Tracker’ report

The Control Total Adjustments Tracker is a very basic, quick view report, to enable users to see the last adjustment loaded for their department without having to download a data extract. It gives the basic higher level values to show the Economic Budget (e.g. Resource/Capital), the Control Budget detail (E.g. DEL or AME), the Economic Ringfence and the adjustment type.

To view the Control Total Adjustments Tracker, navigate to the Reporting Homepage and select ‘Control Total Adjustments Tracker’:

Users can download the report by clicking anywhere in the report and clicking the ‘Export’ button at the top of the page, followed by ‘Export to spreadsheet’. A pop-up box will appear – click ‘Export’ and the report should download in your browser to open in Excel.

Users can also view the same detail presented here within the Budgeting Data Extract report.

Downloading Estimates Reports

Estimates reports are available to download directly from OSCAR, based on Live data or data available within snapshots. Note that if the Live system is pointing towards Mains, the Supplementary Report cannot be run for Live (it will return an empty report). The same applies to Mains when the Live system is pointing to Supplementary Estimates. However, reports can always be run against available snapshots for previous years.

To note that the formatting and content of the OSCAR reports differ to the final reports ready for printing, which incorporate text (such as ambits) and additional formatting where the OSCAR reports are different. It’s advised that these reports are used to analyse the data position only, which should align to any data adjustments loaded to the budgeting system.

1) To download an estimates report, select either the ‘Main Estimate’ or ‘Supplementary Estimate’ report option from the Reporting Homepage.

This will result in a new browser tab opening displaying a number of different options. These options include bespoke reports that are built for DfE and MHCLG. For users looking to run these reports, the steps are the same as set out in this guidance. For all other departments, the report to run will be the Main Estimate/Supplementary Estimate report.

This guidance looks at running a Main Estimate report for HM Treasury. The process is exactly the same for Supplementary Estimates.

2) After clicking the ‘Main Estimates’ option in the previous step, there should be a tile displayed that reads ‘Main Estimate’. Hover over the Main Estimate (or Supplementary Estimate) box so that the ‘Action menu’ appears (three vertical dots). Click the Action menu, and click ‘Run as’ as shown below.

6) Click on the ‘Excel’ option to run the report within Excel. Do not click the ‘Excel Data’ option, as this won’t return any figures. Next click ‘Run’ in the bottom right corner of the page.

To note: other formats of running reports are available. For example, you can run to view the report in HTML to view it on screen, without downloading the report.

7) On the next page, a few different selections are required for the report.

  • In the first two boxes (top left and top centre), the Department you are looking to run the Estimate report for should be selected. Most users will only have one option, but users with multiple departments will be able to see a list of all departments they have access to. In this example HM Treasury is selected.
  • In the top right box, there is a selection for a Pension or Non-Pension Department. All departments will be Non-Pension unless they are a pension estimate[footnote 1]. The pension option produces a different version of Note A.
  • In the bottom left box, the status should be selected. Ordinarily this would be confirmed, to see the current data position. Users can also run a report to view data in submitted, or a combined submitted and confirmed report (so that users can see the total impact of the report once submitted data becomes confirmed).
  • In the bottom right box, the version should be selected. If the report is being run based on Live data, ‘Live’ should be selected. However, there are options for snapshots which will show Main Estimate or Supplementary Estimate reports for previous years.

8) When all selections have been made, click Finish (shown in the bottom bar to the left). A pop-up will appear to show that the report is running. Once completed, the report should download in Excel within your browser.

10) Within the estimate report, the first tab will show information about the report, such as the user who ran it, the date and time it was run, and the options for the version and the department.

The OSCAR generated estimates reports will include the following tabs:

  • Part I
  • Part II Subhead Detail (Main Estimates only)
  • Part II Changes Proposed (Supplementary Estimates only)
  • Part II Revised Subhead Detail (Supplementary Estimates only)
  • Part II Resource to Cash table
  • Part III Note A (SoCNE)
  • Part III Note B (Income)
  • Part III Note C (CFERs)
  • Part III Note E (ALBs)

There are additional tabs that will just show text/remain empty. If there is no data available for any of the above tabs, the table will be empty/show no data.

Reports can be re-run to show any updates as adjustments are loaded to OSCAR.

  1. Armed Forces Pension Scheme, Cabinet Office: Civil Superannuation, Foreign, Commonwealth and Development Office: Overseas Superannuation, Ministry of Justice: Judicial Pension Scheme, National Health Service Pension Scheme, Royal Mail Statutory Pension Scheme, Teachers’ Pension Scheme (England and Wales), and United Kingdom Atomic Energy Authority Pension Schemes. ↩