jagomart
digital resources
picture1_Excel Sample Sheet 41586 | Daily Time Log Ind Cntrs


 181x       Filetype XLSX       File size 0.03 MB       Source: dpi.wi.gov


File: Excel Sample Sheet 41586 | Daily Time Log Ind Cntrs
sheet 1 instructions amp example cacfp daily time log instructions and example instructions use this form to record time spent on cacfprelated tasks for employees who 1 perform cacfp tasks ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions & Example
CACFP Daily Time Log: Instructions and Example
Instructions: Use this form to record time spent on CACFP-related tasks for employees who: 1) perform CACFP tasks and other non-CACFP tasks AND 2) who are funded with CACFP reimbursement. Report hours spent on CACFP administrative tasks and hours spent on food service (operational) tasks. Use a separate form for each employee. Enter in the Agency Name, Employee Name, Employee Position, and the month and year of the form. Complete the remaining information accordingly:
Column A - Indicate the date worked.
Column B - Indicate the time that they started working on CACFP related task.
Column C - Indicate the time that they stopped working on CACFP related task.
Column D - Indicate the total hours spent on the CACFP task.
Column E - Indicate the hourly rate of pay. For salaried employees figure hourly rate based on annual salary. For Owners figure the rate of pay that a person would get paid to perform these CACFP job tasks.
Column F - This column is automatically calculated based on information entered in other columns. The result of Column D x Column E. At the end of the month add up this column and enter it on the bottom. This is the maximum dollar amount for this employee that can be funded with your CACFP reimbursement.
Column G - Enter in the respective Job Code from the list provided that illustrates the specific task that was completed during that time.

A payroll record (i.e. timesheet) for each employee must accompany this CACFP Time Log each month. This payroll record must show the employee name, rate of pay, hours worked, employer taxes paid, benefits earned, date of payment, gross pay, net pay.
CACFP Job Codes:
Operational Tasks Administrative Tasks
1 -FOOD SHOPPING/ORDERING


A - HSIR COMPLETION/UPDATES / HSIS DETERMINATIONS

2 - FOOD PREPARATION/COOKING


B - REVIEW OF CACFP RECORDS FOR ACCURACY

3 - COMPLETING MENU & PRODUCTION RECORDS


C - COMPLETION AND SUBMISSION OF CACFP CLAIM

4 - SERVING MEALS


D - FINANCIAL REPORTING/TRACKING CACFP EXPENSES

5 - KITCHEN / MEAL SERVICE CLEAN-UP


E - CACFP TRAINING








Example Illustrated Below:

Agency Name: ABC Day Care

Employee Name: Sisco Francisco

Position: Director/Cook Month/Year: April 2020







A B C D E F G

CACFP HOURS
CACFP AMOUNT CACFP Job Code(s)
Date Time In Time Out TOTAL hours Rate of Pay $ From List Above
4/2 8:00 AM 2:00 PM 6 15.00 $90.00 1, 2, 3, A, C
4/5 4:00 PM 6:00 PM 2 15.00 $30.00 D
4/15 5:00AM 1:00 PM 8 15.00 $120.00 2





$0.00





$0.00





$0.00





$240.00
*Number in Red Box is the maximum amount that can be charged to CACFP for this employee for the month. Record this number on your General Ledger form for tracking monthly CACFP expenses. These reports, along with your payroll records, will support the number that you report on Line #10 on the Annual CACFP Financial Report.

Sheet 2: TIME LOG_EMPLOYEE #1
CACFP Daily Time Log - Independent








Agency Name:

Employee Name:

Position:
Month/Year:








CACFP HOURS
CACFP AMOUNT CACFP Job Code(s)
Date Time In Time Out TOTAL hours Rate of Pay $ From Instructions





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00
*Number in Red Box is the maximum amount that can be charged to CACFP for this employee for the month. Record this number on your General Ledger form for tracking monthly CACFP expenses. These reports, along with your payroll records, will support the number that you report on Line #10 on the Annual CACFP Financial Report.

Sheet 3: TIME LOG_EMPLOYEE #2
CACFP Daily Time Log - Independent








Agency Name:

Employee Name:

Position:
Month/Year:








CACFP HOURS
CACFP AMOUNT CACFP Job Code(s)
Date Time In Time Out TOTAL hours Rate of Pay $ From Instructions





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00





$0.00
*Number in Red Box is the maximum amount that can be charged to CACFP for this employee for the month. Record this number on your General Ledger form for tracking monthly CACFP expenses. These reports, along with your payroll records, will support the number that you report on Line #10 on the Annual CACFP Financial Report.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions amp example cacfp daily time log and use this form to record spent on cacfprelated tasks for employees who perform other noncacfp are funded with reimbursement report hours administrative food service operational a separate each employee enter in the agency name position month year of complete remaining information accordingly column indicate date worked b that they started working related taskcolumn c stopped d total e hourly rate pay salaried figure based annual salary owners person would get paid these job f is automatically calculated entered columns result x at end add up it bottom maximum dollar amount can be your reimbursementcolumn g respective code from list provided illustrates specific task was completed during timea payroll ie timesheet must accompany show employer taxes benefits earned payment gross net codes shoppingordering hsir completionupdates hsis determinations preparationcooking review records accuracy completing menu production completion submis...

no reviews yet
Please Login to review.