=== Payment Import (DRY RUN - NO CHANGES) ===
File: C:\Users\HomePC\Downloads\transactions_434_to_454_2026-07-04_08-40-05.json
Format: JSON
Mode: DRY RUN
Total transactions: 21

Transaction #1:
  TransID: UG35YAI5V0
  User Ref: 27138518
  Amount: KSh 3,000.00
  Γ£ô Row 2 (User: THOMAS KYENGO WAMBUA): Would allocate KSh 3,000.00 to Loan #2032
Transaction #2:
  TransID: UG37AA0BQU
  User Ref: 25464031
  Amount: KSh 1,800.00
  Γ¥î Row 3 (Ref: 25464031): User not found
Transaction #3:
  TransID: UG3Q8A1ZKQ
  User Ref: 26325879
  Amount: KSh 8,250.00
  Γ£ô Row 4 (User: ALICE MWIHAKI NGUNJIRI): Would allocate KSh 8,250.00 to Loan #2139
Transaction #4:
  TransID: UG3P09Y2FA
  User Ref: 22201137
  Amount: KSh 2,000.00
  Γ¥î Row 5 (Ref: 22201137): User not found
Transaction #5:
  TransID: UG330A967F
  User Ref: 13703075
  Amount: KSh 1,500.00
  Γ¥î Row 6 (Ref: 13703075): User not found
Transaction #6:
  TransID: UG330A99RJ
  User Ref: 13703075
  Amount: KSh 3,500.00
  Γ¥î Row 7 (Ref: 13703075): User not found
Transaction #7:
  TransID: UG33AA91PP
  User Ref: 26594729
  Amount: KSh 5,000.00
  Γ£ô Row 8 (User: PATRICIA MUSYOKA): Would allocate KSh 5,000.00 to Loan #2184
Transaction #8:
  TransID: UG380A0DDD
  User Ref: 22415173
  Amount: KSh 4,000.00
  Γ£ô Row 9 (User: LEAH WANJIRU MWANGI): Would allocate KSh 4,000.00 to Loan #2120
Transaction #9:
  TransID: UG39S9ZU22
  User Ref: 23773848
  Amount: KSh 1,000.00
  Γ£ô Row 10 (User: HARRISON CHEGE): Would allocate KSh 1,000.00 to Loan #2193
Transaction #10:
  TransID: UG3ICA4LWN
  User Ref: 13217819
  Amount: KSh 600.00
  Γ£ô Row 11 (User: JACKSON MAINA K MWANGI): Would allocate KSh 600.00 to Loan #2183
Transaction #11:
  TransID: UG45YAK3Y5
  User Ref: 27138518
  Amount: KSh 2,000.00
  Γ£ô Row 12 (User: THOMAS KYENGO WAMBUA): Would allocate KSh 2,000.00 to Loan #2032
Transaction #12:
  TransID: UG44OAN0TY
  User Ref: 30996747
  Amount: KSh 25,000.00
  Γ¥î Row 13 (Ref: 30996747): User not found
Transaction #13:
  TransID: UG42FA911E
  User Ref: 26801319
  Amount: KSh 4,000.00
  ΓÜá Row 14 (User: josphine wanjiru muriithi): No outstanding balance on Loan #2236
Transaction #14:
  TransID: UG4H1A15EX
  User Ref: 11594587
  Amount: KSh 2,000.00
  Γ¥î Row 15 (Ref: 11594587): User not found
Transaction #15:
  TransID: UG43ZADXGX
  User Ref: 21963314
  Amount: KSh 60,000.00
  ΓÜá Row 16 (User: CAROLINE NYAMAMU): No outstanding balance on Loan #2206
Transaction #16:
  TransID: UG45OA38HP
  User Ref: 27759730
  Amount: KSh 17,000.00
  Γ£ô Row 17 (User: JOYCE WAMUYU GICHUKI): Would allocate KSh 17,000.00 to Loan #2140
Transaction #17:
  TransID: UG43ZAEBMF
  User Ref: 21963314
  Amount: KSh 2,000.00
  ΓÜá Row 18 (User: CAROLINE NYAMAMU): No outstanding balance on Loan #2206
Transaction #18:
  TransID: UG4LCA5UDQ
  User Ref: 39614023
  Amount: KSh 500.00
  Γ¥î Row 19 (Ref: 39614023): User not found
Transaction #19:
  TransID: UG44EAO2ZV
  User Ref: 28136246
  Amount: KSh 10,000.00
  ΓÜá Row 20 (User: ALPHANDA ASIYO): No outstanding balance on Loan #2182
Transaction #20:
  TransID: UG4IYABHHO
  User Ref: 24510126
  Amount: KSh 1,500.00
  Γ£ô Row 21 (User: SYLVIA OKUMU): Would allocate KSh 1,500.00 to Loan #2195
Transaction #21:
  TransID: UG47PAFZFT
  User Ref: 33934070
  Amount: KSh 500.00
  Γ£ô Row 22 (User: SALOME WAMBAIRE JOSEPH): Would allocate KSh 500.00 to Loan #2150

=== SUMMARY ===
Total Processed: 21
Matched: 10
Unmatched: 11
Errors: 0

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

=== UNMATCHED TRANSACTIONS ===
Row 3 | Ref: 25464031 | Reason: User not found | TransID: UG37AA0BQU
Row 5 | Ref: 22201137 | Reason: User not found | TransID: UG3P09Y2FA
Row 6 | Ref: 13703075 | Reason: User not found | TransID: UG330A967F
Row 7 | Ref: 13703075 | Reason: User not found | TransID: UG330A99RJ
Row 13 | Ref: 30996747 | Reason: User not found | TransID: UG44OAN0TY
Row 14 | Ref: 26801319 | Reason: No outstanding balance on Loan #2236 | TransID: UG42FA911E
Row 15 | Ref: 11594587 | Reason: User not found | TransID: UG4H1A15EX
Row 16 | Ref: 21963314 | Reason: No outstanding balance on Loan #2206 | TransID: UG43ZADXGX
Row 18 | Ref: 21963314 | Reason: No outstanding balance on Loan #2206 | TransID: UG43ZAEBMF
Row 19 | Ref: 39614023 | Reason: User not found | TransID: UG4LCA5UDQ
Row 20 | Ref: 28136246 | Reason: No outstanding balance on Loan #2182 | TransID: UG44EAO2ZV
