Introduction


This guide provides a comprehensive overview of the district-level reports available within SchoolCash, offering detailed insights into various financial activities across schools in your district. From year-end summaries to vendor-specific reports, each section outlines the purpose of the report, key data points, and instructions for accessing and generating the reports. By following this guide, district administrators can efficiently monitor school-generated funds, reconcile balances, and ensure compliance with financial reporting requirements.

Table of Contents

District Level Reports


Go to: Main Menu > Reports Menu > District Level Reports

A. Year End Reports


This section contains reports that summarize Year End procedures for districts.


1. Summary - Statement of Finance


This report summarizes financial data at the district level. Fields include: Revenue, Expenses, Adjustments, and Closing Balance.

Go to: Main Menu > Reports Menu > District Level Reports > Year End Reports > Summary - Statement of Finance



2. Overview - Statement of Finance


This report provides a detailed overview of district financial activities including balance adjustments.


Go to: Main Menu > Reports Menu > District Level Reports > Year End Reports > Overview - Statement of Finance


3. Summary - Schedule of Activities Fund

This district-level report summarizes the Schedule of Activities Fund by school/bank account. The school year can be selected as well as an optional date range. Displayed information includes: Revenue and Expenses, Net Revenue/Expense, Balance Forward, Adjustment, and Closing Balance. Grand Totals for each field appear on the last page of the report.
Note: This report has an option to Display Transfers.

Go to: Main Menu > Reports Menu > District Level Reports > Year End Reports > Summary - Schedule of Activities Fund

4. Overview - Schedule of Activities Fund

This report provides an overview of school and district activity funds, displaying net revenues, expenses, and adjustments for the school year.

Go to: Main Menu > Reports Menu > District Level Reports > Year End Reports > Overview - Schedule of Activities Fund

B. Reconciliation Date by School

This report provides the status of bank reconciliations completed by schools, sorted by school name and bank account.

Go to: Main Menu > Reports Menu > District Level Reports > Reconciliation Date by School

C. Bank Service Charge

This report provides a detailed list of bank service charges incurred by each school in the district, including bank name, branch number, and totals.

Go to: Main Menu > Reports Menu > District Level Reports > Bank Service Charge

D. Tax Rebate

This report summarizes tax rebate details by school, including total expenses, tax paid, and rebates.

Go to: Main Menu > Reports Menu > District Level Reports > Tax Rebate

E. Loss Revenue NSF Checks

This report shows schools that have incurred losses due to Non-Sufficient Funds (NSF) checks. Details include the check amount and the date of the loss.

Go to: Main Menu > Reports Menu > District Level Reports > Loss Revenue NSF Checks

1. Overview of Loss Revenue NSF Checks

2. Details of Loss Revenue NSF Checks

F. Umbrella Reports

The Overview Umbrella Report details include Umbrella Name, Opening Balances, Expenses/Revenues, Transfers in and Out, and Balance. The report is summarized with Grand Total information on the last page. If an umbrella is selected for drilldown, expanded details include the selected school-specific category umbrella details.

Go to: Main Menu > Reports Menu > District Level Reports > Umbrella Reports

G. School Generated Funds

This section contains detailed reports on School Generated Funds.

1. Summary – Schedule E

The Schedule E report displays details of school funds, including gross and net SGF balances, expenses, and opening/closing balances.

Go to: Main Menu > Reports Menu > District Level Reports > School Generated Funds > Summary – Schedule E

2. Overview – Schedule E

This report shows an overview of school funds. Note: See Category documentation for further details on Schedule E reporting.

Go to: Main Menu > Reports Menu > District Level Reports > School Generated Funds > Overview – Schedule E

3. Summary – Schedule 14

This report summarizes Schedule 14 activities, including balances and funds related to district schools.

Go to: Main Menu > Reports Menu > District Level Reports > School Generated Funds > Summary – Schedule 14

4. Overview – Schedule 14

This report provides an overview of financial activities from Schedule 14. The School Funds Government Report -Schedule 14 Overview displays SGF Revenue and SGF Expenses, sorted by GL Name. The report displays District Elementary School and District Secondary School information in separate columns. Grand Total summary values for both Revenue and Expenses are also included in the report.

Go to: Main Menu > Reports Menu > District Level Reports > School Generated Funds > Overview – Schedule 14



5. Summary – SGF Year-End Report


District Level School Generated Funds Year-End Summary SGF Summary displays information sorted by revenue/expense. This report displays the GL Account Name, Number, and Budget Manager, Debit and Credit values. Revenue and Expenditure information is summarized with Grand Total values.

Go to: Main Menu > Reports Menu > District Level Reports > School Generated Funds > Summary – SGF Year-End Report

H. Customized Transaction


The Customized Transaction Report offers users many reporting options when detailed custom features are needed.


Go to: Main Menu > Reports Menu > District Level Reports > Customized Transaction


[Image Placeholder - Page 19, Image 16]


I. Uncompleted Rollover


This report ensures schools have completed the Year-End Rollover. It includes school name, bank account, current year, last date reconciled, and balance.


Go to: Main Menu > Reports Menu > District Level Reports > Uncompleted Rollover


[Image Placeholder - Page 20, Image 17]


J. Deposit Statement


This report provides a statement of deposits made by schools.


Go to: Main Menu > Reports Menu > District Level Reports > Deposit Statement


[Image Placeholder - Page 21, Image 18]


K. Opening Balance Validation


This report is useful for new schools starting with the School Cash Suite or schools setting up a new bank account. It ensures that the total category balance matches the bank account balance entered during the setup process. Only schools with discrepancies are included in this report.


Go to: Main Menu > Reports Menu > District Level Reports > Opening Balance Validation


[Image Placeholder - Page 22, Image 19]


L. Vendor 1099


1. Summary Report


This report provides a summary of 1099 data for district vendors.


Go to: Main Menu > Reports Menu > District Level Reports > Vendor 1099 > Summary Report


[Image Placeholder - Page 23, Image 20]


2. Overview Report


This report shows an overview of vendor 1099 details.


Go to: Main Menu > Reports Menu > District Level Reports > Vendor 1099 > Overview Report


[Image Placeholder - Page 24, Image 21]


3. Listing Report


This report provides a detailed listing of all vendors included in the 1099 report.


Go to: Main Menu > Reports Menu > District Level Reports > Vendor 1099 > Listing Report


[Image Placeholder - Page 25, Image 22]


M. One Time Vendor


This report details payments to one-time vendors for the district.


Go to: Main Menu > Reports Menu > District Level Reports > One Time Vendor


[Image Placeholder - Page 26, Image 23]


N. Payment/Invoice Comparison


1. Payment/Invoice Comparison – Summary Report


This report provides a summary comparison of payments and invoices.


Go to: Main Menu > Reports Menu > District Level Reports > Payment/Invoice Comparison > Summary Report

[Image Placeholder - Page 27, Image 24]


2. Payment/Invoice Comparison – Overview Report


This report provides an overview of payment and invoice data.


Go to: Main Menu > Reports Menu > District Level Reports > Payment/Invoice Comparison > Overview Report


[Image Placeholder - Page 28, Image 25]


O. Category Report


1. Category Name Report


This report provides details of category names for district accounts.


Go to: Main Menu > Reports Menu > District Level Reports > Category Report > Category Name Report


[Image Placeholder - Page 29, Image 26]


2. Pivot Table


This report generates a pivot table of category data for the district.


Go to: Main Menu > Reports Menu > District Level Reports > Category Report > Pivot Table


[Image Placeholder - Page 30, Image 27]


3. Category Umbrella Name


This report displays umbrella category names across the district.


Go to: Main Menu > Reports Menu > District Level Reports > Category Report > Category Umbrella Name


[Image Placeholder - Page 31, Image 28]


4. Category Umbrella Name & Type


This report provides details of category umbrella names and types.


Go to: Main Menu > Reports Menu > District Level Reports > Category Report > Category Umbrella Name & Type


[Image Placeholder - Page 32, Image 29]

The Basic Icons


[Image Placeholder - Page 33, Image 30]


Where to Next?