Benefit reports
Use the loan reports to list the loan repayments that fall in a period, for example to prepare the monthly SSS or Pag-IBIG (HDMF) loan remittance, or to see what each employee still owes on a company loan. There are three: the SSS Loan Report, the HDMF Loan Report and the Other Loan Report. Each shows on screen first, then you download an Excel file or create a final report.
Where: Benefits › Team Benefits › the settings (cog) menu › Reports
You need:
- The Loan Manager right to open the reports
- Loan Manager with write access to use Create reports
Which report, when
| You need | Use |
|---|---|
| The SSS salary, calamity or emergency loan amounts to remit | SSS Loan Report |
| The Pag-IBIG multi-purpose or calamity loan amounts to remit | HDMF Loan Report |
| One line per loan with its balance and what is due in the period, for any loan type | Other Loan Report |
All three work on any loan type you pick, so the name only decides the layout. The SSS and HDMF layouts carry the government ID numbers the agencies ask for.
How to run a loan report
- Open Team Benefits, select the settings (cog) icon and choose Reports.
- In Loan Reports, set Country to Philippines. Other countries show No loan reports.
- Select SSS Loan Report, HDMF Loan Report or Other Loan Report. It opens in a new browser tab.
- Next to Installment date, set the Start Date and End Date. The SSS Loan Report starts with the last 30 days filled in; the other two start empty.
- In Loan Type, tick every loan type to include. At least one is required.
- Once rows appear, narrow them with Subsidiary or Cost Centre if you need to.
- Select Create reports to download or save the report.
How to download or create the final report
- Select Create reports.
- For the SSS and HDMF reports, tick Consolidated to get one row per employee, per loan, per month, with that month's instalments added together. Leave it off for one row per instalment.
- Select Preview next to the file (Employee list (Excel), or HDMF Loan on the HDMF report) to download it now. Preview as often as you like.
- When the figures are right, select Create Final Report. KAMI builds it in the background and tells you when it is ready.
The file always follows the filters on screen: dates, loan types, subsidiary and cost centre.
What each report shows
A row is included when its instalment date falls between your Start Date and End Date.
SSS Loan Report, one row per instalment:
| Column | What it is |
|---|---|
| SSS Number | From the employee's profile |
| Name of Borrower | The employee |
| Loan Type | The SSS code (S, C, E, 4 or 1) when the type is named after an SSS loan, otherwise the type's name |
| Loan Account Number | The number entered on the loan |
| Loan date | The loan's start date |
| Outstanding balance | What is still owed on the whole loan today |
| Total Amount Due | The original loan amount |
| Amount To Be Paid | The instalment amount |
The Excel file adds each loan's Status.
HDMF Loan Report, one row per instalment: Employee ID, Name of Borrower, Loan Type, HDMF Number, Tin, Birth Date, Outstanding balance, Total Amount Due and Amount To Be Paid. The Excel file uses the Pag-IBIG layout instead: Pag-IBIG ID, EmployeeID, Last Name, First Name, Middle Name, Loan Type, Amount to be paid, TIN, Birth Date and Status. It has no balances.
Other Loan Report, one row per loan: Employee ID, Name, Loan Type, Outstanding balance, Total Amount Due (the original amount) and Amount To Be Paid, which adds up every instalment of that loan in the date range. The Excel file adds Imported (Yes or No) and Status.
For a loan imported with Calculate Loan set to No, the outstanding balance is the figure from your import file, not one KAMI worked out.
What Happens Next
- The figures are live. Outstanding balance is what is owed when you run the report, not on the end date. Run the remittance report straight after payroll for the month is paid, and keep the file.
- The report doesn't filter by loan status. Use the Status column in the file to leave out loans that are not being repaid, such as rejected or cancelled ones.
- SSS, HDMF and TIN numbers come from each employee's profile. A blank cell means the number is missing there. See Personal details on an employee profile.
Tips
- Name your government loan types exactly (for example SSS Salary Loan), so the SSS report shows the right codes. See Loan type settings explained.
- Run one report per agency. Tick only the SSS loan types for the SSS report and only the Pag-IBIG types for the HDMF report, or the file mixes the two.
- Use the payroll period as the date range when remitting, so the file matches what was deducted on payslips.
- Check that the file total matches the loan deductions on that payroll before you remit. A difference usually means a paused instalment or a payment recorded outside payroll.
- Use the Other Loan Report for company loans. It gives one line per loan, which is what finance needs for a balance check.
Troubleshooting / FAQ
Q: I see "Loan type is required." Tick at least one type in Loan Type.
Q: The report says "There is no data under SSS Loan Report". No instalment of the chosen types falls in your date range. Widen the dates or add loan types.
Q: The HDMF or Other report is empty when it opens. Those two open without dates. Set Start Date and End Date.
Q: Amount To Be Paid shows a dash on screen. Use Create reports › Preview. The Excel file has the amounts.
Q: An employee's loan is missing. Check its loan type is ticked, and that one of its instalment dates falls in the range. A loan whose type was deleted shows as No Loan Type and can't be picked with the filter.
Q: The Loan Type column shows the full name, not a code. The type's name isn't one of the SSS names KAMI recognises. Rename the type.