=== Payment Import (DRY RUN - NO CHANGES) ===
File: C:\Users\HomePC\Downloads\transactions_352_to_434_2026-07-03_15-23-57.json
Format: JSON
Mode: DRY RUN
Total transactions: 83

Transaction #1:
  TransID: UG1HP9IR22
  User Ref: 13743953
  Amount: KSh 1,500.00
  Γ£ô Row 2 (User: ROSEMARY WANJIKU): Would allocate KSh 1,500.00 to Loan #2085
Transaction #2:
  TransID: UG1JN9KM1X
  User Ref: 31942157
  Amount: KSh 1,500.00
  Γ£ô Row 3 (User: MERCY KIHARA KITHINJI): Would allocate KSh 1,500.00 to Loan #2175
Transaction #3:
  TransID: UG1KV9SSDN
  User Ref: 32924429
  Amount: KSh 1,074.00
  Γ£ô Row 4 (User: MARY SINAIDA SIMIYU): Would allocate KSh 1,074.00 to Loan #2064
Transaction #4:
  TransID: UG1R49665W
  User Ref: 23667517
  Amount: KSh 2,000.00
  Γ£ô Row 5 (User: TABITHA MUKAMI NJOROGE): Would allocate KSh 2,000.00 to Loan #2189
Transaction #5:
  TransID: UG1L29DB1T
  User Ref: 28696670
  Amount: KSh 2,000.00
  Γ£ô Row 6 (User: CONRARD ODANGA): Would allocate KSh 2,000.00 to Loan #2265
Transaction #6:
  TransID: UG1B39OHL7
  User Ref: 10976817
  Amount: KSh 30,000.00
  Γ¥î Row 7 (Ref: 10976817): User not found
Transaction #7:
  TransID: UG16N9PFSC
  User Ref: 6204208
  Amount: KSh 1,600.00
  Γ£ô Row 8 (User: JOSEPH MBUGUA NDUATI): Would allocate KSh 1,600.00 to Loan #2226
Transaction #8:
  TransID: UG1029Q3ET
  User Ref: 28626828
  Amount: KSh 30,000.00
  Γ¥î Row 9 (Ref: 28626828): User not found
Transaction #9:
  TransID: UG19S9NSON
  User Ref: 23773848
  Amount: KSh 500.00
  Γ£ô Row 10 (User: HARRISON CHEGE): Would allocate KSh 500.00 to Loan #2193
Transaction #10:
  TransID: UG1CI9RVI0
  User Ref: 30800987
  Amount: KSh 23,000.00
  Γ¥î Row 11 (Ref: 30800987): User not found
Transaction #11:
  TransID: UG1IC9SZ04
  User Ref: 13217819
  Amount: KSh 1,000.00
  Γ£ô Row 12 (User: JACKSON MAINA K MWANGI): Would allocate KSh 1,000.00 to Loan #2183
Transaction #12:
  TransID: UG1G09VC1V
  User Ref: 23165110
  Amount: KSh 4,000.00
  Γ¥î Row 13 (Ref: 23165110): User not found
Transaction #13:
  TransID: UG1DC9SXRD
  User Ref: 32781152
  Amount: KSh 2,300.00
  Γ¥î Row 14 (Ref: 32781152): User not found
Transaction #14:
  TransID: UG1MM9X333
  User Ref: 22841100
  Amount: KSh 100,000.00
  ΓÜá Row 15 (User: REMUEL MWANGI): No outstanding balance on Loan #2018
Transaction #15:
  TransID: UG1309XV99
  User Ref: 13703075
  Amount: KSh 3,000.00
  Γ¥î Row 16 (Ref: 13703075): User not found
Transaction #16:
  TransID: UG1CL9VDM6
  User Ref: 26765596
  Amount: KSh 30,000.00
  ΓÜá Row 17 (User: JOSEPH KARANJA): No outstanding balance on Loan #2080
Transaction #17:
  TransID: UG1IY9YOGR
  User Ref: 24510126
  Amount: KSh 2,000.00
  Γ£ô Row 18 (User: SYLVIA OKUMU): Would allocate KSh 2,000.00 to Loan #2195
Transaction #18:
  TransID: UG16C98PRG
  User Ref: 26751429
  Amount: KSh 5,500.00
  Γ¥î Row 19 (Ref: 26751429): User not found
Transaction #19:
  TransID: UG1H19PB5L
  User Ref: 12475607
  Amount: KSh 60,000.00
  Γ£ô Row 20 (User: BEATRICE MAINA 211): Would allocate KSh 60,000.00 to Loan #2022
Transaction #20:
  TransID: UG1BV9YP35
  User Ref: 20892050
  Amount: KSh 11,250.00
  Γ£ô Row 21 (User: GEORGE MAINA KAMAU): Would allocate KSh 11,250.00 to Loan #2127
Transaction #21:
  TransID: UG1JN9LQRH
  User Ref: 31942157
  Amount: KSh 9,000.00
  Γ£ô Row 22 (User: MERCY KIHARA KITHINJI): Would allocate KSh 9,000.00 to Loan #2175
Transaction #22:
  TransID: UG145A1WTT
  User Ref: 10889384
  Amount: KSh 5,000.00
  ΓÜá Row 23 (User: JANNET NYAMBURA GITAHI): No outstanding balance on Loan #2129
Transaction #23:
  TransID: UG1BCA32XZ
  User Ref: 28092557
  Amount: KSh 21,500.00
  Γ£ô Row 24 (User: CATHERINE NDUKU KIOKO): Would allocate KSh 21,500.00 to Loan #2058
Transaction #24:
  TransID: UG1BKA6OAO
  User Ref: 22346802
  Amount: KSh 49,500.00
  ΓÜá Row 25 (User: AUGUSTINE OJINO): No outstanding balance on Loan #2252
Transaction #25:
  TransID: UG15C9TXFC
  User Ref: 22582935
  Amount: KSh 19,000.00
  ΓÜá Row 26 (User: ISAAC OCHOLA): No outstanding balance on Loan #2250
Transaction #26:
  TransID: UG18J9TBTC
  User Ref: 27892853
  Amount: KSh 2,300.00
  Γ¥î Row 27 (Ref: 27892853): User not found
Transaction #27:
  TransID: UG129A5XIS
  User Ref: 25243691
  Amount: KSh 1,800.00
  Γ¥î Row 28 (Ref: 25243691): User not found
Transaction #28:
  TransID: UG1EP9OXTH
  User Ref: 24239519
  Amount: KSh 1,500.00
  Γ£ô Row 29 (User: DENIS CHIBOLE CHIBOLE): Would allocate KSh 1,500.00 to Loan #2020
Transaction #29:
  TransID: UG1JN9MM1J
  User Ref: 25825416
  Amount: KSh 3,000.00
  Γ¥î Row 30 (Ref: 25825416): User not found
Transaction #30:
  TransID: UG1LG9P5J6
  User Ref: 20545718
  Amount: KSh 3,000.00
  Γ£ô Row 31 (User: LEAH NDUTA WANJIKU): Would allocate KSh 3,000.00 to Loan #2055
Transaction #31:
  TransID: UG19S9QXOF
  User Ref: 23773848
  Amount: KSh 500.00
  Γ£ô Row 32 (User: HARRISON CHEGE): Would allocate KSh 500.00 to Loan #2193
Transaction #32:
  TransID: UG130A0QZV
  User Ref: 13703075
  Amount: KSh 1,000.00
  Γ¥î Row 33 (Ref: 13703075): User not found
Transaction #33:
  TransID: UG1C89KP7M
  User Ref: 13845656
  Amount: KSh 6,000.00
  Γ£ô Row 34 (User: MONICA WANGARI KAGURU): Would allocate KSh 6,000.00 to Loan #2131
Transaction #34:
  TransID: UG2JN9OMTO
  User Ref: 31942157
  Amount: KSh 3,000.00
  Γ£ô Row 35 (User: MERCY KIHARA KITHINJI): Would allocate KSh 3,000.00 to Loan #2175
Transaction #35:
  TransID: UG2G69ROOY
  User Ref: 103300908
  Amount: KSh 18,000.00
  Γ¥î Row 36 (Ref: 103300908): User not found
Transaction #36:
  TransID: UG2M99LA2X
  User Ref: 24663651
  Amount: KSh 500.00
  Γ£ô Row 37 (User: PATRICK MATHAI GATHAYU): Would allocate KSh 500.00 to Loan #2125
Transaction #37:
  TransID: UG2S08IGJO
  User Ref: 24534186
  Amount: KSh 1,000.00
  ΓÜá Row 38 (User: SIMON ODHIAMBO ADATHA): No outstanding balance on Loan #2106
Transaction #38:
  TransID: UG2RDA4Y22
  User Ref: 33872123
  Amount: KSh 25,000.00
  Γ¥î Row 39 (Ref: 33872123): User not found
Transaction #39:
  TransID: UG2G69S2E4
  User Ref: 10330095
  Amount: KSh 1,000.00
  ΓÜá Row 40 (User: MILLYCENT AKINYI ABEKA): No outstanding balance on Loan #2077
Transaction #40:
  TransID: UG2S08IHPU
  User Ref: 24534186
  Amount: KSh 500.00
  ΓÜá Row 41 (User: SIMON ODHIAMBO ADATHA): No outstanding balance on Loan #2106
Transaction #41:
  TransID: UG2JW9GRI8
  User Ref: 32059800
  Amount: KSh 1,800.00
  Γ¥î Row 42 (Ref: 32059800): User not found
Transaction #42:
  TransID: UG25N9UUK8
  User Ref: 1160332
  Amount: KSh 1,300.00
  Γ¥î Row 43 (Ref: 1160332): User not found
Transaction #43:
  TransID: UG2JN9PRK8
  User Ref: 31942157
  Amount: KSh 46,000.00
  Γ£ô Row 44 (User: MERCY KIHARA KITHINJI): Would allocate KSh 46,000.00 to Loan #2175
Transaction #44:
  TransID: UG2O89PTSM
  User Ref: 23742923
  Amount: KSh 18,000.00
  ΓÜá Row 45 (User: CATHERINE WACERA MATHENGE): No outstanding balance on Loan #2075
Transaction #45:
  TransID: UG24CACY90
  User Ref: 11035744
  Amount: KSh 37,000.00
  ΓÜá Row 46 (User: JOYCE MIDEVA MAVISI): No outstanding balance on Loan #2105
Transaction #46:
  TransID: UG2KV9YI8R
  User Ref: 32924429
  Amount: KSh 716.00
  Γ£ô Row 47 (User: MARY SINAIDA SIMIYU): Would allocate KSh 716.00 to Loan #2064
Transaction #47:
  TransID: UG2QYA2GPR
  User Ref: 9947934
  Amount: KSh 30,000.00
  ΓÜá Row 48 (User: IMMACULATE NJOKI KARURI): No outstanding balance on Loan #2008
Transaction #48:
  TransID: UG2D99YEOX
  User Ref: 36154457
  Amount: KSh 1,500.00
  Γ£ô Row 49 (User: YVOMME WANJIRU IRUNGU): Would allocate KSh 1,500.00 to Loan #2213
Transaction #49:
  TransID: UG2QN9U8FL
  User Ref: 10166781
  Amount: KSh 30,000.00
  Γ£ô Row 50 (User: MILKA WAMBUI WANYOIKE): Would allocate KSh 30,000.00 to Loan #2013
Transaction #50:
  TransID: UG2OJ9MSX1
  User Ref: 29954226
  Amount: KSh 26,000.00
  Γ¥î Row 51 (Ref: 29954226): User not found
Transaction #51:
  TransID: UG2IC9YXMK
  User Ref: 13217819
  Amount: KSh 1,000.00
  Γ£ô Row 52 (User: JACKSON MAINA K MWANGI): Would allocate KSh 1,000.00 to Loan #2183
Transaction #52:
  TransID: UG229AAUTK
  User Ref: 25243691
  Amount: KSh 1,000.00
  Γ¥î Row 53 (Ref: 25243691): User not found
Transaction #53:
  TransID: UG28N9ZXBC
  User Ref: 1022226
  Amount: KSh 200.00
  Γ£ô Row 54 (User: VERONICA MWAURA): Would allocate KSh 200.00 to Loan #2181
Transaction #54:
  TransID: UG22PA7QGA
  User Ref: 31398459
  Amount: KSh 6,000.00
  Γ£ô Row 55 (User: ALEX MUTETHIA): Would allocate KSh 6,000.00 to Loan #2069
Transaction #55:
  TransID: UG2J39TZHN
  User Ref: 33668248
  Amount: KSh 5,000.00
  Γ¥î Row 56 (Ref: 33668248): User not found
Transaction #56:
  TransID: UG24DAELIG
  User Ref: 0458071
  Amount: KSh 4,465.00
  ΓÜá Row 57 (User: PATRICK G. KAMAU): No outstanding balance on Loan #2052
Transaction #57:
  TransID: UG3GV9JP4Q
  User Ref: 24716093
  Amount: KSh 37,000.00
  ΓÜá Row 58 (User: MOSES KAVENGI): No outstanding balance on Loan #2104
Transaction #58:
  TransID: UG3PD9UIG9
  User Ref: 22632348
  Amount: KSh 1,300.00
  Γ¥î Row 59 (Ref: 22632348): User not found
Transaction #59:
  TransID: UG39S9VSL7
  User Ref: 23773848
  Amount: KSh 500.00
  Γ£ô Row 60 (User: HARRISON CHEGE): Would allocate KSh 500.00 to Loan #2193
Transaction #60:
  TransID: UG3IYA6DIN
  User Ref: 24510126
  Amount: KSh 2,000.00
  Γ£ô Row 61 (User: SYLVIA OKUMU): Would allocate KSh 2,000.00 to Loan #2195
Transaction #61:
  TransID: UG34UA1JIV
  User Ref: 13687937
  Amount: KSh 20,000.00
  ΓÜá Row 62 (User: JOSEPH WILLIAM GATHINJI THUU): No outstanding balance on Loan #2079
Transaction #62:
  TransID: UG3IDA1TEK
  User Ref: 24713807
  Amount: KSh 5,000.00
  Γ£ô Row 63 (User: JULIUS NDIRANGU KARIUKI): Would allocate KSh 5,000.00 to Loan #2151
Transaction #63:
  TransID: UG3EE9VTGR
  User Ref: 25243691
  Amount: KSh 500.00
  Γ¥î Row 64 (Ref: 25243691): User not found
Transaction #64:
  TransID: UG3O89TG91
  User Ref: 23742923
  Amount: KSh 1,000.00
  ΓÜá Row 65 (User: CATHERINE WACERA MATHENGE): No outstanding balance on Loan #2075
Transaction #65:
  TransID: UG32IA128J
  User Ref: 22535411
  Amount: KSh 5,000.00
  Γ£ô Row 66 (User: NANCY WANJIRU KINYUA): Would allocate KSh 5,000.00 to Loan #2068
Transaction #66:
  TransID: UG3079IQER
  User Ref: 34142031
  Amount: KSh 31,500.00
  ΓÜá Row 67 (User: EMMAH WAIRIMU GITATA): No outstanding balance on Loan #2161
Transaction #67:
  TransID: UG3PMA6XX6
  User Ref: 11002428
  Amount: KSh 5,600.00
  Γ£ô Row 68 (User: JOSEPH NGUNJIRI): Would allocate KSh 5,600.00 to Loan #2234
Transaction #68:
  TransID: UG36V9UYG2
  User Ref: 27338452
  Amount: KSh 5,500.00
  Γ£ô Row 69 (User: BEATRICE WAMBUI MURIITHI): Would allocate KSh 5,500.00 to Loan #2233
Transaction #69:
  TransID: UG3P69YV31
  User Ref: 13427299
  Amount: KSh 2,500.00
  Γ¥î Row 70 (Ref: 13427299): User not found
Transaction #70:
  TransID: UG3H4A3MSK
  User Ref: 21899661
  Amount: KSh 1,800.00
  Γ¥î Row 71 (Ref: 21899661): User not found
Transaction #71:
  TransID: UG385A60PZ
  User Ref: 36326496
  Amount: KSh 4,000.00
  Γ£ô Row 72 (User: FELISTAS MUENDI MILU): Would allocate KSh 4,000.00 to Loan #2054
Transaction #72:
  TransID: UG31ZAAFJY
  User Ref: TERESIA MATHU
  Amount: KSh 20,000.00
  Γ¥î Row 73 (Ref: TERESIA MATHU): User not found
Transaction #73:
  TransID: UG345AADO8
  User Ref: 22694677
  Amount: KSh 169,500.00
  ΓÜá Row 74 (User: ROBERT KAMANDE NGIGI): No outstanding balance on Loan #2006
Transaction #74:
  TransID: UG378A24GH
  User Ref: 24358988
  Amount: KSh 2,000.00
  Γ£ô Row 75 (User: SAMSON OMONDI OKECH): Would allocate KSh 2,000.00 to Loan #2228
Transaction #75:
  TransID: UG3MHA45S1
  User Ref: 13690781
  Amount: KSh 1,500.00
  Γ¥î Row 76 (Ref: 13690781): User not found
Transaction #76:
  TransID: UG3CRA65PW
  User Ref: 30118376
  Amount: KSh 1,000.00
  Γ¥î Row 77 (Ref: 30118376): User not found
Transaction #77:
  TransID: UG3JJ9R7WN
  User Ref: 12415701
  Amount: KSh 2,500.00
  Γ£ô Row 78 (User: ANN NJAMBI KARONG'A): Would allocate KSh 2,500.00 to Loan #2179
Transaction #78:
  TransID: UG3JG9XX74
  User Ref: 23256799
  Amount: KSh 2,300.00
  Γ¥î Row 79 (Ref: 23256799): User not found
Transaction #79:
  TransID: UG302A00WX
  User Ref: 28626828
  Amount: KSh 10,000.00
  Γ¥î Row 80 (Ref: 28626828): User not found
Transaction #80:
  TransID: UG35VA18ZQ
  User Ref: 26713848
  Amount: KSh 13,800.00
  ΓÜá Row 81 (User: ELIZABETH WANJAU MUSYOKA): No outstanding balance on Loan #2130
Transaction #81:
  TransID: UG3NE9YP86
  User Ref: 36580609
  Amount: KSh 11,000.00
  Γ£ô Row 82 (User: CENTRINE NASIMIYU): Would allocate KSh 11,000.00 to Loan #2092
Transaction #82:
  TransID: UG38HA3BS9
  User Ref: 12667846
  Amount: KSh 350.00
  Γ£ô Row 83 (User: JOYCE WAMBURA KAMAU): Would allocate KSh 350.00 to Loan #2063
Transaction #83:
  TransID: UG35YAI5V0
  User Ref: 27138518
  Amount: KSh 3,000.00
  Γ£ô Row 84 (User: THOMAS KYENGO WAMBUA): Would allocate KSh 3,000.00 to Loan #2032

=== SUMMARY ===
Total Processed: 83
Matched: 38
Unmatched: 45
Errors: 0

ΓÜá This was a DRY RUN. No payments were recorded.
Run without --dry-run to apply payments.

=== UNMATCHED TRANSACTIONS ===
Row 7 | Ref: 10976817 | Reason: User not found | TransID: UG1B39OHL7
Row 9 | Ref: 28626828 | Reason: User not found | TransID: UG1029Q3ET
Row 11 | Ref: 30800987 | Reason: User not found | TransID: UG1CI9RVI0
Row 13 | Ref: 23165110 | Reason: User not found | TransID: UG1G09VC1V
Row 14 | Ref: 32781152 | Reason: User not found | TransID: UG1DC9SXRD
Row 15 | Ref: 22841100 | Reason: No outstanding balance on Loan #2018 | TransID: UG1MM9X333
Row 16 | Ref: 13703075 | Reason: User not found | TransID: UG1309XV99
Row 17 | Ref: 26765596 | Reason: No outstanding balance on Loan #2080 | TransID: UG1CL9VDM6
Row 19 | Ref: 26751429 | Reason: User not found | TransID: UG16C98PRG
Row 23 | Ref: 10889384 | Reason: No outstanding balance on Loan #2129 | TransID: UG145A1WTT
Row 25 | Ref: 22346802 | Reason: No outstanding balance on Loan #2252 | TransID: UG1BKA6OAO
Row 26 | Ref: 22582935 | Reason: No outstanding balance on Loan #2250 | TransID: UG15C9TXFC
Row 27 | Ref: 27892853 | Reason: User not found | TransID: UG18J9TBTC
Row 28 | Ref: 25243691 | Reason: User not found | TransID: UG129A5XIS
Row 30 | Ref: 25825416 | Reason: User not found | TransID: UG1JN9MM1J
Row 33 | Ref: 13703075 | Reason: User not found | TransID: UG130A0QZV
Row 36 | Ref: 103300908 | Reason: User not found | TransID: UG2G69ROOY
Row 38 | Ref: 24534186 | Reason: No outstanding balance on Loan #2106 | TransID: UG2S08IGJO
Row 39 | Ref: 33872123 | Reason: User not found | TransID: UG2RDA4Y22
Row 40 | Ref: 10330095 | Reason: No outstanding balance on Loan #2077 | TransID: UG2G69S2E4
Row 41 | Ref: 24534186 | Reason: No outstanding balance on Loan #2106 | TransID: UG2S08IHPU
Row 42 | Ref: 32059800 | Reason: User not found | TransID: UG2JW9GRI8
Row 43 | Ref: 1160332 | Reason: User not found | TransID: UG25N9UUK8
Row 45 | Ref: 23742923 | Reason: No outstanding balance on Loan #2075 | TransID: UG2O89PTSM
Row 46 | Ref: 11035744 | Reason: No outstanding balance on Loan #2105 | TransID: UG24CACY90
Row 48 | Ref: 9947934 | Reason: No outstanding balance on Loan #2008 | TransID: UG2QYA2GPR
Row 51 | Ref: 29954226 | Reason: User not found | TransID: UG2OJ9MSX1
Row 53 | Ref: 25243691 | Reason: User not found | TransID: UG229AAUTK
Row 56 | Ref: 33668248 | Reason: User not found | TransID: UG2J39TZHN
Row 57 | Ref: 0458071 | Reason: No outstanding balance on Loan #2052 | TransID: UG24DAELIG
Row 58 | Ref: 24716093 | Reason: No outstanding balance on Loan #2104 | TransID: UG3GV9JP4Q
Row 59 | Ref: 22632348 | Reason: User not found | TransID: UG3PD9UIG9
Row 62 | Ref: 13687937 | Reason: No outstanding balance on Loan #2079 | TransID: UG34UA1JIV
Row 64 | Ref: 25243691 | Reason: User not found | TransID: UG3EE9VTGR
Row 65 | Ref: 23742923 | Reason: No outstanding balance on Loan #2075 | TransID: UG3O89TG91
Row 67 | Ref: 34142031 | Reason: No outstanding balance on Loan #2161 | TransID: UG3079IQER
Row 70 | Ref: 13427299 | Reason: User not found | TransID: UG3P69YV31
Row 71 | Ref: 21899661 | Reason: User not found | TransID: UG3H4A3MSK
Row 73 | Ref: TERESIA MATHU | Reason: User not found | TransID: UG31ZAAFJY
Row 74 | Ref: 22694677 | Reason: No outstanding balance on Loan #2006 | TransID: UG345AADO8
Row 76 | Ref: 13690781 | Reason: User not found | TransID: UG3MHA45S1
Row 77 | Ref: 30118376 | Reason: User not found | TransID: UG3CRA65PW
Row 79 | Ref: 23256799 | Reason: User not found | TransID: UG3JG9XX74
Row 80 | Ref: 28626828 | Reason: User not found | TransID: UG302A00WX
Row 81 | Ref: 26713848 | Reason: No outstanding balance on Loan #2130 | TransID: UG35VA18ZQ
