MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account
prepared in excel
MDM (Mid-Day-Meals) Bill Preparation Tool- with Auto Rice Account – Can be used in any school in Telangana or Andhra Pradesh or any state if the format is applicable.
SIMPLE TOOL TO PREPARE MDM BILL IN 10 Minutes
HOW TO USE?
After Downloading the file from the links given in the bottom of this post,
DOWNLOAD AVAILABLE IN 2 Types
- MDM without Castewise Entry
- MDM with Castewise Entry
Copy the file into your system folder, then open the file by Double-clicking
then Open the file,
after opening the file you will be presented with this (Primary Information )screen
STEP 1 :
The First Thing to Do…
-Enter School Name
– Enter Mandal
-Enter MDM Agency Name
-Enter MDM Agency Account Number
-Enter Month as (1-1-2020 for Jan,2020)
– Enter UPS RICE OPENING BALANCE IN KG
– Enter HS RICE OPENING BALANCE IN KG
-Enter COST PER CHILD UPS( 6th-8th)
– Enter COST PER CHILD HS (9th – 10th)
-Enter EGG Cost
-Enter UPS Strength
– Enter HS Strength
-Enter NEXT MONTH RICE REQUIREMENT FOR UPS AND HS
THIS IS ONE TIME ENTRY
EVERY MONTH WE NEED TO CHANGE ONLY MONTH NAME
STEP 2 :
IN THE ENTRY SHEET
ENTER DETAILS AS SHOWN BELOW
YOU CAN DO THIS DAILY OR WEEKLY
STEP 3 :
YOUR MDM BILL WILL BE PREPARED AUTOMATICALLY
YOU CAN PRINT
- 6-8-MDMMonthly
-
6-8-EGG BILL
-
9-10-MDM&EGG &
-
RICE ACCOUNT
IMPORTANT!
AFTER DOWNLOADING THE FILE ENTER PRIMARY DETAILS AND SAVE THE FILE
TAKE THIS FRESH PRIMARY INFORMATION GIVEN FILE EVERY MONTH
- ENTER “EGG” on the Egg given day otherwise leave it BLANK
- ENTER RICE RECEIVED and RICE OPENING BALANCE in Kg only
DOWNLOAD by clicking below links
if you get an error ( macros not enabled error ) do this
Click Excel File Menu –> Options –> Trust Center – Trust Center Settings
–>Macro Settings –> Enable All Macros
–>Protected View –> Uncheck All
–> Click OK, then close Excel and open the file again.
see this video…
hope this will help HMs,
Thank you…
