Use in schools

Hi

I am requesting software advice / information on behalf of an Australian school board - K-12.

We are in the process of changing business manager. Our manager has been in place for almost 2 decades and has done a wonderful job, but budgets and finances in general have been inaccurate for a few years. Auditing suggests this is due to
- use of excel documents for calculations that have been edited and re-edited with altering formulae for many years so that errors have been compounding
- inaccurate budgets that were based almost entirely on this gentleman's spreadsheets
- a lack of forecasting software

We require software or a suite of software that can do the following...
- "talk to" our school management system LMS (SEQTA/school pro) to collect family and student data
- "talk to" and/or replace our current excel documents and formulae for student fees, HR related wages calculations, cost of consumables, taxes, rent/lease arrangements etc
- "talk to" our accounting software MYOB (that could be changed if an appropriate suite covered the services provided by MYOB)
- develop budgets with short and long term forecasts
- provide a dash board for reports (specifically strong in the area of KPI reporting
- ability to send/create invoices for multiple accounts
- ability to work on 2 campuses, keeping data separate but combined in some areas.

I am very keen to find a cloud based solution but we are open to advice. We can work with current systems, but the appointment of a new business manager means a unique opportunity has arisen where we can utilise a chance to move to cutting edge technological solutions.

Can this all be done through Zoho One?