# Beyond the Spreadsheet: Solving Modern Budgeting Challenges in Educational Institutions

*Source: https://trginternational.com/blog/education-budgeting-challenges-international-school-groups/*

---

[Budget season at educational institutions](https://trginternational.com/resources/complete-guide-corporate-budgeting/) is, unfortunately, not that different from other sectors. Every October, these finance teams across Southeast Asia begin the same exercise. Templates are distributed to department heads. Faculty submit their staffing projections. Operations estimates its facility costs. Student services submits its program budgets. Then finance spends the next six to eight weeks trying to assemble it all into a plan that makes sense.

The problem is not that the people involved are not capable. It is that the tools being used were not built for what education finance teams are actually being asked to do.

An international school group is not a single business unit with a single revenue stream. It is a cluster of campuses, each with its own cost structure, student population, and mix of funding sources, whether from tuition fees, government grants, research funding, restricted scholarships, or capital contributions from owners or foundations. The financial model that connects all of those moving parts is **not a spreadsheet** that can be distributed by email and consolidated manually.

**Read more:** [The Shadow Excel Ledger: The Hidden Finance Risk in Education Groups](http://trginternational.com/blog/shadow-excel-ledger-education-finance-risk/)

## Why education finance is a complex subject

Most of the assumptions baked into [generic budgeting tools and processes](https://trginternational.com/blog/what-are-the-most-common-approaches-to-budgeting/) do not hold in an education setting. A manufacturing company budgets its raw materials against a production schedule. [A hotel budgets](https://trginternational.com/blog/infor-epm-hospitality-finance/) its staffing against an occupancy forecast. The inputs vary, but the model structure is relatively stable.

An international school group is dealing with a fundamentally different planning problem:

-   **Tuition fees** are the primary income source, and they are directly determined by how many students are enrolled in which programs and at which campuses. If enrolment changes mid-term, revenue changes with it, but the cost base, led by faculty salaries and facility overheads, largely does not.
-   **Funding sources** like tuition revenue, government funding, restricted endowments, research grants, and scholarship pools each have different permissible uses, reporting periods, and compliance requirements.
-   **Staff costs**—such as faculty headcount, subject-level staffing ratios, salary scales tied to qualifications and tenure, substitute cover, and professional development budgets—all feed into the payroll figure, and changes to any of them cascade through the institutional P&L in ways a flat cost-percentage assumption cannot capture.
-   Each campus has its own cost structure, student population, and intercompany charges for shared services. Consolidating all of that into a group-level view while ensuring accuracy and auditability is genuinely difficult.

These characteristics combine to make education finance one of the most technically demanding financial planning environments in any sector. The tools and processes most school groups use to manage it were built for something much simpler.

> **Gain deeper insights into streamlining school and university operations:** [Download the Education Whitepaper: Solving Multi-School Group Financial Challenges with Automation](https://blog.trginternational.com/hubfs/whitepapers/FM/2026/Education%20-%20Solving%20Core%20Finance%20Challenges/whitepaper-education-finance-challenges-automation-cloud-solutions-EN.pdf)

## The 4 recurring annual budgeting bottlenecks in educational institutions

The structural limitations of manual budgeting in educational institutions consistently produce four specific, compounding operational challenges, each a symptom of the same underlying problem: planning tools that were not built for this environment.

### 1\. Fragmented compilation, version conflicts, and the cost allocation problem

Academic faculties, athletic programs, student services, and administrative units all maintain distinct operational priorities. When these departments submit individual spreadsheets, the school’s finance team must manually extract, align, and consolidate the figures. In practice, the submissions arrive in different formats, at different times, and against different interpretations of the planning assumptions finance provided.

In other words, finance teams face 2x, 3x, or even 5x the normal workload when receiving all submissions.

[Version conflicts compound the problem](https://trginternational.com/blog/from-manual-annual-spreadsheets-to-agile-budgeting/). Some departments submit Version 2 before finance has finished processing Version 1. Or, more troubling, a function updates a figure verbally in a meeting without updating the file. The master consolidation model, which is being updated continuously during this process, can contain figures from different iterations of different departments without anyone being certain which version of which submission it reflects.

Then there is the “How to allocate the costs of shared services across campuses in a way that is both financially accurate and fair” financial headache.

In most school groups, this allocation is done using fixed percentage splits agreed at the start of the year. For example, the Singapore campus receives 30 per cent of central IT costs, Bangkok receives 25 per cent, Ho Chi Minh City receives 20 per cent, and so on. The problem is that these fixed percentages were set at a point in time and do not automatically update when the underlying driver changes.

Campus principals who review their P&L at the end of the year and find themselves charged the same overhead percentage as a campus that has twice their student count have legitimate grounds to question whether the allocation is fair, and finance has no automated mechanism to demonstrate that it is.

**Read more:** [Can Your Business Escape The Endless Spreadsheet-And-Email Approval Chain During Budgeting?](https://trginternational.com/blog/replace-spreadsheet-email-budgeting-approval-chain-infor-epm/)

### 2\. Slow board reporting cycles and the multi-currency consolidation challenge

Governing boards, audit committees, and university trustees require precise, structured financial reporting to make informed decisions on capital expenditure, tuition adjustments, and debt management. For an international school group, this reporting must consolidate financial performance across campuses denominated in different currencies, from USD to VND, Thai Baht, etc.

Done manually using spreadsheet-based processes, finance needs three to four weeks of manual data validation, applies the relevant exchange rates for the period, eliminates intercompany transactions, and assembles the group P&L.

In a manual consolidation process, intercompany elimination is a source of recurring error. The group entity records the management fee as revenue. The receiving campus records it as an expense. Both figures appear in the consolidated P&L unless someone specifically identifies the transaction and removes it. This raises questions about the reliability of the consolidation process and prompts a request for finance to demonstrate that it has not happened before.

By the time the board receives the quarterly financial reports, the figures reflect conditions from six to eight weeks earlier, i.e., outdated insights with questionable accuracy. This lag prevents executive teams from making timely operational pivots during the active academic term.

**Read more: ⁠**[⁠The A to Z of Sustainability Reporting to Reach Your Green Goals](https://trginternational.com/blog/a-to-z-sustainability-reporting-for-businesses/)

### 3\. Blind spots in enrolment-driven revenue

Tuition fees are typically set for the academic year in advance and cannot be adjusted mid-cycle. The number of enrolled students is subject to market dynamics, competitive pressures, scholarship commitments, and mid-year attrition that no institution can fully control.

This means an enrolment projection that is five per cent optimistic at a campus with 1,000 students and an average fee of USD 20,000 per year represents a USD 1,000,000 revenue shortfall. For a group with four campuses, a consistent five per cent optimism bias in the enrolment model can potentially become a multi-million dollar planning error.

However, admissions figures, student retention rates, and scholarship allocations frequently live inside standalone Student Information Systems (SIS) or admissions platforms. The financial management system records tuition invoices and receipts when they are generated.

Between the SIS and the financial system, there is typically a gap:

-   Finance lacks real-time visibility into the admissions pipeline during the enrolment period.
-   Finance teams miss early warning signs of enrolment drops during intake periods.
-   Staffing ratios and classroom resource allocations remain pegged to outdated student projections.
-   Mid-year revenue shortfalls force sudden, reactive budget freezes that disrupt academic delivery and campus operations.

On the other hand, scholarships and retention add another layer of complexity.

Scholarship allocations directly reduce the tuition revenue available to the institution, but they are not always reflected in the financial planning model with the precision the revenue impact requires. Student retention is rarely built explicitly into the multi-year financial plan. Instead, most models assume that the next year’s enrolment will be approximately the current year’s enrolment plus or minus the projected intake. When retention rates are lower than expected, this assumption systematically understates the enrolment shortfall the institution faces.

An institution that identifies an enrolment problem during intake can respond by adjusting staffing plans, deferring discretionary spend, or accelerating marketing activity to fill remaining places. An institution that identifies the same problem at later stages is making those decisions in a much more constrained position.

### 4\. Regulatory and funding compliance risks

International school groups must follow increasingly demanding guidelines for government funding, restricted endowments, research grants, and statutory tax reporting. For instance, in Vietnam, [Circular 99/2025/TT-BTC](https://trginternational.com/blog/circular-99-vas-ifrs-accounting-solution/) governs the financial reporting obligations of educational institutions, including the chart of accounts structure, the treatment of tuition revenue, and the documentation standards for deductible expenses. In Thailand, private school operators are subject to the Private School Act and its annual financial reporting requirements. In Cambodia, foreign-invested educational entities must comply with the General Department of Taxation’s reporting obligations under the Law on Taxation.

> **Learn more:** [Corporate Budgeting Across Vietnam, Thailand, and Cambodia: Pain Points, Practices, Tools, and the Road Ahead](https://trginternational.com/resources/corporate-budgeting-best-practices-vietnam-thailand-cambodia/)

Each funding source carries strict covenants defining allowable expenses, reporting periods, and return-of-funds policies. When finance teams track restricted funds (financial aid to students who meet defined criteria) across multiple disconnected workbooks, reconciling them at audit time turns into an exhausting manual investigation.

In practice, most school groups [track restricted funds in separate spreadsheets](https://trginternational.com/blog/shadow-excel-ledger-education-finance-risk/) maintained alongside the main financial management system and updated manually when disbursements are made from the main system. At audit time, these workbooks are reconciled against the general ledger to demonstrate compliance.

This creates compliance vulnerabilities that external auditors quickly uncover, potentially putting future institutional funding or accreditation at risk. These are the visible costs. The less visible cost is the time the finance team spends managing compliance in the current environment that a well-configured financial management system would handle more efficiently.

## **The architecture of modern budget management for educational institutions**

The four bottlenecks described above are not separate problems. They are all symptoms of the same gap: financial management tools that were not built for the specific complexity of multi-campus education finance. Addressing them requires more than a better spreadsheet or a more disciplined budget process.

To break free from spreadsheet limitations, forward-looking institutions are transitioning to [centralised, cloud-based Enterprise Performance Management (EPM) systems](https://trginternational.com/solutions/infor-epm/), which empower finance users through three core architectural pillars:

### **A unified system for effective financial planning and budgeting**

The most important structural change education finance teams need to focus on is connecting the admissions and enrolment pipeline to the financial planning model through direct API connections.

![Integrating shchool systems with Infor solutions](https://wpengine.trginternational.com/wp-content/uploads/2026/09/unified-planning-model-third-party-integrations-api-1024x576.jpg)

When confirmed student registrations in the Student Information System feed directly into the planning model without a manual extract-and-import step, finance has live visibility into the enrolment-driven revenue position throughout the intake period.

**Read more:** [Infor EPM: The FP&A Platform for Modern CFOs](https://trginternational.com/blog/infor-epm-enterprise-budgeting-forecasting-planning-guide/)

Additionally, cloud platforms provide a single, secure environment where department heads enter budget requests into standardised online templates while role-based access ensures that only relevant stakeholders see and edit their designated cost centres. Then, automated approval workflows route budget requests to the appropriate dean, finance director, or bursar, generating an immutable digital audit trail of every change, comment, and sign-off.

### Live cost allocation based on actual drivers, not fixed percentages

Modern financial planning platforms address the shared cost allocation problem through statistical accounts and live allocation drivers. Rather than fixing a percentage split at the start of the year and applying it regardless of what happens to the underlying driver, the platform is configured to allocate central costs in proportion to the current period’s actual student headcount, user licence count, or whichever operational metric best reflects each campus’s consumption of the shared resource.

For instance, when the Bangkok campus’s student headcount falls, its allocation of central IT costs falls with it. Or when the Ho Chi Minh City campus adds a cohort, its share of the shared faculty resource increases accordingly. Campus principals reviewing their P&L can see that their overhead charges reflect their actual operational footprint rather than a fixed percentage decided twelve months ago. The allocation is mathematically fair, dynamically adjusted, and fully auditable.

### Automated consolidation with intercompany eliminations

For multi-campus groups operating across multiple currencies, automated consolidation eliminates the most time-intensive and error-prone part of the monthly close process. When actuals flow from the financial management system into the planning platform automatically, via an integration layer that handles currency translation, finance no longer needs to spend days extracting, converting, and consolidating campus-level figures.

[Intercompany eliminations](https://blog.trginternational.com/what-is-intercompany-accounting) configured in the system run automatically as part of the consolidation process. Management fees charged by the group entity to campuses are eliminated against the corresponding income in a single system step, and the consolidated group P&L is available as soon as each campus period close is completed.

### Dimensional tagging for restricted fund compliance

The restricted fund tracking problem can be solved by tagging transactions with fund dimensions at the point of posting, thus eliminating the need to maintain a separate spreadsheet for compliance. When a grant disbursement is coded to the correct fund dimension in the financial management system, the compliance reporting is automatically available from the same system that recorded the transaction.

Finance can run a real-time report showing all expenditures against a specific grant, coded by expense category, cross-referenced against the grant covenant’s permitted uses, and reconciled to the fund balance, without opening a separate spreadsheet. When an external auditor asks for a complete transaction record for a specific grant, the report is generated in seconds from a system-generated audit trail.

### **Continuous and Scenario-Based Forecasting**

Instead of treating budgeting as an annual static exercise, modern solutions like [cloud-based Enterprise Performance Management (EPM) platforms](https://trginternational.com/solutions/infor-epm/) empower finance teams to model complex scenarios and maintain continuous rolling forecasts:

Planning Scenario

What it looks like with spreadsheets

What it looks like with an EPM platform

**Enrolment drops 8% at one campus mid-intake**

Finance manually revises the campus revenue tab, updates the staffing cost tab separately, then rebuilds the group P&L from scratch.

The full impact on group EBITDA takes 2-3 days to work through. Scholarship commitments are not updated because they live in a separate file.

The enrolment driver is adjusted once. Tuition revenue, variable staffing cost, scholarship expense, and campus contribution margin all recalculate automatically. The CFO sees the full group P&L impact within minutes, including the effect on campuses whose shared cost allocation has shifted.

**Group consolidation at quarter-end across 4 campuses in 3 currencies**

Finance exports actuals from each campus system, converts to group reporting currency at the relevant exchange rates in a side spreadsheet, manually identifies and removes intercompany management fee transactions, and assembles the group P&L. The process takes 2-3 weeks. Missed eliminations surface at the annual audit.

Actuals flow automatically from each campus financial management system into the planning platform. Currency translation is applied at the configured exchange rate. Intercompany eliminations run as part of the consolidation step. The group P&L is available as soon as the last campus closes its period.

**Board asks: what is each campus’s true cost per enrolled student this quarter?**

Finance exports the cost data, exports the enrolment figure from the student information system, and builds the calculation in a new spreadsheet. Shared central costs are allocated using last year’s fixed percentage splits, which no longer reflect current enrolment ratios.

The metric is available from the live planning model because student headcount is a configured driver and shared costs are allocated in proportion to current enrolment. Finance runs the report and presents it in the same board session where the question was asked.

**External auditor requests a full transaction record for a restricted scholarship fund**

Finance opens the fund tracking spreadsheet, reconciles it against the general ledger for the period, traces missing entries through email approval threads, and reconstructs any transactions posted to the wrong code.

Finance runs a report from the financial management system filtered by the fund dimension. Every disbursement, coded at the point of posting, is returned with the date, amount, expense category, and the campus that processed it. The auditor has a complete, system-generated transaction record in minutes.

All in all, the budget is not the problem; the school’s finance process is. Your finance team already have the skills; what they need is the right tools. Yet they are given tools that make manual workarounds more effective, to the point that they become routine. As a result, most figures presented to the board of management are already partially outdated.

The four bottlenecks described in this article can be eliminated, and process redesign requires a planning infrastructure built for the specific complexity of multi-campus education finance, including live enrolment drivers, automated consolidation, real-time cost allocation, and dimensional fund tracking that generates its own audit trail.

The institutions that invest in that infrastructure now are the ones that will close their next budget cycle faster, present their board with timely insights, and walk into their next audit with a compliance record that the system generated, not that the finance team reconstructed.

**The big question now is: Is your budget fit for 2027? Interested in exploring how effectively businesses in Vietnam, Thailand, and Cambodia produce their annual plans? Download our toolkit (with a not-so-secret complimentary resource added) today!**

[![Is your budget fit for 2027?](https://no-cache.hubspot.com/cta/default/125873/interactive-221126919505.png)](https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/redirect?encryptedPayload=AVxigLLd2e7FA35smR8JBljZK%2B%2BHfDJE1tFRlXDpzg%2FXXqg83istC5Zz%2F8yiszW67Nb9e5pMW8r9G1QLolgwfGnQk1OjtZSFewgLCtxNNqTM%2FmFYZi8ExxDQ3%2BgZE1ZCAv2pV0SyxZqvJTTbZWA1Hv1QEyAc3qXren42iGtyLU4f9LoSMhMrqHmjpm1H09R8hofiKiXMosb99cpLjv9%2FcRmd92qW&webInteractiveContentId=221126919505&portalId=125873)

## Frequently asked questions

### Why does the budget cycle take so long at international school groups?

The primary driver of long budget cycles in education is the multi-department, multi-campus submission and consolidation process. Each campus and department submits its own budget independently, and finance must reconcile inconsistencies, resolve version conflicts, and rebuild the consolidation from scratch each year.

### What is the biggest budgeting challenge international school groups make?

The most consequential hurdle is building the budget on a fixed enrolment assumption without a mechanism to detect and respond to enrolment changes during the intake period. A mid-year enrolment shortfall may not be identified until the first quarterly review, leaving the institution three or four months into the year with a cost base that no longer matches available revenue.

### What financial management software is used in international schools?

International school groups typically require [financial management solutions](https://trginternational.com/industries/education/) that support multi-entity consolidation, multi-currency reporting, and dimensional analysis across campuses, programmes, and funding sources. [Infor SunSystems Cloud](https://trginternational.com/solutions/infor-sunsystems-cloud/) is widely deployed in education groups across Asia Pacific for financial management and reporting; [Infor EPM](https://trginternational.com/solutions/infor-epm/) extends that with dedicated budgeting, forecasting, and scenario planning capability.

### How does Infor EPM handle enrolment-driven revenue planning in schools?

[Infor EPM supports driver-based planning](https://trginternational.com/blog/infor-epm-enterprise-budgeting-forecasting-planning-guide/), which means student headcount can be configured as the master driver that determines tuition revenue, staffing ratios, variable cost allocations, and scholarship expense across all campuses simultaneously. When the revenue manager or admissions team updates the enrolment assumption, all downstream financial lines recalculate automatically. This gives the CFO a real-time view of the full financial impact of any enrolment movement.

**For more FAQs on our solutions, please check out our dedicated frequently asked questions page [here](https://trginternational.com/faq/) or share your queries with us via the [contact us form](https://trginternational.com/contacts-and-locations/).**