|

Bromcom Finance: How do I create a Trial balance report and compare in DTSApps ? – Devon schools

Your local authority will give you access to a power BI monthly budget report in a CSV format, this report is used to compare what has been recorded in Bromcom finance accounts.

To compare the Local Authority Power BI report you need to take the following steps:

  1. Create Trial balance report in Bromcom Finance – Modules> Finance> Homepage>Reports> Trial Balance by ledger code
  2. Select your dates.
  3. Click Preview
  4. Click Export
  5. Tick save local copy and select from drop down CSV

5. Click done

6. Log into – DTSApps

7.Select Trial Balance from the menu

8. Load your Trial balance report from Bromcom and then your Power BI report from your Local Authority. If unsure about downloading the power BI, Please speak with your Schools finance contact/officer for advice and instructions on downloading the power BI report, as the power BI report is produced by DCC.

9) Please note you can exclude funds if you wish in schools settings if you wish.

 

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: 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: Updating Staff Current Job Title

    Posted on Updated on

    To update the staff current job title in bulk go to Staff > Selection > Select All and then Actions > Manual Data Export. From here select “Basic Details” and tick “Include empty records where data does not exist” and click Export Open the spreadsheet that has been downloaded and enter all required information. After…

  • Bromcom Finance: Why can’t I post my Petty Cash?

    Posted on Updated on

    My petty cash saves but does not post and has a “No” in the posting column. This is likely to be due to your Petty Cash book running our of folio numbers. Go to Modules> Finance>Homepage> Maintenance> Books. Ensure you have enough folio numbers for each line of expenditure record. If not, you will need…

  • Bromcom: MCAS User Activity

    Posted on Updated on

    You may be starting to roll out MCAS and have been sending links out to parents. In Bromcom, you can run a report that shows you which students parents have not activated their account. You can run the User Accounts Report under Reports>MCAS>Account Report.  Here you will be able to run a report of all…