AI Report Filling PoC

Use placeholders in your Excel template:
{{ CS_FILL("path.to.json.data") }} - Fills directly from JSON data.
{{ CS_AI_FILL(A1, "AI prompt") }} - Fills using AI based on prompt/cell + JSON data.

{
    "linked_player_uuid": "test-player",
    "operator_uuid": "test-operator",
    "case_uuid": "test-case",
    "case_reference": "TEST123",
    "case_duration": 30,
    "generated_at": "2024-07-30T10:00:00Z",
    "window_start_date_time": "2024-07-01T00:00:00Z",
    "window_end_date_time": "2024-07-30T23:59:59Z",
    "region": "GB",
    "requested_deposit_amount": 1000,
    "financial_account_snapshots": [],
    "recategorizations": [],
    "aggregate_transaction_category_map": {},
    "monthly_spend": 5000.5,
    "risk_matrix": {
        "name": "TestMatrix",
        "status": "ACTIVE"
    },
    "recommended_decision": "APPROVE",
    "insufficient_data": false,
    "risk_rating": "LOW",
    "score": 85,
    "automated_markers": {},
    "statistics": {
        "totals": {
            "total_balance_net": 1500,
            "total_in_abs": 5000,
            "total_out_abs": 3500,
            "total_net": 1500,
            "total_essential_costs_abs": 2000,
            "total_committed_costs_abs": 1000
        },
        "averages": {
            "average_committed_costs_abs": 1000,
            "average_essential_costs_abs": 2000,
            "average_expected_income_abs": 5000,
            "average_disposable_income_abs": 2000,
            "average_expected_salary_abs": 4500
        },
        "current_month": {
            "total_balance_net": 1500,
            "total_committed_costs_abs": 1000,
            "total_essential_costs_abs": 2000,
            "total_in_abs": 5000,
            "total_out_abs": 3500,
            "current_month_disposable_available_funds_net": 1500,
            "current_month_income_received_percentage_abs": 100
        }
    },
    "insights": {
        "current_month_insights": {
            "gambling": {
                "spend_net": -60000,
                "gambling_income": {
                    "total_abs": 20000,
                    "percentage": "0.08"
                },
                "gambling_spend": {
                    "total_abs": 80000,
                    "percentage": "0.15"
                },
                "operators": 3
            },
            "financial": {
                "negative_balance_ratio": 10,
                "returned_direct_debits": {
                    "total_abs": 5000,
                    "percentage": "0.01"
                },
                "cash_withdrawals": {
                    "total_abs": 30000,
                    "percentage": "0.06"
                },
                "credit_repayments": {
                    "total_abs": 20000,
                    "percentage": "0.04"
                },
                "outgoing_bank_transfers": {
                    "total_abs": 15000,
                    "percentage": "0.03"
                }
            },
            "category": {
                "GAMBLING": {
                    "total_net": -60000,
                    "percentage_income": 8,
                    "percentage_expenditure": 15
                },
                "RENT": {
                    "total_net": -100000,
                    "percentage_income": 0,
                    "percentage_expenditure": 20
                },
                "PAYCHECKS": {
                    "total_net": 250000,
                    "percentage_income": 100,
                    "percentage_expenditure": 0
                }
            },
            "liquidity": {
                "average_income": {
                    "total_abs": 250000,
                    "average": 250000
                },
                "committed_costs": {
                    "total_abs": 120000,
                    "average": 120000
                },
                "essential_costs": {
                    "total_abs": 100000,
                    "average": 100000
                }
            }
        },
        "three_month_insights": {
            "gambling": {
                "spend_net": -180000,
                "gambling_income": {
                    "total_abs": 70000,
                    "percentage": "0.09"
                },
                "gambling_spend": {
                    "total_abs": 250000,
                    "percentage": "0.17"
                },
                "operators": 5
            }
        }
    }
}
Processing... Please wait. This may take a moment.
Download Generated Report