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.

    • Related Articles

    • 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. ...

    • 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 Open and Overdue Balance Reports

      Overview The Open and Overdue Balance Report provides a summary of students with outstanding balances, overdue balances, or both. It helps administrators track receivables and identify students whose fee payments require follow-up. This report is ...

    • Export, Print, Search, and Filter Reports

      Overview Reports in openSIS include common tools that help users find, organize, print, and export information. Although the available options may vary by report, most report screens include search fields, filters, export controls, print options, and ...

    • 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 ...