RF210002179735 - SBB F

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 16

Republic of the Ph

SOCIAL SECURTY

SALARY/SLERP/CALAMITY/LRP
COLLECTION R
For the Applicable Month

Employer Name: SBB FARM INC Total Employee Billed: 86


Employer ID: 09-1507963-4 - 000 Total Employee Count 86

SS Number Name of Borrower LOAN TYPE LOAN ACCOUNT NUMBER

0911767801 LEO A BRAGAT S SL201905200931004


0913578577 ROLLY PANIM DANO C CL202008252574181
0914084028 GERRY ENGUITO ANDRES C CL202009092993286
0914302959 LORENZO ANDRADE VILLA JR S SL202007171623046
0914975975 RODELIO ACEDO BARRITO C CL202008182438650
0916719074 DANNY ALINDAY ALCORAN S SL202010193357644
0917456653 TERSO CEBALIOS LANZADERAS C CL202008042131487
0917456653 TERSO CEBALIOS LANZADERAS S SL202007161576625
0918256687 JOSELYN DOGLAS PETALCO C CL202008202499060
0918256687 JOSELYN DOGLAS PETALCO S SL202008052135310
0918963284 ROGILIO CORONIL DICDICAN C CL202009082916077
0918963284 ROGILIO CORONIL DICDICAN S SL201907241319425
0920346624 RICHARD MONTANI GEPIGA C CL202009022777637
0920346624 RICHARD MONTANI GEPIGA S SL202008262605515
0921421234 ZALDY YAMID CARPENTERO S SL202008072217744
0922877104 JOEL DUCOG FLORES C CL202009082930409
0923388197 CHARLIE RIVERA CASAS S SL202009223210212
0923864255 JOEL ALISON YAMID S SL202009143153522
0924751985 GLENN SERVIDAD ALCORAN S SL202008252572805
0925192831 ALLEN ALVAREZ ELEGUEN S SL202008062164693
0925968586 RANEL PINTON ALARCON C CL202008042123995
0925968586 RANEL PINTON ALARCON S SL202008072215113
0926695311 MELECIO MONTANI GEPIGA C CL202008222532137
0926695311 MELECIO MONTANI GEPIGA S SL202007031232003
0926907562 JOEL JALA PERGES SR S SL202010163347299
0927469397 RHYAN ARTIGAS BRAGAT C CL202008102261051
0927489157 CHARLIE ALISON CARPENTERO C CL202008292699924
0927789637 SHERLEY PAPELERAS TENORIO C CL202008142357568
0927789637 SHERLEY PAPELERAS TENORIO S SL201908201472486
0928975615 RUDY GUIMBAAN DAYEN C CL202009022773746
0929522371 JOSEPH RETUTAS GARNICA S SL202009233220581
0929920009 IFROS YANA JUGARAP C CL202009093016016
0929920009 IFROS YANA JUGARAP S SL202009072904720
0930240723 REJHON RIO YAMID C CL202009143130802
0930240723 REJHON RIO YAMID S SL201808162160281
0930742027 ADRIAN HONCULADA DORLONE C CL202008042129084
0930742027 ADRIAN HONCULADA DORLONE S SL202002100214887
0931225912 EDWIN DE LA CRUZ HALLADOR S SL202009173175857
0931494992 CELSO SALODES ERONICO C CL202009072902948
0931494992 CELSO SALODES ERONICO S SL202009022786235
0931510559 EMELIANO LABAREJAS BENTULA C CL202008282677193
0931510559 EMELIANO LABAREJAS BENTULA S SL202008242559874
0931860830 RANIEL AMARILLO VELAYO C CL202008182437706
0931860830 RANIEL AMARILLO VELAYO S SL202008032075957
0931914951 HONEYLYN LETRAN SARAYNO C CL202008072208254
0932121358 FLORENTINO AMARILLO VELAYO C CL202008042108983
0932121358 FLORENTINO AMARILLO VELAYO S SL201905301001818
0932121374 ARNEL SEBIO PINGOT C CL202008042112841
0932121400 RICKY RUBIN GORRERO C CL202008172420946
0932121400 RICKY RUBIN GORRERO S SL202008032078024
0932121471 EFEPANIO JUGARAP MAHINAY C CL202008052142419
0932283966 DEXTER PINGKI SOMBILON C CL202008082227360
0932283966 DEXTER PINGKI SOMBILON S SL201909271684321
0932414829 JERRALD SITOY LICONG C CL202007281946244
0932414829 JERRALD SITOY LICONG S SL202002100214888
0932728421 ERNEL FRASCO CABELIS S SL202007231794217
0932936776 ARVEN ADSALAN MAGLANTAY C CL202008172414958
0932936776 ARVEN ADSALAN MAGLANTAY S SL202007181662363
0933133125 ARNEL AMARILLO VELAYO S SL202009022761526
0933177796 RYAN CAHILOG SENAJON C CL202008042122268
0933315053 CARMELITO CARPENTERO BAND C CL202008142373742
0933315053 CARMELITO CARPENTERO BAND S SL202007010982961
0933463536 VINCENT RIVERA CASAS C CL202008252597681
0933463536 VINCENT RIVERA CASAS S SL202008052138437
0933637375 ALLAN PANUNCIA CAHILOG S SL202009022778300
0934073844 ELVIN ALQUIZAR FLORES C CL202008132342470
0934073844 ELVIN ALQUIZAR FLORES S SL201808292244523
0934771010 NOEL LARIOSA DORLONES C CL202008032077944
0936195296 ALFREDO PECINA PADOHINOG J S SL202008262628299
0936195319 EDWARD BARRETTO SAMPAYAN S SL201910241847303
0936817422 RONEL YBAÑEZ JALA S SL202008262630215
0937332524 MICHAEL MALEG PASLANGAN C CL202008172428090
0937460221 DECJONES FLORES MELENCION C CL202008132351873
0937716069 MARLON JUGARAP PONSICA C CL202008032082013
0937716069 MARLON JUGARAP PONSICA S SL201905301001864
0937716166 LEONARD MANINGO SINICA C CL202008102250760
0937716166 LEONARD MANINGO SINICA S SL202003140443673
0939452237 EVANDER EGAY TUBIDA C CL202008282663860
0939737910 GILBERT ARGUILLA ANGELIA C CL202008212520701
0939737910 GILBERT ARGUILLA ANGELIA S SL202008182435461
0941239545 MILLIEROSE LEGARDE MAMZA C CL202008032073502
0941558077 DARWIN AGOR VILLA C CL202007221726912
0942496248 DEXTER AMAN VILLA C CL202008242562087
0942496248 DEXTER AMAN VILLA S SL202008082226693
3325966606 SALCEDO ESLANAN ROSALES S SL201910171802292
0914084028 GERRY ENGUITO ANDRES S SL201401290106471
Republic of the Philippines
SOCIAL SECURTY SYSTEM

SALARY/SLERP/CALAMITY/LRP/EMERGENCY LOAN
COLLECTION REPORT
For the Applicable Month of JUNE 2021

Total Amount Due/Billed: 60,898.87 Payment Reference No.:


Total Amount to be paid: 73,761.74 RTPL_C3riAl_c0De_232222254950390496

LOAN DATE OUTSTANDING BALANCE TOTAL AMOUNT DUE AMOUNT TO BE PAID

05/20/2019 279.17 279.17 279.17


08/25/2020 8,903.61 487.37 487.37
09/09/2020 2,549.80 132.91 132.91
07/17/2020 7,248.12 507.42 507.42
08/18/2020 7,284.74 398.74 398.74
10/19/2020 12,498.11 737.94 737.94
08/04/2020 5,665.96 310.14 310.14
07/16/2020 8,565.92 599.67 599.67
08/20/2020 2,428.26 132.91 132.91
08/05/2020 4,199.97 276.77 276.77
09/08/2020 6,799.50 354.44 354.44
07/24/2019 2,214.71 738.21 738.21
09/02/2020 6,799.50 354.44 354.44
08/26/2020 11,199.88 738.04 738.04
08/07/2020 11,899.89 784.13 784.13
09/08/2020 8,499.34 443.07 443.07
09/22/2020 11,851.74 738.03 738.03
09/14/2020 12,593.01 823.49 823.49
08/25/2020 13,299.87 876.36 876.36
08/06/2020 9,799.92 645.79 645.79
08/04/2020 7,284.76 398.76 398.76
08/07/2020 12,599.88 830.30 830.3
08/22/2020 5,665.96 310.14 310.14
07/03/2020 8,565.92 599.67 599.67
10/16/2020 4,296.20 253.67 253.67
08/10/2020 5,665.96 310.14 310.14
08/29/2020 4,856.54 265.84 265.84
08/14/2020 10,517.11 570.67 10,517.11
08/20/2019 3,667.55 914.35 3,667.55
09/02/2020 6,799.34 354.28 354.28
09/23/2020 9,797.82 643.71 643.71
09/09/2020 5,949.55 310.14 310.14
09/07/2020 4,814.80 299.83 299.83
09/14/2020 5,099.62 265.83 265.83
08/16/2018 7,386.34 7,386.34 0.00
08/04/2020 5,665.96 310.14 310.14
02/10/2020 6,276.70 646.03 646.03
09/17/2020 9,629.57 599.64 599.64
09/07/2020 5,949.55 310.14 310.14
09/02/2020 4,814.80 299.83 299.83
08/28/2020 5,665.96 310.14 310.14
08/24/2020 9,099.95 599.65 599.65
08/18/2020 5,665.96 310.14 310.14
08/03/2020 9,736.94 583.33 583.33
08/07/2020 9,708.72 527.38 9,708.72
08/04/2020 5,665.96 310.14 310.14
05/30/2019 3,687.18 3,687.18 3,687.18
08/04/2020 5,666.06 310.24 310.24
08/17/2020 5,665.96 310.14 310.14
08/03/2020 9,800.16 646.03 646.03
08/05/2020 5,665.98 310.16 310.16
08/08/2020 6,475.41 354.45 354.45
09/27/2019 1,596.15 317.41 317.41
07/28/2020 5,380.96 310.15 310.15
02/10/2020 2,914.22 299.94 299.94
07/23/2020 11,201.86 784.46 784.46
08/17/2020 7,284.76 398.76 398.76
07/18/2020 11,201.54 784.14 784.14
09/02/2020 10,370.28 645.78 645.78
08/04/2020 5,665.96 310.14 310.14
08/14/2020 5,665.96 310.14 310.14
07/01/2020 8,565.93 599.68 599.68
08/25/2020 5,665.96 310.14 310.14
08/05/2020 7,671.56 62.88 62.88
09/02/2020 9,792.98 638.91 638.91
08/13/2020 4,047.14 221.53 221.53
08/29/2018 4,992.58 4,992.58 2,500.00
08/03/2020 5,665.96 310.14 310.14
08/26/2020 9,100.18 599.88 599.88
10/24/2019 3,546.75 591.74 591.74
08/26/2020 9,099.96 599.66 599.66
08/17/2020 5,665.90 310.08 310.08
08/13/2020 5,666.06 310.24 310.24
08/03/2020 5,665.96 310.14 310.14
05/30/2019 323.11 323.11 323.11
08/10/2020 5,665.96 310.14 310.14
03/14/2020 3,192.55 299.94 299.94
08/28/2020 5,665.96 310.14 310.14
08/21/2020 5,665.96 310.14 310.14
08/18/2020 4,549.97 299.82 299.82
08/03/2020 9,708.09 526.75 9,708.09
07/22/2020 4,612.24 265.84 265.84
08/24/2020 5,665.96 310.14 310.14
08/08/2020 4,898.96 321.87 321.87
10/17/2019 4,648.77 784.46 784.46
01/29/2014 8,320.53 8,320.53 0.00
RF210002179735
ADDING A RECORD NOT INCLUDED IN THE PRE-GENERATED LOAN COLLECTION LIST (LCL):

Note: Only employees reported thru Employment Report (R1A) will be included automatically in the next loan bil

1.     Encode the Employee's Social Security number


a.      Must be ten (10) numerical digits
b.     Format: 1234567890
c.     This will be validated by the embedded validation system of the excel sheet.

2.     Encode the EMPLOYEE’S Name

3.     Indicate the LOAN TYPE following the list of loan codes below:

4.     Encode the EMPLOYEE’S Account Number


5.     Encode the LOAN DATE
a.     Must not be greater than generation date of LCL
b.     Format: MM/DD/YYYY

6.     Encode the OUTSTANDING BALANCE, if any.


Note: If not available, leave it blank or put “0”.
a.     Must be numerical digits
b.     Format: 9999999.99

7.     Encode the TOTAL AMOUNT DUE, if any.


Note: If not available, leave it blank or put “0”.
a.     Must be numerical digits
b.     Format: 9999999.99

8.     Encode the AMOUNT TO BE PAID, if any.


Note: If not available, leave it blank or put “0”.
a.     Must be numerical digits
b.     If under yellow line, amount to be paid must not be greater than outstanding balance
b.     Format: 9999999.99

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

NOTE: THIS IS FOR LARGE ACCOUNTS ONLY.


cally in the next loan billing.

excel sheet.
n outstanding balance

oneous by the validation criteria.


s and would need to be corrected. Refer to the above criteria to double check the validation criteria.
Remove or correct the details of one account.

o add new records not included in the pre-generated list.

sheet and ensure the validity of all entries.


nd should be corrected.

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

You might also like