Education ERP Consultant, Canada

Provincial rules, one system design

Because education is regulated by each province, two schools with the same size and curriculum can face quite different back-office requirements. Some provinces provide partial funding to qualifying independent schools, with reporting conditions attached; others provide none, so tuition and fundraising carry the full cost. Private career colleges are registered and overseen provincially, and the rules on student contracts, tuition protection and refunds come from that framework.

Sales tax adds another layer. Many educational services are treated as exempt from GST or HST, but goods and some services a school sells, such as uniforms, meals, camps or textbooks, may be treated differently, and provincial sales tax or QST can apply in its own way. Your accountant confirms each case; the ERP needs tax codes per fee item and per province.

For an organization operating in more than one province, I document these differences side by side and design one chart of accounts with province and campus dimensions rather than separate systems. Readers wanting the sector-wide view can start with ERP for education; national tax and trade notes are on the Canada overview.

Independent schools: donations, receipts and charitable reporting

Many Canadian independent schools are registered charities, which brings donation receipting and charitable reporting into the finance system. Annual giving, capital campaign pledges paid over several years, gifts in kind and endowed bursary funds all need to be recorded so that official receipts are accurate and restricted money is spent as intended. Families may also look to the school for receipts connected to tuition or childcare components at tax time, depending on the program and the rules that apply.

In practice, schools often keep donor records in a fundraising database and send summaries to finance, while tuition sits in a separate student billing tool. Reconciling the two is where errors appear, especially when a family both pays tuition and makes a gift.

I map the full cycle from pledge to receipt to fund release, decide with your finance lead and accountant which system issues which receipt, and define the data that passes between them. Where a general ERP cannot carry fund restrictions cleanly, I say so and propose a connected specialist tool rather than forcing it. The gap analysis is where that decision is documented.

International students, homestay and agent commissions

International students are central to many Canadian independent schools, language schools and colleges, and they create billing that domestic families never see. A single student may owe an application fee, a tuition deposit required for an acceptance letter, full tuition, homestay placement and monthly homestay fees, custodianship services, medical insurance, airport pickup and activity programs. Payments arrive by international wire, card or payment platforms, sometimes in currencies other than Canadian dollars.

Behind the scenes, homestay families are paid monthly, so the school is both billing students and paying hosts for the same placement. Education agents who refer students earn commissions on agreed terms, which have to be calculated, approved and paid, and sometimes clawed back if a student withdraws early. Refund rules for students whose study permit is refused also need clear handling.

I design the student account, the homestay payable cycle and the agent commission process together, so the international office and finance work from the same figures. That design usually sits at the center of the solution design for schools with significant international enrollment.

Private career colleges and refund policies

Private career colleges in Canada sell programs that can run for months, often paid through a mix of personal funds, installment plans, government student loans and grants, or third-party sponsors such as employers and agencies. Each funding source arrives on its own schedule and has to be matched to the right student account and program period.

Refunds are the area where colleges most often struggle. Provincial frameworks typically set how much is refundable depending on when a student withdraws, and contracts must reflect them. When refunds are calculated by hand in a spreadsheet, mistakes and delays follow, and they are visible to regulators and students alike.

I document the college's refund policy as rules the system can apply, tied to program start dates and withdrawal dates recorded in the student system. I also design deferred revenue for multi-month programs, so income is recognized as the program is delivered rather than when cash arrives, following your accountant's guidance. Admissions advisors, finance and the registrar review the design together. For a structured approach to writing these rules, see my ERP business analysis for Canada.

French, English and remote delivery across time zones

Schools and colleges in Quebec, and organizations serving francophone families elsewhere, often need invoices, statements, receipts and parent communication in French, with English versions for others. I list every document and notification that needs both languages and check the templates during evaluation, because translation quality and layout vary between platforms.

Go-live timing follows the school year. For K-12 independent schools, the safest window is usually after final summer statements and before fall tuition is billed, with care to avoid the first weeks of re-enrollment. Colleges with monthly intakes often switch at the start of a quieter intake rather than a calendar date. Open balances, deposits held for incoming international students and active installment plans are reconciled before cutover.

I deliver all of this remotely, planning live sessions around the time zone of your head office and using recorded walkthroughs for campuses further east or west. On-site visits are available only by arrangement. To learn how I support Canadian organizations outside education, see ERP consulting in Canada.