Financial Management for Homeschool & Microschool Co-ops

Executive Summary

Most homeschool co-ops and microschools manage finances with tools that were never built for them — and it shows. Tuition is tracked in spreadsheets. Step-Up scholarship disbursements are reconciled by hand. Invoices are built one at a time. Collections are reactive. Admissions and billing live in separate systems with no connection between them.

The problem, in three points:

• Families pay differently than businesses do — per-family sibling discounts, two separate payment streams (checks and state scholarships), and multiple programs with different schedules — none of which generic billing tools support natively
• The administrative team is tiny: the person doing billing is also the teacher, the event coordinator, and often a parent; there's no margin for a steep learning curve or a tool that requires a manual
• Florida's Step-Up for Students scholarship program creates a compliance obligation for every participating school — an adequate accounting system, proper fund classification, and expenditure documentation — that spreadsheets cannot satisfy

What Microschool Ledger does, in three points:

• Handles the full family lifecycle end-to-end: public inquiry → admissions pipeline → enrolled family → tuition charges → Step-Up reconciliation → family portal → year-end audit — in one place, with no installation and no IT department
• Eliminates the Step-Up reconciliation bottleneck: paste the EMA portal export and the system matches every disbursement to the right student and program automatically; re-imports are safe and deduplicated
• Produces the accounting records a CPA needs for the AUP audit — P&L, expense detail by category, scholarship funds received — with a one-click Export for CPA workbook

"Before Microschool Ledger, managing tuition required cross-referencing spreadsheets, manually reconciling StepUp portal exports, and building invoices by hand. Collections were reactive — overdue balances were discovered late."

Microschool Ledger has been running at The Grow Co-op in South Florida since 2024, managing six-figure annual revenue across multiple programs, two payment sources, and 20–30 families. It is available now for homeschool cooperatives and microschools. To schedule a demo: info@microschoolledger.com

1. The Problem With Generic Tools

Most homeschool co-ops and microschools start managing finances the same way: a Google Sheet for tuition tracking, a separate spreadsheet for expenses, an accounting app that was designed for a dental office, and a lot of manual work in between. For a small organization run by parents and teachers, this works — until it doesn't.

As enrollment grows and the Florida Step-Up for Students scholarship program adds a second payment stream to reconcile, the spreadsheet approach starts to crack.

2. What Microschool Ledger Is

Microschool Ledger is a purpose-built financial management system for homeschool cooperatives and microschools. It handles the full family lifecycle — from the first public inquiry through the admissions pipeline, enrollment, monthly charge generation, payment reconciliation, collections, family self-service, and year-end reporting — in a single tool that understands how co-ops actually operate.

It was built from scratch at The Grow Co-op in South Florida and has been in active use since 2024, managing six-figure annual revenue across multiple programs, two payment sources, and 20–30 families.

What makes it different:

• Built specifically for co-ops — not adapted from a tool designed for businesses or schools
• Family-based billing with sibling discount tiers, not per-student invoicing
• Native Florida Step-Up for Students integration — no manual data entry from the portal
• Full admissions pipeline from public inquiry to enrolled student, with one-click Convert-to-Family
• No installation, no servers, no IT required — runs entirely in a web browser
• No per-seat licensing — a flat monthly fee regardless of how many admins use it
• Full audit log of every data change, with before/after state and user email

Technology: Microschool Ledger runs in any modern web browser, hosted on Firebase (Google's cloud infrastructure) with real-time data sync. All data is backed by Firestore, Google's managed database — no server to provision, no backups to configure, no maintenance windows. There is no installation. There is no app to download.

3. Features in Detail

3.1 Home Dashboard

The home dashboard is action-oriented — it surfaces what needs attention immediately, rather than presenting a wall of charts.

• Collection Progress card — inline progress bar (green/amber/red) showing the percentage of past-due expected revenue that has been collected
• StepUp import reminder — amber action card appears when no StepUp import has run in 7 or more days; shows pending count and prompts a re-import when payments clear
• Overdue families flagged at the top with balance amounts
• Enrollment counts by program and school year
• Quick-action shortcuts to the most common workflows
• Session tracking and login/logout audit trail

3.2 Admissions Pipeline

The family relationship starts before enrollment. Microschool Ledger includes a full admissions system that takes a prospective family from first contact to enrolled student — with no re-keying of data between admissions and billing.

Public forms — no login required:

• A lightweight interest form captures contact info and custom questions, dropping submissions straight into the leads pipeline automatically
• A full application form supports multiple students per family, multiple guardians, essay prompts, a required-document checklist, scholarship interest per student, and an electronic signature on submission

Two-stage pipeline:

Convert to Family in one click — when an applicant is accepted and enrolled, their complete record (guardians, students, funding details) converts to a live family in the billing system. No duplicate data entry. No mismatched records.

Pipeline reporting — live funnel counts by stage, plus a projected-revenue table that applies the school's own conversion-rate assumptions to forecast expected enrollment and tuition revenue.

Configurable admissions (Setup → Admissions) — entry terms, grade range, essay prompts, required checklist items, optional application fee, and interest-form questions — all editable per school with no code changes.

3.3 Families & Students

Microschool Ledger is organized around families, not individual students. Every record flows from a family, which carries the billing relationship, contact information, and family type.

• Primary parent name, family type, email, phone, and address
• Smart status badges: Paid in Full, Balance Due, Payment Overdue
• Auto-sorted by balance (highest owed first) for easy prioritization
• Search and filter by name, status, or balance
• Globe badge indicates which families have portal access enabled

All family types and rates are configurable in Setup. Nothing is hardcoded.

3.4 Catalog — Programs & Fee Items

The Catalog tab is the single place to define everything that generates a charge:

• Programs sub-tab — define programs with payment plan schedules: deposit percentage, deposit month, number of payment months, start month, and frequency (monthly or quarterly). Year-specific plans allow different pricing and schedules each academic year.
• Fee Catalog sub-tab — a library of reusable fee items: registration fees, materials charges, technology fees, field trip costs — each with a unit price, unit label, and expense category.
• Auto-apply on enrollment — tag a catalog item to one or more programs. When a student enrolls in a tagged program, a flat charge is automatically generated — no manual step required.

3.5 Enrollment & Tuition

Enrollment is the core of Microschool Ledger's billing logic. When a student is enrolled in a program for a school year, the system generates a complete schedule of charges automatically — no manual calculation required.

The guided enrollment wizard lets the administrator select family → student → program → school year. Annual tuition is looked up automatically from pricing rules based on family type and sibling position. The system previews the full charge schedule before saving.

Sibling discounts are calculated per program. Discount percentages are configurable per program in Setup. Teacher families also receive sibling discounts at the applicable rates.

Microschool Ledger supports multiple simultaneous school years — useful during March–May when next year's deposits are being collected alongside the current year's monthly payments.

3.6 Flat Charges

Add a charge that isn't tied to a tuition enrollment — a $300 Writing Workshop semester fee, a $50 registration fee, a $150 materials charge. Each flat charge has: description, amount, due date, school year, category (Tuition / Registration / Materials / Other), and an optional student link. Flat charges flow into the family balance automatically and appear as "Other Charges" on invoices.

3.7 Field Trips

Create field trips with date, location, status (draft / open / confirmed / cancelled), capacity, and a cost structure (per student / per adult / per sibling). Families RSVP through the parent portal. The server validates capacity atomically — a database transaction prevents overbooking even if multiple families submit RSVPs simultaneously. Overflow goes to a managed waitlist. One click generates flat charges for all confirmed RSVPs based on the trip's cost structure.

3.8 Payments & Reconciliation

Microschool Ledger manages two completely different payment streams — direct family payments and Florida Step-Up scholarship disbursements — and reconciles them against the same family balance.

• Manual payments — record payments by check, Stripe, or other method; appliedYear field explicitly tags each payment to a school year
• Florida Step-Up CSV import — paste the EMA portal export directly; payments are matched by student sequence number; deduplication on re-import; program attribution is automatic
• Fill StepUp Invoice CSV — paste an EMA Service Orders export to auto-populate the Business Invoice # column for each row; saves hours of manual lookup work per billing cycle
• Bulk payment import — Stripe CSV exports imported in bulk with fuzzy family name matching; bank transaction CSV import with automatic income/expense detection

3.9 Invoicing & Collections

The collections dashboard sorts all families by current balance — highest owed at the top — with overdue status flagged prominently. A direct "Add Payment" shortcut is available from the collections row.

Starting in 2026–2027, every family has a 4-character invoice prefix automatically derived from their last name (e.g. SMIT). Each charge on an invoice carries a formatted invoice number — SMIT-2627-DEP for the deposit, SMIT-2627-JUN for June, and so on.

Each school sets its own invoice title, payment instructions block (Venmo handle, check payable-to, bank account details), header note, and footer note — all in Setup → School Info with no code changes required.

Automated payment reminders:

• A nightly job reviews every family with an outstanding balance and an email address on file
• Families outside a 28-day cooldown window are queued for admin review — no emails fire automatically
• The administrator previews each pending reminder (To, Subject, balance amount) and approves before it sends
• Replies from families go directly to the school's inbox, not to the platform

3.10 Family Portal

Families access their own account at the school's portal link with no admin login required. Sign-in is passwordless — the parent enters an email address, clicks the link that arrives, and is signed in instantly. A parent can sign in with any email the school already has on file for their family, so there is no separate invitation to send and track first — a school can switch the portal on for every family at once. (An optional branded invite email is still available as a nudge.)

What families can do:

• View current balance with status badge (Paid in Full / Balance Due / Payment Overdue)
• Review full enrollment detail for the current year
• Access complete payment history and printable invoices
• RSVP to upcoming field trips (waitlist handled automatically)
• Pay online — credit card, ACH bank transfer, Apple Pay, or Google Pay via Stripe; autopay enrollment available for automatic monthly settlement
• Update their own contact information — parent names, email, phone, mailing address, a second guardian, and how they'd like to hear from the school — from a self-service My Info tab; corrections flow straight back into the school's records

Multi-parent access: a family can authorize more than one parent email (e.g. two households); each parent gets their own passwordless sign-in to the same account.

"Confirm your family info" campaign: to refresh contact data — for example at the start of a new year — the school can email every family a private, no-login link to a pre-filled form where parents confirm their details and opt in to email and text updates. Answers merge back into the record automatically. The school can target the whole family list or just the families enrolled for the coming year, and can send a test to one family before the full send.

No-login payment links: for families who would rather not sign in, the school can send a secure payment link that opens a public payment page showing the family's live balance. Reminder and invoice emails embed it automatically. The amount, family, and target are derived server-side from the stored link and capped to the outstanding balance, so a link cannot be tampered with to misapply or overcharge a payment.

Access is enforced at the database layer — not just in the UI. A portal family cannot access another family's records or any financial data that isn't their own, regardless of what the browser requests.

3.11 Financial Reporting & P&L

• P&L Overview — Revenue (Projected vs. Collected vs. Variance), Expenses (Budget vs. Actual vs. Variance), and Net Income in one unified table; filterable by school year and program
• Cash Flow view — month-by-month table of expected income vs. actual received, with variance and cumulative columns; know exactly which months you're behind on collections and by how much
• Financial Health view — break-even analysis, revenue per student, year-over-year trends, revenue forecast through end of year
• Expense tracking — date, amount, description, category, subcategory, program attribution, vendor; configurable categories with per-year budget targets; CSV import and category manager
• AUP Compliance tab — auto-computed readiness checklist; total StepUp funds received with amber warning at the $250,000 threshold; one-click Export for CPA workbook

3.12 Administration & Security

Role-based access: multiple roles (Admin, Viewer, and others) enforced at the database layer — not just the UI. Admin users require a server-side grant after verifying access-list membership. Logging into Google is not enough on its own.

Full audit log: every create, update, and delete action is logged with the action type, entity changed, full before and after state, user email, and timestamp. Filterable by action type and entity topic.

Automated nightly backups: data is backed up to Google Cloud Storage every night at 2 AM. Up to 30 days of backups are available in Setup → Data Tools with one-click restore. Selective restore shows backup vs. live record counts and restores only the collections you select — the recovery path for a single wiped collection without rolling back everything else.

3.13 QuickBooks Online Integration

For schools whose accountant or bookkeeper works in QuickBooks Online, Microschool Ledger connects directly via the official Intuit OAuth flow — no manual data export required.

• OAuth connection — an admin connects the school's QBO account in Setup with one click; Microschool Ledger handles the token exchange and refresh automatically
• Customer reconciliation — QBO customers (parents and student sub-customers) are pulled and matched against Microschool Ledger's family and student records; unmatched records on either side are flagged for review
• StepUp Allocation Report — generates a QBO-ready summary of Step-Up scholarship disbursements by student, program, and funding source; designed to map cleanly to QBO's class/customer structure
• Payment pull and matching — QBO payments can be pulled and matched against Microschool Ledger ledger entries with a side-by-side reconciliation view; admin reviews before any ledger write

The integration is read-and-reconcile, not write-and-sync — which avoids the common failure mode where a two-way sync creates duplicate or misattributed entries in both systems. Tokens are stored server-side only and never exposed to the browser.

3.14 Communications

Send targeted announcements to the right families — returning vs. new, enrolled in a specific program, or the full roster — without a separate email tool. Audience segments are built from live enrollment and family data, and a message can start from a saved template. A reusable template library ships with 9 ready-made microschool templates — re-enrollment intent, missing documents, Step Up/ESA approval reminders, autopay failure, field trip deadlines, beginning-of-year assessments, weather closures, volunteer/fundraiser asks, and scholarship award follow-up — alongside the option to write your own.

Automated flows follow up on the admissions pipeline without staff having to track every lead by hand: a nurture series for interested families who haven't applied yet, reminders for applicants who started but didn't finish, and reminders for accepted families who haven't confirmed their spot. Every automated flow — including the "Confirm your family info" campaign (§3.10) — is turned on or off, and its live sent/pending/failed counts reviewed, from one place. A unified send history covers manual sends, workflow sends, and automated sends together, and unsubscribe management is built in.

4. The Annual Workflow

Microschool Ledger is designed around the homeschool co-op school year calendar. Understanding the annual workflow shows how all the features work together.

5. Florida Step-Up for Students — Deep Dive

For Florida co-ops, the Step-Up for Students scholarship program represents a significant portion of revenue. Many families rely on it to offset tuition. Managing it manually — entering disbursements from the portal one by one, checking them against student records, reconciling against invoices — can take hours per billing cycle.

Microschool Ledger eliminates that entirely.

How the import works:

1. Export from the Step-Up portal
2. Navigate to Payments → Import Step-Up in Microschool Ledger
3. Paste the tab-delimited data
4. Review matched and unmatched records
5. Import

Each record in the portal export contains a student sequence number. Microschool Ledger matches this to the corresponding student record in the system — so every disbursement is automatically attributed to the right student and reflected in that family's balance.

Program attribution:

The Step-Up portal uses a "Category Detail Name" field to indicate what the payment covers. Microschool Ledger uses this to automatically attribute payments to the correct program — no manual re-tagging required.

Deduplication & re-import:

Re-exports from the Step-Up portal are handled safely: existing records are identified by a composite key and not duplicated. If a previous import was missing program attribution data, a fresh import backfills that field on the existing record.

Fill StepUp Invoice CSV:

Before each scholarship submission cycle, schools must populate the Business Invoice # column in the EMA Service Orders export. Microschool Ledger automates this entirely — paste the EMA export, and the system derives the correct invoice number for each row from enrollment data. What used to require a manual lookup table is now a single paste operation.

Compliance documentation:

The family statement generated by Microschool Ledger includes Step-Up compliance language required for reimbursement documentation — automatically, on every statement, with no manual editing required.

6. AUP Compliance — A Statutory Requirement

Validated against the 2025-2026 Step Up Private School Handbook, Florida Statute 1002.421(1)(q).

The Step Up Private School Handbook establishes that AUP requirements apply uniformly to all private schools that receive scholarship funds — not just large ones. Every participating school must demonstrate:

1. An adequate accounting system and system of financial controls
2. A process for deposit and classification of scholarship funds
3. Proper expenditure of scholarship funds for education-related expenses

Schools receiving more than $250,000 in aggregate scholarship dollars in a school year must additionally contract with a licensed CPA to formally conduct an AUP engagement.

For private school prospects: "Microschool Ledger gives you the accounting system, financial controls, and expenditure records the StepUp AUP requires — out of the box."

7. Pricing Plans

Microschool Ledger is offered in three tiers, designed to let co-ops start with what they need and add capability as they grow. Every tier includes the core billing workflow — enrollment, tuition tracking, collections, and family statements.

Why it pays for itself:

Even at $199/month, Microschool Ledger typically pays for itself before the first Step-Up reconciliation of the month is run.

8. What's Next

Microschool Ledger is under active development, with a roadmap focused on deeper automation and tighter integration with the tools schools already use.

• Batch invoice generation — generate statements for all families at once as a ZIP of PDFs or a combined document, rather than one at a time
• Next Year Setup Wizard — an annual guided workflow that walks the administrator through: carrying over or updating programs, adjusting tuition rates with last year's rates shown for comparison, configuring payment plans, setting the expense budget, and re-enrolling returning students in bulk
• Pricing tier enforcement — in-app gating of Pro features by subscription tier, with upgrade prompts and trial access for new tenants
• Expanded QBO sync — automatic push of new MSLedger payments into QBO, reducing the reconciliation step to a confirmation rather than a manual match

9. Getting Started

Microschool Ledger is available now for homeschool cooperatives and microschools on the Pro plan (Essentials and Standard are coming soon). Onboarding includes a hands-on setup session — we configure your programs, pricing rules, payment plans, and import your existing family data together.

To schedule a demo or start onboarding, reach out directly: info@microschoolledger.com

What onboarding looks like:

1. Initial call to understand your co-op's programs, pricing structure, and current workflow
2. Setup session: programs, payment plans, pricing rules, and family types configured in Microschool Ledger
3. Data import: existing family and student records imported from your current spreadsheets
4. Walkthrough of the admissions pipeline, collections dashboard, statement generation, and Step-Up import workflow
5. Ongoing: priority support

What you'll need:

• A list of your active families and students (spreadsheet is fine)
• Your current tuition rates by family type and program
• Your payment plan structure (deposit amount, monthly schedule)
• Student sequence numbers from the Step-Up portal (for scholarship reconciliation)

Microschool Ledger has been running at The Grow Co-op since 2024. It currently manages 20–30 families, 40–60 students, and multiple programs across two school years simultaneously. It is actively maintained and expanded based on real administrator feedback.