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.