Payroll -> Remittances-> SSS R3 File: Generating the SSS R3 File after the payment made of monthly SSS Contribution to get the TR/SBR Number and date of payment required in entry form to process. The excel-generated file SSS monthly contribution header must not change the format. For those companies with multiple branches but the reporting to Social Security System (SSS) should only one report; you can manually merge the row data from column A to column J and the format is they same in the last row is the total amount. Don't delete column J that contains employee ID needed in generating SSS R3 File. The SSS R3 employee list in dat file output, the last 2 columns are remarks and date hired. The remark value in our excel file is column K and the value is "N"-Normal, "1"-New Hired, and "2"-Separated. Column K is blank if the remark is normal or put "1" if new hire and column L inputs the date with a format "mmddyyyy" same entry with separated input "2". The system validates the amount paid input against the total in uploaded excel file to generate; if not equal, the system will prompt a message below the "Generated R3 File" button. After the processing is done, the system displays SSS Report Generation for downloading the SSS R3 file requirement. (see screenshot below)
SSS Monthly Contribution Source Excel File
For Report Printing
SSS R3 File
LATEST BLOG POST
Automate Employees Loan Deduction in Every Payroll Process
Automate the loan deduction process by setting up a payroll deduction for each employee loan. This can be done by creating a payroll deduction category specifically for the loan and linking it to the employee's loan.
Benefits of Automated Timekeeping and Attendance Solution
Automated timekeeping and attendance solutions make it easier for employees to track their time and attendance. This can lead to increased productivity, as employees are better able to focus on their work rather than worrying about the accuracy of their time tracking.
Steps How to Manage an HRIS Software Implementation
Define the Goals and Objectives of the HRIS Software Implementation: Identify the purpose of the new system and how it will benefit the organization.
Online Timekeeping Management and Payroll System
Designed to track an employee’s time worked and generate an accurate payroll, system allows employees to clock in and out, track hours worked, view their timecards, and view their pay stubs.
Benefits of Paperless Timekeeping vs. Manual Processing
Paperless timekeeping processes can save businesses time and money by reducing the time spent handling paperwork and manual data entry.
SSS Contribution Table for 2023 (Employee and Employer)
The new SSS contribution table effective January 2023 which applies to employers and employees monthly contribution.
BIR Withholding Tax Table for the Year 2023 Onward
Under Revenue Regulation (RR) 11-2018 Annex E, the new schedule of withholding tax on compensation effective January 1, 2023 and onward.
Steps How to Test and Explore HRIS and Payroll System
Step by step procedure how to test and explore the online application using available modules from employees master data and other setup-to-proceed user testing.
HR Private Employee Master Data
HR private employee master data contains the personal details, job information, educational background, training, allowance, and 201 files of your employees that all information stored in the database for easy retrieval of records.
HR Public Employee Master Data: Personal Data Sheet
Personal Information, Family Background, Educational Background, Civil Service Eligibility, Work Experience, Voluntary Work, Learning & Development, Other Information, Questionnaire, 201 Files, Payroll Setup, Job Information, Allowance.
Tips how to start?
- Create an account.
- Verify the account via email sent by the system after registration is completed.
- Fill-up the form available in your dashboard account and wait for admin approval.
- After your account is approved the first step to do is create a department located at HRD -> Tools -> Department.
- Now ready to create employee master data located at HRD -> Employees.
- Explore the HR Payroll user guide manual as reference for self-testing.
Free Online Tools
- Mortgage Calculator
- Alphalist Conversion to BIR .Dat File Format
- BIR Alphalist .Dat File Conversion to ITR Form 2316
- BIR Relief Purchases Dat File Conversion
- BIR Relief Sales Dat File Conversion
- BIR Relief Importation Dat File Conversion
- SSS R3 File Generator Monthly Payment
- DTR Biometric Finger Scanner Time & Attendance System Free Download