Aging of Accounts — CSV Extractor

Branch: Sto.tomas Branch · Switch Branch

Filter
Clear Export to Excel

Reasons and Causes of Delinquency

REASONS AND CAUSES AND
DELINQUENCY
Member
count
1 to 3 Mos. 3 to 6 Mos. 6 to 12 Mos. 12 Mos. Over TOTAL
Count Amount Count Amount Count Amount Count Amount Count Amount
AFFIDAVIT OF LOSS 9 1 5,000.00 6 129,151.16 8 546,216.04 48 4,443,660.60 63 5,124,027.80
FUND TRANSFER 5 2 11,585.95 10 609,239.43 9 768,777.25 10 525,293.02 31 1,914,895.65
RESIGNATION 7 1 46,999.00 3 58,999.00 3 140,000.00 29 2,479,958.53 36 2,725,956.53
RETIREMENT 3 0 - 0 - 4 110,402.36 2 11,201.97 6 121,604.33
TERMINATION 1 0 - 0 - 0 - 8 555,445.80 8 555,445.80
DRUG RELATED CASES 0 - 0 - 0 - 0 - 0 -
ABROAD 21 5 531,673.64 4 107,339.97 6 241,560.99 80 7,556,049.42 95 8,436,624.02
TRANSFER OF RESIDENCE 5 0 - 0 - 2 21,270.35 6 61,094.64 8 82,364.99
UNLOCATED/ AT LARGE 2 1 10,000.00 5 315,135.82 4 130,000.00 10 574,410.52 20 1,029,546.34
SICKNESS 3 0 - 0 - 6 192,516.68 4 147,621.92 10 340,138.60
INSUFFIECIENT NET PAY 102 21 137,150.31 25 326,354.10 53 980,845.71 106 3,313,645.46 205 4,757,995.58
UNDEDUCTED/ BUMPED OFF 0 - 0 - 0 - 0 - 0 -
BUSINESS FAILURE 0 - 0 - 0 - 0 - 0 -
DEATH 0 - 0 - 0 - 0 - 0 -
NO REMITTANCE 0 - 0 - 0 - 0 - 0 -
JOB LOSS/RETRENCHMENT 6 0 - 2 108,401.60 1 2,913.89 11 1,063,362.89 14 1,174,678.38
ADA Depository Bank 0 - 0 - 0 - 0 - 0 -
Transfer of Work Assignment 3 0 - 0 - 6 391,847.00 4 52,162.92 10 444,009.92
FARM FAILURE 0 - 0 - 0 - 0 - 0 -
GARNISHMENT 3 3 297,641.36 7 416,441.36 0 - 4 176,000.00 14 890,082.72
Absent Without Leave (AWOL) 1 0 - 2 39,845.63 2 39,845.63 0 - 4 79,691.26
NO CAPACITY TO PAY 16 1 1,244.90 0 - 11 123,200.26 20 128,498.59 32 252,943.75
OTHERS (Pls, Specify) 2 0 - 0 - 0 - 4 21,576.90 4 21,576.90