Reporting on Meals

In Arbor, you can use our built-in reporting for Meals, or you can create your own custom reports.

Please note that it is not possible to report on meal choices for future dates, unless you are using Rotating Meal Menus.

Using our out-of-the-box meal reports

Go to School > Meals > Meal Reports from the left-hand menu.

For all of the report tables, you can change the date ranges by clicking on the filters at the top of the page, and download them by clicking Download.

Numbers by week

This report shows a breakdown of each provision per week, for the current term.

Screenshot_2022-11-28_at_14.33.20.png 

Numbers by form

This report shows all registration forms and the different meal provisions your school offers. This grid will show the number of times each provision was taken on that day within the registration form.

The date can be changed by choosing a different date and clicking on Change Date.

Screenshot_2022-11-28_at_14.34.29.png

Screenshot_2022-11-28_at_14.33.58.png

 

The meal register can also be accessed here by scrolling down to the bottom of the page and clicking on View Register for _.

Screen_Shot_2019-05-03_at_14.31.22.png 

Monthly payments

This report shows the payments your school has received for each month this academic year.

This report loads the month, money collected, money deposited, invoiced amount, surplus and balance.

Screenshot_2022-11-28_at_14.34.47.png

 

Clicking on a month will load a page with the weekly payments within that month. 

Screenshot_2022-11-28_at_14.35.11.png 

Charges by person 

This report shows students that have been charged a meal over a specific period of time. You can filter down the report to only show specific registration forms if needed.

Screenshot_2022-11-28_at_14.35.29.png

Charges by date

This report shows a list of all meal charges for the selected date.

Screenshot_2022-11-28_at_14.36.57.png

The Meal Funding Report

On the meal funding report, you can report on current or past years and weeks, and look at the student and staff meals taken that week.

Screenshot_2022-11-28_at_14.37.25.png

 

You can also see a list of uncategorised meals here. You can see how to resolve these here: Unknown and uncategorised meals and how to fix them

Screenshot_2022-11-28_at_14.37.48.png

 

 

Meals taken for an individual student

You can report on individual student meals from their student profile. Just go to the Meals section of their profile and click the Historic Attendance tab. You can see further details here: The student profile

Screenshot_2022-11-28_at_14.39.19.png

 

Using the Custom Report Writer

You can create a custom report from School > Custom Report Writer. You can see more information on how to set up a report here: Creating a report

In step 1, you can select whether your report is about Student or Staff meals.

Screenshot_2022-02-09_at_15.19.50.png

 

When you select these options, the columns automatically included will be the list below. You can remove these, edit these or add additional columns as needed.

  • Name (Student or Staff)
  • Meal
  • Meal sitting
  • Meal date and time
  • Meal type
  • Meal provision
  • Meal price category
  • Meal invoice amount

Screenshot_2022-02-09_at_15.22.28.png

 

Add the Meal Price Category Statistic column to add a count of certain meal price categories.

Screenshot_2022-02-09_at_15.46.49.png

Screenshot_2022-11-28_at_14.40.39.png

 

Top Tip: This column can also be used when you apply a grouping to your report! So for example, you can find the total number of FSM meals taken per year group.

Screenshot_2022-11-28_at_14.41.31.png

Was this article helpful?
0 out of 4 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.