Bromcom Finance and DTSApps – Download and Reformat process PLYMOUTH SCHOOLS

This FAQ is for Plymouth Schools and explains how to reformat your reconciliation file downloaded from DfE S2S to ensure it can be imported into Bromcom Finance.

  1. Download your relevant reconciliation files from DfE School to School
  2. Unzip your file using 7 zip and your Plymouth credentials (Please ensure that the file size is above 0KB, if it shows as 0KB this can indicate that the incorrect password was entered).
  3. Log into DTSApps with your login credentials
  4.  From the menu on the left, click “Reformat”
  5. Click upload from file and browse to the location of your newly downloaded reconciliation files and select one file at a time to process.  These files are in transmission number order, please import oldest first.
  6. The formatted file will in appear in the green window “Files ready to download” click the green “Download” button to download the .TXT file, which will then show in your downloads folder with the short file name as shown in the screen shot above. If there is no option to ‘Download’ this is because the file number does not match the next ‘Expected’ transmission number. You will need to upload the next expected file to continue.
  7. It is up to the individual school on how you manage your files, shared locations etc.
  8. You will need to repeat the above steps for each file you download from your local authority
  9. Your formatted file is now ready for import into Bromcom as follows : Modules > Finance> Homepage> Routines> Automatic Reconciliation> Import

Please see the reconciliation FAQ https://faq.scomis.org/kb2395869/

How useful was this article?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

Similar Posts

  • Bromcom Finance: How can I print my imported “Automatic Reconciliation file”

    Posted on Updated on

    Once in Modules > Finance> Homepage>Routines> Automatic reconciliation, please right click in the listing and then click export as shown in the screen shot  below.  This will then allow you to export to excel or csv and print as required.   How useful was this article? Click on a star to rate it! Submit Rating…

  • Bromcom Finance: Year End Payroll clearance from FC01 ** Local payments – Devon LA**

    Posted on Updated on

    Local payments need to carry out a payroll clearance in order to set the Fund Control 01 to zero , prior to preliminary close down. Please see the following steps: Step 1 – Modules > Finance> Homepage>General Ledger>Journals.  Select “Year End journal” if you have already run  preliminary close or standard journal if you have…

  • Bromcom Finance: Year End Procedures 2025

    Posted on Updated on

    Please find the following guides for Bromcom Finance Year End Procedures: 1)   Part 1 Guide  Preparing for the year end 2) Part 2 Guide Setting up the new year 3)   Part 3 Guide – Closing the Financial year   How useful was this article? Click on a star to rate it! Submit Rating Average rating /…

  • Bromcom Finance & Budgeting : How do I enter a Variance reason in Budget Variances

    Posted on Updated on

    Modules> Finance> Homepage> Budgeting> Budget Variances In the budget variances you can add a budget variance reason against e.g a Cost centre as shown in this example below: Note: Any Variance reason needs to be added before you sort your columns – see sorting columns FAQ – Bromcom Finance & Budgets: How do I sort…

  • Bromcom Finance: How to process your invoices, in Central Authorisation and “Print & Export”

    Posted on Updated on

    Once you have added your invoices into Bromcom finance, you will need to authorise and batch up any invoices and credit notes created as follows : In Bromcom, navigate to Bromcom Finance Home page: 1) Click on Central Authorisation in the Routines area: 2) You will see any invoices and Credit notes that have been…