Accounting Procedures Handbook

FOOD SERVICE REPORTING 16.4 FOOD SERVICE FUND Check bank deposit reports daily for unacceptable over/short amounts. Investigate further if necessary. Check daily bank deposits report to verify cash deposit reconciles to bank report. • Making the data available to the Management Information Systems(M.I.S.) department Contact MIS a few days after the close of each school week, requesting that the prior week’s information be exported into BusinessPlus. After checking the journal entry against the week’s meal and revenue reports, post the entry. B. Compiling Operating Statistics Reports 1. The operating statistics report provides a perspective at how the cafeteria’s financial and operating activities are performing individually and comprehensively. This information is on the Meals per Labor Hour Excel Spreadsheet (10.11stats). 2. To create the MPLH spreadsheet collect and insert the following data: a. From the Food Service Area Manager obtain a copy of the FoodStaff Total Hours Report for daily hours b. Determine serving days by referring to calendar c. Print Meal and Revenue reports for the entire month by school and use these totals for total breakfasts, lunches, and ala carte d. Use Snack report from Food Service reimbursement reports for snack totals e. Obtain enrollment, # F&R, %F&R from VBoss report available from Food Service. All other items on spreadsheet are formulas. The totals will accumulate on the cover page. Forward this spreadsheet to Comptroller and Food Service Supervisor monthly. 3. Distribution of reimbursement spreadsheet (fsmsderev) is also created from monthly Meal and Revenue reports by school. 4. To create this report at the beginning of the school year, insert the current reimbursement rate. a. From the Meal and Revenue monthly reports, enter the number of meals in each category. The total breakfast and lunch should reconcile to the claim report. Enter the total MMA and FFVP dollars from the reimbursement reports received from Food Service. b. Use this spreadsheet to create a journal entry in Business Plus to distribute the reimbursement by school after you have been notified by the Accounting manager that the reimbursement has been received. 5. Bank Reconciliation spreadsheet is used by Accounting Manager to reconcile the Food Service sweep bank account. a. To create this spreadsheet, insert weekly bank deposit amounts received from Food Service with bank slips attached. Insert deposits in transit from bank statement, insert re-deposited amounts from bank statement, and insert bank deposits per bank from statement. b. Once all revenue is posted to Business Plus from export process, request the following report: GL2000 with N detail, JE, dates, Key=5*727, object 10*, 11*, 2900598, 4640. This will produce the numbers by school to be inserted in Deposits per IFAS column. c. Reconcile any differences; forward the report to Accounting manager.