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: Raising orders on suppliers websites for example: YPO & Amazon

    Posted on Updated on

    Raising orders on suppliers websites for example Amazon and YPO, the prices are lower and and saves schools money, enabling importing into Bromcom Finance. Bromcom are working on adding a Punchout to Bromcom Finance, whereby orders placed on a suppliers site are automatically put back into the system, so no import, its a live link…

  • Bromcom Finance: Accounts Receivable, receipt “Post Box is greyed out”

    Posted on Updated on

    If the post box is “greyed out” please ensure you do the following:   Record the receipt and ensure you click save and print.  If you don’t print, the receipt will not be available in “Paying in Slips” Browse to Modules> Finance>Accounts receivable> Paying in slips> Click the purple add button, you will see the…

  • 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…

  • DEVON ONLY – Amending & Importing Period 13 reconciliation files to Period 12

    Posted on Updated on

    Devon Payments have sent down reconciliation files for period 13. Unfortunately it is not possible to import files into Bromcom for Period 13 as this period is only for adjustments. If you have not already downloaded the files from DTSApps please see DEVON ONLY: DTSApps account code changes – Frequently Asked Questions for guidance on…

  • 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…