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: Base Pay mapping FAQs

    Posted on Updated on

    Please see this guide for commonly asked questions around “Base Pay Mapping” If you need assistance with setting up mapping please see the following FAQ How to add Base Pay Mapping Scenario 1 – I have staff with the role of “Teaching assistants ” that need to be mapped to multiple cost centres In Bromcom…

  • 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: 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 and DTSApps: How do I process my Petty cash file – DEVON SCHOOLS

    Posted on Updated on

    Navigate to Modules> Finance> Homepage> General ledger> Petty Cash Processing. 1) Click the yellow button to add an expenditure or green button to add a reimbursement 2) Add your expense lines on the right hand side VAT Reg Numbers Note : When adding multiple lines of expenditure, please remove the VAT Reg number if not…

  • Bromcom Finance & DTSApps – DEVON SCHOOLS

    Posted on Updated on

    Bromcom Finance: How to process your invoices, in Central Authorisation and “Print & Export” DTSApps – Bromcom Integration Guidance Bromcom Finance: Raising orders on suppliers websites for example: YPO & Amazon Bromcom Finance: How to cancel “Passed for Pay” Invoices Bromcom Finance: I have clicked print and not print and export Bromcom Finance and DTSApps:…