Report Best Practices 

Ala Carte:  Individual A la Carte items served for a range of dates which can be filtered to display a school group, specific school, serving period, menu product, and can be grouped by school in a summary or detailed format.

Account Activity: This report is commonly used to display all deposits (prepayments).

Bank Deposit: Deposits for breakfast and lunch for a range of dates which can be filtered to display a school group, specific school, and/or bank in a summary or detailed format.

Building Summary: An overview of sales quantities and dollars for each school with over/under and total deposit summaries.

Cashier Deposit: Provides you with each cashier’s reconciliation. It includes a cash and check breakdown. 

Check Listing: A breakdown of checks received for a specific serving date.

Daily Sales: This report is recommended for end-of-day reconciliation. Provides breakdown of all sales processed for a specified date range. This report will show the over/under for both the declared amount (cashier totals) and the actual amount (close day totals). 

Edit Check: This is useful for spotting potential over-claims. This report will show No-ID sales and Off-Site Sales with a breakdown of meals and attendance per school.

Meal Report: Displays Meal Counts (Reimbursable and Non-Reimbursable), Tender Types (Account, Cash, Check, or Charge totals), and Student Statuses, (Free, Reduced, and Paid and Adults), for a specific date range.

Menu Products Sold: Gives detailed information about every item sold broken down by student status and school.

Monthly School Account Summary: Displays monthly balances of all participating accounts within each site. This report also tracks monthly deposits received, charges collected, and accounts utilized per site.

Online Payment Detail: Provides all MySchoolBucks online payments for a specific date range and school. This report is used to compare food service program prepayment activity with their bank reports. 

Parent Deposit: Displays information regarding deposits made via the MySchoolBucks payment portal. 

Reimbursement Due: Shows estimated reimbursement values over a given range of dates for both CEP and non-CEP schools.

Sales Tax Report: This report is useful for providing a breakdown of total sales for both Taxable and Non-Taxable items sold. The last page of this report will give you the combined sales for all schools.  This report is very large and will need to be filtered to provide the best result.

Sales Overview Report: The Sales Overview Report is designed to provide a comprehensive summary of meal sales, including the number of meals sold, total sales, revenue, and reimbursement amounts.  

Serving Line Sales: Provides information regarding prepayment, reconciliation, and sales data per POS serving line for a range of dates. This report is typically used by Business Office personnel to compare food service program financial activity with bank reports.

Special Provision Edit Check (CEP Districts): Shows enrollment, attendance percentage, and meal counts per serving day for CEP schools.

Transaction History: Shows every POS transaction and back office adjustment for a range of dates. This report is helpful for a district that has found an error on the Daily Sales Report and needs to research to resolve the issue.

Student Enrollment: A snapshot as of April 1 that includes active students who qualify as identified students (students categorically eligible for free meals) based on USDA guidelines. The report shows your student eligibility totals, ISP percentage rate, and Eligible for Community Eligibility Provision (CEP) result, based on 25% or more of enrolled students being directly certified. This report will be blank until April 1st of the current academic year.

Students w/o Eligibility Determination: This report displays all students or households who have not submitted a free & reduced application. The purpose of this report is to assist district administrators in communicating with families who have not yet completed a Free & Reduced Application.

Student Listing: A customized listing of student and adult account balances, student and adult names, POS ID, district ID, grade, eligibility status, and homeroom. It also displays Free, Reduced, and Paid totals, grand totals of all account balances, and charge amounts.

Balance Summary: Balances for the current date which can be filtered to display a school group, specific school, for active or inactive students in a summary, detailed, or school format. 

Debt Management: This report is used to monitor acquired debt. The report can be filtered by school group, school, District ID, Age of Debt, Upper Limit Balance as well as a balance threshold.

POS Roster: This report can be used to serve students when the POS Serving Line is unavailable. The report can be filtered by a school group, school, grade, homeroom, status, medical alerts, serving line notes.

Standard Claims:  is a primary financial document in Mosaic that provides a list of monthly reimbursable meal totals broken out by student eligibility statuses (Free, Reduced, and Paid). This report is specifically designed for schools that are not participating in the CEP program. CEP districts should use the Special Provision Edit Check Report.

Race & Ethnicity Student Data Breakdown: This report provides active student statistics for race and ethnicity as provided on applications and student records.

Eligibility Record Listing: This report provides a general overview of applications, it is a critical component of the annual verification process. After the initial selection of applications for verification is complete, managers run this report to reflect and document the specific applications included in the verification pool. (tracks the underlying application documents)

Eligibility Record Student Listing: This report is a list of students on an application based on the selected criteria. This report includes the student’s name, district ID, App ID, eligibility, categorical eligibility, the date of qualification, Student and application totals by school and district are also provided at the end of the report. (tracks the individual students receiving benefits from those documents).

Eligibility Record Summary: As part of the September reporting, NYS requires that you report your district SNAP and Medicaid DC totals. This is the best choice in Mosaic.

Eligibility Statistics by School: A breakdown of eligibility statuses by school, and enrollment percentages. Enrollment data is displayed for students who qualify for Free & Reduced benefits who are on an active income and Direct Cert application, students who do not have an application, and students who are federally denied but have qualified for additional benefits based on supplemental state-level programs.

Eligibility Statistics by Grade: The Eligibility Statistics By Grade report provides a breakdown of eligibility statuses by grade, along with their corresponding enrollment percentages. Enrollment data is displayed for students who qualify for Free & Reduced benefits who are on an active application, as well as students who do not have an application.

Status Compare: This report will show discrepancies between a student application status or a reimbursable status that does not have an active application. Typically, this report should be blank unless a student's status needs to be verified for accuracy.

Menu Product Detail Report: Provides a comprehensive list of all menu items that were added in Mosaic as an option to include on a menu board. Running this report provides a quick glance to verify the accuracy of the product setup. This includes description, pricing, and taxability. 

User Assignments Report:  Lists all your users and their security role that they are assigned with, to operate the Mosaic POS and Mosaic Web.