Building and Sales Reconciliation Report

Reports > Transaction > Building and Sales Reconciliation

The Building and Sales Reconciliation report provides a summary of transactions for the selected building(s) and date(s).
Note: All revenues are local revenue only. The Building and Sales Reconciliation report does not include reimbursement.

1. General Information: Select the report structure parameters.

   1. Enter a Name for the report.
      Default: Building and Sales Reconciliation

   2. Select the Output format (HTML or PDF).
      Default: PDF

   3. Select a report Template if you would like to use the parameters of a previously configured report. Then skip to Step 7.

   4. Click Reset to restore default selections.

2. Filter: Filter the report data.

   1. Select a Building to filter transactions by building(s).
      Note: If no building is selected, all buildings will be included.

   2. Select a Date range to filter by.
      Note: If no date range is selected, the report will run for today's date.

3. Report Display: Choose the data configuration.

   1. Show: Determine which selection(s) will appear in the report.

      • Cash: Each denomination, quantity, and dollar value counted in cash count.

      • Check: Each check.

      • Items: Each sales item, quantity, and local revenue organized by serving session.

      • Reconciliation: Each Reconcile By unit with associated expected revenue amounts.

      • Sales: Each person type and eligibility with quantity and local revenue listed by serving session.
        Default: Cash, Checks, Reconciliation, and Sales.

   2. Group By: Choose to separate the report by building or date if desired.
      Default: Building

   3. Reconcile By: Choose the parameter by which the reconciliation is presented.

      • Building: Reconciles by building.

      • Cashier: Reconciles by cashier for the selected building(s) and date(s).

      • Cashier and Point of Service Device: Reconciles by each unique cashier and device combination.

      • Date: Reconciles by dates on which transactions occurred.

      • Point of Service Device: Reconciles by each POS device for the selected building(s).
        Default: Point of Service Device

4. Format: Configure output formatting.

   1. Select the Paper Format (CR80, Legal, or Letter).
      Default: Letter

   2. Select the Orientation (Landscape or Portrait).
      Default: Landscape

   3. Check Include Header to include the District Logo and report name.

   4. Check Include Footer to include the date and time the report was requested, the number of pages, and the TITAN logo.

   5. Check Include Filter to include the information selected in Step 2.

5. Click Save as Template to save the selected parameters as a template for future use.
   

1. Enter a template Name.

2. Check Public to make the template available for other users.

3. Select the Security Roles that can access the public template.

4. Click Cancel to return to the previous screen without saving this report as a template or

5. Click Save.

6. Click Reset to restore defaults.

7. Click Request Report to run the report. The report will appear in the bell icon when complete.

Report Format

1. Header: Notice the District Logo, Report Title, Serving Building Name, Date, and District Name.

2. Sales: Each person type and eligibility with quantity and local revenue listed by serving session.

1. Building: Notice the building number, building name, and attendance factor.

2. Serving Session: Notice the data is broken down by serving session.

3. Notice the Student Free, Student Reduced, Student Paid, Student Total, Non Student Total, Serving Session Total, and Grand Total row headers.

4. Eligible: Notice the enrollment counts for each eligibility status and the student total enrollment for the serving building.

5. Percent: Notice the Percent Participation of each eligibility status and the student total.
   Note: (Percent Participation = Reimbursable Sold / Eligible x 100%)

6. Meal Sales: Notice the Reimbursable Sold, Reimbursable Earned, Non-Reimbursable Sold, Non-Reimbursable Earned, and Total meal counts and dollars for each row.
   Note: The reimbursable columns will highlight in red for the rows in which the number served is higher than the enrollment times the attendance factor.

7. A la Carte Sales: Notice the Sold, Earned, and Total counts, and the Total dollar value for each row.

8. Grand Total = Meal Sales Total Dollars + A la Carte Sales Total Dollars

3. Items: Each sales item, quantity, and local revenue organized by serving session.

1. Notice the serving session. Notice the sales item name, serving session Total, and Grand Total row headers.

2. Notice the count and dollar value of items sold as Free, Reduced, and Paid reimbursable meals, Non-Reimbursable items, the student Total, non-student Total, and grand Total.

4. Reconciliation: Each Reconcile By unit with associated expected and received amounts.

1. Notice the building number and building name.

2. Notice the Reconcile By selection and the row header for each. Notice the total row header.

3. Prepaid Account Changes: Net changes of prepaid accounts assigned to building.
   Note: Negative indicates that more money was spent than paid for the selected parameters. Positive indicates that more money was paid than spent.

4. Online Payments: A total of online payments.
   Note: Online Payments only show at the District Office unless the school is assigned to a payment processing group.

5. Non Cash Adjustments: A total of balance adjustments and transfers

6. Cash Expected: Notice the sum of cash documented on POS or back office transactions as received, refunded, and the net total.

7. Cash & Checks Received: Notice the cash/coin, checks, and the total counted in the cash count.

8. Over/Short = Cash/Coin Received - Total Cash Expected

5. Cash Section: Notice the denomination name, dollar value, count, and amount. Notice the total cash and total coins.

6. Checks Section - notice the Check Number, student Identifier, Last Name, Check Amount, and Comments for each check. Notice the Number of Checks and the Total Check amount.

7. Filters: Notice the name(s) and value(s) of selected filters.

8. Footer - notice the date and time the report was requested, pages, and TITAN logo.