Exhibit F - Dental Claims Incurred and Claims Paid.xlsx

XLSX spreadsheet 23 KB Posted

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

About this file

Exhibit F is a dental claims data file for the Colorado Dental Benefits Program, documenting claims incurred and paid by Master Account ID 00000007649 across two benefit plan categories: Basic and Basic Plus. The file contains detailed records of dental claims spanning from May 2025 through June 2026, with incurrence months ranging from May 2025 back to June 2025 and payment months occurring between May 2025 and June 2026. The data is organized by incurrence month, payment month, and corresponding paid amounts for each claim record, enabling tracking of claim processing timelines and payment patterns across the dental benefits portfolio.

The Basic plan category generated total dental claims paid of $7,768,453.16, while the Basic Plus plan category produced significantly higher claims of $21,035,815.22, reflecting substantially greater utilization or claim values under the enhanced plan option. The data demonstrates typical dental claim payment patterns with claims incurred in earlier months often paid in subsequent months, indicating standard claims processing lag times. The largest single monthly payments occur in months where claims incurred in the immediate prior month are processed, with notable payments in April 2026 ($510,774.18 for Basic and $1,229,849.58 for Basic Plus for April incurrence), indicating consistent claim volume and processing activity throughout the contract 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 .