DATATOPDF - SALARY SLIP TEMPLATE

FILES
1. Salary_Slip_Template_QuickTools4U_Style.docx - upload this as the Word template.
2. Salary_Slip_Sample_Data.xlsx - use the Data sheet for bulk upload.

HOW TO USE
1. Open the Word template and replace the ABC Enterprises logo once using Picture Format > Change Picture.
2. Edit fixed company information in the Word template if it is the same for all employees: Company Name, Address, PAN, GSTIN, signatory label and footer.
3. Keep all employee-specific values in the Excel data file. Do not change placeholder spelling in Word.
4. Upload the Word template and the Data sheet to DataToPDF.
5. Use Employee_ID or Employee_Name plus Salary_Month as your generated PDF filename fields.

IMPORTANT PLACEHOLDERS
Company details: Company_Name, Company_Address, Company_PAN, Company_GSTIN
Payroll period: Salary_Month, Salary_Year
Employee: Employee_Name, Employee_ID, Designation, Department, Date_of_Joining, Location, Bank_Name, Bank_Account_Masked, Employee_PAN, UAN
Attendance: Calendar_Days, Paid_Days, LOP_Days, Leave_Balance, Payment_Mode
Earnings: Basic_Salary, HRA, Conveyance_Allowance, Special_Allowance, Bonus_Incentive, Other_Earnings, Gross_Earnings
Deductions: PF_Deduction, ESI_Deduction, Professional_Tax, TDS_Deduction, Loan_Recovery, Other_Deductions, Total_Deductions
Net pay: Net_Pay, Net_Pay_Words
Payment/remarks: Payment_Reference, Bank_UTR_No, Remarks

PRE-CALCULATE IN EXCEL
Gross_Earnings = all earnings added together.
Total_Deductions = all deduction heads added together.
Net_Pay = Gross_Earnings - Total_Deductions.
Net_Pay_Words should already be prepared as text in the Excel sheet.

NOTES
- The template supports a consistent 6-line earnings and 6-line deductions breakup for easy bulk generation.
- Use 0.00 where a component does not apply; do not leave columns blank if a clean output is needed.
- This is a payroll document. Ensure the figures and statutory deductions are verified by the employer/accountant before sharing it.
