Generate Daily Transaction Reports | openSIS

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 monitor daily financial activity across the institution.

Use this report to review daily collections, verify transactions, reconcile payments, and track financial activity over a specific period.

Unlike the Payment History Report, which focuses on student payment records, the Daily Transaction Report displays all billing transactions—including charges, payments, and deposits—for the selected date range.

Prerequisites

Before generating this report, ensure that:

  • Billing and fee transactions have been recorded.
  • Student fee assignments and payment records exist.
  • You have permission to access the Reports module.

Generate the Daily Transaction Report

  1. Navigate to Reports > Billing & Fees.
  2. Select Daily Transaction.
  3. Select the From Date.
  4. Select the To Date.
  5. Click Search.

The daily transaction report is displayed.

Understanding the Report

The report displays transaction details, including:

  • Transaction Date
  • Transaction Type
  • Student Name
  • Student ID
  • Grade Level
  • Transaction
  • Fee Type
  • Amount
  • Payment Method

Use the Search field to quickly locate a specific transaction or student.

Use Advanced Search to further refine the displayed results.

View Student Ledger

Click a 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 activity while investigating a transaction.

Export the Report

Click the Excel icon to export the report for additional analysis or record keeping.

Click the Print icon to generate a printer-friendly version of the report.

Filter the Report

Use the Filter icon to customize the displayed transactions based on your reporting requirements.

Tips

  • Generate this report regularly to reconcile daily billing transactions.
  • Review the Student Ledger when additional financial details are required.
  • Use date ranges to audit transactions for a specific billing cycle or accounting period.
  • Export the report for accounting, auditing, or financial reporting purposes.