The spreadsheet that runs the department
Every university department has one. A budget spreadsheet maintained by the department administrator, updated when someone remembers, and reconciled against the bank statement at month-end.
Faculty heads check it before approving purchases. Researchers reference it before ordering lab supplies. The finance office uses it to track spending against allocations. Everyone relies on it, and it is always out of date.
The problem is structural. Spreadsheets are static documents in a dynamic spending environment. A purchase made on Monday does not appear in the spreadsheet until someone enters it, which might be Thursday, or next week, or never if the receipt gets lost.
For universities managing dozens of departments, each with their own budget, the aggregate effect is significant. The central finance team spends days each month reconciling departmental spending against allocations, chasing missing receipts, and correcting spreadsheet errors.
Three problems with university expense management
1. Shared procurement cards obscure accountability. Most departments share one or two procurement cards. When multiple researchers and administrators use the same card, attributing purchases to specific projects, grants, or cost centres requires manual detective work after the fact. The finance office spends hours each month sorting through transactions that could have been attributed automatically at the point of purchase.
2. Reimbursements burden academic staff. Researchers and lecturers frequently pay for conference travel, books, and supplies out of pocket, then submit reimbursement claims that take weeks to process. This is particularly problematic for early-career researchers on limited salaries, who may be out of pocket for hundreds of dollars while waiting for the university’s reimbursement cycle to complete.
3. Grant spending is hard to track in real time. Research grants have strict spending rules and reporting requirements. When grant expenditure is tracked in a spreadsheet that is updated weekly, the principal investigator cannot see the true remaining balance when making purchasing decisions. This creates a risk of either overspending the grant or leaving funds unspent because the researcher is uncertain about the remaining balance.
Teach For Australia, which operates across education institutions, found that expense management consumed significant administrative time:
Teach For Australia cut expense management time in half after switching from manual processes to automated tracking.
What per-department budget management looks like
The replacement for spreadsheet budgets follows the same pattern that works for schools and multi-site organisations:
Each department gets its own budget. The School of Engineering has a different allocation than the School of Arts. Each budget has a limit, a reset cycle (typically per semester or per financial year), and its own set of cards.
Individual cards for authorised staff. Instead of sharing a procurement card, each department administrator, researcher, or project lead gets their own card linked to their department’s budget. Purchases are automatically attributed to the right person and the right cost centre.
Grant budgets are separate. Research grants can be set up as individual budgets with their own cards and spending controls. The principal investigator sees the remaining balance in real time and can track spending against grant categories.
Receipts are captured at the point of purchase. The buyer photographs the receipt on their phone. It is matched to the transaction, categorised, and available for reporting immediately.
The finance office sees everything. A central dashboard shows spending across all departments, all grants, and all cost centres in real time. Month-end reconciliation becomes a review process, not a reconstruction.
How this changes month-end for the finance office
The central finance team at a university typically spends the first week of each month reconciling departmental spending. This involves:
- Downloading bank statements for each procurement card
- Matching transactions to purchase orders and receipts
- Chasing departments for missing documentation
- Correcting spreadsheet entries that do not match the bank feed
- Preparing reports for each department head
With real-time expense tracking, most of this work is eliminated. Transactions are already matched to receipts, categorised, and attributed to departments. The finance office reviews and approves rather than reconstructs.
The time savings are not limited to the finance office. Department administrators who previously spent hours each month updating budget spreadsheets and chasing colleagues for receipts can redirect that time to supporting academic and research activities. For departments with large research portfolios, this means the administrator can focus on grant compliance and reporting rather than basic expense reconciliation.
Aspire Education, which manages 15 centres (a comparable multi-site challenge), found that each centre saved one day per week on administration after switching. Aurora Southern Highlands Steiner School saves 4 hours per week on expense-related administration. These time savings are consistent across education institutions regardless of size, because the underlying problem is the same: manual processes that do not scale.
Research grant compliance
Research grants from bodies like the ARC, NHMRC, and university internal funds have specific spending rules. Funds must be spent within approved categories, within the grant period, and with complete documentation.
Real-time budget tracking with per-grant visibility gives principal investigators confidence that they are spending within their allocation. It also gives the research office confidence that grant funds are being used appropriately, without requiring manual audits.
The practical difference is significant. A principal investigator managing a three-year ARC Discovery grant can check their remaining balance before ordering equipment, rather than emailing the department administrator and waiting for a spreadsheet update. When the grant period ends, the final acquittal report draws from structured transaction data rather than a manual reconstruction of three years of bank statements.
For departments managing multiple concurrent grants, the ability to see all grant budgets on a single dashboard eliminates the risk of accidentally spending one grant’s funds on another grant’s expenses. Each grant operates as its own ring-fenced budget with its own cards and controls.
The same structure works for university-funded research centres, industry partnerships, and philanthropic endowments. Each funding source gets its own budget, its own reporting, and its own audit trail. Transaction data syncs to Xero automatically, so the finance office receives clean, categorised data rather than raw bank feeds that need manual sorting.
For universities considering the switch, the education expense management solution page covers the full feature set. For a broader look at how business budgeting software handles multi-department budgets, see the product overview. For expense management software that replaces shared procurement cards, see the product page.
