Overview
EduSchools provides comprehensive financial reporting tools to help you track revenue, monitor outstanding fees, analyze payment trends, and generate professional statements for students and auditing purposes.
- Operational Reports: Daily/weekly reports for fee tracking
- Student Reports: Individual statements and receipts
- Analytical Reports: Trends, aging, and collection analysis
- Compliance Reports: Audit trails and financial period summaries
Available Reports
1. Aging Report
Navigate to Finance → Reports → Aging Report
The Aging Report shows outstanding balances categorized by how long they've been overdue.
Report Structure
| Category | Description |
|---|---|
| Current | Not yet overdue (0-30 days) |
| 31-60 Days | 1-2 months overdue |
| 61-90 Days | 2-3 months overdue |
| 90+ Days | Seriously overdue (requires immediate action) |
How to Use
- Select academic year
- Filter by grade (optional)
- Export to Excel/PDF
- Use for collection priority planning
Accounts in the 90+ days category should receive immediate attention. Consider payment plans, reminders, or collection procedures.
2. Collection Report
Navigate to Finance → Reports → Collection Report
Tracks payment collection trends over time with visual charts and summaries.
Report Features
- Monthly collection totals
- Payment method breakdown
- Collection rate percentage
- Comparison to previous periods
- Outstanding vs. collected visualization
Best Uses
- Monthly financial reviews
- Board presentations
- Cash flow forecasting
- Identifying payment patterns
3. Student Statement
Navigate to Finance → Reports → Student Statement
Generate detailed financial statements for individual students or families.
Statement Includes
- Student and family information
- All fees charged
- All payments received
- Discounts applied
- Penalties assessed
- Current balance
- Transaction history with dates
Generation Options
- Date Range: Specify start and end dates
- Format: PDF (for printing) or Excel (for analysis)
- Delivery: Download, print, or email to parent
- Include Details: Show/hide transaction details
Tip: Send statements at the end of each term to keep parents informed.
4. Payment Receipt
Navigate to Finance → Reports → Payment Receipt
Generate official payment receipts for any transaction.
Receipt Information
- Official receipt number
- Payment date and amount
- Payment method
- Received from (student/family name)
- Purpose of payment
- Remaining balance
- School letterhead and logo
Usage
- Print immediately after recording payment
- Email receipt to parent
- Reprint old receipts from transaction history
- Attach to correspondence
5. Grade Fees Outlook
Navigate to Finance → Reports → Grade Fees Outlook
Summary of fee charges and payments by grade level.
Report Shows
- Total fees charged per grade
- Total payments received per grade
- Outstanding balance per grade
- Collection rate percentage per grade
- Number of students per grade
- Average fees per student
Strategic Uses
- Identify which grades have collection issues
- Budget planning for next academic year
- Compare fee structures across grades
- Resource allocation decisions
6. Outstanding Fees Report
Navigate to Finance → Reports → Outstanding Fees
Comprehensive list of all students with outstanding balances.
Report Details
- Student number and name
- Grade and family information
- Total fees charged
- Total payments made
- Outstanding balance
- Days overdue
- Last payment date
- Contact information
Filtering Options
- Filter by grade
- Filter by minimum balance amount
- Filter by days overdue
- Sort by balance (highest to lowest)
- Sort by days overdue
Use this report weekly to:
- Identify accounts needing reminders
- Plan collection phone calls
- Prepare payment arrangement meetings
- Track collection progress over time
Report Customization
Date Range Selection
Most reports allow you to specify:
- Start Date: Beginning of reporting period
- End Date: End of reporting period
- Quick Options: This Month, This Quarter, This Year, Last Year
Export Options
- PDF: Best for printing and emailing
- Excel: Best for further analysis and manipulation
- Print: Direct printing from browser
Filters
Apply multiple filters to narrow results:
- Academic year
- Grade level
- Payment status
- Balance threshold
- Date ranges
Report Scheduling (Future Feature)
Future versions will include automated report scheduling:
- Email reports automatically on set schedules
- Daily, weekly, or monthly delivery
- Send to multiple recipients
- Custom report templates
Best Practices
Daily
- Review transactions recorded today
- Check for processing errors
Weekly
- Outstanding Fees Report
- Collection progress tracking
- Send payment reminders
Monthly
- Collection Report
- Grade Fees Outlook
- Aging Report
- Send student statements
- Board financial summary
Quarterly
- Comprehensive financial review
- Budget vs. actual analysis
- Trend analysis across quarters
Annually
- Year-end financial statements
- Audit preparation reports
- Annual collection rate analysis
- Budget planning for next year
Interpreting Financial Data
Collection Rate
Formula: (Total Payments ÷ Total Fees Charged) × 100
| Rate | Status | Action |
|---|---|---|
| 95-100% | Excellent | Maintain current practices |
| 85-94% | Good | Standard follow-up |
| 75-84% | Fair | Increase reminder frequency |
| Below 75% | Poor | Review fee policies and collection procedures |
Key Performance Indicators (KPIs)
- Average Days to Pay: How long it takes families to pay
- Outstanding Balance Ratio: Outstanding ÷ Total Charged
- Bad Debt Percentage: Uncollectable ÷ Total Charged
- Payment Method Mix: Distribution across payment methods
Common Tasks
Generate these reports for auditors:
- Complete transaction history for the period
- Collection report with totals by month
- Reconciliation reports for all bank accounts
- Outstanding fees report as of period end
- List of all discounts and refunds with approvals
- Chart of accounts summary
Currently, you can email individual statements from the Student Statement page by clicking "Email to Parent".
For bulk statements, you'll need to:
- Generate statements for all students
- Export as PDF
- Use your email system to send to families
Automated bulk email delivery is planned for a future release.
Recommended schedule:
- Monthly: For accounts with activity
- End of Term: Comprehensive statements for all families
- Before Holidays: Reminder of outstanding balances
- On Request: Any time a parent requests their statement
More frequent communication improves payment rates and reduces disputes.