Schools Division Integrated Planning in the Accountability Framework App
Non-profit education and research organisation, Middle East
In short
How can a schools network replace separate planning spreadsheets with one app?
Each year, the schools division network of the client had to plan business, manpower and finances for all of its schools and centres, in separate spreadsheets that someone had to merge by hand. The cycle had a fixed calendar and a presidential review, so late or inconsistent plans cost real time. We added integrated planning to its existing Accountability Framework app.
Results in numbers
- schools on shared templates
- 30+
- departments imported
- c. 90
- academic years
- 3
At a glance
- Business, manpower and financial planning in one app
- Planning for 3 academic years per school or centre
- More than 30 schools and centres on one set of templates
The client
The schools division is the school education arm of the client in the region. It runs a network of schools and centres, and already tracked its strategic accountability framework in a Power Apps app on SharePoint.
What it was costing them
- Manual consolidation: plans from every school and centre arrived in different spreadsheets and had to be merged before review.
- Inconsistent entries: positions, expense types and departments were typed freely, so totals did not line up.
- Tight calendar: a yearly cycle with a president's review left little room to correct late or wrong plans.
- Hand-offs between teams: finance and HR each owned part of the plan, with no one place to see the whole.
What we built
We extended the existing Accountability Framework Power Apps app with planning screens for initiatives, enrolment, manpower and non-staff costs, and an integrated planning view.
- One template for every school: initiative planning brings student enrolment, manpower and budget requirements into one place.
- Finance owns what Finance knows: a revenue and student enrolment planning screen for the finance team.
- HR owns what HR knows: a manpower planning screen for the HR team, with positions from an HR-provided list.
- Costs by type: a non-staff cost planning screen, with expense types from a finance-provided list.
- The whole picture for leadership: an integrated planning view for super users that brings the calculations together.
- Clean start: planning data moved from Excel into new SharePoint lists, using prepared import files with schools, centres, departments, grades and positions.
- Right access: roles control who can enter and who can see each screen.
- Safe go-live: user acceptance testing with assigned roles, test data cleared afterwards, and admin training for assigning roles.
Results
- Four planning areas (initiatives, enrolment, manpower, non-staff costs) and an integrated view added to the existing app.
- Import files prepared for more than 30 schools and centres and about 90 departments.
- Planning covers three academic years, with the process for adding a third year defined.
- Result: fewer rounds of correction between entities, finance and HR before the plan goes to review.
The risk most teams miss
SharePoint lists work for one cycle, but planning rows multiply by school, department, grade and year. In month three, a plan list passes a few hundred rows per sheet, views slow down and thresholds appear, while role lists drift out of date. We prepared clean lookup lists and defined roles, and we recommend moving the plan data to Dataverse before the second cycle.
What we would add today
Improvements we would add on top of what is live.
- Move planning data to Dataverse with row-level security so each school sees only its own plan, and finance and HR only their sections.
- Add a business process flow and approval stages, so a plan moves from entity leadership to review to approved with a visible status.
- Use Dataverse calculated and rollup columns for revenue, staff cost and cost recovery.
- Publish the integrated plan in Power BI on Dataverse for the leadership review.
- Deploy through Power Platform pipelines with environment variables for the lists and lookup sources.
Technology
Power Apps (canvas), SharePoint Online lists, Microsoft Excel (import), Microsoft 365.
Tell us how many teams each fill part of your yearly plan, and we will tell you how to bring them into one app.
Products and capabilities
- Power Apps
- SharePoint
- integrated planning
- budget planning
- manpower planning
- data migration
- role-based access
The service behind this work
Power Platform developmentThe service behind this work
Power BI
Related use cases
FinanceBank Reconciliation Proof of Concept for Oracle
Matching bank transactions to finance records by hand costs time every day and ties the process to the people who know the rules. The client was moving to a new Oracle system and asked how reconciliation could work on it. We ran a short proof of concept on its own data.
Weighbridge Integration and Automated Invoicing for Quarries
At a quarry every load is weighed, but the weight often stops at the gate. When tickets are keyed in again for invoicing, bills go out late, mistakes slip in and stock figures lag behind what has left the site. We linked the weighbridge to invoicing and to a live view of reserves.
FDU-FDC Finance Data Update and Compare Canvas Apps
Finance users who are not technical had to write SQL formulas to load Excel data into a database, so a simple task became slow and hard. The client needed an easier way to update and compare finance data. We delivered canvas Power Apps that connect to the existing data source and keep Excel export.
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.