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
| File | Type | Posted |
|---|---|---|
| Inquiries and Answers for RFP AABA 2027-0021.pdf | ||
| Exhibit B - Offeror Questionnaire.xlsx | XLSX spreadsheet | |
| Administrative Information for RFP AABA 2027-0021.pdf | ||
| Exhibit D - Information Technology Contract.docx | DOCX document | |
| Exhibit C - Cost Exhibit.xlsx | XLSX spreadsheet | |
| Exhibit E - W-9 - Fillable.pdf | ||
| Exhibit A - Specifications and Requirements for RFP AABA 2027-0021.pdf |
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 ID | IncurMonth | PaidMonth | Paid Amount |
| Totals | $7,768,453.16 | ||
| 00000007649 | Apr 2026 | Jun 2026 | $7,405.60 |
| 00000007649 | Mar 2026 | Jun 2026 | $4,568.72 |
| 00000007649 | Feb 2026 | Jun 2026 | $1,157.70 |
| 00000007649 | Jan 2026 | Jun 2026 | $2,448.70 |
| 00000007649 | Dec 2025 | Jun 2026 | $570.50 |
| 00000007649 | Nov 2025 | Jun 2026 | $357.60 |
| 00000007649 | Oct 2025 | Jun 2026 | $1,119.00 |
| 00000007649 | Sep 2025 | Jun 2026 | $308.50 |
| 00000007649 | Aug 2025 | Jun 2026 | $406.00 |
| 00000007649 | Jul 2025 | Jun 2026 | $165.60 |
| 00000007649 | Jun 2025 | Jun 2026 | $457.00 |
| 00000007649 | Apr 2026 | May 2026 | $144,397.06 |
| 00000007649 | Mar 2026 | May 2026 | $9,100.63 |
| 00000007649 | Feb 2026 | May 2026 | $1,887.24 |
| 00000007649 | Jan 2026 | May 2026 | $1,850.81 |
| 00000007649 | Dec 2025 | May 2026 | $1,938.10 |
| 00000007649 | Nov 2025 | May 2026 | $428.12 |
| 00000007649 | Oct 2025 | May 2026 | $153.00 |
| 00000007649 | Sep 2025 | May 2026 | $626.00 |
| 00000007649 | Aug 2025 | May 2026 | $312.50 |
| 00000007649 | Jul 2025 | May 2026 | $141.40 |
| 00000007649 | Jun 2025 | May 2026 | $106.00 |
| 00000007649 | May 2025 | May 2026 | $116.00 |
| 00000007649 | Apr 2026 | Apr 2026 | $510,774.18 |
| 00000007649 | Mar 2026 | Apr 2026 | $144,465.16 |
| 00000007649 | Feb 2026 | Apr 2026 | $9,829.31 |
| 00000007649 | Jan 2026 | Apr 2026 | $4,608.76 |
| 00000007649 | Dec 2025 | Apr 2026 | $1,982.14 |
| 00000007649 | Nov 2025 | Apr 2026 | $609.00 |
| 00000007649 | Oct 2025 | Apr 2026 | $104.21 |
| 00000007649 | Sep 2025 | Apr 2026 | $911.67 |
| 00000007649 | Aug 2025 | Apr 2026 | $400.79 |
| 00000007649 | Jul 2025 | Apr 2026 | $247.70 |
| 00000007649 | Jun 2025 | Apr 2026 | $544.48 |
| 00000007649 | May 2025 | Apr 2026 | $166.00 |
| 00000007649 | Mar 2026 | Mar 2026 | $543,099.25 |
| 00000007649 | Feb 2026 | Mar 2026 | $127,186.98 |
| 00000007649 | Jan 2026 | Mar 2026 | $8,516.30 |
| 00000007649 | Dec 2025 | Mar 2026 | $4,636.52 |
| 00000007649 | Nov 2025 | Mar 2026 | $794.00 |
| 00000007649 | Oct 2025 | Mar 2026 | $3,391.50 |
| 00000007649 | Sep 2025 | Mar 2026 | $488.00 |
| 00000007649 | Aug 2025 | Mar 2026 | $1,829.80 |
| 00000007649 | Jul 2025 | Mar 2026 | $1,158.00 |
| 00000007649 | Jun 2025 | Mar 2026 | $381.81 |
| 00000007649 | May 2025 | Mar 2026 | $538.00 |
| 00000007649 | Feb 2026 | Feb 2026 | $495,428.45 |
| 00000007649 | Jan 2026 | Feb 2026 | $119,973.01 |
| 00000007649 | Dec 2025 | Feb 2026 | $9,058.30 |
| 00000007649 | Nov 2025 | Feb 2026 | $3,159.96 |
| 00000007649 | Oct 2025 | Feb 2026 | $4,778.91 |
| 00000007649 | Sep 2025 | Feb 2026 | $437.10 |
| 00000007649 | Aug 2025 | Feb 2026 | $563.41 |
| 00000007649 | Jul 2025 | Feb 2026 | $1,266.70 |
| 00000007649 | Jun 2025 | Feb 2026 | $285.28 |
| 00000007649 | May 2025 | Feb 2026 | $409.19 |
| 00000007649 | Jan 2026 | Jan 2026 | $503,918.43 |
| 00000007649 | Dec 2025 | Jan 2026 | $132,518.18 |
| 00000007649 | Nov 2025 | Jan 2026 | $5,283.61 |
| 00000007649 | Oct 2025 | Jan 2026 | $6,031.54 |
| 00000007649 | Sep 2025 | Jan 2026 | $4,919.93 |
| 00000007649 | Aug 2025 | Jan 2026 | $654.16 |
| 00000007649 | Jul 2025 | Jan 2026 | $532.80 |
| 00000007649 | Jun 2025 | Jan 2026 | $1,113.70 |
| 00000007649 | May 2025 | Jan 2026 | $347.50 |
| 00000007649 | Dec 2025 | Dec 2025 | $460,140.46 |
| 00000007649 | Nov 2025 | Dec 2025 | $141,964.22 |
| 00000007649 | Oct 2025 | Dec 2025 | $17,908.18 |
| 00000007649 | Sep 2025 | Dec 2025 | $13,008.96 |
| 00000007649 | Aug 2025 | Dec 2025 | $6,911.42 |
| 00000007649 | Jul 2025 | Dec 2025 | $4,258.57 |
| 00000007649 | Jun 2025 | Dec 2025 | $551.30 |
| 00000007649 | May 2025 | Dec 2025 | $1,633.46 |
| 00000007649 | Nov 2025 | Nov 2025 | $393,930.90 |
| 00000007649 | Oct 2025 | Nov 2025 | $91,390.20 |
| 00000007649 | Sep 2025 | Nov 2025 | $6,068.07 |
| 00000007649 | Aug 2025 | Nov 2025 | $3,823.60 |
| 00000007649 | Jul 2025 | Nov 2025 | $3,239.69 |
| 00000007649 | Jun 2025 | Nov 2025 | $604.40 |
| 00000007649 | May 2025 | Nov 2025 | $418.30 |
| 00000007649 | Oct 2025 | Oct 2025 | $565,618.57 |
| 00000007649 | Sep 2025 | Oct 2025 | $112,006.29 |
| 00000007649 | Aug 2025 | Oct 2025 | $9,499.30 |
| 00000007649 | Jul 2025 | Oct 2025 | $4,407.80 |
| 00000007649 | Jun 2025 | Oct 2025 | $1,664.60 |
| 00000007649 | May 2025 | Oct 2025 | $1,821.90 |
| 00000007649 | Sep 2025 | Sep 2025 | $520,304.24 |
| 00000007649 | Aug 2025 | Sep 2025 | $131,535.28 |
| 00000007649 | Jul 2025 | Sep 2025 | $11,043.71 |
| 00000007649 | Jun 2025 | Sep 2025 | $7,573.10 |
| 00000007649 | May 2025 | Sep 2025 | $1,184.10 |
| 00000007649 | Aug 2025 | Aug 2025 | $462,244.07 |
| 00000007649 | Jul 2025 | Aug 2025 | $132,900.02 |
| 00000007649 | Jun 2025 | Aug 2025 | $12,628.92 |
| 00000007649 | May 2025 | Aug 2025 | $4,913.59 |
| 00000007649 | Jul 2025 | Jul 2025 | $538,645.90 |
| 00000007649 | Jun 2025 | Jul 2025 | $133,948.46 |
| 00000007649 | May 2025 | Jul 2025 | $8,532.80 |
| 00000007649 | Jun 2025 | Jun 2025 | $491,252.17 |
| 00000007649 | May 2025 | Jun 2025 | $110,490.67 |
| 00000007649 | May 2025 | May 2025 | $523,020.44 |
Basic Plus
| Master Account ID | IncurMonth | PaidMonth | Paid Amount |
| Totals | $21,035,815.22 | ||
| 00000007649 | Apr 2026 | Jun 2026 | $54,408.41 |
| 00000007649 | Mar 2026 | Jun 2026 | $12,051.50 |
| 00000007649 | Feb 2026 | Jun 2026 | $5,131.60 |
| 00000007649 | Jan 2026 | Jun 2026 | $10,671.85 |
| 00000007649 | Dec 2025 | Jun 2026 | $4,263.20 |
| 00000007649 | Nov 2025 | Jun 2026 | $3,536.40 |
| 00000007649 | Oct 2025 | Jun 2026 | $3,032.80 |
| 00000007649 | Sep 2025 | Jun 2026 | $4,100.73 |
| 00000007649 | Aug 2025 | Jun 2026 | $2,131.00 |
| 00000007649 | Jul 2025 | Jun 2026 | $1,207.20 |
| 00000007649 | Jun 2025 | Jun 2026 | $2,869.00 |
| 00000007649 | May 2025 | Jun 2026 | $1,738.80 |
| 00000007649 | Apr 2026 | May 2026 | $430,007.72 |
| 00000007649 | Mar 2026 | May 2026 | $50,761.68 |
| 00000007649 | Feb 2026 | May 2026 | $15,400.29 |
| 00000007649 | Jan 2026 | May 2026 | $12,320.28 |
| 00000007649 | Dec 2025 | May 2026 | $6,093.77 |
| 00000007649 | Nov 2025 | May 2026 | $6,802.17 |
| 00000007649 | Oct 2025 | May 2026 | $2,003.69 |
| 00000007649 | Sep 2025 | May 2026 | $4,475.57 |
| 00000007649 | Aug 2025 | May 2026 | $213.67 |
| 00000007649 | Jul 2025 | May 2026 | $2,119.77 |
| 00000007649 | Jun 2025 | May 2026 | $794.37 |
| 00000007649 | May 2025 | May 2026 | $2,116.00 |
| 00000007649 | Apr 2026 | Apr 2026 | $1,229,849.58 |
| 00000007649 | Mar 2026 | Apr 2026 | $460,450.17 |
| 00000007649 | Feb 2026 | Apr 2026 | $58,532.59 |
| 00000007649 | Jan 2026 | Apr 2026 | $20,089.44 |
| 00000007649 | Dec 2025 | Apr 2026 | $16,388.00 |
| 00000007649 | Nov 2025 | Apr 2026 | $9,245.14 |
| 00000007649 | Oct 2025 | Apr 2026 | $4,634.18 |
| 00000007649 | Sep 2025 | Apr 2026 | $4,815.76 |
| 00000007649 | Aug 2025 | Apr 2026 | $26.54 |
| 00000007649 | Jul 2025 | Apr 2026 | $4,529.37 |
| 00000007649 | Jun 2025 | Apr 2026 | $2,348.97 |
| 00000007649 | May 2025 | Apr 2026 | $2,747.96 |
| 00000007649 | Mar 2026 | Mar 2026 | $1,289,933.03 |
| 00000007649 | Feb 2026 | Mar 2026 | $410,622.56 |
| 00000007649 | Jan 2026 | Mar 2026 | $38,849.54 |
| 00000007649 | Dec 2025 | Mar 2026 | $20,650.73 |
| 00000007649 | Nov 2025 | Mar 2026 | $10,746.97 |
| 00000007649 | Oct 2025 | Mar 2026 | $9,265.49 |
| 00000007649 | Sep 2025 | Mar 2026 | $2,426.40 |
| 00000007649 | Aug 2025 | Mar 2026 | $1,278.92 |
| 00000007649 | Jul 2025 | Mar 2026 | $3,249.40 |
| 00000007649 | Jun 2025 | Mar 2026 | $717.22 |
| 00000007649 | May 2025 | Mar 2026 | $711.63 |
| 00000007649 | Feb 2026 | Feb 2026 | $1,213,534.70 |
| 00000007649 | Jan 2026 | Feb 2026 | $374,090.53 |
| 00000007649 | Dec 2025 | Feb 2026 | $52,310.01 |
| 00000007649 | Nov 2025 | Feb 2026 | $17,246.81 |
| 00000007649 | Oct 2025 | Feb 2026 | $12,732.14 |
| 00000007649 | Sep 2025 | Feb 2026 | $5,412.20 |
| 00000007649 | Aug 2025 | Feb 2026 | $7,420.00 |
| 00000007649 | Jul 2025 | Feb 2026 | $4,882.60 |
| 00000007649 | Jun 2025 | Feb 2026 | $3,467.80 |
| 00000007649 | May 2025 | Feb 2026 | $2,985.90 |
| 00000007649 | Jan 2026 | Jan 2026 | $1,240,035.87 |
| 00000007649 | Dec 2025 | Jan 2026 | $412,938.54 |
| 00000007649 | Nov 2025 | Jan 2026 | $42,414.07 |
| 00000007649 | Oct 2025 | Jan 2026 | $23,995.46 |
| 00000007649 | Sep 2025 | Jan 2026 | $20,007.55 |
| 00000007649 | Aug 2025 | Jan 2026 | $6,006.30 |
| 00000007649 | Jul 2025 | Jan 2026 | $6,127.18 |
| 00000007649 | Jun 2025 | Jan 2026 | $2,168.00 |
| 00000007649 | May 2025 | Jan 2026 | $134.00 |
| 00000007649 | Dec 2025 | Dec 2025 | $1,186,817.27 |
| 00000007649 | Nov 2025 | Dec 2025 | $461,079.40 |
| 00000007649 | Oct 2025 | Dec 2025 | $61,911.71 |
| 00000007649 | Sep 2025 | Dec 2025 | $29,943.65 |
| 00000007649 | Aug 2025 | Dec 2025 | $13,429.01 |
| 00000007649 | Jul 2025 | Dec 2025 | $16,085.24 |
| 00000007649 | Jun 2025 | Dec 2025 | $5,362.20 |
| 00000007649 | May 2025 | Dec 2025 | $4,642.32 |
| 00000007649 | Nov 2025 | Nov 2025 | $1,005,747.98 |
| 00000007649 | Oct 2025 | Nov 2025 | $272,510.50 |
| 00000007649 | Sep 2025 | Nov 2025 | $26,801.93 |
| 00000007649 | Aug 2025 | Nov 2025 | $22,519.05 |
| 00000007649 | Jul 2025 | Nov 2025 | $24,428.50 |
| 00000007649 | Jun 2025 | Nov 2025 | $2,680.10 |
| 00000007649 | May 2025 | Nov 2025 | $674.90 |
| 00000007649 | Oct 2025 | Oct 2025 | $1,463,333.90 |
| 00000007649 | Sep 2025 | Oct 2025 | $328,756.99 |
| 00000007649 | Aug 2025 | Oct 2025 | $47,348.90 |
| 00000007649 | Jul 2025 | Oct 2025 | $24,128.40 |
| 00000007649 | Jun 2025 | Oct 2025 | $7,690.53 |
| 00000007649 | May 2025 | Oct 2025 | $4,241.20 |
| 00000007649 | Sep 2025 | Sep 2025 | $1,315,024.97 |
| 00000007649 | Aug 2025 | Sep 2025 | $420,102.73 |
| 00000007649 | Jul 2025 | Sep 2025 | $65,835.63 |
| 00000007649 | Jun 2025 | Sep 2025 | $18,158.92 |
| 00000007649 | May 2025 | Sep 2025 | $6,841.11 |
| 00000007649 | Aug 2025 | Aug 2025 | $1,282,712.93 |
| 00000007649 | Jul 2025 | Aug 2025 | $521,965.23 |
| 00000007649 | Jun 2025 | Aug 2025 | $37,190.10 |
| 00000007649 | May 2025 | Aug 2025 | $16,167.93 |
| 00000007649 | Jul 2025 | Jul 2025 | $1,511,656.93 |
| 00000007649 | Jun 2025 | Jul 2025 | $406,360.05 |
| 00000007649 | May 2025 | Jul 2025 | $39,447.08 |
| 00000007649 | Jun 2025 | Jun 2025 | $1,237,738.08 |
| 00000007649 | May 2025 | Jun 2025 | $314,478.09 |
| 00000007649 | May 2025 | May 2025 | $1,143,731.04 |
File details come from the government source that posted it. Updated .