Skip to content

Administration 183: Maintained Schools Reconciliation update


Further to Administration 181: Maintained Schools Salary Reconciliation update – Support for schools and settings, we have now posted a journal to correct the iTrent coding error within the April Salary payments.

For Primary Schools ONLY:

We have also implemented a data fix that looks for any school files from 20th April that have not yet been imported into automatic reconciliation in Bromcom as at 11:00 to 12:00 this morning and makes only those files available for download in the “Files ready to download” in the green box on DTS Apps under reconciliation reformat.

Yesterday afternoon a file called 25_01-Pay was also released. That file contains the pay files that failed originally due to not having a ledger code and have not yet been imported into automatic reconciliation in Bromcom at 11:00 to 12:00 this morning. If you downloaded and imported the file prior to 11:00 to 12:00 today, you have an earlier version that may contain reconciliation errors. Just delete these from automatic reconciliation please.

Anything that hasn’t been imported into Bromcom will be in the “Files ready to download” in the green box in DTS Apps.  

Primary schools please follow the following steps to complete your reconciliation:

  • You will need to work through all the files in the “Files ready to download” in the green box on DTS Apps under reconciliation reformat.
  • In date order, starting with the oldest file first (based on file name), import each file and complete the reconciliation for that file before you move on to importing the next file.
  • Some files may be blank, containing no data. This is because the fix to remove these would take even longer. If any of the files are blank and contain no data and is imported into Bromcom, automatic reconciliation will advise ‘no records found to reconcile’.
  • Once you have imported the files you can delete the incorrect unreconciled pay files from automatic reconciliation

A report ‘Automatic Reconciliation Status’ can be ran to identify all files that have been imported and whether items have been reconciled, deleted or unreconciled.  Schools may find this report useful in helping to identify items that have already been reconciled prior to the new import. It also identifies the fund the items were imported into.

We are still working on a fix for Secondary and Special Schools and will update you as soon as possible.