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 & Budgets: How can I export my Budget Variance Report?

    Posted on Updated on

    Modules> Finance> Budgeting> Budget Variances You can export your budget variances report by clicking into any of the budget lines and then right click, select “Export” to CSV or Excel, as shown in the below screen shot:     How useful was this article? Click on a star to rate it! Submit Rating Average rating…

  • Bromcom Finance: How do I add a pay award ?

    Posted on Updated on

    Please note: This method is recommended for confirmed pay awards, if adding a projected pay award, please follow step 5  Browse to Config>Administration>Base Pay Structures>double click the required Base Pay structure, e.g JK – Job Evaluation Hours Per Annum, JE – Job Evaluation All Year Round,  JL – Job Evaluation > HPA 5 yrs, Teachers…

  • Bromcom Finance & DTSApps – PLYMOUTH SCHOOLS

    Posted on Updated on

    Bromcom Finance: How to process your invoices, in Central Authorisation and “Print & Export” 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: How to process your invoice…

  • Bromcom Finance: How do I add an additional allowance?

    Posted on Updated on

    If you need to add an additional allowance for a staff member, you will first need to add a new version date for the allowance as follows: Browse to Config>Administration> Additional allowances Click the allowance line E.G  if you want to update TL3 – Teaching and learning responsibilities Under the “Versions” click add new date…

  • Bromcom Finance: How to cancel “Passed for Pay” Invoices

    Posted on Updated on

    There are a couple of reasons you might need to cancel your raised “Passed for Pay” Invoices: If you have lost your “Print and export” text file that is required for processing through DTSApps, you will need to cancel your invoices and re-raise them.  If you have raised an invoice and now no longer require…

  • Bromcom Finance: How to add Base Pay Mapping?

    Posted on Updated on

    Please see the following guide on how to map your base pay: Modules> Finance> Homepage> Staff> Base Pay mapping Base Pay Mapping How useful was this article? Click on a star to rate it! Submit Rating Average rating / 5. Vote count: No votes so far! Be the first to rate this post.