RF210002179735 - SBB F
RF210002179735 - SBB F
RF210002179735 - SBB F
SOCIAL SECURTY
SALARY/SLERP/CALAMITY/LRP
COLLECTION R
For the Applicable Month
SALARY/SLERP/CALAMITY/LRP/EMERGENCY LOAN
COLLECTION REPORT
For the Applicable Month of JUNE 2021
Note: Only employees reported thru Employment Report (R1A) will be included automatically in the next loan bil
3. Indicate the LOAN TYPE following the list of loan codes below:
DESCRIPTIONS OF BUTTONS:
A. Click the “ERROR” button to find and highlight values that are deemed erroneous by the validation
a. Cells highlighted in red are deemed to contain erroneous values and would need to be c
b. Rows highlighted in red are deemed to have a duplicate entry. Remove or correct the de
B. Click the “ADD” button for easy and quick selection on last row of the LCL to add new records not in
C. Click the “VALIDATE” button once you have completed filling out the excel sheet and ensure the va
a. If with error in the list, cells with error (will be highlighted in red) and should be corrected.
b. Once corrected, please click “VALIDATE” revalidate the corrected entries.
c. The file will NOT be saved and will NOT be uploaded if errors are still unaddressed and t
REMINDERS:
• Details in pre-generated accounts (highlighted in yellow) are not editable EXCEPT on the amount to be
• For pre-generated accounts, amount to be paid must not exceed the amount under the outstanding ba
excel sheet.
n outstanding balance
e still unaddressed and the “VALIDATE” button has NOT been clicked for validation.
PT on the amount to be paid column.
nder the outstanding balance column