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: What do the different status’s mean when processing invoices

    Posted on Updated on

    Authorised – This means the Invoice has been “Authorised” and the user would have clicked “Authorise” within the invoice, ready to centrally authorised. Passed for Pay – This means the Invoice has been processed through “Central Authorisation” and print and exported the batch to create a file to upload to the “Local Authority” Paid – This…

  • Bromcom Finance: How do I map my classroom teacher to multiple funds?

    Posted on Updated on

    You may have a classroom teacher who works in nursery as well as the main school and is paid from multiple funds. This FAQ explains how to deal with this in Bromcom. You can also use this if a teacher is paid entirely from a different fund to your other teachers. Please see the following…

  • Bromcom Finance: How do I setup a Free Text (Sundry) invoice

    Posted on Updated on

    Sundry Invoices should be raised for ad hoc and/or infrequent payments e.g. for payments to staff. You cannot raise a purchase order or free text order against sundry suppliers. Sundry suppliers and invoices can be setup as below: Browse to Modules> Finance> Homepage>Supplier and complete the supplier setup if not already done Tick “Sundry Supplier”…

  • Bromcom Finance: Error posting Individual salary payment

    Posted on Updated on

    When posting the Individual salary payment an error is generated as below : This is most likely due to the “Base Pay” associated with the ledger codes being used, having missing information e.g Missing Financial subgroup. Please browse to: Modules> Finance> Homepage>Staffing> Base Pay Mapping, locate the Base pay being used for the individual salary…

  • Bromcom Finance: I have clicked print and not print and export

    Posted on Updated on

    When processing your payments file in central processing for county, you need to click “Print & Export” only. This is because it produces two files a text file and PDF file.  You will need the text file to process through DTSAPPS. If you have clicked print, this will produce a PDF file in central authorisation…