The invention relates to a yield increasing fertilizer for sesame, which is prepared from the following raw materials in percentage by weight: 5-10% of dry duck excrement, 10-15% of dry rabbit excrement, 20-23% of dry cattle excrement, 8-11% of plant ash, 10-15% of cottonseed hull, 3-7% of calcium superphosphate, 14-22% of zinc fertilizer, 5-8% of phosphate fertilizer, 3-5% of methamidophos, 1-2% of Bavistin and 1-2% of pesticide. The method for preparing the yield increasing fertilizer for sesame comprises the following steps: proportionally putting the first ten raw materials into a mixer, mixing for 60 minutes, taking out, putting the mixture into a pulverizer to pulverize the mixture into 160-mesh particles, taking out, adding the pesticide, evenly mixing, pouring the mixture into the mixer, mixing for 30 minutes, and making the mixture into cylindrical yield increasing fertilizer columns for sesame by using a molding machine, wherein each column weighs 30 grams, and is 5 centimeters high and 7 centimeters wide. The molded yield increasing fertilizer columns need to be compact and solid, and can not be easily broken when being held by hands.