Sheet 1: Summary

	
	
	
	
	
	
	
	
	

		
AFL SNP Monthly Financial Report
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
TCDSB SCHOOLS & THE ANGEL FOUNDATION FOR LEARNING
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
School/Program Name
		


		


		


		
Reporting Month
		
Year
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
NOTE:
		
Information can only be entered into cells shaded grey.
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
ADJUSTED BANK BALANCE (from Report #11M - Reconciliation Detail Report)
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
CURRENT MONTH INCOME (REVENUE)
		


		


		


		


		
TOTAL
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
FROM REPORT #11
		
Category #
		
Category Name
		


		


		


		


		


		
Student Nutrition Program Monthly Report Process
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36001
		
Grants (municipal and provincial funding only)
		


		


		


		


		
Step 1:
		
You will need the following reports from the KEV school banking system:
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36002
		
Parent Donations (including cheques to AFL for tax receipts)
		


		


		

		Bubnic, Kimberly (The Angel Foundation for Learning):
Can be negative if a cheque was written to AFL.
		

		


		


		


		


		
#11M - Reconciliation Detail Report
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36004
		
Community Fundraising
		


		


		


		


		


		


		


		
#11 - Customized Transaction Report (for the month you just reconciled; sort by Category Number)
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36005
		
Grocery Foundation
		


		


		


		


		


		
Step 2:
		
Open and save a copy of the "AFL SNP Monthly Report" Excel file
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36006
		
Breakfast Clubs of Canada
		


		


		


		


		


		


		


		
Complete the Summary page, picking up amounts from report #11M and #11
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36007
		
President's Choice Children's Charity
		


		


		


		


		


		


		


		
If you use vouchers or gift cards, complete the Vouchers & Gift Cards page
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36008
		
Other Revenue (i.e. HST rebate)
		


		


		


		


		


		


		


		
Complete the Program Information page
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Gift Card Donations                                                                     
		


		
 Identify Source:
		


		


		


		


		


		


		
Once all three pages have been completed, print a copy, and sign/date the program information page
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		
Step 3:
		
Compile all paperwork, including:
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		
Summary, Vouchers & Gift Cards, and Program Information pages from this Excel file
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		
KEV school banking reports #11 and #11M
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		
QUANTITY
		


		


		


		
Bank Statement
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Voucher/Coupon Donations
		


		
 Identify Source:
		


		


		


		


		


		


		
Invoices/receipts
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
(e.g. egg coupons)
		


		


		


		


		


		


		
Step 4:
		
Photocopy all of the above paperwork and keep the photocopy on file at the school
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		
Step 5:
		
Staple together and mail the original copy to AFL via Board courier
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
TOTAL INCOME
		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
CURRENT MONTH EXPENSES (attach original receipts)
		


		


		


		
KEV SCHOOL BANKING
		
GIFT CARDS
		
TOTAL
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
FROM REPORT #11
		
Category #
		
Category Name
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36101
		
Food
		


		

		Bubnic, Kimberly (The Angel Foundation for Learning):
Pick up amounts from Report #11 - Customized Transaction Report
		

		
 $-   
		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36102
		
Supplies
		


		


		
 $-   
		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36103
		
Honorarium
		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36104
		
Small Equipment
		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36105
		
Bank Charges
		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
36106
		
Other Expenses
		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
TOTAL EXPENSES
		


		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
NET INCOME/(EXPENSE) FOR THE MONTH
		


		


		


		


		
 $-   
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
YES
	
	

		
If you have gift cards:
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
NO
	
	

		


		
Did you count/verify gift cards on hand on the last day of the month?
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
N/A
	
	

		


		
Does it match the gift card closing balance on the next page?
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
If you have vouchers or coupons:
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Did you count vouchers/coupons on hand on the last day of the month?
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Does it match the number of vouchers/coupons remaining - closing balance on the next page?
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
Page 1 of 3
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
November 2018
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	



Sheet 2: Vouchers & Gift Cards

	
	
	
	
	
	
	
	
	

		
AFL SNP Monthly Financial Report
		


		


	
	

		
TCDSB SCHOOLS & THE ANGEL FOUNDATION FOR LEARNING
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
0
		


		


		


		


		
0
		
0
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
VOUCHER TRACKING
		


		


	
	

		
NUMBER OF VOUCHERS/COUPONS  - OPENING BALANCE 
		


		


		


		


		


		


		


		


		

		Bubnic, Kimberly (The Angel Foundation for Learning):
Ending balance from last month's report.
		

		


		


	
	

		
Quantity of Voucher/Coupon Donations Received
		


		


		


		


		


		


		


		


		
 -   
		


		


	
	

		
Vouchers/Coupons Available to use
		


		


		


		


		


		


		


		


		
 -   
		


		


	
	

		
Number of Vouchers/Coupons Redeemed
		


		


		


		


		


		


		


		


		


		


		


	
	

		
NUMBER OF VOUCHERS/COUPONS REMAINING - CLOSING BALANCE
		


		


		


		


		


		


		


		


		
 -   
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
GIFT CARD TRACKING
		


		


	
	

		
GIFT CARD  - OPENING BALANCE 
		


		


		


		


		


		


		


		


		

		Bubnic, Kimberly (The Angel Foundation for Learning):
Ending balance from last month's report.
		   
		


		


	
	

		
Gift Card Donations Received
		


		


		


		


		


		


		


		


		
 $-   
		


		


	
	

		
Gift Card Available
		


		


		


		


		


		


		


		


		
 $-   
		


		


	
	

		
Gift Card Purchases
		


		


		


		


		


		


		


		


		
 $-   
		


		


	
	

		
GIFT CARD - CLOSING BALANCE
		


		


		


		


		


		


		


		


		
 $-   
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
GIFT CARD RECEIPTS
		


		


	
	

		
RECEIPT DATE (MM/DD/YY)
		
ITEM NUMBER
		
STORE NAME
		
Gift Card #
		
Food
		
Supplies
		
TOTAL
		


		


	
	

		


		
1
		


		

		Enter the last four (4) digits of the Gift Card number.
		

		


		


		
 $-   
		


		


	
	

		


		
2
		


		


		


		


		
 $-   
		


		


	
	

		


		
3
		


		


		


		


		
 $-   
		


		


	
	

		


		
4
		


		


		


		


		
 $-   
		


		


	
	

		


		
5
		


		


		


		


		
 $-   
		


		


	
	

		


		
6
		


		


		


		


		
 $-   
		


		


	
	

		


		
7
		


		


		


		


		
 $-   
		


		


	
	

		


		
8
		


		


		


		


		
 $-   
		


		


	
	

		


		
9
		


		


		


		


		
 $-   
		


		


	
	

		


		
10
		


		


		


		


		
 $-   
		


		


	
	

		


		
11
		


		


		


		


		
 $-   
		


		


	
	

		


		
12
		


		


		


		


		
 $-   
		


		


	
	

		


		
13
		


		


		


		


		
 $-   
		


		


	
	

		


		
14
		


		


		


		


		
 $-   
		


		


	
	

		


		
15
		


		


		


		


		
 $-   
		


		


	
	

		


		


		


		


		


		


		
TOTALS
		
 $-   
		
 $-   
		
 $-   
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		
Page 2 of 3
		


		


	
	

		


		


		


		


		


		


		


		


		


		
November 2018
		


		


	



Sheet 3: Program Information

	
	
	
	
	
	
	

		
AFL SNP Monthly Financial Report
		
	

		
TCDSB SCHOOLS & THE ANGEL FOUNDATION FOR LEARNING
		
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
0
		


		


		
0
		
0
	
	

		


		


		


		


		


		


		


	
	

		
Program Information
		


		


		
Breakfast
		
Lunch
		
Morning Meal
		
Snacks
	
	

		
Number of days operating during the month
		


		


		


		


	
	

		
Number of students served per day
		


		


		


		


	
	

		
Number of meals served 
		
0
		
0
		
0
		
0
	
	

		
Number of Volunteers
		


		


		


		


		


		


	
	

		
Number of Volunteer hours for the month
		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Estimated value of food donations   
		
Description 
		


		
$ Value
	
	

		


		


	
	

		


		


		


		


		


	
	

		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Comments
		
	

		


		
	

		
	

		
	

		
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Co-ordinator: 
		


		


		


		
Principal:
		


		


	
	

		


		


		


		
	

		
Print Name
		


		
Print Name
		
	

		


		


		


		
	

		
Signature
		


		
Signature
		
	

		


		


		


		
	

		
Date
		


		
Date
		
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
SUBMISSION INFORMATION
		
	

		


		


		
Submission Checklist:
		


		
Send completed, signed report via Board office
		


		


	
	

		


		

 
		
		
Print monthly report
		


		
courier to:
		


		


	
	

		


		
Attach KEV school banking reports - #11, #11M
		


		
The Angel Foundation for Learning - Nutrition
		


		


	
	

		


		
Attach original bank statement
		


		
Attention: Nutrition Managers
		


		


	
	

		


		


		
Attach original invoices and receipts
		


		


		


		


	
	

		


		


		
Photocopy all paperwork and file copy at school
		


		


		


		


	
	

		


		

 
		
		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		
Page 3 of 3
	
	

		


		


		


		


		


		


		
November 2018