Lunch File Conversion

  • Steps to Pull the Report
  • Log in to SchoolCash Catalog
    Navigate to your SchoolCash Catalog dashboard.
  • Access Reports
  • From the main menu, select Reports.
  • Under Catalog Reports, click Item Attachment Report.
  • Apply Filters
    Use the available filters to narrow down your report:
  • Payment Status (paid, unpaid, partially paid)
  • Date
  • Generate the Report
    Click Generate to view the report.
  • Export or Print
  • Use the Export to CSV option for analysis or
  • Print directly from the interface.
Slide 1 Heading
Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click Here
Slide 2 Heading
Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Click Here
            Beaver County School District File Converter        
   
       

Beaver County School District SchoolCash/SIS file conversion Tool

       

            A client-side tool for fast, private CSV conversion. Your file is never uploaded to a server.        

       

            Step 1. Go to School Cash, for the school you need to download the report, -Catalog.-Item Attachmet Report,-Export as CSV        

       

            Step 2. Use this tool to upload the file that was just downloaded from School Cash to convert it to a format useful for SIS        

       

            Step 3. Go to SIS and upload the file that was just converted from Step 2 (repeat these steps for each school)         

   
   
                   
   
       
                       

       
            Current Configuration (14-Column Input):            
                   
  • Grouping: Rows are grouped by Student ID (Original Column 2 / Index 1).
  • Value Aggregation: Column 8 (Value) is summed for all grouped transactions.
  • Date Selection: The latest date from all grouped transactions is used.
    •                
  • Extracted Data Columns (Output Columns B, C, D): Original indices 1, 7, and 12 (Columns 2, 8, and 13).
    •                
  • Data Cleaning: Original Index 7 (Column 8) is cleaned to remove currency symbols and commas before summing.
    •                
  • Summary Row Cell 1: Contains the Unique Student Count (Number of processed rows).
    •                
  • **Summary Row Cell 2:** Contains the **Total Sum of all aggregated transaction values (Column 8)**, formatted to two decimal places (e.g., `12500.50`). **(Updated)**
    •                
  • Sorting: Final aggregated rows are sorted by the Date column (ascending).
    •                
  • Download Filename: Uses selected school code prefix: [SCHOOL]-YYYY-MM-DD-HH-MM-SS.csv.
    •            
       
   
        
       

After downloading the converted file, go to SIS to upload the file to the Food Service menu.