Deposit Report

This functionality is only available to districts that have purchased Campus Point of Sale as add-on functionality.

PATH: Point of Sale > Reports > Deposit Report

The Deposit Report generates a list of check, cash and credit card deposits made through the  Household FS Deposit and Person FS Deposit tools used by school staff, as well as deposits made directly at a Point of Sale Terminal and the online Portal Food Service tool.

This article includes the following topics:

Deposit Report Editor

Generating the Report

The following sections explain how to generate the Deposit Report and how report editor fields will impact report results.

Selecting Parameters

Parameters define the scope of the report, per the Which school and period would you like to include in the report? section.

Selecting Parameters
  1.  Select a School to report on from the dropdown field. The default for this field is the school currently selected in the Campus toolbar.
  2. Select a School Year from the dropdown. The default for this field is the Year currently selected in the Campus toolbar.
  3. Select a Summary Type for the report. 
  4. Enter the Date parameters for the selected Summary Type (i.e., Date, Start/End Date or Month).
  5. Select a Date Type.

Field

Description

School

The school (or all schools in the district) for which the report results should be generated.

School Year

The school year for which the report results should be generated.

Summary Type

These options allow the user to specify the date parameter(s) of the transactions returned in the report results: 

  • Daily - Deposits occurring on a specified date. When this option is selected, a Date field will appear.
  • Period - Deposits occurring within a date range will be returned by the report. When this option is selected, a Start Date and an End Date field will appear.
  • Month - Deposits occurring within the selected month will be returned by the report. When this option is selected, a Month field will appear.

Date Type

These options allow the user to choose the sorting method of deposit transactions in the report results:

  • Transaction Date - When this option is selected, the deposit transactions will be sorted by the date on which they occurred.
  • Post Date- When this option is selected, the deposit transactions will be sorted by the date on which they posted to the Campus server.

    The Transaction Date and Post Date are often the same; however, differences occur if the network is interrupted before all transactions can be posted. In this event, the transaction messages are stored in a queue until the network is reconnected and the messages can be processed.

Sorting Options

Sorting Options define how data is sorted on the report, per the Which type of report would you like to generate? section. In the Group By field, select the

Depending on the option selected in the Group By area, the additional fields for sorting the report results will differ.

Location Option

Sorting Options - Location
  1. Select a Sort Option
  2. Select which Payment deposit options to be included in the report results. 

Field

Description

Sort Option

Options shown for this area depend upon the Group By value selected.

When Location is chosen in the Group By area, these options will appear as the available sorting methods for deposit transactions in the report results:

  • Deposit Type - When this option is selected, the deposit transactions will be sorted by the type of deposit (i.e., cash, check, credit card).
  • Transaction Time - When this option is selected, the deposit transactions will be sorted by the time of day at which they occurred.

Payment

These options allow the user to specify the type of deposit transactions to be included in the report results.

  • Online - When this box is checked, transactions made online, through use of the Portal Payments tool, will be included in the report results. This only applies in districts where the Payments feature is enabled.
  • In Office - When this box is checked, transactions made through the criteria chosen in the Select Deposit Locations area will be included in the report results.
  • POS Deposit - When this box is checked, cash or check deposits made at a Point of Sale Terminal will be included in report results

Household Option

Sorting Options - Household
  1. Select a Sort Option. Options include:
  2. Select which Payment deposit options to be included in the report results. Options include:

Field

Description

Sort Option

Options shown for this area depend upon the Group By value selected.

When Household is chosen in the Group By area, these options will appear as the available sorting methods for deposit transactions in the report results:

  • Guardian Name - When this options is selected, the deposit transactions will be sorted by the guardian of the household for which they were made.
  • Deposit Amount (Desc) - When this option is selected, the deposit transactions will be sorted by the amount of the deposit, from the largest to the smallest amount.

Payment

These options allow the user to specify the type of deposit transactions to be included in the report results.

  • Online - When this box is checked, transactions made online, through use of the Portal Payments tool, will be included in the report results. This only applies in districts where the Payments feature is enabled.
  • In Office - When this box is checked, transactions made through the criteria chosen in the Select Deposit Locations area will be included in the report results.
  • POS Deposit - When this box is checked, cash or check deposits made at a Point of Sale Terminal will be included in report results

Selecting Deposit Locations

The Select Deposit Locations box will display the payment locations that may be included within the report.

Selecting Deposit Locations

Select as many deposit locations as desired. Locations displayed are those related to the school appearing in the School field.

Analyzing Report Results

The following sections break down each column of each report in order to allow better analysis of results.

Grouped By Location

The Group By Location option generates a report listing each deposit transaction per location.

Deposit Report (grouped by Location)

Column/Field

Description

Location

The location in which the deposit was made. Locations are defined in the Payment Location tool. For deposits made online via the Payments tool on the the Portal, a location of Online Payment will always report.

School

The school in which the deposit was made.

Payment

The type of payment used for depositing money: Check, Cash or Savings (Account).

Amount

The amount of money deposited into the patron's account.

Transaction Time

The time in which the deposit was entered into the Point of Sale terminal.

Post Time

The time in which the deposited money was applied to the patron's account.

Student (Student#)

The student (and corresponding Student ID) depositing money into their account.

Grade

The grade of the student having money deposited into their account.

Account

The account number of the account receiving the deposit.

Amount

The amount of money deposited into the patron's account. If the amount is crossed out, this indicates the deposit was voided and information about the date and time of transaction void is listed below the Transaction Time, Post Time and Student (Student#) columns.

Grouped By Household

The Group By Household option generates a report listing all transactions per household.

Deposit Report (grouped by Household)

Column/Field

Description

Household

The household account receiving deposited money. 

Payment (Location)

The type of payment used for deposit (Cash, Check, Savings) and where the deposit was made.

Transaction Time

The time in which the deposit transaction was entered into the Point of Sale terminal.

Student (#) - Grade

The name, corresponding Student ID and grade level of the student depositing money into their family account.

Account

The account number of the account receiving deposited money.

Amount

The amount of money deposited into the patron's family account. If the amount is in red font, this indicates the deposit transaction was voided.

Feedback