Sample HR Budget Spreadsheet

Plan HR budget on yearly basis. All expenses related with pay roll divided into two major divisions like direct expenses & Indirect expenses.

In direct expenses take salary -all forms, esi, epf contributions involved by the employer,staff duty meal,training and development etc.

In In-direct expenses take staff welfare, uniform, insurance,annual day, bonus,gratuity, lave salary etc. All expenses to be projected accurately by HR head and presented to the Management for approval.

In this capital expenses to be projected separately for example some thing to be purchased as first time like computer, cafeteria kitchen equipments etc.

Just go through the attachment file which will suit with your requirements.

 

#REF! Proposed Expenditure for
Till Dec’08  Till Dec’09 variance variance Particulars 2010 APRIL 2010 MAY 2010 JUNE 2010 JULY 2010 AUG 2010 SEPTEM 2010 OCTO 2010 NOVEM 2010 DECEM 2011 JAN. 2011 FEB 2011  MAR TOTAL FY 2010-11
 Rs. Lacs  Rs. Lacs  Rs. Lacs %  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs  Rs. Lacs
 DIRECT SALARY
 Salary – Direct
 Salary-Deputation
 Casuals
 Co’s Contribution to PF
 Co’s Contribution to ESI
 Outsourcing (Incl Gardening)
 Staff Duty Meal
 Uniforms
 Recruitment/Training
 Sub-Total
 INDIRECT SALARY
Bonus/ Exgratia
 Leave Encashment
 Medical Reimbursement
Leave  Travel Allowance
 Trainees Stipend
 Medical check up
 Staff Welfare
 Gratuity
 Staff Accommodation
 Sub-Total
Total

 

Click Here To Download Prepare HR Budget