Skip to main content

Online Student Invoicing (OSI) Quick Start Guide

Updated over 3 months ago

Overview

Online Student Invoicing (OSI) is a feature that allows schools to create and manage invoices for student debts, obligations, and fees in bulk. OSI works in conjunction with Online School Payments (OSP) and Online Teacher Receipting (OTR) systems.

Key Points:

  • OSI cannot be used independently - it requires either OSP or OTR

  • Designed for mass invoice assignment (hundreds or thousands of students at once)

  • Bookkeepers must be familiar with OSP and/or OTR operations

Getting Started

Prerequisites

Access Requirements

  • Premium Feature: OSI is only available to districts with premium access

  • Free Version Users: If using the standard free version of OSP, you likely cannot use OSI

  • OTR Users: Should have access to OSI by default

Required Knowledge

Before using OSI, you should understand:

  • How to create products in OSP

  • How to generate sales reports

  • How to process refunds

  • School Activity Fund (SAF) deposit procedures

  • District policies for student debts and obligations

Login Process

  1. Navigate to your site or visit osmsinc.com/login

  2. Enter your Username and Password

  3. Select your school from the dropdown

System Configuration

Product Setup Requirements

Creating OSP Products

OSI requires OSP Products to function as "Obligation Types." Follow these steps:

  1. Go to Transactions → OSP Products → Edit/Add New → Required Fields tab

  2. Fill out required information

  3. Important: Set Price Type to "Obligation"

  4. Do not use optional features from other tabs

Best Practices

  • Create one OSP Product per invoice type or category

  • Use generic product names (e.g., "Student Fees" instead of "12th Grade Student Fees for Honors Students Only")

  • One OSP Product can handle hundreds or thousands of invoices

Creating Invoices

Invoice Generation Methods

1. Manual Creation

  • Path: Students → Student Detailed Obligation → Add New

  • Use Case: Small tests or 1-3 school pilots only

  • Not recommended for large deployments

2. Import Spreadsheet (Recommended)

  • Path: Import/Export → Import Detailed Obligations

  • Requirements: Must use official Excel template saved as .XLS file

  • Best Practice: Export data from your Student Information System (SIS) and modify to match template

  • Critical: Template must be used EXACTLY as written

3. Daily FTP Spreadsheet

  • Central office sends district-wide invoice list

  • OSMS uploads directly

4. Automated (Online Automated Invoicing)

  • OSMS creates invoices automatically based on triggers

  • Example: Chemistry students automatically get Lab Fee invoices

  • Requires premium license and additional setup

5. District-Specific Implementations

Contact OSMS Support or Central Office for custom implementations

Processing Payments

How Parents Access Invoices

OSP Store

  1. Parents log in (top right corner)

  2. Navigate to "Your Account Page"

  3. System displays outstanding invoice message with link to "Pay Obligation" page

OSP App

  1. Parents log in

  2. Select state, district, school category, and school

  3. Invoices display directly under student's name

Payment Options

For Parents

  • OSP Store/App: Must pay in full via credit card only

  • Automatic notification of outstanding invoices upon login

For School Staff

  • OTR Cashier Screen: Can process full or partial payments

  • Payment methods: cash, check, or credit card

  • System automatically updates remaining balance

Payment Verification

To confirm invoices are payable:

  1. Go to Transactions → Teacher Receipting-New

  2. Select a student with an invoice

  3. Invoice details should appear in "Student Detailed Obligations" section

Managing Invoices

Adjusting Invoices

Write-Off Process

Use when waiving fees or marking invoices as completed without payment:

  1. Navigate to Students → Student Detailed Obligation

  2. Search and filter as needed

  3. Click magnifying glass to search

  4. Edit the specific Detailed Obligation

  5. Go to Write-Off Section

  6. Enter Write-Off Amount

  7. If payment was made outside OSMS, enter amount in External Amount field

  8. Enter Write-Off Reason

  9. Click Update to save

Deleting Invoices

  • Manual/Import Users: Delete via Students → Student Detailed Obligation → Delete

  • Integration Users: Upload new Excel file (overwrites existing invoices)

  • Automated/FTP Users: No deletion needed (invoices created daily through feeds)

Reporting

Invoice-Specific Reports

Access via Reports → Additional Reports → Obligation Reports:

  • Obligation Balance by Sponsor/Teacher: Unpaid vs. paid invoices sorted by sponsor/teacher and date/student

  • Detailed Obligations Outstanding: Unpaid invoices with sorting options

  • Obligations Due By School Student Attends: View unpaid district invoices for your school only

  • Detailed Obligation Balance: Unpaid vs. paid invoices with grade filtering

  • Obligation Invoice: Printable letter for parents (compatible with business #10 window envelopes)

Transaction Reports

Updated every 12 hours (3am and 3pm EDT):

  • Simple Reports: Reports → Sponsor/Teacher Activities OR Activity Date Range

  • Detailed Reports: Reports → Additional Reports → Transaction Reports

Troubleshooting

Common Issues

Invoice Not Visible in OSP/OTR

Cause: Obligation Type doesn't match Product Name (case sensitive) or OSP Product is inactive Solution: Check exact spelling and case, verify date range and active status

Import Sheet Not Uploading

Check these requirements:

  • Excel file saved as .xls format (97-2003)

  • No extra sheets in workbook

  • Sheet must be labeled "Sheet1"

  • Header row cannot be removed

  • No extra columns added

  • No duplicate Obligation IDs

  • Student information must match system records exactly

Student ID Issues

  • If Student ID begins with zero, add apostrophe (') at beginning

  • Use "Text" number format in Excel to prevent leading zero removal

School ID Mismatch

  • Find your School ID: Transactions → OSP Products → Activity Number column

  • School ID is characters before the hyphen (e.g., ZY995-123 = School ID ZY995)

Excel Template Requirements

Mandatory Columns

  • Obligation ID

  • Student ID

  • Last Name

  • First Name

  • School ID

  • School Name

  • Obligation Date

  • Obligation Type

  • Obligation Amount

  • Obligation Description

  • User Def 1, 2, 3 (optional custom fields)

File Preparation Tips

  • Remove blank rows after last student entry

  • Remove blank columns after last mandatory column

  • Save as CSV to check for extra commas indicating blank rows/columns

Quick Reference Checklist

Setup Process

  1. ✅ Create OSP Product (Price Type = Obligation)

  2. ✅ Create invoices (manual, import, or automated)

  3. ✅ Inform parents (automatic via OSP store/app)

  4. ✅ Process payments (OSP store/app or OTR)

  5. ✅ Complete deposits (credit card via ACH, cash/check manually)

  6. ✅ Post funds in SAF system (EPES, SFO, etc.)

Key Reminders

  • OSI requires either OSP or OTR to function

  • One OSP Product can handle multiple invoice types

  • Excel templates must be used exactly as provided

  • Obligation Types are case-sensitive

  • Students can have invoices follow them between schools, but payments must be made at originating school

Did this answer your question?