Milk Audit

Table of Contents

In This Article

What does the milk audit do?

Wondering if the milk audit is right for you?  Watch this quick video that highlights the milk audit features to see if it's something you want to use.

 


Get started with the Milk Audit

You must have the View Milk Audit permission enabled on your account to use the Milk Audit feature. 

Use the Milk Audit to compare the amount of milk purchased with the amount of milk needed, based on menus and meal counts. It looks at data from other areas of KidKare, such as Attendance/Meal Counts, Menus, and Receipts. Carryovers and write offs are also considered.

Before using this function:

  • Enter receipts.

  • Record menus.

  • Record meal counts.

View the Milk Audit

  1. From the menu to the left, click Claims.

  2. Click Milk Audit. The Milk Audit page opens.

  3. Click the Month box and select the claim month to view.

  4. Select Calculated to view milk audit information based on calculated quantities (attendance x required quantities), or select Calculated + Actual Served to view milk audit information based on calculated and actual served quantities.

    Note: This option may not display according to your settings. If this is the case, the numbers you are viewing are the Calculated numbers.  See Manage Allergies to learn more about how to set this up.

  5. The following information displays in the table for the selected month:

    • Previous Month Carry Over/Starting Balance: This may be the ending balance from the previous month (depending on your specific policy settings). To edit starting balances, click , enter the new amount, and click . Note that this option may not be available according to your preferences or the preferences your food program sponsor set (if you are a sponsored center).

    • Purchased: This is the amount of milk purchased, based on receipt date.

    • Required: This is the amount of milk required based on menus and meal counts.

    • Written Off: This is the amount of milk written off for the month. For example, this number accounts for cases in which the milk was spilled, spoiled, and so on.

    • End of Month Balance: This is the amount of milk leftover at the end of the month.

    • Actual Served: This is the actual total of milk served during the selected month based on meal records. This row only displays if you select Calculated + Actual in Step 4.

    • Actual End of Month Balance: This is the actual end of month balance based on the following formula: Carry Over + Purchased - Written Off - Actual Served. This row only displays if you select Calculated + Actual in Step 4.

  6. Click Print and choose a report to print. You can choose Summary Report or Detailed Report. Both reports download as PDFs.

Any milk served to a child marked with a milk allergy as Parent Provided does not show up on the Milk Audit.  The Milk Audit only shows substitute milk that the center purchases and supplies.

 


Use the Daily Calendar

Use the Daily Calendar to view and/or add milk events, such as purchases or write offs.

  1. Click Show Daily Calendar. The Daily Calendar displays at the bottom of the window. The Calculated version is shown in the figure below.

  2. Click the drop-down menu and select the milk type. You can choose from Whole1%/Skim, or Substitute.

  3. To add a write off:

    1. In the Draggable Events section, click the Write Off event and drag it to the calendar.

    2. Drop it on the day on which to apply it. The Milk Write Off pop-up opens.

      A day can only have one write off event at a time. You cannot change the date in the Milk Write Off pop-up. If you are a sponsored center, your food program sponsor must enable this feature.

    3. Click the text box and enter the amount of milk you are writing off.

    4. Click the corresponding drop-down menu and select GallonsPints, or Quarts. All units of measure are converted to gallons once you save.

    5. Click Save.

  4. To add a purchase:

    1. In the Draggable Events section, click the Purchase event and drag it to the calendar.

      You must have the Vendor/Receipts permission enabled on your account to access and work with Purchase events. If you are a sponsored center, your food program sponsor must enable this feature.

    2. Drop it on the day on which to apply it. The Add Expenses pop-up opens.

    3. Select Quick Entry or Itemized Entry.

    4. Enter your milk quantities. For instructions see the Receipts article.

    5. Click Save.

  5. To edit an event:

    1. Click the event to edit. A pop-up opens.

    2. Enter new information over the existing information. Note that you cannot change the event date.

    3. Click Save.

  6. To remove an event:

    1. Click the X in the right corner of the event banner.

    2. Respond to the confirmation prompt.

 


Additional Calendar Items

The following items also display on the calendar:

  • Required: Required amounts display for each day where an calculated or calculated + actual calculation is present. You cannot add, move, or remove these markers.

  •  Milk Shortage (Calculated): This icon displays on each day for which the daily ending balance value is calculated to be negative.  Click this icon to view the anticipated shortage amount.

  •  Milk Shortage (Actual): This icon displays on each day for which the daily ending balance based on the calculated values is negative. Click this icon to view the actual shortage amount.

  • Shortage Analysis: This section displays the calculated total amount of gallons you are short by day or by claim. This is determined by how your system is set up. For sponsored centers, your food program sponsor makes this distinction. If you selected Calculated + Actual at the top of the page, the actual shortages display as well.