Report Details

Back to Reports
Report Information
  • ID: 34
  • Type: daily_total_cumulative_statement
  • Report Date: 2025-07-07
  • Created: 2025-07-07 10:56:10
  • Status: Completed
  • Completed: 2025-07-07 10:56:48
  • Format: json
Report Parameters
Parameter Value
report_type daily_total_cumulative_statement
report_date 2025-07-07
group_by organizations
output_format json
excel_template templates/daily_total_cumulative_statement.xlsx
targets_file data/targets.json
all_organizations True
date_from 2025-07-01
date_to 2025-07-02
date_type I
status P
agreement A
specialty_type S
cache_ttl 3780
workers 5
Report Preview
{
  "report_type": "daily_total_cumulative_statement",
  "report_date": "2025-07-07",
  "generated_at": "2025-07-07T10:56:48",
  "grouping": "organizations",
  "groups": {
    "01": {
      "id": "01",
      "name": "Tadawi Medical - KHM",
      "day_metrics": {
        "day_net_amt_total": 0.0,
        "day_net_amt_op_em": 0.0,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 0.0,
        "day_patient_share_total": 0.0,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 0.0,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 0
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 253656.9270805,
        "cum_net_amt_op_em": 253656.9270805,
        "cum_net_amt_ip": 0.0,
        "cum_company_share_total": 48426.523,
        "cum_patient_share_total": 205230.4040805,
        "cum_company_share_op_em": 48426.523,
        "cum_company_share_ip": 0.0,
        "cum_patient_share_op_em": 205230.4040805,
        "cum_patient_share_ip": 0.0,
        "cum_transaction_count": 2824
      },
      "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": 1900000,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": 429032.2580645161,
        "expected_monthly_revenue_percentage_to_this_day": 0.22580645161290322,
        "actual_revenue_percentage": 0.1335036458318421
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.8090865344882482,
        "cum_credit_percentage": 0.1909134655117519,
        "cum_moh_percentage": 0.0
      }
    },
    "02": {
      "id": "02",
      "name": "Tadawi Medical - Jazan",
      "day_metrics": {
        "day_net_amt_total": 0.0,
        "day_net_amt_op_em": 0.0,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 0.0,
        "day_patient_share_total": 0.0,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 0.0,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 0
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 107049.64180000001,
        "cum_net_amt_op_em": 84349.6418,
        "cum_net_amt_ip": 22700.0,
        "cum_company_share_total": 23570.2,
        "cum_patient_share_total": 83479.4418,
        "cum_company_share_op_em": 17370.2,
        "cum_company_share_ip": 6200.0,
        "cum_patient_share_op_em": 66979.4418,
        "cum_patient_share_ip": 16500.0,
        "cum_transaction_count": 630
      },
      "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": 1900000,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": 429032.2580645161,
        "expected_monthly_revenue_percentage_to_this_day": 0.22580645161290322,
        "actual_revenue_percentage": 0.056341916736842114
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.7798199078140212,
        "cum_credit_percentage": 0.2201800921859787,
        "cum_moh_percentage": 0.0
      }
    },
    "03": {
      "id": "03",
      "name": "Tadawi Medical - ABH",
      "day_metrics": {
        "day_net_amt_total": 0.0,
        "day_net_amt_op_em": 0.0,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 0.0,
        "day_patient_share_total": 0.0,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 0.0,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 0
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 446574.69629,
        "cum_net_amt_op_em": 446574.69629,
        "cum_net_amt_ip": 0.0,
        "cum_company_share_total": 55537.05300000001,
        "cum_patient_share_total": 391037.64329,
        "cum_company_share_op_em": 55537.05300000001,
        "cum_company_share_ip": 0.0,
        "cum_patient_share_op_em": 391037.64329,
        "cum_patient_share_ip": 0.0,
        "cum_transaction_count": 4052
      },
      "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": 1900000,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": 429032.2580645161,
        "expected_monthly_revenue_percentage_to_this_day": 0.22580645161290322,
        "actual_revenue_percentage": 0.2350393138368421
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.8756377075069768,
        "cum_credit_percentage": 0.12436229249302326,
        "cum_moh_percentage": 0.0
      }
    },
    "05": {
      "id": "05",
      "name": "Tadawi Medical - MSF",
      "day_metrics": {
        "day_net_amt_total": 0.0,
        "day_net_amt_op_em": 0.0,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 0.0,
        "day_patient_share_total": 0.0,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 0.0,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 0
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 193025.85,
        "cum_net_amt_op_em": 91125.85,
        "cum_net_amt_ip": 101900.0,
        "cum_company_share_total": 84900.0,
        "cum_patient_share_total": 108125.85,
        "cum_company_share_op_em": 0.0,
        "cum_company_share_ip": 84900.0,
        "cum_patient_share_op_em": 91125.85,
        "cum_patient_share_ip": 17000.0,
        "cum_transaction_count": 225
      },
      "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": 1900000,
        "yearly_target": 25000000,
        "expected_monthly_target_to_this_day": 429032.2580645161,
        "expected_monthly_revenue_percentage_to_this_day": 0.22580645161290322,
        "actual_revenue_percentage": 0.10159255263157894
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.5601625378155309,
        "cum_credit_percentage": 0.43983746218446906,
        "cum_moh_percentage": 0.0
      }
    },
    "08": {
      "id": "08",
      "name": "Tadawi Medical - GNP",
      "day_metrics": {
        "day_net_amt_total": 0.0,
        "day_net_amt_op_em": 0.0,
        "day_net_amt_ip": 0.0,
        "day_company_share_total": 0.0,
        "day_patient_share_total": 0.0,
        "day_company_share_op_em": 0.0,
        "day_company_share_ip": 0.0,
        "day_patient_share_op_em": 0.0,
        "day_patient_share_ip": 0.0,
        "day_transaction_count": 0
      },
      "cumulative_metrics": {
        "cum_net_amt_total": 884670.7938870501,
        "cum_net_amt_op_em": 277858.67692625,
        "cum_net_amt_ip": 606812.1169608,
        "cum_company_share_total": 667586.9579608,
        "cum_patient_share_total": 217083.83592624997,
        "cum_company_share_op_em": 174940.57,
        "cum_company_share_ip": 492646.38796079997,
        "cum_patient_share_op_em": 102918.10692625001,
        "cum_patient_share_ip": 114165.729,
        "cum_transaction_count": 3921
      },
      "moh_metrics": {
        "day_patient_share_moh": 0.0,
        "day_company_share_moh": 0.0,
        "day_total_share_moh": 0.0,
        "cum_patient_share_moh": 74079.50899999999,
        "cum_company_share_moh": 269756.2304608,
        "cum_total_share_moh": 343835.73946079996
      },
      "targets": {
        "daily_target": null,
        "monthly_target": 800000,
        "yearly_target": 9000000,
        "expected_monthly_target_to_this_day": 180645.1612903226,
        "expected_monthly_revenue_percentage_to_this_day": 0.22580645161290322,
        "actual_revenue_percentage": 1.1058384923588127
      },
      "cumulative_percentage_metrics": {
        "cum_cash_percentage": 0.24538374887728692,
        "cum_credit_percentage": 0.7546162511227129,
        "cum_moh_percentage": 0.0
      }
    }
  },
  "summary": {
    "day_metrics": {
      "day_net_amt_total": 0.0,
      "day_net_amt_op_em": 0.0,
      "day_net_amt_ip": 0.0,
      "day_company_share_total": 0.0,
      "day_patient_share_total": 0.0,
      "day_company_share_op_em": 0.0,
      "day_company_share_ip": 0.0,
      "day_patient_share_op_em": 0.0,
      "day_patient_share_ip": 0.0,
      "day_transaction_count": 0
    },
    "cumulative_metrics": {
      "cum_net_amt_total": 1884977.90905755,
      "cum_net_amt_op_em": 1153565.7920967499,
      "cum_net_amt_ip": 731412.1169608,
      "cum_company_share_total": 880020.7339607999,
      "cum_patient_share_total": 1004957.17509675,
      "cum_company_share_op_em": 296274.346,
      "cum_company_share_ip": 583746.3879608,
      "cum_patient_share_op_em": 857291.44609675,
      "cum_patient_share_ip": 147665.729,
      "cum_transaction_count": 11652
    },
    "moh_metrics": {
      "day_patient_share_moh": 0.0,
      "day_company_share_moh": 0.0,
      "day_total_share_moh": 0.0,
      "cum_patient_share_moh": 74079.50899999999,
      "cum_company_share_moh": 269756.2304608,
      "cum_total_share_moh": 343835.73946079996
    },
    "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.533140027937626,
      "cum_credit_percentage": 0.466859972062374,
      "cum_moh_percentage": 0.0
    }
  }
}