Report Details

Back to Reports
Report Information
  • ID: 5
  • Type: daily_total_cumulative_statement
  • Report Date: 2025-02-06
  • Created: 2025-07-03 13:10:31
  • Status: Completed
  • Completed: 2025-07-03 13:12:09
  • Format: json
Report Parameters
Parameter Value
report_type daily_total_cumulative_statement
report_date 2025-02-06
group_by organizations
output_format json
excel_template templates/daily_total_cumulative_statement.xlsx
targets_file data/targets.json
date_from 2025-01-31
date_to 2025-02-06
date_type I
status P
agreement A
specialty_type S
cache_ttl 3600
workers 5
Report Preview
{
  "report_type": "daily_total_cumulative_statement",
  "report_date": "2025-02-06",
  "generated_at": "2025-07-03T13:12:09",
  "grouping": "organizations",
  "groups": {
    "01": {
      "id": "01",
      "name": "Tadawi Medical - KHM",
      "day_metrics": {
        "day_net_amt_total": 80151.24355999999,
        "day_net_amt_op_em": 80151.24355999999,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 15777.880598,
        "day_patient_share_total": 64373.362962,
        "day_company_share_op_em": 15777.880598,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 64373.362962,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 1098
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 584933.867604,
        "cum_net_amt_op_em": 584933.867604,
        "cum_net_amt_ip": 0.0,
        "cum_company_share_total": 138582.8579832,
        "cum_patient_share_total": 446351.00962080003,
        "cum_company_share_op_em": 138582.8579832,
        "cum_company_share_ip": 0.0,
        "cum_patient_share_op_em": 446351.00962080003,
        "cum_patient_share_ip": 0.0,
        "cum_transaction_count": 7829
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 0.0,
        "day_total_share_moh": 0.0,
        "cum_patient_share_moh": 0.0,
        "cum_company_share_moh": 0.0,
        "cum_total_share_moh": 0.0
      },
      "targets": {
        "daily_target": null,
        "monthly_target": null,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": null,
        "expected_monthly_revenue_percentage_to_this_day": null,
        "actual_revenue_percentage": null
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.76307944255158,
        "cum_credit_percentage": 0.23692055744842003,
        "cum_moh_percentage": 0.0
      }
    },
    "02": {
      "id": "02",
      "name": "Tadawi Medical - Jazan",
      "day_metrics": {
        "day_net_amt_total": 75690.789,
        "day_net_amt_op_em": 65202.789000000004,
        "day_net_amt_ip": 10488.0,
        "day_company_share_total": 15889.739749999999,
        "day_patient_share_total": 59801.04925000001,
        "day_company_share_op_em": 9289.73975,
        "day_company_share_ip": 6600.0,
        "day_patient_share_op_em": 55913.049250000004,
        "day_patient_share_ip": 3888.0,
        "day_transaction_count": 376
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 315650.86699999997,
        "cum_net_amt_op_em": 260062.867,
        "cum_net_amt_ip": 55588.0,
        "cum_company_share_total": 79720.23575,
        "cum_patient_share_total": 235930.63124999998,
        "cum_company_share_op_em": 56520.23574999999,
        "cum_company_share_ip": 23200.0,
        "cum_patient_share_op_em": 203542.63125000003,
        "cum_patient_share_ip": 32388.0,
        "cum_transaction_count": 2231
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 0.0,
        "day_total_share_moh": 0.0,
        "cum_patient_share_moh": 0.0,
        "cum_company_share_moh": 0.0,
        "cum_total_share_moh": 0.0
      },
      "targets": {
        "daily_target": null,
        "monthly_target": null,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": null,
        "expected_monthly_revenue_percentage_to_this_day": null,
        "actual_revenue_percentage": null
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.747441733622737,
        "cum_credit_percentage": 0.252558266377263,
        "cum_moh_percentage": 0.0
      }
    },
    "03": {
      "id": "03",
      "name": "Tadawi Medical - ABH",
      "day_metrics": {
        "day_net_amt_total": 173658.13868899998,
        "day_net_amt_op_em": 173658.13868899998,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 19207.7051152,
        "day_patient_share_total": 154450.43357380002,
        "day_company_share_op_em": 19207.7051152,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 154450.43357380002,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 1562
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 1071702.0424330002,
        "cum_net_amt_op_em": 1071702.0424330002,
        "cum_net_amt_ip": 0.0,
        "cum_company_share_total": 134373.24544929998,
        "cum_patient_share_total": 937328.7969837,
        "cum_company_share_op_em": 134373.24544929998,
        "cum_company_share_ip": 0.0,
        "cum_patient_share_op_em": 937328.7969837,
        "cum_patient_share_ip": 0.0,
        "cum_transaction_count": 10116
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 0.0,
        "day_total_share_moh": 0.0,
        "cum_patient_share_moh": 0.0,
        "cum_company_share_moh": 0.0,
        "cum_total_share_moh": 0.0
      },
      "targets": {
        "daily_target": null,
        "monthly_target": null,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": null,
        "expected_monthly_revenue_percentage_to_this_day": null,
        "actual_revenue_percentage": null
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.8746169736280027,
        "cum_credit_percentage": 0.12538302637199708,
        "cum_moh_percentage": 0.0
      }
    },
    "05": {
      "id": "05",
      "name": "Tadawi Medical - MSF",
      "day_metrics": {
        "day_net_amt_total": 79921.3,
        "day_net_amt_op_em": 36171.3,
        "day_net_amt_ip": 43750.0,
        "day_company_share_total": 31250.0,
        "day_patient_share_total": 48671.3,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 31250.0,
        "day_patient_share_op_em": 36171.3,
        "day_patient_share_ip": 12500.0,
        "day_transaction_count": 121
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 479993.5,
        "cum_net_amt_op_em": 280742.5,
        "cum_net_amt_ip": 199251.0,
        "cum_company_share_total": 103750.0,
        "cum_patient_share_total": 376243.5,
        "cum_company_share_op_em": 0.0,
        "cum_company_share_ip": 103750.0,
        "cum_patient_share_op_em": 280742.5,
        "cum_patient_share_ip": 95501.0,
        "cum_transaction_count": 776
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 0.0,
        "day_total_share_moh": 0.0,
        "cum_patient_share_moh": 0.0,
        "cum_company_share_moh": 0.0,
        "cum_total_share_moh": 0.0
      },
      "targets": {
        "daily_target": null,
        "monthly_target": null,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": null,
        "expected_monthly_revenue_percentage_to_this_day": null,
        "actual_revenue_percentage": null
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.7838512396522036,
        "cum_credit_percentage": 0.21614876034779637,
        "cum_moh_percentage": 0.0
      }
    },
    "08": {
      "id": "08",
      "name": "Tadawi Medical - GNP",
      "day_metrics": {
        "day_net_amt_total": 430193.77095909,
        "day_net_amt_op_em": 101769.76935509,
        "day_net_amt_ip": 328424.001604,
        "day_company_share_total": 402824.77295519994,
        "day_patient_share_total": 27368.998003889996,
        "day_company_share_op_em": 79425.7713512,
        "day_company_share_ip": 323399.001604,
        "day_patient_share_op_em": 22343.998003889996,
        "day_patient_share_ip": 5025.0,
        "day_transaction_count": 1817
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 2568291.44990629,
        "cum_net_amt_op_em": 756416.48628309,
        "cum_net_amt_ip": 1811874.9636232,
        "cum_company_share_total": 2276440.87559125,
        "cum_patient_share_total": 291850.57431504,
        "cum_company_share_op_em": 534940.9119680501,
        "cum_company_share_ip": 1741499.9636232,
        "cum_patient_share_op_em": 221475.57431504002,
        "cum_patient_share_ip": 70375.0,
        "cum_transaction_count": 11418
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 224034.863296,
        "day_total_share_moh": 224034.863296,
        "cum_patient_share_moh": 0.0,
        "cum_company_share_moh": 1062776.7312802,
        "cum_total_share_moh": 1062776.7312802
      },
      "targets": {
        "daily_target": null,
        "monthly_target": null,
        "yearly_target": 9000000,
        "expected_monthly_target_to_this_day": null,
        "expected_monthly_revenue_percentage_to_this_day": null,
        "actual_revenue_percentage": null
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.11363608064251775,
        "cum_credit_percentage": 0.799132829091549,
        "cum_moh_percentage": 0.08723109026593318
      }
    }
  },
  "summary": {
    "day_metrics": {
      "day_net_amt_total": 839615.2422080899,
      "day_net_amt_op_em": 456953.24060409,
      "day_net_amt_ip": 382662.001604,
      "day_company_share_total": 484950.0984184,
      "day_patient_share_total": 354665.14378969,
      "day_company_share_op_em": 123701.09681439999,
      "day_company_share_ip": 361249.001604,
      "day_patient_share_op_em": 333252.14378969,
      "day_patient_share_ip": 21413.0,
      "day_transaction_count": 4974
    },
    "cumulative_metrics": {
      "cum_net_amt_total": 5020571.72694329,
      "cum_net_amt_op_em": 2953857.76332009,
      "cum_net_amt_ip": 2066713.9636231998,
      "cum_company_share_total": 2732867.21477375,
      "cum_patient_share_total": 2287704.51216954,
      "cum_company_share_op_em": 864417.25115055,
      "cum_company_share_ip": 1868449.9636231998,
      "cum_patient_share_op_em": 2089440.51216954,
      "cum_patient_share_ip": 198264.0,
      "cum_transaction_count": 32370
    },
    "moh_metrics": {
      "day_patient_share_moh": 0.0,
      "day_company_share_moh": 224034.863296,
      "day_total_share_moh": 224034.863296,
      "cum_patient_share_moh": 0.0,
      "cum_company_share_moh": 1062776.7312802,
      "cum_total_share_moh": 1062776.7312802
    },
    "targets": {
      "daily_target": null,
      "monthly_target": null,
      "yearly_target": null,
      "expected_monthly_target_to_this_day": null,
      "expected_monthly_revenue_percentage_to_this_day": null,
      "actual_revenue_percentage": null
    },
    "cumulative_percentage_metrics": {
      "cum_cash_percentage": 0.4556661345743544,
      "cum_credit_percentage": 0.4997104887504954,
      "cum_moh_percentage": 0.04462337667515025
    }
  }
}