Reconcile IRIS Financials with DfE Returns

Requires Version 7.2103 or later

After uploading your organisation's financial information, reconcile IRIS Financials with the figures displayed in the Department for Education (DfE) account return.

DfE academy accounts returned values are displayed rounded to the nearest thousand.

  1. Run a Summary Enquiry for the accounting period, selecting the following Summaries:
    • Accounts Return for the financial year you have uploaded
    • Nominal Parent Code
  2. Select Periods, then Period Range.
    1. Change All to Between.
    2. In Value 1, enter the .00 period code for the financial year.
    3. In Value 2, enter the .97 period code for the financial year.
    4. Clear Include Register Transactions.
  3. To reconcile the Bench Marking sections, run another Summary Enquiry for the accounting period, selecting the following Summaries:
    • Accounts Return Benchmarking for the financial year you have uploaded
    • Nominal Parent Code
  4. Select Periods, then Period Range.
    1. Change All to Between.
    2. In Value 1, enter the .00 period code for the financial year.
    3. In Value 2, enter the .12 period code for the financial year.
    4. Clear Include Register Transactions.
  5. To reconcile counterparty transactions, run another Summary Enquiry for the accounting period, selecting the following Summaries:
    • Accounts Return Counterparty for the financial year you have uploaded
    • Nominal Parent Code
  6. Select Periods, then Period Range.
    1. Change All to Between.
    2. In Value 1, enter the .00 period code for the financial year.
    3. In Value 2, enter the .12 period code for the financial year.
    4. Clear Include Register Transactions.
  7. To reconcile nominals that roll up their opening balances from period 00 into other codes, run another Summary Enquiry for the accounting period, selecting the following Summaries:
    • Opening Balance Nominal
    • CoreNominal
  8. Select Periods, then Period Range.
    1. Change All to Equals.
    2. In Value 1, enter the .00 period code for the financial year.
    3. Clear Include Register Transactions and Include Prior Year Actuals.

Did you know? 
To help reconcile uploaded balances you can also download the return, FMS mapping, or draft trust financials statements from the Academies Account Return portal. For more information about the options available, contact your DfE representative.