Who this is for: school bookkeepers, finance secretaries, and district auditors running reports and tracking daily sales in Edlio Pay (OSP).
Core Financial & Sales Reports Catalog
Edlio Pay provides extensive reporting to support bank reconciliation, sponsor tracking, and auditing. Navigate to Reports or Reports >> Additional Reports:
Report Name | Best Used For | Menu Location |
Detail Sales Report | Full transaction breakdown showing order number, purchaser, item, payment method, and amount. |
|
Sales by Payment | Summarizes revenues grouped by credit card type, in-person cash/check, or batch settlement. |
|
Undeposited Receipts | Tracks in-person receipts entered into OTR or OSC that have not yet been batched into a deposit. |
|
Custom Fields Inquiry | Exports free-text answers and Form Fields data (such as t-shirt sizes, parent notes, or emergency contacts) to Excel. |
|
Refunded / Reversed Transactions | Audits all refunded line items, return reasons, and voided receipts across a selected date window. |
|
Taxable Items Only | Calculates total tax liability for items flagged as taxable for state and municipal remittance. |
|
Report Refresh Timing & Data Availability
Batch Synchronization: OSP reports draw from an aggregated reporting database that updates on scheduled intervals—typically twice daily (approximately 3:00 AM and 3:00 PM local time). If a customer just placed an order 10 minutes ago, it may not populate in historical summary reports until the subsequent refresh cycle.
Real-Time Lookups: If you need immediate confirmation of a recent payment before the next scheduled reporting batch, navigate to
Inquiry >> OSP Payment Inquiryto look up individual live transactions by order number or purchaser email.Report Sorting: On-screen report tables have fixed sorting presets. To sort by custom parameters (such as student last name or grade), click Export to Excel at the top of the report view.
Managing Automated Nightly & Statement Notification Emails
Edlio Pay automatically distributes financial summaries to authorized school contacts:
OSP Bookkeeper Nightly Sales Report: An automated daily email detailing all transactions completed over the previous 24 hours.
Undeposited Receipts Report: Alerts bookkeepers to outstanding in-person receipt totals awaiting deposit submission.
Semi-Monthly Statement Notices: Official notification containing deposit amount summaries and remittance dates.
Adding or Removing Email Recipients:
To add a new bookkeeper or remove an offboarding staff member from receiving nightly sales or statement emails, submit a request to Edlio Pay Support. Specify the school name, the exact notification type (e.g., Nightly Sales vs. Statements), and the email address to add or remove.
Troubleshooting Report Issues
Report Keeps Spinning / Loading: If a report fails to render, open an Incognito window or clear your browser cache and cookies. Extremely large date windows (e.g., pulling 3 full fiscal years at once) can time out; narrow your date filter to a single month or quarter.
Student Names Missing from Sponsor Report: If a product was configured with No Student ID Required checked on its Additional Options tab, purchasers are not required to select a student profile, so student names will not appear on the report.
Missing 'Custom Fields Inquiry' Menu: Access to export custom Form Fields data requires an elevated reporting permission. If this menu item is missing under Inquiry, contact Support to have the permission flagged on your user account.