Reconcile IRIS Financials with DfE Returns

Only for organisations using the DfE Chart of Accounts version.

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 return values are displayed rounded to the nearest thousand.

  1. Run a Trial Balance for the accounting period, using the following criteria:
    1. Select Nominal Index, then Accounts Return for the financial year.
    2. In Periods select Between, then select periods 00 to 97.
  2. To reconcile the Bench Marking sections, run another Trial Balance for the accounting period, using the following criteria:
    1. Select Nominal Index, then Accounts Return Benchmarking for the financial year you have uploaded.
    2. In Periods select Between, then select periods 00 to 12.
  3. To reconcile counter party transactions, run another Trial Balance for the accounting period, using the following criteria:
    1. Select Nominal Index, then Accounts Return Counterparty for the financial year you have uploaded.
    2. In Periods select Between, then select periods 00 to 12.
  4. To reconcile nominals that roll up their opening balances from period 00 into other codes, run another Trial Balance for the accounting period, using the following criteria:
    1. Select Nominal Index, then Opening Balance Nominal.
    2. In Periods select Equals, then select period 00.

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 DfErepresentative.