Year to Date (YTD) refers to the period beginning the first day of the calendar year or fiscal year up to the current date. The YTD is important in analyzing the previous payroll run made prior to using the Sprout Payroll system.
Follow these simple steps on how to fill up YTD template to be uploaded in Sprout Payroll:
1. Go to Payroll Run tab
2. Click Upload YTD
3. Click Download Excel template
4. Fill out the necessary details on the template
Employee Information:
- Status (leave it blank)
- Employee ID
- First Name
- Middle Name
- Last Name
Taxable Compensation Income:
- Basic Salary - the salaries and wages of the employee
- Absent Amount (for the particular period) - leaves that are without pay
- Late/Undertime Amount (for the particular period) - the working time that is less than full time or the required minimum
- Others (if any) - these are taxable earnings that are not related to basic salary
- Commission - these are incentives based on sales
- Profit Sharing - these are the incentives based on revenue
- Fees Including Directors Fee
- Taxable 13th-Month Pay and Other Benefits - these are the employee's bonuses given by the employer
- Hazard Pay - these are the additional pay for hazardous duties
- Overtime Amount (for the particular period) - the additional pay in excess of the required working hours
- Others (if any)
- Cost of Living Allowance (Taxable) - taxable allowance
- Fixed Housing Allowance (Taxable) - allowance that are categorized as fringe benefits
Non- Taxable/ Exempt Compensation Income
- Basic Salary (MWE) - the lowest wage an employee may be paid
- Absent (MWE) - leaves that are without pay
- Late/Undertime (MWE) - the working time that is less than full time or the required minimum
- Holiday Pay (MWE) - these are any form of paid time off, such as a government-declared holiday
- Overtime Pay (MWE) - the additional pay in excess of the required working hours
- Night Shift Differential (MWE) - the additional pay for worked hours between 10:00 PM to 6:00 AM
- Hazard Pay (MWE) - these are the additional pay for hazardous duties
- 13th-Month Pay and Other Benefits - these are the employee's bonuses given by the employer
- De Minimis Benefits - these are the benefits given on top of compensation
- Salaries & Other Forms of Compensation - the salaries and wages of the employee
- SSSEE - the SSS share of the employee
- SSSEC - the SSS share of the employee's compensation
- SSSER - the SSS share of the employer
- PHEE - the PHIC share of the employee
- PHER - the PHIC share of the employer
- HDMFEE - the HMDF share of the employee
- HDMFER - the HMDF share of the employer
- HDMF Additional - HMDF 2 or the additional HMDF contribution
TAX
- Withholding Tax - the tax withheld of the employee
OTHERS
- Reimbursable Allowance - the expenses of the employee that is reimbursable from the employer (e.g travel allowance, meal allowance, communication allowance, etc.)
- SSS Loan - the paid amount from the employee's SSS Loan
- SSS Calamity Loan - the paid amount from the employee's SSS Calamity Loan
- HDMF Loan - the paid amount from the employee's HDMF Loan
- HDMF Calamity Loan - the paid amount from the employee's HDMF Calamity Loan
- Miscellaneous
Net Pay
- Net Pay - the exact take home pay of the employee
5. Once done inputting the information in the template, upload the saved file
Comments
0 comments
Article is closed for comments.