Skip to content

HME Demo

Car BI
Funeral BI

Funeral BI Dashboard (Demo)

Funeral Table: Members

MemberID	FullName	IDNumber	Area	Phone	JoinDate	Status
MemberID	FullName	IDNumber	Area	Phone	JoinDate	Status
M001	John Mokoena	8001015009087	Soweto	723456789	10/03/2022	Active
M002	Thabo Dlamini	7505056009081	Tembisa	734567890	15/06/2021	Active
M003	Sarah Nkosi	9009097009085	Katlehong	712345678	05/01/2023	Active

Funeral Table: Policies

PolicyID	MemberID	PlanName	FamilySize	MonthlyFee	StartDate	Status
PolicyID	MemberID	PlanName	FamilySize	MonthlyFee	StartDate	Status
P001	M001	Family 10	10	350	10/03/2022	Active
P002	M002	Family 5	5	250	15/06/2021	Active
P003	M003	Family 8	8	300	05/01/2023	Active
				Total = 900
				Avg = 300.00

Funeral Table: Claims

ClaimID	PolicyID	MemberName	Area	ClaimDate	Amount	Status	ClaimCount
ClaimID	PolicyID	MemberName	Area	ClaimDate	Amount	Status	ClaimCount
C004	P003	Sarah Nkosi	Katlehong	05/01/2025	11,000	Paid	1
C001	P001	John Mokoena	Soweto	12/01/2025	12,000	Paid	1
C002	P002	Thabo Dlamini	Tembisa	20/02/2025	8,500	Paid	1
C005	P002	Thabo Dlamini	Soweto	26/02/2025	5,000	Pending	1
C003	P003	Sarah Nkosi	Katlehong	05/03/2025	10,000	Pending	1
					Total = 46,500
					Avg = 9,300.00

Funeral Table: Payments

PaymentID	PolicyID	Month	Amount	PaymentDate	Status
PaymentID	PolicyID	Month	Amount	PaymentDate	Status
PY001	P001	01/01/2025	350	05/01/2025	Paid
PY002	P002	01/01/2025	250	08/01/2025	Paid
PY003	P003	01/01/2025	300	20/01/2025	Late
			Total = 900
			Avg = 300.00

© 2026 HME Demo

Car BI
Funeral BI

Dynamic title for modals

Are you sure?

Please confirm deletion. There is no undo!