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: Year End Procedures

    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 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: How to Import your reconciliation file and deal with failed reconciliation items

    Posted on Updated on

    Once you have downloaded your file from your local authority the next step is to import the reconciliation file into Bromcom Finance. 1 ) Navigate to Modules > Finance > Homepage and select Routines > Automatic Reconciliation. Click the purple Import button top left and browse to file location of the reconciliation file 2) Select…

  • 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 can I find my carry forward figures ?

    Posted on Updated on

    Devon LA have opted for “Retained earnings” to show in all schools databases.  This means the route for locating the previous years carry forward figures is as follows: Previous year carry forward  E.G from previous financial year –  Financial year 23/24 – Please follow: Modules> Finance> Homepage>> General Ledger> Chart of Accounts Enquiry You can…

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