Generate Payment History Reports | openSIS

Generate Payment History Reports

Overview

The Payment History Report provides a record of payments received from students during a selected reporting period. It allows administrators to review payment transactions, verify payment amounts, and generate printable payment statements.

Use this report to reconcile fee collections, confirm student payments, and maintain payment records for financial reporting.

Unlike the Account Statement Report, which includes charges, invoices, balances, and deposits, the Payment History Report focuses specifically on completed payment transactions.


Prerequisites

Before generating this report, ensure that:

  • Student payments have been recorded in the Billing & Fees module.
  • Fee assignments exist for the students.
  • You have permission to access the Reports module.

Generate the Payment History Report

  1. Navigate to Reports > Billing & Fees.
  2. Select Payment History.
  3. Select the required reporting period from Select Date.
  4. (Optional) Enable Show Overdue Only if you want to filter the report accordingly.
  5. Click Search.

The payment history report is displayed.


Understanding the Report

The report displays payment information for each student, including:

  • Student Name
  • Student ID
  • Grade Level
  • Phone Number
  • Paid Amount
  • Open Balance
  • Overdue Balance
  • Print option

Use the Search field to quickly locate a student.

Use Advanced Search to apply additional filters.


View Student Ledger

Click the Student Name to open the student's Ledger.

The Student Ledger provides a complete financial overview of the student's account, including:

  • Total Fees
  • Total Payments
  • Balance Due
  • Deposits
  • Transaction history
  • Charges
  • Payments
  • Due dates
  • Payment methods
  • Outstanding balances

This allows you to review the student's complete billing history without leaving the report workflow.


Click the Print icon in the Action column.

The printable payment statement includes:

  • School information
  • Student information
  • Total Fees
  • Total Payments
  • Balance Due
  • Deposit Balance
  • Payment date
  • Fee Type
  • Transaction Type
  • Payment Method
  • Amount Paid

The statement can be printed or saved as a PDF for record keeping.


  1. Select one or more students using the checkboxes.
  2. Click Print Statement for selected students.

openSIS generates printable payment statements for the selected students.


Export the Report

Click the Excel icon to export the payment history report.


Filter the Report

Use the Filter icon to customize the displayed records.


Tips

  • Use this report to verify payments received during a selected period.
  • Open the Student Ledger when you need additional billing details beyond payment records.
  • Print payment statements when responding to parent payment inquiries.
  • Export payment history for accounting and financial reconciliation.

    • Related Articles

    • Generate Account Statement Reports

      Overview The Account Statement Report provides a detailed financial statement for each student, including assigned fees, payments received, outstanding balances, deposits, and transaction history for a selected reporting period. This report is useful ...
    • Generate Daily Transaction Reports

      Overview The Daily Transaction Report provides a chronological record of all billing and fee transactions performed within a selected date range. It includes charges, payments, deposits, and other financial transactions, allowing administrators to ...
    • Generate Collection by Fee Type Reports

      Overview The Collection by Fee Type Report provides a summary of fees assigned to students based on a selected fee type and payment status. It helps administrators track fee collections, identify unpaid or partially paid fees, and monitor the ...
    • Understand the Billing and Fees Dashboard

      Overview The Billing and Fees Dashboard provides a summary of your institution's fee collection status. It displays key financial metrics, collection trends, overdue balances, and payment insights, helping administrators monitor billing activities ...
    • Record a Student Fee Payment

      Overview After fees have been assigned, administrators can record payments received from students or parents. Payments can be applied to one or multiple outstanding charges and may also be adjusted using the student's available deposit balance. ...