=== PHASE 2: Denis Transaction Reconciliation ===

Donation record bf885e30 status: N/A
Transfer 6c759df3 status: N/A
Bank response status: N/A
Bank response payload: N/A

=== Running reconcileStkTransfers for the date range covering this transfer ===
{
    "success": true,
    "from_date": "2026-09-07",
    "to_date": "2026-09-07",
    "stuck_transfers": 7,
    "reconciled": 0,
    "failed": 0,
    "results": [
        {
            "transfer_id": "3c6f7f44-1cd9-4ac8-bc78-59f407d97832",
            "message_reference": "STK2609071346531496",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071346531496",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "No response from user.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071346531496",
                    "MessageDateTime": "2026-09-22T02:09:58",
                    "MessageCode": "1037",
                    "MessageDescription": "No response from user."
                }
            }
        },
        {
            "transfer_id": "5fab9d9a-1223-489b-a149-eb19fef464e2",
            "message_reference": "STK2609071338563646",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071338563646",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "No response from user.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071338563646",
                    "MessageDateTime": "2026-09-22T02:09:59",
                    "MessageCode": "1037",
                    "MessageDescription": "No response from user."
                }
            }
        },
        {
            "transfer_id": "647f6410-fcc4-4887-8885-9ef6c78a14ce",
            "message_reference": "STK2609071319174152",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071319174152",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "DS timeout user cannot be reached.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071319174152",
                    "MessageDateTime": "2026-09-22T02:09:59",
                    "MessageCode": "1037",
                    "MessageDescription": "DS timeout user cannot be reached."
                }
            }
        },
        {
            "transfer_id": "76efd55e-af90-4504-b469-4f00ab987370",
            "message_reference": "STK2609071348257014",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071348257014",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "No response from user.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071348257014",
                    "MessageDateTime": "2026-09-22T02:09:59",
                    "MessageCode": "1037",
                    "MessageDescription": "No response from user."
                }
            }
        },
        {
            "transfer_id": "cdf1835e-4b0e-4f35-b5f0-217a0f2c3c51",
            "message_reference": "STK2609071313292058",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071313292058",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "DS timeout user cannot be reached.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071313292058",
                    "MessageDateTime": "2026-09-22T02:09:00",
                    "MessageCode": "1037",
                    "MessageDescription": "DS timeout user cannot be reached."
                }
            }
        },
        {
            "transfer_id": "ea689dad-18ee-4217-b58f-691f4d8a1fc5",
            "message_reference": "STK2609071338532454",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071338532454",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "No response from user.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071338532454",
                    "MessageDateTime": "2026-09-22T02:09:00",
                    "MessageCode": "1037",
                    "MessageDescription": "No response from user."
                }
            }
        },
        {
            "transfer_id": "f062ca81-ab77-4ff5-a040-65d550c86f69",
            "message_reference": "STK2609071350086461",
            "status": "pending",
            "bank_status": {
                "status": "PENDING",
                "message_reference": "STK2609071350086461",
                "transaction_id": null,
                "amount": 0,
                "message_code": "1037",
                "message_description": "No response from user.",
                "is_customer_action_required": true,
                "response": {
                    "MessageReference": "STK2609071350086461",
                    "MessageDateTime": "2026-09-22T02:09:00",
                    "MessageCode": "1037",
                    "MessageDescription": "No response from user."
                }
            }
        }
    ]
}

=== Post-reconciliation state ===
Donation bf885e30 status after reconciliation: N/A
Donation bf885e30 payment_ref after reconciliation: N/A

=== Wallet transactions after reconciliation ===
{
    "id": "1cde1354-3346-416b-ade5-72cabd924fda",
    "wallet_type": "donation",
    "direction": "credit",
    "source": "wallet_fixup",
    "reference_id": "cc5137df-1ec6-4db1-b91f-62650a594c66",
    "reference_table": "donation_payment_records",
    "party_name": null,
    "party_phone": null,
    "gross_amount": "50.00",
    "mpesa_charge": "0.00",
    "system_fee": "0.00",
    "net_amount": "50.00",
    "running_balance": "50.00",
    "mpesa_receipt": "donation-350c6ca6-c31d-4125-a22c-7d682a24edc5-ws_CO_d80e0b411a484f865507b5af",
    "idempotency_key": null,
    "status": "completed",
    "notes": "Missed callback repair - fund drive wallet update",
    "created_by": "350c6ca6-c31d-4125-a22c-7d682a24edc5",
    "occurred_at": "2026-09-07 14:56:27.000",
    "created_at": "2026-09-07 14:56:27.000"
}
{
    "id": "811e8c67-30c0-4d06-b007-bb0c830190f1",
    "wallet_type": "donation",
    "direction": "credit",
    "source": "stk_status",
    "reference_id": "e0fda4a0-4caa-4be8-bad5-0eaf50542139",
    "reference_table": "donation_payment_records",
    "party_name": null,
    "party_phone": null,
    "gross_amount": "5.00",
    "mpesa_charge": "0.00",
    "system_fee": "0.00",
    "net_amount": "5.00",
    "running_balance": "65.00",
    "mpesa_receipt": "STK2609201317449513",
    "idempotency_key": null,
    "status": "completed",
    "notes": "Fund drive payment - campaign 132daf7a-afb0-4f6b-833b-e3f56c4cfc35",
    "created_by": "11111111-1111-1111-1111-111111111111",
    "occurred_at": "2026-09-20 13:57:42.000",
    "created_at": "2026-09-20 13:57:42.000"
}
{
    "id": "e34f405e-d287-4a05-a1fc-827a97f28236",
    "wallet_type": "donation",
    "direction": "credit",
    "source": "bank_reconciliation",
    "reference_id": "1c46c432-20af-41ae-bf9a-6871dd7479a2",
    "reference_table": "donation_payment_records",
    "party_name": null,
    "party_phone": null,
    "gross_amount": "10.00",
    "mpesa_charge": "0.00",
    "system_fee": "0.00",
    "net_amount": "10.00",
    "running_balance": "60.00",
    "mpesa_receipt": "CB0161240",
    "idempotency_key": null,
    "status": "completed",
    "notes": "Bank reconciliation - missed callback repair",
    "created_by": "11111111-1111-1111-1111-111111111111",
    "occurred_at": "2026-09-20 09:59:54.000",
    "created_at": "2026-09-20 09:59:54.000"
}