Exhibit F - Dental Claims Incurred and Claims Paid.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Dental Benefits Program
Solicitation number
RFP AABA 2027000021 3
Issued by
Denver County, Colorado

About this file

Exhibit F - Dental Claims Incurred and Claims Paid

This is a dental claims data exhibit associated with Colorado's Dental Benefits Program, detailing historical claims activity for a single master account (00000007649) across two benefit plan categories: Basic and Basic Plus. The document presents comprehensive claims payment records spanning from May 2025 through June 2026, organized by incurrence month and payment month to illustrate claims processing timelines and payment patterns. The Basic plan category generated $7,768,453.16 in total paid claims, while the Basic Plus category accumulated $21,035,815.22 in total paid claims, reflecting significantly higher utilization and costs under the enhanced coverage tier.

The data demonstrates claims payment patterns with considerable variation in monthly amounts, ranging from under $100 to over $1.2 million per claim cohort, indicating substantial member enrollment and diverse dental service utilization. Individual claim payments within each month-to-month combination vary widely, with some claims paid within the same month as incurrence and others experiencing multi-month processing delays. The combined total paid claims across both plan categories amount to approximately $28.8 million, representing substantial claims volume and processing activity under the state's dental benefits program during the documented period.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Basic

Master Account IDIncurMonthPaidMonthPaid Amount
Totals$7,768,453.16
00000007649Apr 2026Jun 2026$7,405.60
00000007649Mar 2026Jun 2026$4,568.72
00000007649Feb 2026Jun 2026$1,157.70
00000007649Jan 2026Jun 2026$2,448.70
00000007649Dec 2025Jun 2026$570.50
00000007649Nov 2025Jun 2026$357.60
00000007649Oct 2025Jun 2026$1,119.00
00000007649Sep 2025Jun 2026$308.50
00000007649Aug 2025Jun 2026$406.00
00000007649Jul 2025Jun 2026$165.60
00000007649Jun 2025Jun 2026$457.00
00000007649Apr 2026May 2026$144,397.06
00000007649Mar 2026May 2026$9,100.63
00000007649Feb 2026May 2026$1,887.24
00000007649Jan 2026May 2026$1,850.81
00000007649Dec 2025May 2026$1,938.10
00000007649Nov 2025May 2026$428.12
00000007649Oct 2025May 2026$153.00
00000007649Sep 2025May 2026$626.00
00000007649Aug 2025May 2026$312.50
00000007649Jul 2025May 2026$141.40
00000007649Jun 2025May 2026$106.00
00000007649May 2025May 2026$116.00
00000007649Apr 2026Apr 2026$510,774.18
00000007649Mar 2026Apr 2026$144,465.16
00000007649Feb 2026Apr 2026$9,829.31
00000007649Jan 2026Apr 2026$4,608.76
00000007649Dec 2025Apr 2026$1,982.14
00000007649Nov 2025Apr 2026$609.00
00000007649Oct 2025Apr 2026$104.21
00000007649Sep 2025Apr 2026$911.67
00000007649Aug 2025Apr 2026$400.79
00000007649Jul 2025Apr 2026$247.70
00000007649Jun 2025Apr 2026$544.48
00000007649May 2025Apr 2026$166.00
00000007649Mar 2026Mar 2026$543,099.25
00000007649Feb 2026Mar 2026$127,186.98
00000007649Jan 2026Mar 2026$8,516.30
00000007649Dec 2025Mar 2026$4,636.52
00000007649Nov 2025Mar 2026$794.00
00000007649Oct 2025Mar 2026$3,391.50
00000007649Sep 2025Mar 2026$488.00
00000007649Aug 2025Mar 2026$1,829.80
00000007649Jul 2025Mar 2026$1,158.00
00000007649Jun 2025Mar 2026$381.81
00000007649May 2025Mar 2026$538.00
00000007649Feb 2026Feb 2026$495,428.45
00000007649Jan 2026Feb 2026$119,973.01
00000007649Dec 2025Feb 2026$9,058.30
00000007649Nov 2025Feb 2026$3,159.96
00000007649Oct 2025Feb 2026$4,778.91
00000007649Sep 2025Feb 2026$437.10
00000007649Aug 2025Feb 2026$563.41
00000007649Jul 2025Feb 2026$1,266.70
00000007649Jun 2025Feb 2026$285.28
00000007649May 2025Feb 2026$409.19
00000007649Jan 2026Jan 2026$503,918.43
00000007649Dec 2025Jan 2026$132,518.18
00000007649Nov 2025Jan 2026$5,283.61
00000007649Oct 2025Jan 2026$6,031.54
00000007649Sep 2025Jan 2026$4,919.93
00000007649Aug 2025Jan 2026$654.16
00000007649Jul 2025Jan 2026$532.80
00000007649Jun 2025Jan 2026$1,113.70
00000007649May 2025Jan 2026$347.50
00000007649Dec 2025Dec 2025$460,140.46
00000007649Nov 2025Dec 2025$141,964.22
00000007649Oct 2025Dec 2025$17,908.18
00000007649Sep 2025Dec 2025$13,008.96
00000007649Aug 2025Dec 2025$6,911.42
00000007649Jul 2025Dec 2025$4,258.57
00000007649Jun 2025Dec 2025$551.30
00000007649May 2025Dec 2025$1,633.46
00000007649Nov 2025Nov 2025$393,930.90
00000007649Oct 2025Nov 2025$91,390.20
00000007649Sep 2025Nov 2025$6,068.07
00000007649Aug 2025Nov 2025$3,823.60
00000007649Jul 2025Nov 2025$3,239.69
00000007649Jun 2025Nov 2025$604.40
00000007649May 2025Nov 2025$418.30
00000007649Oct 2025Oct 2025$565,618.57
00000007649Sep 2025Oct 2025$112,006.29
00000007649Aug 2025Oct 2025$9,499.30
00000007649Jul 2025Oct 2025$4,407.80
00000007649Jun 2025Oct 2025$1,664.60
00000007649May 2025Oct 2025$1,821.90
00000007649Sep 2025Sep 2025$520,304.24
00000007649Aug 2025Sep 2025$131,535.28
00000007649Jul 2025Sep 2025$11,043.71
00000007649Jun 2025Sep 2025$7,573.10
00000007649May 2025Sep 2025$1,184.10
00000007649Aug 2025Aug 2025$462,244.07
00000007649Jul 2025Aug 2025$132,900.02
00000007649Jun 2025Aug 2025$12,628.92
00000007649May 2025Aug 2025$4,913.59
00000007649Jul 2025Jul 2025$538,645.90
00000007649Jun 2025Jul 2025$133,948.46
00000007649May 2025Jul 2025$8,532.80
00000007649Jun 2025Jun 2025$491,252.17
00000007649May 2025Jun 2025$110,490.67
00000007649May 2025May 2025$523,020.44

Basic Plus

Master Account IDIncurMonthPaidMonthPaid Amount
Totals$21,035,815.22
00000007649Apr 2026Jun 2026$54,408.41
00000007649Mar 2026Jun 2026$12,051.50
00000007649Feb 2026Jun 2026$5,131.60
00000007649Jan 2026Jun 2026$10,671.85
00000007649Dec 2025Jun 2026$4,263.20
00000007649Nov 2025Jun 2026$3,536.40
00000007649Oct 2025Jun 2026$3,032.80
00000007649Sep 2025Jun 2026$4,100.73
00000007649Aug 2025Jun 2026$2,131.00
00000007649Jul 2025Jun 2026$1,207.20
00000007649Jun 2025Jun 2026$2,869.00
00000007649May 2025Jun 2026$1,738.80
00000007649Apr 2026May 2026$430,007.72
00000007649Mar 2026May 2026$50,761.68
00000007649Feb 2026May 2026$15,400.29
00000007649Jan 2026May 2026$12,320.28
00000007649Dec 2025May 2026$6,093.77
00000007649Nov 2025May 2026$6,802.17
00000007649Oct 2025May 2026$2,003.69
00000007649Sep 2025May 2026$4,475.57
00000007649Aug 2025May 2026$213.67
00000007649Jul 2025May 2026$2,119.77
00000007649Jun 2025May 2026$794.37
00000007649May 2025May 2026$2,116.00
00000007649Apr 2026Apr 2026$1,229,849.58
00000007649Mar 2026Apr 2026$460,450.17
00000007649Feb 2026Apr 2026$58,532.59
00000007649Jan 2026Apr 2026$20,089.44
00000007649Dec 2025Apr 2026$16,388.00
00000007649Nov 2025Apr 2026$9,245.14
00000007649Oct 2025Apr 2026$4,634.18
00000007649Sep 2025Apr 2026$4,815.76
00000007649Aug 2025Apr 2026$26.54
00000007649Jul 2025Apr 2026$4,529.37
00000007649Jun 2025Apr 2026$2,348.97
00000007649May 2025Apr 2026$2,747.96
00000007649Mar 2026Mar 2026$1,289,933.03
00000007649Feb 2026Mar 2026$410,622.56
00000007649Jan 2026Mar 2026$38,849.54
00000007649Dec 2025Mar 2026$20,650.73
00000007649Nov 2025Mar 2026$10,746.97
00000007649Oct 2025Mar 2026$9,265.49
00000007649Sep 2025Mar 2026$2,426.40
00000007649Aug 2025Mar 2026$1,278.92
00000007649Jul 2025Mar 2026$3,249.40
00000007649Jun 2025Mar 2026$717.22
00000007649May 2025Mar 2026$711.63
00000007649Feb 2026Feb 2026$1,213,534.70
00000007649Jan 2026Feb 2026$374,090.53
00000007649Dec 2025Feb 2026$52,310.01
00000007649Nov 2025Feb 2026$17,246.81
00000007649Oct 2025Feb 2026$12,732.14
00000007649Sep 2025Feb 2026$5,412.20
00000007649Aug 2025Feb 2026$7,420.00
00000007649Jul 2025Feb 2026$4,882.60
00000007649Jun 2025Feb 2026$3,467.80
00000007649May 2025Feb 2026$2,985.90
00000007649Jan 2026Jan 2026$1,240,035.87
00000007649Dec 2025Jan 2026$412,938.54
00000007649Nov 2025Jan 2026$42,414.07
00000007649Oct 2025Jan 2026$23,995.46
00000007649Sep 2025Jan 2026$20,007.55
00000007649Aug 2025Jan 2026$6,006.30
00000007649Jul 2025Jan 2026$6,127.18
00000007649Jun 2025Jan 2026$2,168.00
00000007649May 2025Jan 2026$134.00
00000007649Dec 2025Dec 2025$1,186,817.27
00000007649Nov 2025Dec 2025$461,079.40
00000007649Oct 2025Dec 2025$61,911.71
00000007649Sep 2025Dec 2025$29,943.65
00000007649Aug 2025Dec 2025$13,429.01
00000007649Jul 2025Dec 2025$16,085.24
00000007649Jun 2025Dec 2025$5,362.20
00000007649May 2025Dec 2025$4,642.32
00000007649Nov 2025Nov 2025$1,005,747.98
00000007649Oct 2025Nov 2025$272,510.50
00000007649Sep 2025Nov 2025$26,801.93
00000007649Aug 2025Nov 2025$22,519.05
00000007649Jul 2025Nov 2025$24,428.50
00000007649Jun 2025Nov 2025$2,680.10
00000007649May 2025Nov 2025$674.90
00000007649Oct 2025Oct 2025$1,463,333.90
00000007649Sep 2025Oct 2025$328,756.99
00000007649Aug 2025Oct 2025$47,348.90
00000007649Jul 2025Oct 2025$24,128.40
00000007649Jun 2025Oct 2025$7,690.53
00000007649May 2025Oct 2025$4,241.20
00000007649Sep 2025Sep 2025$1,315,024.97
00000007649Aug 2025Sep 2025$420,102.73
00000007649Jul 2025Sep 2025$65,835.63
00000007649Jun 2025Sep 2025$18,158.92
00000007649May 2025Sep 2025$6,841.11
00000007649Aug 2025Aug 2025$1,282,712.93
00000007649Jul 2025Aug 2025$521,965.23
00000007649Jun 2025Aug 2025$37,190.10
00000007649May 2025Aug 2025$16,167.93
00000007649Jul 2025Jul 2025$1,511,656.93
00000007649Jun 2025Jul 2025$406,360.05
00000007649May 2025Jul 2025$39,447.08
00000007649Jun 2025Jun 2025$1,237,738.08
00000007649May 2025Jun 2025$314,478.09
00000007649May 2025May 2025$1,143,731.04

File details come from the government source that posted it. Updated .