|

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 & Budgets: How do I sort columns in my Budget Variance

    Posted on Updated on

    Modules> Finance> Homepage> Budgeting> Budget Variances You can click on any the heading e.g  Cost Centre Description and drag to above “Drag here to set row groups”   –  see example below before sorting Example after sorting to Cost Centre description Please also see Budget planning user guide     How useful was this article? Click…

  • Bromcom Finance: How do I setup a Free Text (Sundry) invoice

    Posted on Updated on

    Sundry Invoices should be raised for ad hoc and/or infrequent payments e.g. for payments to staff. You cannot raise a purchase order or free text order against sundry suppliers. Sundry suppliers and invoices can be setup as below: Browse to Modules> Finance> Homepage>Supplier and complete the supplier setup if not already done Tick “Sundry Supplier”…

  • Creating a Wraparound Care club to collect Nursery Payments

    Posted on Updated on

    All 3 to 4-year-olds in England can get 570 free hours per year. It’s usually taken as 15 hours a week for 38 weeks of the year. You can choose to take fewer hours over more weeks, if your childcare provider offers this option. Some parents wish their child to have extra hours and will…

  • Bromcom: How do I create a CTF that includes leavers?

    Posted on Updated on

    If you need to create a CTF that includes both current pupils and those that are leavers for Key Stage DFE Assessments, you can do this using the search filters option from within the student area. EYFS – Please check with your LA. If you are a Devon school-Upload to Devon Transfer Phonics – Please…